GET https://de.csi-mkt.int.coyotesystems.com/fr/coyote-secure/configuration

Response
200 OK
IP
147.243.245.238
Profiled on
Token
1f5973

Query Metrics

15 Database Queries
8 Different statements
148.42 ms Query time
0 Invalid entities
37 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 3.75 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
]
View formatted query    View runnable query    Explain query
2 3.47 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
]
View formatted query    View runnable query    Explain query
3 6.36 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-secure"
  1
]
View formatted query    View runnable query    Explain query
4 5.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: 
[
  10
]
View formatted query    View runnable query    Explain query
5 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: 
[
  10
]
View formatted query    View runnable query    Explain query
6 8.98 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_fr3760173207190"
]
View formatted query    View runnable query    Explain query
7 9.47 ms 
SELECT c0_.id AS id_0, c0_.gencode AS gencode_1, c0_.category_id AS category_id_2, c0_.category_web AS category_web_3, c0_.nom AS nom_4, c0_.description AS description_5, c0_.description_en AS description_en_6, c0_.product_id AS product_id_7, c0_.type_embarque_id AS type_embarque_id_8, c0_.duration AS duration_9, c0_.ecotax_no_tax AS ecotax_no_tax_10, c0_.price_no_tax AS price_no_tax_11, c0_.price_with_tax AS price_with_tax_12, c0_.guarantee_days AS guarantee_days_13, c0_.periodicity AS periodicity_14, c0_.renewal AS renewal_15, c0_.tax_rate AS tax_rate_16, c0_.tax_rate_id AS tax_rate_id_17, c0_.tax_value AS tax_value_18, c0_.transferrable AS transferrable_19, c0_.weight AS weight_20, c0_.actif AS actif_21, c0_.stock AS stock_22, c0_.document_note AS document_note_23, c0_.linked_brand AS linked_brand_24, c0_.country_id AS country_id_25, c0_.service_package_id AS service_package_id_26, c0_.yearly AS yearly_27, c0_.partenaire_id AS partenaire_id_28, c0_.update_date AS update_date_29, c0_.products_linked AS products_linked_30, l1_.id AS id_31, l1_.iso_lang AS iso_lang_32, l1_.default_lang AS default_lang_33, d2_.id AS id_34, d2_.gencode AS gencode_35, d2_.nom_cms AS nom_cms_36, d2_.nom AS nom_37, d2_.sub_title AS sub_title_38, d2_.publish AS publish_39, d2_.alias AS alias_40, d2_.stock AS stock_41, d2_.gabarit_path AS gabarit_path_42, d2_.title AS title_43, d2_.metadata AS metadata_44, d2_.video AS video_45, d2_.date_update AS date_update_46, d2_.click_to_store AS click_to_store_47, d2_.user_manual AS user_manual_48, d2_.advertising AS advertising_49, a3_.id AS id_50, a3_.nom_cms AS nom_cms_51, a3_.nom AS nom_52, a3_.title AS title_53, a3_.sub_title AS sub_title_54, a3_.accroche_commerciale AS accroche_commerciale_55, a3_.publish AS publish_56, a3_.alias AS alias_57, a3_.stock AS stock_58, a3_.gencode AS gencode_59, a3_.gabarit_path AS gabarit_path_60, a3_.metadata AS metadata_61, a3_.date_update AS date_update_62, a3_.ordering AS ordering_63, o4_.id AS id_64, o4_.nom AS nom_65, o4_.nom_cms AS nom_cms_66, o4_.title AS title_67, o4_.description AS description_68, o4_.gencode AS gencode_69, o4_.date_update AS date_update_70, o4_.publish AS publish_71, o4_.sub_title AS sub_title_72, s5_.id AS id_73, s5_.nom AS nom_74, s5_.nom_cms AS nom_cms_75, s5_.gencode AS gencode_76, s5_.date_update AS date_update_77, s5_.publish AS publish_78, c0_.lang_id AS lang_id_79, l1_.country_id AS country_id_80, d2_.lang_id AS lang_id_81, d2_.compiere_data_id AS compiere_data_id_82, d2_.update_by_id AS update_by_id_83, a3_.lang_id AS lang_id_84, a3_.compiere_data_id AS compiere_data_id_85, a3_.category_id AS category_id_86, a3_.update_by_id AS update_by_id_87, o4_.compiere_data_id AS compiere_data_id_88, o4_.lang_id AS lang_id_89, o4_.update_by_id AS update_by_id_90, s5_.lang_id AS lang_id_91, s5_.compiere_data_id AS compiere_data_id_92, s5_.update_by_id AS update_by_id_93 FROM compiere_data c0_ LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id WHERE c0_.gencode = ? AND c0_.lang_id = ?
Parameters: 
[
  "2990000000780"
  1
]
View formatted query    View runnable query    Explain query
8 47.21 ms 
SELECT c0_.id AS id_0, c0_.gencode AS gencode_1, c0_.category_id AS category_id_2, c0_.category_web AS category_web_3, c0_.nom AS nom_4, c0_.description AS description_5, c0_.description_en AS description_en_6, c0_.product_id AS product_id_7, c0_.type_embarque_id AS type_embarque_id_8, c0_.duration AS duration_9, c0_.ecotax_no_tax AS ecotax_no_tax_10, c0_.price_no_tax AS price_no_tax_11, c0_.price_with_tax AS price_with_tax_12, c0_.guarantee_days AS guarantee_days_13, c0_.periodicity AS periodicity_14, c0_.renewal AS renewal_15, c0_.tax_rate AS tax_rate_16, c0_.tax_rate_id AS tax_rate_id_17, c0_.tax_value AS tax_value_18, c0_.transferrable AS transferrable_19, c0_.weight AS weight_20, c0_.actif AS actif_21, c0_.stock AS stock_22, c0_.document_note AS document_note_23, c0_.linked_brand AS linked_brand_24, c0_.country_id AS country_id_25, c0_.service_package_id AS service_package_id_26, c0_.yearly AS yearly_27, c0_.partenaire_id AS partenaire_id_28, c0_.update_date AS update_date_29, c0_.products_linked AS products_linked_30, l1_.id AS id_31, l1_.iso_lang AS iso_lang_32, l1_.default_lang AS default_lang_33, d2_.id AS id_34, d2_.gencode AS gencode_35, d2_.nom_cms AS nom_cms_36, d2_.nom AS nom_37, d2_.sub_title AS sub_title_38, d2_.publish AS publish_39, d2_.alias AS alias_40, d2_.stock AS stock_41, d2_.gabarit_path AS gabarit_path_42, d2_.title AS title_43, d2_.metadata AS metadata_44, d2_.video AS video_45, d2_.date_update AS date_update_46, d2_.click_to_store AS click_to_store_47, d2_.user_manual AS user_manual_48, d2_.advertising AS advertising_49, a3_.id AS id_50, a3_.nom_cms AS nom_cms_51, a3_.nom AS nom_52, a3_.title AS title_53, a3_.sub_title AS sub_title_54, a3_.accroche_commerciale AS accroche_commerciale_55, a3_.publish AS publish_56, a3_.alias AS alias_57, a3_.stock AS stock_58, a3_.gencode AS gencode_59, a3_.gabarit_path AS gabarit_path_60, a3_.metadata AS metadata_61, a3_.date_update AS date_update_62, a3_.ordering AS ordering_63, o4_.id AS id_64, o4_.nom AS nom_65, o4_.nom_cms AS nom_cms_66, o4_.title AS title_67, o4_.description AS description_68, o4_.gencode AS gencode_69, o4_.date_update AS date_update_70, o4_.publish AS publish_71, o4_.sub_title AS sub_title_72, s5_.id AS id_73, s5_.nom AS nom_74, s5_.nom_cms AS nom_cms_75, s5_.gencode AS gencode_76, s5_.date_update AS date_update_77, s5_.publish AS publish_78, c0_.lang_id AS lang_id_79, l1_.country_id AS country_id_80, d2_.lang_id AS lang_id_81, d2_.compiere_data_id AS compiere_data_id_82, d2_.update_by_id AS update_by_id_83, a3_.lang_id AS lang_id_84, a3_.compiere_data_id AS compiere_data_id_85, a3_.category_id AS category_id_86, a3_.update_by_id AS update_by_id_87, o4_.compiere_data_id AS compiere_data_id_88, o4_.lang_id AS lang_id_89, o4_.update_by_id AS update_by_id_90, s5_.lang_id AS lang_id_91, s5_.compiere_data_id AS compiere_data_id_92, s5_.update_by_id AS update_by_id_93 FROM compiere_data c0_ LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id WHERE c0_.gencode = ? AND c0_.lang_id = ?
Parameters: 
[
  "2990000000782"
  1
]
View formatted query    View runnable query    Explain query
9 1.86 ms 
SELECT c0_.id AS id_0, c0_.gencode AS gencode_1, c0_.category_id AS category_id_2, c0_.category_web AS category_web_3, c0_.nom AS nom_4, c0_.description AS description_5, c0_.description_en AS description_en_6, c0_.product_id AS product_id_7, c0_.type_embarque_id AS type_embarque_id_8, c0_.duration AS duration_9, c0_.ecotax_no_tax AS ecotax_no_tax_10, c0_.price_no_tax AS price_no_tax_11, c0_.price_with_tax AS price_with_tax_12, c0_.guarantee_days AS guarantee_days_13, c0_.periodicity AS periodicity_14, c0_.renewal AS renewal_15, c0_.tax_rate AS tax_rate_16, c0_.tax_rate_id AS tax_rate_id_17, c0_.tax_value AS tax_value_18, c0_.transferrable AS transferrable_19, c0_.weight AS weight_20, c0_.actif AS actif_21, c0_.stock AS stock_22, c0_.document_note AS document_note_23, c0_.linked_brand AS linked_brand_24, c0_.country_id AS country_id_25, c0_.service_package_id AS service_package_id_26, c0_.yearly AS yearly_27, c0_.partenaire_id AS partenaire_id_28, c0_.update_date AS update_date_29, c0_.products_linked AS products_linked_30, l1_.id AS id_31, l1_.iso_lang AS iso_lang_32, l1_.default_lang AS default_lang_33, d2_.id AS id_34, d2_.gencode AS gencode_35, d2_.nom_cms AS nom_cms_36, d2_.nom AS nom_37, d2_.sub_title AS sub_title_38, d2_.publish AS publish_39, d2_.alias AS alias_40, d2_.stock AS stock_41, d2_.gabarit_path AS gabarit_path_42, d2_.title AS title_43, d2_.metadata AS metadata_44, d2_.video AS video_45, d2_.date_update AS date_update_46, d2_.click_to_store AS click_to_store_47, d2_.user_manual AS user_manual_48, d2_.advertising AS advertising_49, a3_.id AS id_50, a3_.nom_cms AS nom_cms_51, a3_.nom AS nom_52, a3_.title AS title_53, a3_.sub_title AS sub_title_54, a3_.accroche_commerciale AS accroche_commerciale_55, a3_.publish AS publish_56, a3_.alias AS alias_57, a3_.stock AS stock_58, a3_.gencode AS gencode_59, a3_.gabarit_path AS gabarit_path_60, a3_.metadata AS metadata_61, a3_.date_update AS date_update_62, a3_.ordering AS ordering_63, o4_.id AS id_64, o4_.nom AS nom_65, o4_.nom_cms AS nom_cms_66, o4_.title AS title_67, o4_.description AS description_68, o4_.gencode AS gencode_69, o4_.date_update AS date_update_70, o4_.publish AS publish_71, o4_.sub_title AS sub_title_72, s5_.id AS id_73, s5_.nom AS nom_74, s5_.nom_cms AS nom_cms_75, s5_.gencode AS gencode_76, s5_.date_update AS date_update_77, s5_.publish AS publish_78, c0_.lang_id AS lang_id_79, l1_.country_id AS country_id_80, d2_.lang_id AS lang_id_81, d2_.compiere_data_id AS compiere_data_id_82, d2_.update_by_id AS update_by_id_83, a3_.lang_id AS lang_id_84, a3_.compiere_data_id AS compiere_data_id_85, a3_.category_id AS category_id_86, a3_.update_by_id AS update_by_id_87, o4_.compiere_data_id AS compiere_data_id_88, o4_.lang_id AS lang_id_89, o4_.update_by_id AS update_by_id_90, s5_.lang_id AS lang_id_91, s5_.compiere_data_id AS compiere_data_id_92, s5_.update_by_id AS update_by_id_93 FROM compiere_data c0_ LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id WHERE c0_.gencode = ? AND c0_.lang_id = ?
Parameters: 
[
  "2990000000781"
  1
]
View formatted query    View runnable query    Explain query
10 3.98 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.lang_id AS lang_id_4 FROM accessory_category t0 ORDER BY t0.ordering DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 17.43 ms 
SELECT c0_.id AS id_0, c0_.gencode AS gencode_1, c0_.category_id AS category_id_2, c0_.category_web AS category_web_3, c0_.nom AS nom_4, c0_.description AS description_5, c0_.description_en AS description_en_6, c0_.product_id AS product_id_7, c0_.type_embarque_id AS type_embarque_id_8, c0_.duration AS duration_9, c0_.ecotax_no_tax AS ecotax_no_tax_10, c0_.price_no_tax AS price_no_tax_11, c0_.price_with_tax AS price_with_tax_12, c0_.guarantee_days AS guarantee_days_13, c0_.periodicity AS periodicity_14, c0_.renewal AS renewal_15, c0_.tax_rate AS tax_rate_16, c0_.tax_rate_id AS tax_rate_id_17, c0_.tax_value AS tax_value_18, c0_.transferrable AS transferrable_19, c0_.weight AS weight_20, c0_.actif AS actif_21, c0_.stock AS stock_22, c0_.document_note AS document_note_23, c0_.linked_brand AS linked_brand_24, c0_.country_id AS country_id_25, c0_.service_package_id AS service_package_id_26, c0_.yearly AS yearly_27, c0_.partenaire_id AS partenaire_id_28, c0_.update_date AS update_date_29, c0_.products_linked AS products_linked_30, l1_.id AS id_31, l1_.iso_lang AS iso_lang_32, l1_.default_lang AS default_lang_33, d2_.id AS id_34, d2_.gencode AS gencode_35, d2_.nom_cms AS nom_cms_36, d2_.nom AS nom_37, d2_.sub_title AS sub_title_38, d2_.publish AS publish_39, d2_.alias AS alias_40, d2_.stock AS stock_41, d2_.gabarit_path AS gabarit_path_42, d2_.title AS title_43, d2_.metadata AS metadata_44, d2_.video AS video_45, d2_.date_update AS date_update_46, d2_.click_to_store AS click_to_store_47, d2_.user_manual AS user_manual_48, d2_.advertising AS advertising_49, a3_.id AS id_50, a3_.nom_cms AS nom_cms_51, a3_.nom AS nom_52, a3_.title AS title_53, a3_.sub_title AS sub_title_54, a3_.accroche_commerciale AS accroche_commerciale_55, a3_.publish AS publish_56, a3_.alias AS alias_57, a3_.stock AS stock_58, a3_.gencode AS gencode_59, a3_.gabarit_path AS gabarit_path_60, a3_.metadata AS metadata_61, a3_.date_update AS date_update_62, a3_.ordering AS ordering_63, o4_.id AS id_64, o4_.nom AS nom_65, o4_.nom_cms AS nom_cms_66, o4_.title AS title_67, o4_.description AS description_68, o4_.gencode AS gencode_69, o4_.date_update AS date_update_70, o4_.publish AS publish_71, o4_.sub_title AS sub_title_72, s5_.id AS id_73, s5_.nom AS nom_74, s5_.nom_cms AS nom_cms_75, s5_.gencode AS gencode_76, s5_.date_update AS date_update_77, s5_.publish AS publish_78, c0_.lang_id AS lang_id_79, l1_.country_id AS country_id_80, d2_.lang_id AS lang_id_81, d2_.compiere_data_id AS compiere_data_id_82, d2_.update_by_id AS update_by_id_83, a3_.lang_id AS lang_id_84, a3_.compiere_data_id AS compiere_data_id_85, a3_.category_id AS category_id_86, a3_.update_by_id AS update_by_id_87, o4_.compiere_data_id AS compiere_data_id_88, o4_.lang_id AS lang_id_89, o4_.update_by_id AS update_by_id_90, s5_.lang_id AS lang_id_91, s5_.compiere_data_id AS compiere_data_id_92, s5_.update_by_id AS update_by_id_93 FROM compiere_data c0_ LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id WHERE c0_.gencode = ? AND c0_.lang_id = ?
Parameters: 
[
  "2000000810337"
  1
]
View formatted query    View runnable query    Explain query
12 1.88 ms 
SELECT c0_.id AS id_0, c0_.gencode AS gencode_1, c0_.category_id AS category_id_2, c0_.category_web AS category_web_3, c0_.nom AS nom_4, c0_.description AS description_5, c0_.description_en AS description_en_6, c0_.product_id AS product_id_7, c0_.type_embarque_id AS type_embarque_id_8, c0_.duration AS duration_9, c0_.ecotax_no_tax AS ecotax_no_tax_10, c0_.price_no_tax AS price_no_tax_11, c0_.price_with_tax AS price_with_tax_12, c0_.guarantee_days AS guarantee_days_13, c0_.periodicity AS periodicity_14, c0_.renewal AS renewal_15, c0_.tax_rate AS tax_rate_16, c0_.tax_rate_id AS tax_rate_id_17, c0_.tax_value AS tax_value_18, c0_.transferrable AS transferrable_19, c0_.weight AS weight_20, c0_.actif AS actif_21, c0_.stock AS stock_22, c0_.document_note AS document_note_23, c0_.linked_brand AS linked_brand_24, c0_.country_id AS country_id_25, c0_.service_package_id AS service_package_id_26, c0_.yearly AS yearly_27, c0_.partenaire_id AS partenaire_id_28, c0_.update_date AS update_date_29, c0_.products_linked AS products_linked_30, l1_.id AS id_31, l1_.iso_lang AS iso_lang_32, l1_.default_lang AS default_lang_33, d2_.id AS id_34, d2_.gencode AS gencode_35, d2_.nom_cms AS nom_cms_36, d2_.nom AS nom_37, d2_.sub_title AS sub_title_38, d2_.publish AS publish_39, d2_.alias AS alias_40, d2_.stock AS stock_41, d2_.gabarit_path AS gabarit_path_42, d2_.title AS title_43, d2_.metadata AS metadata_44, d2_.video AS video_45, d2_.date_update AS date_update_46, d2_.click_to_store AS click_to_store_47, d2_.user_manual AS user_manual_48, d2_.advertising AS advertising_49, a3_.id AS id_50, a3_.nom_cms AS nom_cms_51, a3_.nom AS nom_52, a3_.title AS title_53, a3_.sub_title AS sub_title_54, a3_.accroche_commerciale AS accroche_commerciale_55, a3_.publish AS publish_56, a3_.alias AS alias_57, a3_.stock AS stock_58, a3_.gencode AS gencode_59, a3_.gabarit_path AS gabarit_path_60, a3_.metadata AS metadata_61, a3_.date_update AS date_update_62, a3_.ordering AS ordering_63, o4_.id AS id_64, o4_.nom AS nom_65, o4_.nom_cms AS nom_cms_66, o4_.title AS title_67, o4_.description AS description_68, o4_.gencode AS gencode_69, o4_.date_update AS date_update_70, o4_.publish AS publish_71, o4_.sub_title AS sub_title_72, s5_.id AS id_73, s5_.nom AS nom_74, s5_.nom_cms AS nom_cms_75, s5_.gencode AS gencode_76, s5_.date_update AS date_update_77, s5_.publish AS publish_78, c0_.lang_id AS lang_id_79, l1_.country_id AS country_id_80, d2_.lang_id AS lang_id_81, d2_.compiere_data_id AS compiere_data_id_82, d2_.update_by_id AS update_by_id_83, a3_.lang_id AS lang_id_84, a3_.compiere_data_id AS compiere_data_id_85, a3_.category_id AS category_id_86, a3_.update_by_id AS update_by_id_87, o4_.compiere_data_id AS compiere_data_id_88, o4_.lang_id AS lang_id_89, o4_.update_by_id AS update_by_id_90, s5_.lang_id AS lang_id_91, s5_.compiere_data_id AS compiere_data_id_92, s5_.update_by_id AS update_by_id_93 FROM compiere_data c0_ LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id WHERE c0_.gencode = ? AND c0_.lang_id = ?
Parameters: 
[
  "7180000100151"
  1
]
View formatted query    View runnable query    Explain query
13 14.59 ms 
SELECT c0_.id AS id_0, c0_.gencode AS gencode_1, c0_.category_id AS category_id_2, c0_.category_web AS category_web_3, c0_.nom AS nom_4, c0_.description AS description_5, c0_.description_en AS description_en_6, c0_.product_id AS product_id_7, c0_.type_embarque_id AS type_embarque_id_8, c0_.duration AS duration_9, c0_.ecotax_no_tax AS ecotax_no_tax_10, c0_.price_no_tax AS price_no_tax_11, c0_.price_with_tax AS price_with_tax_12, c0_.guarantee_days AS guarantee_days_13, c0_.periodicity AS periodicity_14, c0_.renewal AS renewal_15, c0_.tax_rate AS tax_rate_16, c0_.tax_rate_id AS tax_rate_id_17, c0_.tax_value AS tax_value_18, c0_.transferrable AS transferrable_19, c0_.weight AS weight_20, c0_.actif AS actif_21, c0_.stock AS stock_22, c0_.document_note AS document_note_23, c0_.linked_brand AS linked_brand_24, c0_.country_id AS country_id_25, c0_.service_package_id AS service_package_id_26, c0_.yearly AS yearly_27, c0_.partenaire_id AS partenaire_id_28, c0_.update_date AS update_date_29, c0_.products_linked AS products_linked_30, l1_.id AS id_31, l1_.iso_lang AS iso_lang_32, l1_.default_lang AS default_lang_33, d2_.id AS id_34, d2_.gencode AS gencode_35, d2_.nom_cms AS nom_cms_36, d2_.nom AS nom_37, d2_.sub_title AS sub_title_38, d2_.publish AS publish_39, d2_.alias AS alias_40, d2_.stock AS stock_41, d2_.gabarit_path AS gabarit_path_42, d2_.title AS title_43, d2_.metadata AS metadata_44, d2_.video AS video_45, d2_.date_update AS date_update_46, d2_.click_to_store AS click_to_store_47, d2_.user_manual AS user_manual_48, d2_.advertising AS advertising_49, a3_.id AS id_50, a3_.nom_cms AS nom_cms_51, a3_.nom AS nom_52, a3_.title AS title_53, a3_.sub_title AS sub_title_54, a3_.accroche_commerciale AS accroche_commerciale_55, a3_.publish AS publish_56, a3_.alias AS alias_57, a3_.stock AS stock_58, a3_.gencode AS gencode_59, a3_.gabarit_path AS gabarit_path_60, a3_.metadata AS metadata_61, a3_.date_update AS date_update_62, a3_.ordering AS ordering_63, o4_.id AS id_64, o4_.nom AS nom_65, o4_.nom_cms AS nom_cms_66, o4_.title AS title_67, o4_.description AS description_68, o4_.gencode AS gencode_69, o4_.date_update AS date_update_70, o4_.publish AS publish_71, o4_.sub_title AS sub_title_72, s5_.id AS id_73, s5_.nom AS nom_74, s5_.nom_cms AS nom_cms_75, s5_.gencode AS gencode_76, s5_.date_update AS date_update_77, s5_.publish AS publish_78, c0_.lang_id AS lang_id_79, l1_.country_id AS country_id_80, d2_.lang_id AS lang_id_81, d2_.compiere_data_id AS compiere_data_id_82, d2_.update_by_id AS update_by_id_83, a3_.lang_id AS lang_id_84, a3_.compiere_data_id AS compiere_data_id_85, a3_.category_id AS category_id_86, a3_.update_by_id AS update_by_id_87, o4_.compiere_data_id AS compiere_data_id_88, o4_.lang_id AS lang_id_89, o4_.update_by_id AS update_by_id_90, s5_.lang_id AS lang_id_91, s5_.compiere_data_id AS compiere_data_id_92, s5_.update_by_id AS update_by_id_93 FROM compiere_data c0_ LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id WHERE c0_.gencode = ? AND c0_.lang_id = ?
Parameters: 
[
  "7180000100153"
  1
]
View formatted query    View runnable query    Explain query
14 13.03 ms 
SELECT c0_.id AS id_0, c0_.gencode AS gencode_1, c0_.category_id AS category_id_2, c0_.category_web AS category_web_3, c0_.nom AS nom_4, c0_.description AS description_5, c0_.description_en AS description_en_6, c0_.product_id AS product_id_7, c0_.type_embarque_id AS type_embarque_id_8, c0_.duration AS duration_9, c0_.ecotax_no_tax AS ecotax_no_tax_10, c0_.price_no_tax AS price_no_tax_11, c0_.price_with_tax AS price_with_tax_12, c0_.guarantee_days AS guarantee_days_13, c0_.periodicity AS periodicity_14, c0_.renewal AS renewal_15, c0_.tax_rate AS tax_rate_16, c0_.tax_rate_id AS tax_rate_id_17, c0_.tax_value AS tax_value_18, c0_.transferrable AS transferrable_19, c0_.weight AS weight_20, c0_.actif AS actif_21, c0_.stock AS stock_22, c0_.document_note AS document_note_23, c0_.linked_brand AS linked_brand_24, c0_.country_id AS country_id_25, c0_.service_package_id AS service_package_id_26, c0_.yearly AS yearly_27, c0_.partenaire_id AS partenaire_id_28, c0_.update_date AS update_date_29, c0_.products_linked AS products_linked_30, l1_.id AS id_31, l1_.iso_lang AS iso_lang_32, l1_.default_lang AS default_lang_33, d2_.id AS id_34, d2_.gencode AS gencode_35, d2_.nom_cms AS nom_cms_36, d2_.nom AS nom_37, d2_.sub_title AS sub_title_38, d2_.publish AS publish_39, d2_.alias AS alias_40, d2_.stock AS stock_41, d2_.gabarit_path AS gabarit_path_42, d2_.title AS title_43, d2_.metadata AS metadata_44, d2_.video AS video_45, d2_.date_update AS date_update_46, d2_.click_to_store AS click_to_store_47, d2_.user_manual AS user_manual_48, d2_.advertising AS advertising_49, a3_.id AS id_50, a3_.nom_cms AS nom_cms_51, a3_.nom AS nom_52, a3_.title AS title_53, a3_.sub_title AS sub_title_54, a3_.accroche_commerciale AS accroche_commerciale_55, a3_.publish AS publish_56, a3_.alias AS alias_57, a3_.stock AS stock_58, a3_.gencode AS gencode_59, a3_.gabarit_path AS gabarit_path_60, a3_.metadata AS metadata_61, a3_.date_update AS date_update_62, a3_.ordering AS ordering_63, o4_.id AS id_64, o4_.nom AS nom_65, o4_.nom_cms AS nom_cms_66, o4_.title AS title_67, o4_.description AS description_68, o4_.gencode AS gencode_69, o4_.date_update AS date_update_70, o4_.publish AS publish_71, o4_.sub_title AS sub_title_72, s5_.id AS id_73, s5_.nom AS nom_74, s5_.nom_cms AS nom_cms_75, s5_.gencode AS gencode_76, s5_.date_update AS date_update_77, s5_.publish AS publish_78, c0_.lang_id AS lang_id_79, l1_.country_id AS country_id_80, d2_.lang_id AS lang_id_81, d2_.compiere_data_id AS compiere_data_id_82, d2_.update_by_id AS update_by_id_83, a3_.lang_id AS lang_id_84, a3_.compiere_data_id AS compiere_data_id_85, a3_.category_id AS category_id_86, a3_.update_by_id AS update_by_id_87, o4_.compiere_data_id AS compiere_data_id_88, o4_.lang_id AS lang_id_89, o4_.update_by_id AS update_by_id_90, s5_.lang_id AS lang_id_91, s5_.compiere_data_id AS compiere_data_id_92, s5_.update_by_id AS update_by_id_93 FROM compiere_data c0_ LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id WHERE c0_.gencode = ? AND c0_.lang_id = ?
Parameters: 
[
  "2000000000051"
  1
]
View formatted query    View runnable query    Explain query
15 9.37 ms 
SELECT c0_.id AS id_0, c0_.gencode AS gencode_1, c0_.category_id AS category_id_2, c0_.category_web AS category_web_3, c0_.nom AS nom_4, c0_.description AS description_5, c0_.description_en AS description_en_6, c0_.product_id AS product_id_7, c0_.type_embarque_id AS type_embarque_id_8, c0_.duration AS duration_9, c0_.ecotax_no_tax AS ecotax_no_tax_10, c0_.price_no_tax AS price_no_tax_11, c0_.price_with_tax AS price_with_tax_12, c0_.guarantee_days AS guarantee_days_13, c0_.periodicity AS periodicity_14, c0_.renewal AS renewal_15, c0_.tax_rate AS tax_rate_16, c0_.tax_rate_id AS tax_rate_id_17, c0_.tax_value AS tax_value_18, c0_.transferrable AS transferrable_19, c0_.weight AS weight_20, c0_.actif AS actif_21, c0_.stock AS stock_22, c0_.document_note AS document_note_23, c0_.linked_brand AS linked_brand_24, c0_.country_id AS country_id_25, c0_.service_package_id AS service_package_id_26, c0_.yearly AS yearly_27, c0_.partenaire_id AS partenaire_id_28, c0_.update_date AS update_date_29, c0_.products_linked AS products_linked_30, l1_.id AS id_31, l1_.iso_lang AS iso_lang_32, l1_.default_lang AS default_lang_33, d2_.id AS id_34, d2_.gencode AS gencode_35, d2_.nom_cms AS nom_cms_36, d2_.nom AS nom_37, d2_.sub_title AS sub_title_38, d2_.publish AS publish_39, d2_.alias AS alias_40, d2_.stock AS stock_41, d2_.gabarit_path AS gabarit_path_42, d2_.title AS title_43, d2_.metadata AS metadata_44, d2_.video AS video_45, d2_.date_update AS date_update_46, d2_.click_to_store AS click_to_store_47, d2_.user_manual AS user_manual_48, d2_.advertising AS advertising_49, a3_.id AS id_50, a3_.nom_cms AS nom_cms_51, a3_.nom AS nom_52, a3_.title AS title_53, a3_.sub_title AS sub_title_54, a3_.accroche_commerciale AS accroche_commerciale_55, a3_.publish AS publish_56, a3_.alias AS alias_57, a3_.stock AS stock_58, a3_.gencode AS gencode_59, a3_.gabarit_path AS gabarit_path_60, a3_.metadata AS metadata_61, a3_.date_update AS date_update_62, a3_.ordering AS ordering_63, o4_.id AS id_64, o4_.nom AS nom_65, o4_.nom_cms AS nom_cms_66, o4_.title AS title_67, o4_.description AS description_68, o4_.gencode AS gencode_69, o4_.date_update AS date_update_70, o4_.publish AS publish_71, o4_.sub_title AS sub_title_72, s5_.id AS id_73, s5_.nom AS nom_74, s5_.nom_cms AS nom_cms_75, s5_.gencode AS gencode_76, s5_.date_update AS date_update_77, s5_.publish AS publish_78, c0_.lang_id AS lang_id_79, l1_.country_id AS country_id_80, d2_.lang_id AS lang_id_81, d2_.compiere_data_id AS compiere_data_id_82, d2_.update_by_id AS update_by_id_83, a3_.lang_id AS lang_id_84, a3_.compiere_data_id AS compiere_data_id_85, a3_.category_id AS category_id_86, a3_.update_by_id AS update_by_id_87, o4_.compiere_data_id AS compiere_data_id_88, o4_.lang_id AS lang_id_89, o4_.update_by_id AS update_by_id_90, s5_.lang_id AS lang_id_91, s5_.compiere_data_id AS compiere_data_id_92, s5_.update_by_id AS update_by_id_93 FROM compiere_data c0_ LEFT JOIN lang l1_ ON c0_.lang_id = l1_.id LEFT JOIN device d2_ ON c0_.id = d2_.compiere_data_id LEFT JOIN accessory a3_ ON c0_.id = a3_.compiere_data_id LEFT JOIN `option` o4_ ON c0_.id = o4_.compiere_data_id LEFT JOIN subscription s5_ ON c0_.id = s5_.compiere_data_id WHERE c0_.gencode = ? AND c0_.lang_id = ?
Parameters: 
[
  "2000000666687"
  1
]
View formatted query    View runnable query    Explain query

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\AccessoryCategory 21
App\Entity\Lang 7
App\Entity\CompiereData 6
App\Entity\Country 1
App\Entity\Device 1
App\Entity\ImageData 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.