Query Metrics
34
Database Queries
16
Different statements
21.28 ms
Query time
6
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.71 ms |
SELECT h0_.id AS id_0, h0_.uuid AS uuid_1, h0_.`index` AS index_2, h0_.resource_id AS resource_id_3 FROM highlighted_resource h0_ ORDER BY h0_.id ASC
Parameters:
[] |
| 2 | 1.48 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.purpose AS purpose_4, t0.thematics AS thematics_5, t0.aptitudes AS aptitudes_6, t0.materials AS materials_7, t0.use_contexts AS use_contexts_8, t0.targets AS targets_9, t0.certified AS certified_10, t0.type AS type_11, t0.description AS description_12, t0.created_at AS created_at_13, t0.extra_properties AS extra_properties_14, t0.format AS format_15, t0.status AS status_16, t0.submission AS submission_17, t0.views AS views_18, t0.created_by_id AS created_by_id_19, t0.root_id AS root_id_20, t0.seo_id AS seo_id_21 FROM resource t0 WHERE t0.id = ?
Parameters:
[
15
]
|
| 3 | 2.14 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.`index` AS index_3, t0.resource_id AS resource_id_4, t0.file_id AS file_id_5, t0.thumbnail_id AS thumbnail_id_6 FROM resource_image t0 WHERE t0.resource_id = ? ORDER BY t0.`index` ASC
Parameters:
[
15
]
|
| 4 | 1.97 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.filename AS filename_3, t0.created_at AS created_at_4, t0.context AS context_5 FROM file t0 WHERE t0.id = ?
Parameters:
[
22
]
|
| 5 | 0.75 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.filename AS filename_3, t0.created_at AS created_at_4, t0.context AS context_5 FROM file t0 WHERE t0.id = ?
Parameters:
[
47
]
|
| 6 | 0.67 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.`index` AS index_3, t0.name AS name_4, t0.resource_id AS resource_id_5, t0.document_id AS document_id_6 FROM resource_document t0 WHERE t0.resource_id = ? ORDER BY t0.`index` ASC
Parameters:
[
15
]
|
| 7 | 0.45 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.filename AS filename_3, t0.created_at AS created_at_4, t0.context AS context_5 FROM file t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 8 | 2.75 ms |
SELECT t0.id AS id_6, t0.status AS status_7, t0.uuid AS uuid_8, t0.price AS price_9, t0.created_at AS created_at_10, t0.resource_id AS resource_id_11, t0.resource_id AS resource_id_12, t0.supplied_by_id AS supplied_by_id_13, t0.type, t1.stock AS stock_14, t1.affiliate_link AS affiliate_link_15, t3.departments AS departments_16, t3.departments_enabled AS departments_enabled_17, t3.place_id AS place_id_18, t4.downloads_count AS downloads_count_19, t5.url AS url_20 FROM offer t0 LEFT JOIN offer_purchase t1 ON t0.id = t1.id LEFT JOIN offer_rent t2 ON t0.id = t2.id LEFT JOIN offer_on_site t3 ON t0.id = t3.id LEFT JOIN offer_download t4 ON t0.id = t4.id LEFT JOIN offer_online t5 ON t0.id = t5.id WHERE t0.resource_id = ?
Parameters:
[
15
]
|
| 9 | 0.57 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.type AS type_5, t0.uuid AS uuid_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.business_name AS business_name_9, t0.business_type AS business_type_10, t0.notification_settings AS notification_settings_11, t0.department AS department_12, t0.country AS country_13, t0.gender AS gender_14, t0.comment AS comment_15, t0.stripe_connect_account_id AS stripe_connect_account_id_16, t0.enabled AS enabled_17, t0.locked AS locked_18, t0.created_at AS created_at_19, t0.stripe_transfers_status AS stripe_transfers_status_20, t0.stripe_payouts_enabled AS stripe_payouts_enabled_21, t0.address_id AS address_id_22, t0.gts_id AS gts_id_23, t0.billing_address_id AS billing_address_id_24 FROM user t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 10 | 0.40 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.type AS type_4, u0_.uuid AS uuid_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.business_name AS business_name_8, u0_.business_type AS business_type_9, u0_.notification_settings AS notification_settings_10, u0_.department AS department_11, u0_.country AS country_12, u0_.gender AS gender_13, u0_.comment AS comment_14, u0_.stripe_connect_account_id AS stripe_connect_account_id_15, u0_.enabled AS enabled_16, u0_.locked AS locked_17, u0_.created_at AS created_at_18, u0_.stripe_transfers_status AS stripe_transfers_status_19, u0_.stripe_payouts_enabled AS stripe_payouts_enabled_20, u0_.address_id AS address_id_21, u0_.gts_id AS gts_id_22, u0_.billing_address_id AS billing_address_id_23 FROM user u0_ WHERE u0_.id = ?
Parameters:
[
3
]
|
| 11 | 0.36 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.type AS type_4, u0_.uuid AS uuid_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.business_name AS business_name_8, u0_.business_type AS business_type_9, u0_.notification_settings AS notification_settings_10, u0_.department AS department_11, u0_.country AS country_12, u0_.gender AS gender_13, u0_.comment AS comment_14, u0_.stripe_connect_account_id AS stripe_connect_account_id_15, u0_.enabled AS enabled_16, u0_.locked AS locked_17, u0_.created_at AS created_at_18, u0_.stripe_transfers_status AS stripe_transfers_status_19, u0_.stripe_payouts_enabled AS stripe_payouts_enabled_20, u0_.address_id AS address_id_21, u0_.gts_id AS gts_id_22, u0_.billing_address_id AS billing_address_id_23 FROM user u0_ WHERE u0_.id = ?
Parameters:
[
3
]
|
| 12 | 0.35 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.price AS price_4, t0.shipped_in AS shipped_in_5, t0.delivered_in AS delivered_in_6, t0.offer_id AS offer_id_7 FROM offer_shipping t0 WHERE t0.offer_id = ?
Parameters:
[
16
]
|
| 13 | 0.76 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.pedagogy AS pedagogy_4, t0.autonomy AS autonomy_5, t0.satisfaction AS satisfaction_6, t0.theory AS theory_7, t0.comment AS comment_8, t0.status AS status_9, t0.created_by_email AS created_by_email_10, t0.created_by_id AS created_by_id_11, t0.resource_id AS resource_id_12, t0.reviewed_from_id AS reviewed_from_id_13 FROM review t0 WHERE t0.resource_id = ?
Parameters:
[
15
]
|
| 14 | 0.27 ms |
SELECT t0.id AS id_1 FROM resource_root t0 WHERE t0.id = ?
Parameters:
[
15
]
|
| 15 | 0.38 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.purpose AS purpose_4, t0.thematics AS thematics_5, t0.aptitudes AS aptitudes_6, t0.materials AS materials_7, t0.use_contexts AS use_contexts_8, t0.targets AS targets_9, t0.certified AS certified_10, t0.type AS type_11, t0.description AS description_12, t0.created_at AS created_at_13, t0.extra_properties AS extra_properties_14, t0.format AS format_15, t0.status AS status_16, t0.submission AS submission_17, t0.views AS views_18, t0.created_by_id AS created_by_id_19, t0.root_id AS root_id_20, t0.seo_id AS seo_id_21 FROM resource t0 WHERE t0.root_id = ?
Parameters:
[
15
]
|
| 16 | 0.42 ms |
SELECT AVG(r0_.theory) AS sclr_0 FROM review r0_ WHERE r0_.resource_id = ? AND r0_.status = ?
Parameters:
[ 15 "published" ] |
| 17 | 0.29 ms |
SELECT AVG(r0_.pedagogy) AS sclr_0 FROM review r0_ WHERE r0_.resource_id = ? AND r0_.status = ?
Parameters:
[ 15 "published" ] |
| 18 | 0.32 ms |
SELECT AVG(r0_.autonomy) AS sclr_0 FROM review r0_ WHERE r0_.resource_id = ? AND r0_.status = ?
Parameters:
[ 15 "published" ] |
| 19 | 0.31 ms |
SELECT AVG(r0_.satisfaction) AS sclr_0 FROM review r0_ WHERE r0_.resource_id = ? AND r0_.status = ?
Parameters:
[ 15 "published" ] |
| 20 | 0.36 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.purpose AS purpose_4, t0.thematics AS thematics_5, t0.aptitudes AS aptitudes_6, t0.materials AS materials_7, t0.use_contexts AS use_contexts_8, t0.targets AS targets_9, t0.certified AS certified_10, t0.type AS type_11, t0.description AS description_12, t0.created_at AS created_at_13, t0.extra_properties AS extra_properties_14, t0.format AS format_15, t0.status AS status_16, t0.submission AS submission_17, t0.views AS views_18, t0.created_by_id AS created_by_id_19, t0.root_id AS root_id_20, t0.seo_id AS seo_id_21 FROM resource t0 WHERE t0.id = ?
Parameters:
[
40
]
|
| 21 | 0.34 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.`index` AS index_3, t0.resource_id AS resource_id_4, t0.file_id AS file_id_5, t0.thumbnail_id AS thumbnail_id_6 FROM resource_image t0 WHERE t0.resource_id = ? ORDER BY t0.`index` ASC
Parameters:
[
40
]
|
| 22 | 0.31 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.`index` AS index_3, t0.name AS name_4, t0.resource_id AS resource_id_5, t0.document_id AS document_id_6 FROM resource_document t0 WHERE t0.resource_id = ? ORDER BY t0.`index` ASC
Parameters:
[
40
]
|
| 23 | 0.49 ms |
SELECT t0.id AS id_6, t0.status AS status_7, t0.uuid AS uuid_8, t0.price AS price_9, t0.created_at AS created_at_10, t0.resource_id AS resource_id_11, t0.resource_id AS resource_id_12, t0.supplied_by_id AS supplied_by_id_13, t0.type, t1.stock AS stock_14, t1.affiliate_link AS affiliate_link_15, t3.departments AS departments_16, t3.departments_enabled AS departments_enabled_17, t3.place_id AS place_id_18, t4.downloads_count AS downloads_count_19, t5.url AS url_20 FROM offer t0 LEFT JOIN offer_purchase t1 ON t0.id = t1.id LEFT JOIN offer_rent t2 ON t0.id = t2.id LEFT JOIN offer_on_site t3 ON t0.id = t3.id LEFT JOIN offer_download t4 ON t0.id = t4.id LEFT JOIN offer_online t5 ON t0.id = t5.id WHERE t0.resource_id = ?
Parameters:
[
40
]
|
| 24 | 0.35 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.type AS type_5, t0.uuid AS uuid_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.business_name AS business_name_9, t0.business_type AS business_type_10, t0.notification_settings AS notification_settings_11, t0.department AS department_12, t0.country AS country_13, t0.gender AS gender_14, t0.comment AS comment_15, t0.stripe_connect_account_id AS stripe_connect_account_id_16, t0.enabled AS enabled_17, t0.locked AS locked_18, t0.created_at AS created_at_19, t0.stripe_transfers_status AS stripe_transfers_status_20, t0.stripe_payouts_enabled AS stripe_payouts_enabled_21, t0.address_id AS address_id_22, t0.gts_id AS gts_id_23, t0.billing_address_id AS billing_address_id_24 FROM user t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 25 | 0.42 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.type AS type_4, u0_.uuid AS uuid_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.business_name AS business_name_8, u0_.business_type AS business_type_9, u0_.notification_settings AS notification_settings_10, u0_.department AS department_11, u0_.country AS country_12, u0_.gender AS gender_13, u0_.comment AS comment_14, u0_.stripe_connect_account_id AS stripe_connect_account_id_15, u0_.enabled AS enabled_16, u0_.locked AS locked_17, u0_.created_at AS created_at_18, u0_.stripe_transfers_status AS stripe_transfers_status_19, u0_.stripe_payouts_enabled AS stripe_payouts_enabled_20, u0_.address_id AS address_id_21, u0_.gts_id AS gts_id_22, u0_.billing_address_id AS billing_address_id_23 FROM user u0_ WHERE u0_.id = ?
Parameters:
[
3
]
|
| 26 | 0.31 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.type AS type_4, u0_.uuid AS uuid_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.business_name AS business_name_8, u0_.business_type AS business_type_9, u0_.notification_settings AS notification_settings_10, u0_.department AS department_11, u0_.country AS country_12, u0_.gender AS gender_13, u0_.comment AS comment_14, u0_.stripe_connect_account_id AS stripe_connect_account_id_15, u0_.enabled AS enabled_16, u0_.locked AS locked_17, u0_.created_at AS created_at_18, u0_.stripe_transfers_status AS stripe_transfers_status_19, u0_.stripe_payouts_enabled AS stripe_payouts_enabled_20, u0_.address_id AS address_id_21, u0_.gts_id AS gts_id_22, u0_.billing_address_id AS billing_address_id_23 FROM user u0_ WHERE u0_.id = ?
Parameters:
[
3
]
|
| 27 | 0.30 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.price AS price_4, t0.shipped_in AS shipped_in_5, t0.delivered_in AS delivered_in_6, t0.offer_id AS offer_id_7 FROM offer_shipping t0 WHERE t0.offer_id = ?
Parameters:
[
45
]
|
| 28 | 0.31 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.pedagogy AS pedagogy_4, t0.autonomy AS autonomy_5, t0.satisfaction AS satisfaction_6, t0.theory AS theory_7, t0.comment AS comment_8, t0.status AS status_9, t0.created_by_email AS created_by_email_10, t0.created_by_id AS created_by_id_11, t0.resource_id AS resource_id_12, t0.reviewed_from_id AS reviewed_from_id_13 FROM review t0 WHERE t0.resource_id = ?
Parameters:
[
40
]
|
| 29 | 0.23 ms |
SELECT t0.id AS id_1 FROM resource_root t0 WHERE t0.id = ?
Parameters:
[
40
]
|
| 30 | 0.34 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.purpose AS purpose_4, t0.thematics AS thematics_5, t0.aptitudes AS aptitudes_6, t0.materials AS materials_7, t0.use_contexts AS use_contexts_8, t0.targets AS targets_9, t0.certified AS certified_10, t0.type AS type_11, t0.description AS description_12, t0.created_at AS created_at_13, t0.extra_properties AS extra_properties_14, t0.format AS format_15, t0.status AS status_16, t0.submission AS submission_17, t0.views AS views_18, t0.created_by_id AS created_by_id_19, t0.root_id AS root_id_20, t0.seo_id AS seo_id_21 FROM resource t0 WHERE t0.root_id = ?
Parameters:
[
40
]
|
| 31 | 0.29 ms |
SELECT AVG(r0_.theory) AS sclr_0 FROM review r0_ WHERE r0_.resource_id = ? AND r0_.status = ?
Parameters:
[ 40 "published" ] |
| 32 | 0.30 ms |
SELECT AVG(r0_.pedagogy) AS sclr_0 FROM review r0_ WHERE r0_.resource_id = ? AND r0_.status = ?
Parameters:
[ 40 "published" ] |
| 33 | 0.29 ms |
SELECT AVG(r0_.autonomy) AS sclr_0 FROM review r0_ WHERE r0_.resource_id = ? AND r0_.status = ?
Parameters:
[ 40 "published" ] |
| 34 | 0.29 ms |
SELECT AVG(r0_.satisfaction) AS sclr_0 FROM review r0_ WHERE r0_.resource_id = ? AND r0_.status = ?
Parameters:
[ 40 "published" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\HighlightedResource | No errors. |
| App\Entity\Resource | No errors. |
| App\Entity\Offer |
|
| App\Entity\User | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\OrderItem | No errors. |
| App\Entity\OrderItemShipping | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\File | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\SupplierInvoice | No errors. |
| App\Entity\CustomerInvoice | No errors. |
| App\Entity\FavoriteResource | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\OfferShipping | No errors. |
| App\Entity\ResourceImage | No errors. |
| App\Entity\ResourceDocument | No errors. |
| App\Entity\ResourceRoot | No errors. |
| App\Entity\Seo | No errors. |
| App\Entity\OfferPurchase |
|
| App\Entity\OfferRent |
|
| App\Entity\OfferOnSite |
|
| App\Entity\OfferDownload |
|
| App\Entity\OfferOnline |
|