Query Metrics
46
Database Queries
10
Different statements
321.51 ms
Query time
0
Invalid entities
70
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.36 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.iso_code AS iso_code_2, c0_.b2b AS b2b_3 FROM country c0_ WHERE c0_.iso_code = ? AND c0_.b2b = ?
Parameters:
[ "FR" 0 ] |
| 2 | 12.12 ms |
SELECT t0.id AS id_1, t0.iso_lang AS iso_lang_2, t0.default_lang AS default_lang_3, t0.country_id AS country_id_4 FROM lang t0 WHERE t0.country_id = ?
Parameters:
[
1
]
|
| 3 | 5.50 ms |
SELECT t0.id AS id_1, t0.gencode AS gencode_2, t0.nom_cms AS nom_cms_3, t0.nom AS nom_4, t0.sub_title AS sub_title_5, t0.publish AS publish_6, t0.alias AS alias_7, t0.stock AS stock_8, t0.gabarit_path AS gabarit_path_9, t0.title AS title_10, t0.metadata AS metadata_11, t0.video AS video_12, t0.date_update AS date_update_13, t0.click_to_store AS click_to_store_14, t0.user_manual AS user_manual_15, t0.advertising AS advertising_16, t0.lang_id AS lang_id_17, t0.compiere_data_id AS compiere_data_id_18, t19.id AS id_20, t19.title AS title_21, t19.recap_title AS recap_title_22, t19.description AS description_23, t19.payment_title AS payment_title_24, t19.device_id AS device_id_25, t19.subscription_id AS subscription_id_26, t19.accessory_id AS accessory_id_27, t19.option_id AS option_id_28, t0.update_by_id AS update_by_id_29 FROM device t0 LEFT JOIN purchase_funnel t19 ON t19.device_id = t0.id WHERE t0.alias = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[ "coyote-max" 1 ] |
| 4 | 1.65 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
31
]
|
| 5 | 54.67 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
31
]
|
| 6 | 5.29 ms |
SELECT t0.id AS id_1, t0.gencode AS gencode_2, t0.category_id AS category_id_3, t0.category_web AS category_web_4, t0.nom AS nom_5, t0.description AS description_6, t0.description_en AS description_en_7, t0.product_id AS product_id_8, t0.type_embarque_id AS type_embarque_id_9, t0.duration AS duration_10, t0.ecotax_no_tax AS ecotax_no_tax_11, t0.price_no_tax AS price_no_tax_12, t0.price_with_tax AS price_with_tax_13, t0.guarantee_days AS guarantee_days_14, t0.periodicity AS periodicity_15, t0.renewal AS renewal_16, t0.tax_rate AS tax_rate_17, t0.tax_rate_id AS tax_rate_id_18, t0.tax_value AS tax_value_19, t0.transferrable AS transferrable_20, t0.weight AS weight_21, t0.actif AS actif_22, t0.stock AS stock_23, t0.document_note AS document_note_24, t0.linked_brand AS linked_brand_25, t0.country_id AS country_id_26, t0.service_package_id AS service_package_id_27, t0.yearly AS yearly_28, t0.partenaire_id AS partenaire_id_29, t0.update_date AS update_date_30, t0.products_linked AS products_linked_31, t0.lang_id AS lang_id_32, t33.id AS id_34, t33.gencode AS gencode_35, t33.nom_cms AS nom_cms_36, t33.nom AS nom_37, t33.sub_title AS sub_title_38, t33.publish AS publish_39, t33.alias AS alias_40, t33.stock AS stock_41, t33.gabarit_path AS gabarit_path_42, t33.title AS title_43, t33.metadata AS metadata_44, t33.video AS video_45, t33.date_update AS date_update_46, t33.click_to_store AS click_to_store_47, t33.user_manual AS user_manual_48, t33.advertising AS advertising_49, t33.lang_id AS lang_id_50, t33.compiere_data_id AS compiere_data_id_51, t33.update_by_id AS update_by_id_52, t53.id AS id_54, t53.nom_cms AS nom_cms_55, t53.nom AS nom_56, t53.title AS title_57, t53.sub_title AS sub_title_58, t53.accroche_commerciale AS accroche_commerciale_59, t53.publish AS publish_60, t53.alias AS alias_61, t53.stock AS stock_62, t53.gencode AS gencode_63, t53.gabarit_path AS gabarit_path_64, t53.metadata AS metadata_65, t53.date_update AS date_update_66, t53.ordering AS ordering_67, t53.lang_id AS lang_id_68, t53.compiere_data_id AS compiere_data_id_69, t53.category_id AS category_id_70, t53.update_by_id AS update_by_id_71, t72.id AS id_73, t72.nom AS nom_74, t72.nom_cms AS nom_cms_75, t72.title AS title_76, t72.description AS description_77, t72.gencode AS gencode_78, t72.date_update AS date_update_79, t72.publish AS publish_80, t72.sub_title AS sub_title_81, t72.compiere_data_id AS compiere_data_id_82, t72.lang_id AS lang_id_83, t72.update_by_id AS update_by_id_84, t85.id AS id_86, t85.nom AS nom_87, t85.nom_cms AS nom_cms_88, t85.gencode AS gencode_89, t85.date_update AS date_update_90, t85.publish AS publish_91, t85.lang_id AS lang_id_92, t85.compiere_data_id AS compiere_data_id_93, t85.update_by_id AS update_by_id_94 FROM compiere_data t0 LEFT JOIN device t33 ON t33.compiere_data_id = t0.id LEFT JOIN accessory t53 ON t53.compiere_data_id = t0.id LEFT JOIN `option` t72 ON t72.compiere_data_id = t0.id LEFT JOIN subscription t85 ON t85.compiere_data_id = t0.id WHERE t0.id = ?
Parameters:
[
"FR_fr3760173208616"
]
|
| 7 | 57.70 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.alias AS alias_4, t0.id_ticket AS id_ticket_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.legalnotice AS legalnotice_8, t0.additional_html AS additional_html_9, t0.content_card_nav AS content_card_nav_10, t0.content_banner AS content_banner_11, t0.display_slide AS display_slide_12, t0.lang_id AS lang_id_13 FROM promotion_automation t0 WHERE t0.active = ?
Parameters:
[
1
]
|
| 8 | 3.20 ms |
SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.name AS name_2, p0_.alias AS alias_3, p0_.id_ticket AS id_ticket_4, p0_.start_date AS start_date_5, p0_.end_date AS end_date_6, p0_.legalnotice AS legalnotice_7, p0_.additional_html AS additional_html_8, p0_.content_card_nav AS content_card_nav_9, p0_.content_banner AS content_banner_10, p0_.display_slide AS display_slide_11, p0_.lang_id AS lang_id_12 FROM promotion_automation p0_ WHERE p0_.active = ? AND p0_.start_date <= ? AND p0_.end_date >= ? LIMIT 1
Parameters:
[ 1 "2026-07-17 14:03:24" "2026-07-17 14:03:24" ] |
| 9 | 48.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.device_id AS device_id_4, t0.accessory_id AS accessory_id_5, t0.field_id AS field_id_6 FROM content t0 WHERE t0.device_id = ?
Parameters:
[
31
]
|
| 10 | 7.53 ms |
SELECT t0.id AS id_1, t0.gencode AS gencode_2, t0.nom_cms AS nom_cms_3, t0.nom AS nom_4, t0.sub_title AS sub_title_5, t0.publish AS publish_6, t0.alias AS alias_7, t0.stock AS stock_8, t0.gabarit_path AS gabarit_path_9, t0.title AS title_10, t0.metadata AS metadata_11, t0.video AS video_12, t0.date_update AS date_update_13, t0.click_to_store AS click_to_store_14, t0.user_manual AS user_manual_15, t0.advertising AS advertising_16, t0.lang_id AS lang_id_17, t0.compiere_data_id AS compiere_data_id_18, t19.id AS id_20, t19.title AS title_21, t19.recap_title AS recap_title_22, t19.description AS description_23, t19.payment_title AS payment_title_24, t19.device_id AS device_id_25, t19.subscription_id AS subscription_id_26, t19.accessory_id AS accessory_id_27, t19.option_id AS option_id_28, t0.update_by_id AS update_by_id_29 FROM device t0 LEFT JOIN purchase_funnel t19 ON t19.device_id = t0.id WHERE t0.publish = ?
Parameters:
[
1
]
|
| 11 | 1.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
1
]
|
| 12 | 3.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
4
]
|
| 13 | 2.85 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
1
]
|
| 14 | 1.42 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
7
]
|
| 15 | 4.02 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
4
]
|
| 16 | 1.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
10
]
|
| 17 | 1.13 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
7
]
|
| 18 | 3.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
13
]
|
| 19 | 1.41 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
10
]
|
| 20 | 1.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
16
]
|
| 21 | 1.33 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
13
]
|
| 22 | 55.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
19
]
|
| 23 | 1.41 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
16
]
|
| 24 | 3.81 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
22
]
|
| 25 | 1.16 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
19
]
|
| 26 | 1.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
25
]
|
| 27 | 1.11 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
22
]
|
| 28 | 2.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
28
]
|
| 29 | 1.11 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
25
]
|
| 30 | 4.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
34
]
|
| 31 | 1.13 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
28
]
|
| 32 | 1.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
37
]
|
| 33 | 1.10 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
34
]
|
| 34 | 1.75 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
40
]
|
| 35 | 1.12 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
37
]
|
| 36 | 1.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
43
]
|
| 37 | 3.31 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
40
]
|
| 38 | 1.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
46
]
|
| 39 | 3.50 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
43
]
|
| 40 | 1.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
49
]
|
| 41 | 1.11 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
46
]
|
| 42 | 1.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM content_tag t0 INNER JOIN device_content_tag ON t0.id = device_content_tag.content_tag_id WHERE device_content_tag.device_id = ?
Parameters:
[
52
]
|
| 43 | 2.85 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
49
]
|
| 44 | 1.09 ms |
SELECT t0.id AS id_1, t0.path AS path_2, t0.title AS title_3, t0.is_main AS is_main_4, t0.device_id AS device_id_5, t0.accessory_id AS accessory_id_6 FROM image_data t0 WHERE t0.device_id IN (?)
Parameters:
[
52
]
|
| 45 | 4.56 ms |
SELECT t0.id AS id_1, t0.gencode AS gencode_2, t0.nom_cms AS nom_cms_3, t0.nom AS nom_4, t0.sub_title AS sub_title_5, t0.publish AS publish_6, t0.alias AS alias_7, t0.stock AS stock_8, t0.gabarit_path AS gabarit_path_9, t0.title AS title_10, t0.metadata AS metadata_11, t0.video AS video_12, t0.date_update AS date_update_13, t0.click_to_store AS click_to_store_14, t0.user_manual AS user_manual_15, t0.advertising AS advertising_16, t0.lang_id AS lang_id_17, t0.compiere_data_id AS compiere_data_id_18, t19.id AS id_20, t19.title AS title_21, t19.recap_title AS recap_title_22, t19.description AS description_23, t19.payment_title AS payment_title_24, t19.device_id AS device_id_25, t19.subscription_id AS subscription_id_26, t19.accessory_id AS accessory_id_27, t19.option_id AS option_id_28, t0.update_by_id AS update_by_id_29 FROM device t0 LEFT JOIN purchase_funnel t19 ON t19.device_id = t0.id WHERE t0.publish = ?
Parameters:
[
1
]
|
| 46 | 1.31 ms |
SELECT t0.id AS id_1, t0.gencode AS gencode_2, t0.nom_cms AS nom_cms_3, t0.nom AS nom_4, t0.sub_title AS sub_title_5, t0.publish AS publish_6, t0.alias AS alias_7, t0.stock AS stock_8, t0.gabarit_path AS gabarit_path_9, t0.title AS title_10, t0.metadata AS metadata_11, t0.video AS video_12, t0.date_update AS date_update_13, t0.click_to_store AS click_to_store_14, t0.user_manual AS user_manual_15, t0.advertising AS advertising_16, t0.lang_id AS lang_id_17, t0.compiere_data_id AS compiere_data_id_18, t19.id AS id_20, t19.title AS title_21, t19.recap_title AS recap_title_22, t19.description AS description_23, t19.payment_title AS payment_title_24, t19.device_id AS device_id_25, t19.subscription_id AS subscription_id_26, t19.accessory_id AS accessory_id_27, t19.option_id AS option_id_28, t0.update_by_id AS update_by_id_29 FROM device t0 LEFT JOIN purchase_funnel t19 ON t19.device_id = t0.id WHERE t0.publish = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| old_csi | doctrine.dbal.old_csi_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Device | 18 |
| App\Entity\CompiereData | 18 |
| App\Entity\ImageData | 18 |
| App\Entity\Lang | 7 |
| App\Entity\Content | 4 |
| App\Entity\ContentField | 4 |
| App\Entity\Country | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Country | No errors. |
| App\Entity\Lang | No errors. |
| App\Entity\Translation | No errors. |
| App\Entity\CompiereData | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\AccessoryCategory | No errors. |
| App\Entity\Carousel | No errors. |
| App\Entity\Offer | No errors. |
| App\Entity\Device | No errors. |
| App\Entity\PurchaseFunnel | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\Accessory | No errors. |
| App\Entity\Option | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Content | No errors. |
| App\Entity\BackupDevice | No errors. |
| App\Entity\ContentTag | No errors. |
| App\Entity\ImageData | No errors. |
| App\Entity\PromotionAutomation | No errors. |
| App\Entity\ContentField | No errors. |