Query Metrics
86
Database Queries
48
Different statements
83.51 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.28 ms (9.92%) |
16 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.work_keys AS work_keys_6, t0.slug AS slug_7, t0.entity_id AS entity_id_8, t9.position AS position_10, t9.id AS id_11, t9.date_add AS date_add_12, t9.date_upd AS date_upd_13, t9.deleted AS deleted_14, t9.locked AS locked_15, t9.is_draft AS is_draft_16, t9.can_be_deleted AS can_be_deleted_17, t9.owner_organization_id AS owner_organization_id_18, t9.section_id AS section_id_19, t9.thumbnail_id AS thumbnail_id_20, t9.author_id AS author_id_21 FROM app_blog_page_section_item_i18n t0 INNER JOIN app_blog_page_section_item t9 ON t0.entity_id = t9.id WHERE t0.entity_id = ?
Parameters:
[
236
]
|
|
7.38 ms (8.84%) |
9 |
SELECT t0.context_type AS context_type_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.actor_id AS actor_id_10, t11.lastname AS lastname_12, t11.firstname AS firstname_13, t11.birth_place AS birth_place_14, t11.birth_date AS birth_date_15, t11.gender AS gender_16, t11.id AS id_17, t11.date_add AS date_add_18, t11.date_upd AS date_upd_19, t11.deleted AS deleted_20, t11.locked AS locked_21, t11.is_draft AS is_draft_22, t11.can_be_deleted AS can_be_deleted_23, t11.owner_organization_id AS owner_organization_id_24, t11.access_id AS access_id_25, t11.author_id AS author_id_26, t0.organization_id AS organization_id_27, t28.name AS name_29, t28.is_plateform_manager AS is_plateform_manager_30, t28.id AS id_31, t28.date_add AS date_add_32, t28.date_upd AS date_upd_33, t28.deleted AS deleted_34, t28.locked AS locked_35, t28.is_draft AS is_draft_36, t28.can_be_deleted AS can_be_deleted_37, t28.owner_organization_id AS owner_organization_id_38, t28.actor_id AS actor_id_39, t28.thumbnail_id AS thumbnail_id_40, t28.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_core_user_workspace t0 INNER JOIN app_core_user_actor t11 ON t0.actor_id = t11.id INNER JOIN app_core_user_organization t28 ON t0.organization_id = t28.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.deleted = ? LIMIT 1
Parameters:
[
0
]
|
|
6.54 ms (7.83%) |
11 |
SELECT t0.name AS name_1, t0.code AS code_2, t0.value AS value_3, t0.clean_value AS clean_value_4, t0.id AS id_5, t0.date_add AS date_add_6, t0.date_upd AS date_upd_7, t0.deleted AS deleted_8, t0.locked AS locked_9, t0.is_draft AS is_draft_10, t0.can_be_deleted AS can_be_deleted_11, t0.owner_organization_id AS owner_organization_id_12, t0.author_id AS author_id_13, t14.lastname AS lastname_15, t14.firstname AS firstname_16, t14.birth_place AS birth_place_17, t14.birth_date AS birth_date_18, t14.gender AS gender_19, t14.id AS id_20, t14.date_add AS date_add_21, t14.date_upd AS date_upd_22, t14.deleted AS deleted_23, t14.locked AS locked_24, t14.is_draft AS is_draft_25, t14.can_be_deleted AS can_be_deleted_26, t14.owner_organization_id AS owner_organization_id_27, t14.access_id AS access_id_28, t14.author_id AS author_id_29 FROM app_core_parameter t0 LEFT JOIN app_core_user_actor t14 ON t0.author_id = t14.id WHERE t0.code = ? LIMIT 1
Parameters:
[
"param.app.main.phone.number"
]
|
|
5.86 ms (7.02%) |
1 |
SELECT DISTINCT id_3 FROM (SELECT DISTINCT id_3, position_2 FROM (SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_2 ASC) dctrn_result LIMIT 100000
Parameters:
[] |
|
3.43 ms (4.10%) |
1 |
SELECT t0.name AS name_1, t0.description AS description_2, t0.slug AS slug_3, t0.position AS position_4, t0.status AS status_5, t0.phone_number AS phone_number_6, t0.address AS address_7, t0.email AS email_8, t0.customer_service AS customer_service_9, t0.swift_code AS swift_code_10, t0.zip_code AS zip_code_11, t0.regular_address AS regular_address_12, t0.hours AS hours_13, t0.longitude AS longitude_14, t0.latitude AS latitude_15, t0.is_main AS is_main_16, t0.id AS id_17, t0.date_add AS date_add_18, t0.date_upd AS date_upd_19, t0.deleted AS deleted_20, t0.locked AS locked_21, t0.is_draft AS is_draft_22, t0.can_be_deleted AS can_be_deleted_23, t0.owner_organization_id AS owner_organization_id_24, t0.thumbnail_id AS thumbnail_id_25, t26.filename AS filename_27, t26.original_name AS original_name_28, t26.mime_type AS mime_type_29, t26.extension AS extension_30, t26.size AS size_31, t26.url AS url_32, t26.id AS id_33, t26.date_add AS date_add_34, t26.date_upd AS date_upd_35, t26.deleted AS deleted_36, t26.locked AS locked_37, t26.is_draft AS is_draft_38, t26.can_be_deleted AS can_be_deleted_39, t26.owner_organization_id AS owner_organization_id_40, t26.author_id AS author_id_41, t0.author_id AS author_id_42, t43.lastname AS lastname_44, t43.firstname AS firstname_45, t43.birth_place AS birth_place_46, t43.birth_date AS birth_date_47, t43.gender AS gender_48, t43.id AS id_49, t43.date_add AS date_add_50, t43.date_upd AS date_upd_51, t43.deleted AS deleted_52, t43.locked AS locked_53, t43.is_draft AS is_draft_54, t43.can_be_deleted AS can_be_deleted_55, t43.owner_organization_id AS owner_organization_id_56, t43.access_id AS access_id_57, t43.author_id AS author_id_58 FROM app_business_agency t0 LEFT JOIN app_core_attachment t26 ON t0.thumbnail_id = t26.id LEFT JOIN app_core_user_actor t43 ON t0.author_id = t43.id WHERE t0.is_main = ? AND t0.deleted = ? LIMIT 1
Parameters:
[ 1 0 ] |
|
3.38 ms (4.04%) |
1 |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.id = ?
Parameters:
[
25
]
|
|
3.32 ms (3.97%) |
1 |
SELECT t0.position AS position_1, t0.id AS id_2, t0.date_add AS date_add_3, t0.date_upd AS date_upd_4, t0.deleted AS deleted_5, t0.locked AS locked_6, t0.is_draft AS is_draft_7, t0.can_be_deleted AS can_be_deleted_8, t0.owner_organization_id AS owner_organization_id_9, t0.section_id AS section_id_10, t11.class_css AS class_css_12, t11.type AS type_13, t11.position AS position_14, t11.id AS id_15, t11.date_add AS date_add_16, t11.date_upd AS date_upd_17, t11.deleted AS deleted_18, t11.locked AS locked_19, t11.is_draft AS is_draft_20, t11.can_be_deleted AS can_be_deleted_21, t11.owner_organization_id AS owner_organization_id_22, t11.thumbnail_id AS thumbnail_id_23, t11.product_id AS product_id_24, t11.cms_page_id AS cms_page_id_25, t11.author_id AS author_id_26, t0.thumbnail_id AS thumbnail_id_27, t28.filename AS filename_29, t28.original_name AS original_name_30, t28.mime_type AS mime_type_31, t28.extension AS extension_32, t28.size AS size_33, t28.url AS url_34, t28.id AS id_35, t28.date_add AS date_add_36, t28.date_upd AS date_upd_37, t28.deleted AS deleted_38, t28.locked AS locked_39, t28.is_draft AS is_draft_40, t28.can_be_deleted AS can_be_deleted_41, t28.owner_organization_id AS owner_organization_id_42, t28.author_id AS author_id_43, t0.author_id AS author_id_44, t45.lastname AS lastname_46, t45.firstname AS firstname_47, t45.birth_place AS birth_place_48, t45.birth_date AS birth_date_49, t45.gender AS gender_50, t45.id AS id_51, t45.date_add AS date_add_52, t45.date_upd AS date_upd_53, t45.deleted AS deleted_54, t45.locked AS locked_55, t45.is_draft AS is_draft_56, t45.can_be_deleted AS can_be_deleted_57, t45.owner_organization_id AS owner_organization_id_58, t45.access_id AS access_id_59, t45.author_id AS author_id_60 FROM app_blog_page_section_item t0 LEFT JOIN app_blog_page_section t11 ON t0.section_id = t11.id LEFT JOIN app_core_attachment t28 ON t0.thumbnail_id = t28.id LEFT JOIN app_core_user_actor t45 ON t0.author_id = t45.id WHERE t0.section_id IN (?, ?, ?, ?)
Parameters:
[ 72 73 74 75 ] |
|
2.96 ms (3.54%) |
2 |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?)
Parameters:
[
25
]
|
|
2.86 ms (3.42%) |
1 |
SELECT DISTINCT id_9 FROM (SELECT DISTINCT id_9, publish_date_1 FROM (SELECT a0_.type AS type_0, a0_.publish_date AS publish_date_1, a0_.expiry_date AS expiry_date_2, a0_.source_url AS source_url_3, a0_.location AS location_4, a0_.status AS status_5, a0_.is_editor_choice AS is_editor_choice_6, a0_.hide_title AS hide_title_7, a0_.hide_excerpt AS hide_excerpt_8, a0_.id AS id_9, a0_.date_add AS date_add_10, a0_.date_upd AS date_upd_11, a0_.deleted AS deleted_12, a0_.locked AS locked_13, a0_.is_draft AS is_draft_14, a0_.can_be_deleted AS can_be_deleted_15, a0_.owner_organization_id AS owner_organization_id_16, a1_.excerpt AS excerpt_17, a1_.intro AS intro_18, a1_.id AS id_19, a1_.locale AS locale_20, a1_.name AS name_21, a1_.description AS description_22, a1_.meta_description AS meta_description_23, a1_.work_keys AS work_keys_24, a1_.slug AS slug_25, a2_.color AS color_26, a2_.bg_color AS bg_color_27, a2_.type AS type_28, a2_.target AS target_29, a2_.target_menu AS target_menu_30, a2_.client_type AS client_type_31, a2_.position AS position_32, a2_.status AS status_33, a2_.id AS id_34, a2_.date_add AS date_add_35, a2_.date_upd AS date_upd_36, a2_.deleted AS deleted_37, a2_.locked AS locked_38, a2_.is_draft AS is_draft_39, a2_.can_be_deleted AS can_be_deleted_40, a2_.owner_organization_id AS owner_organization_id_41 FROM app_blog_post a0_ INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a0_.deleted = 0) dctrn_result_inner ORDER BY publish_date_1 DESC) dctrn_result LIMIT 4
Parameters:
[] |
|
2.85 ms (3.42%) |
1 |
SELECT DISTINCT id_6 FROM (SELECT DISTINCT id_6, position_4 FROM (SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_4 ASC) dctrn_result LIMIT 10
Parameters:
[] |
|
2.48 ms (2.97%) |
2 |
SELECT t0.title AS title_1, t0.sub_title AS sub_title_2, t0.excerpt AS excerpt_3, t0.id AS id_4, t0.locale AS locale_5, t0.name AS name_6, t0.description AS description_7, t0.meta_description AS meta_description_8, t0.work_keys AS work_keys_9, t0.slug AS slug_10, t0.entity_id AS entity_id_11, t12.is_downloaded AS is_downloaded_13, t12.is_show_page AS is_show_page_14, t12.code AS code_15, t12.type AS type_16, t12.status AS status_17, t12.id AS id_18, t12.date_add AS date_add_19, t12.date_upd AS date_upd_20, t12.deleted AS deleted_21, t12.locked AS locked_22, t12.is_draft AS is_draft_23, t12.can_be_deleted AS can_be_deleted_24, t12.owner_organization_id AS owner_organization_id_25, t12.attachment_id AS attachment_id_26, t12.author_id AS author_id_27 FROM app_core_cms_page_i18n t0 INNER JOIN app_core_cms_page t12 ON t0.entity_id = t12.id WHERE t0.entity_id = ?
Parameters:
[
33
]
|
|
2.37 ms (2.84%) |
1 |
SELECT DISTINCT id_5 FROM (SELECT DISTINCT id_5, date_add_6 FROM (SELECT a0_.is_downloaded AS is_downloaded_0, a0_.is_show_page AS is_show_page_1, a0_.code AS code_2, a0_.type AS type_3, a0_.status AS status_4, a0_.id AS id_5, a0_.date_add AS date_add_6, a0_.date_upd AS date_upd_7, a0_.deleted AS deleted_8, a0_.locked AS locked_9, a0_.is_draft AS is_draft_10, a0_.can_be_deleted AS can_be_deleted_11, a0_.owner_organization_id AS owner_organization_id_12, a1_.title AS title_13, a1_.sub_title AS sub_title_14, a1_.excerpt AS excerpt_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_core_cms_page a0_ INNER JOIN app_core_cms_page_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.type = 'condition' AND a0_.deleted = 0) dctrn_result_inner ORDER BY date_add_6 DESC) dctrn_result LIMIT 10
Parameters:
[] |
|
2.34 ms (2.81%) |
1 |
SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10
Parameters:
[] |
|
2.28 ms (2.74%) |
1 |
SELECT t0.address AS address_1, t0.regular_address AS regular_address_2, t0.footer_address AS footer_address_3, t0.hours AS hours_4, t0.id AS id_5, t0.locale AS locale_6, t0.name AS name_7, t0.description AS description_8, t0.meta_description AS meta_description_9, t0.work_keys AS work_keys_10, t0.slug AS slug_11, t0.entity_id AS entity_id_12, t13.name AS name_14, t13.description AS description_15, t13.slug AS slug_16, t13.position AS position_17, t13.status AS status_18, t13.phone_number AS phone_number_19, t13.address AS address_20, t13.email AS email_21, t13.customer_service AS customer_service_22, t13.swift_code AS swift_code_23, t13.zip_code AS zip_code_24, t13.regular_address AS regular_address_25, t13.hours AS hours_26, t13.longitude AS longitude_27, t13.latitude AS latitude_28, t13.is_main AS is_main_29, t13.id AS id_30, t13.date_add AS date_add_31, t13.date_upd AS date_upd_32, t13.deleted AS deleted_33, t13.locked AS locked_34, t13.is_draft AS is_draft_35, t13.can_be_deleted AS can_be_deleted_36, t13.owner_organization_id AS owner_organization_id_37, t13.thumbnail_id AS thumbnail_id_38, t13.author_id AS author_id_39 FROM app_business_agency_i18n t0 INNER JOIN app_business_agency t13 ON t0.entity_id = t13.id WHERE t0.entity_id = ?
Parameters:
[
1
]
|
|
1.90 ms (2.28%) |
2 |
SELECT t0.is_downloaded AS is_downloaded_1, t0.is_show_page AS is_show_page_2, t0.code AS code_3, t0.type AS type_4, t0.status AS status_5, t0.id AS id_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8, t0.deleted AS deleted_9, t0.locked AS locked_10, t0.is_draft AS is_draft_11, t0.can_be_deleted AS can_be_deleted_12, t0.owner_organization_id AS owner_organization_id_13, t0.attachment_id AS attachment_id_14, t15.filename AS filename_16, t15.original_name AS original_name_17, t15.mime_type AS mime_type_18, t15.extension AS extension_19, t15.size AS size_20, t15.url AS url_21, t15.id AS id_22, t15.date_add AS date_add_23, t15.date_upd AS date_upd_24, t15.deleted AS deleted_25, t15.locked AS locked_26, t15.is_draft AS is_draft_27, t15.can_be_deleted AS can_be_deleted_28, t15.owner_organization_id AS owner_organization_id_29, t15.author_id AS author_id_30, t0.author_id AS author_id_31, t32.lastname AS lastname_33, t32.firstname AS firstname_34, t32.birth_place AS birth_place_35, t32.birth_date AS birth_date_36, t32.gender AS gender_37, t32.id AS id_38, t32.date_add AS date_add_39, t32.date_upd AS date_upd_40, t32.deleted AS deleted_41, t32.locked AS locked_42, t32.is_draft AS is_draft_43, t32.can_be_deleted AS can_be_deleted_44, t32.owner_organization_id AS owner_organization_id_45, t32.access_id AS access_id_46, t32.author_id AS author_id_47 FROM app_core_cms_page t0 LEFT JOIN app_core_attachment t15 ON t0.attachment_id = t15.id LEFT JOIN app_core_user_actor t32 ON t0.author_id = t32.id WHERE t0.code = ? LIMIT 1
Parameters:
[
"app.privacy.policy"
]
|
|
1.85 ms (2.22%) |
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.work_keys AS work_keys_6, t0.slug AS slug_7, t0.entity_id AS entity_id_8, t9.name AS name_10, t9.url AS url_11, t9.description AS description_12, t9.type AS type_13, t9.position AS position_14, t9.status AS status_15, t9.id AS id_16, t9.date_add AS date_add_17, t9.date_upd AS date_upd_18, t9.deleted AS deleted_19, t9.locked AS locked_20, t9.is_draft AS is_draft_21, t9.can_be_deleted AS can_be_deleted_22, t9.owner_organization_id AS owner_organization_id_23, t9.thumbnail_id AS thumbnail_id_24, t9.author_id AS author_id_25 FROM app_business_website_i18n t0 INNER JOIN app_business_website t9 ON t0.entity_id = t9.id WHERE t0.entity_id = ?
Parameters:
[
1
]
|
|
1.78 ms (2.13%) |
1 |
SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10
Parameters:
[] |
|
1.78 ms (2.13%) |
1 |
SELECT t0.sub_title AS sub_title_1, t0.id AS id_2, t0.locale AS locale_3, t0.name AS name_4, t0.description AS description_5, t0.meta_description AS meta_description_6, t0.work_keys AS work_keys_7, t0.slug AS slug_8, t0.entity_id AS entity_id_9, t10.status AS status_11, t10.target AS target_12, t10.group_type AS group_type_13, t10.target_menu AS target_menu_14, t10.client_type AS client_type_15, t10.lend_type AS lend_type_16, t10.lend_types AS lend_types_17, t10.show_in_menu AS show_in_menu_18, t10.show_title AS show_title_19, t10.position AS position_20, t10.anchor AS anchor_21, t10.id AS id_22, t10.date_add AS date_add_23, t10.date_upd AS date_upd_24, t10.deleted AS deleted_25, t10.locked AS locked_26, t10.is_draft AS is_draft_27, t10.can_be_deleted AS can_be_deleted_28, t10.owner_organization_id AS owner_organization_id_29, t10.type_id AS type_id_30, t10.parent_id AS parent_id_31, t10.thumbnail_id AS thumbnail_id_32, t10.author_id AS author_id_33 FROM app_business_product_i18n t0 INNER JOIN app_business_product t10 ON t0.entity_id = t10.id WHERE t0.entity_id = ?
Parameters:
[
25
]
|
|
1.76 ms (2.11%) |
1 |
SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50, a0_.thumbnail_id AS thumbnail_id_51, a0_.product_id AS product_id_52, a0_.cms_page_id AS cms_page_id_53, a0_.author_id AS author_id_54, a1_.entity_id AS entity_id_55, a2_.type_id AS type_id_56, a2_.parent_id AS parent_id_57, a2_.thumbnail_id AS thumbnail_id_58, a2_.author_id AS author_id_59, a3_.attachment_id AS attachment_id_60, a3_.author_id AS author_id_61 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?, ?) ORDER BY a0_.position ASC
Parameters:
[ 72 73 74 75 ] |
|
1.35 ms (1.62%) |
3 |
SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?)
Parameters:
[ 206 214 ] |
|
1.27 ms (1.52%) |
1 |
SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (?) ORDER BY a0_.position ASC
Parameters:
[
23
]
|
|
0.92 ms (1.10%) |
1 |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?)
Parameters:
[ 41 26 ] |
|
0.76 ms (0.91%) |
1 |
SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10
Parameters:
[] |
|
0.75 ms (0.90%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_6 FROM (SELECT a0_.name AS name_0, a0_.url AS url_1, a0_.description AS description_2, a0_.type AS type_3, a0_.position AS position_4, a0_.status AS status_5, a0_.id AS id_6, a0_.date_add AS date_add_7, a0_.date_upd AS date_upd_8, a0_.deleted AS deleted_9, a0_.locked AS locked_10, a0_.is_draft AS is_draft_11, a0_.can_be_deleted AS can_be_deleted_12, a0_.owner_organization_id AS owner_organization_id_13, a1_.id AS id_14, a1_.locale AS locale_15, a1_.name AS name_16, a1_.description AS description_17, a1_.meta_description AS meta_description_18, a1_.work_keys AS work_keys_19, a1_.slug AS slug_20 FROM app_business_website a0_ INNER JOIN app_business_website_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'url' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.73 ms (0.88%) |
1 |
SELECT a0_.is_downloaded AS is_downloaded_0, a0_.is_show_page AS is_show_page_1, a0_.code AS code_2, a0_.type AS type_3, a0_.status AS status_4, a0_.id AS id_5, a0_.date_add AS date_add_6, a0_.date_upd AS date_upd_7, a0_.deleted AS deleted_8, a0_.locked AS locked_9, a0_.is_draft AS is_draft_10, a0_.can_be_deleted AS can_be_deleted_11, a0_.owner_organization_id AS owner_organization_id_12, a1_.title AS title_13, a1_.sub_title AS sub_title_14, a1_.excerpt AS excerpt_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22, a0_.attachment_id AS attachment_id_23, a0_.author_id AS author_id_24, a1_.entity_id AS entity_id_25 FROM app_core_cms_page a0_ INNER JOIN app_core_cms_page_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.type = 'general_information' AND a0_.deleted = 0 AND a0_.id IN (?, ?) ORDER BY a0_.date_add DESC
Parameters:
[ 2 3 ] |
|
0.71 ms (0.85%) |
1 |
SELECT a0_.is_downloaded AS is_downloaded_0, a0_.is_show_page AS is_show_page_1, a0_.code AS code_2, a0_.type AS type_3, a0_.status AS status_4, a0_.id AS id_5, a0_.date_add AS date_add_6, a0_.date_upd AS date_upd_7, a0_.deleted AS deleted_8, a0_.locked AS locked_9, a0_.is_draft AS is_draft_10, a0_.can_be_deleted AS can_be_deleted_11, a0_.owner_organization_id AS owner_organization_id_12, a1_.title AS title_13, a1_.sub_title AS sub_title_14, a1_.excerpt AS excerpt_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22, a0_.attachment_id AS attachment_id_23, a0_.author_id AS author_id_24, a1_.entity_id AS entity_id_25 FROM app_core_cms_page a0_ INNER JOIN app_core_cms_page_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.type = 'condition' AND a0_.deleted = 0 AND a0_.id IN (?, ?) ORDER BY a0_.date_add DESC
Parameters:
[ 13 12 ] |
|
0.69 ms (0.83%) |
1 |
SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY a0_.position ASC
Parameters:
[ 29 30 19 20 21 22 ] |
|
0.67 ms (0.81%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'physical_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.64 ms (0.77%) |
1 |
SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42, a0_.type_id AS type_id_43, a0_.parent_id AS parent_id_44, a0_.thumbnail_id AS thumbnail_id_45, a0_.author_id AS author_id_46, a1_.entity_id AS entity_id_47, a2_.author_id AS author_id_48 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 AND a0_.id IN (?, ?, ?) ORDER BY a0_.position ASC
Parameters:
[ 41 25 26 ] |
|
0.63 ms (0.76%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'physical_person' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.63 ms (0.75%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT a0_.is_downloaded AS is_downloaded_0, a0_.is_show_page AS is_show_page_1, a0_.code AS code_2, a0_.type AS type_3, a0_.status AS status_4, a0_.id AS id_5, a0_.date_add AS date_add_6, a0_.date_upd AS date_upd_7, a0_.deleted AS deleted_8, a0_.locked AS locked_9, a0_.is_draft AS is_draft_10, a0_.can_be_deleted AS can_be_deleted_11, a0_.owner_organization_id AS owner_organization_id_12, a1_.title AS title_13, a1_.sub_title AS sub_title_14, a1_.excerpt AS excerpt_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_core_cms_page a0_ INNER JOIN app_core_cms_page_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.type = 'condition' AND a0_.deleted = 0 ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.58 ms (0.69%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT a0_.class_css AS class_css_0, a0_.type AS type_1, a0_.position AS position_2, a0_.id AS id_3, a0_.date_add AS date_add_4, a0_.date_upd AS date_upd_5, a0_.deleted AS deleted_6, a0_.locked AS locked_7, a0_.is_draft AS is_draft_8, a0_.can_be_deleted AS can_be_deleted_9, a0_.owner_organization_id AS owner_organization_id_10, a1_.sub_title AS sub_title_11, a1_.id AS id_12, a1_.locale AS locale_13, a1_.name AS name_14, a1_.description AS description_15, a1_.meta_description AS meta_description_16, a1_.work_keys AS work_keys_17, a1_.slug AS slug_18, a2_.status AS status_19, a2_.target AS target_20, a2_.group_type AS group_type_21, a2_.target_menu AS target_menu_22, a2_.client_type AS client_type_23, a2_.lend_type AS lend_type_24, a2_.lend_types AS lend_types_25, a2_.show_in_menu AS show_in_menu_26, a2_.show_title AS show_title_27, a2_.position AS position_28, a2_.anchor AS anchor_29, a2_.id AS id_30, a2_.date_add AS date_add_31, a2_.date_upd AS date_upd_32, a2_.deleted AS deleted_33, a2_.locked AS locked_34, a2_.is_draft AS is_draft_35, a2_.can_be_deleted AS can_be_deleted_36, a2_.owner_organization_id AS owner_organization_id_37, a3_.is_downloaded AS is_downloaded_38, a3_.is_show_page AS is_show_page_39, a3_.code AS code_40, a3_.type AS type_41, a3_.status AS status_42, a3_.id AS id_43, a3_.date_add AS date_add_44, a3_.date_upd AS date_upd_45, a3_.deleted AS deleted_46, a3_.locked AS locked_47, a3_.is_draft AS is_draft_48, a3_.can_be_deleted AS can_be_deleted_49, a3_.owner_organization_id AS owner_organization_id_50 FROM app_blog_page_section a0_ INNER JOIN app_blog_page_section_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_product a2_ ON a0_.product_id = a2_.id LEFT JOIN app_core_cms_page a3_ ON a0_.cms_page_id = a3_.id WHERE a0_.deleted = 0 AND a2_.id = '25' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.57 ms (0.69%) |
1 |
SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?)
Parameters:
[
197
]
|
|
0.56 ms (0.67%) |
1 |
SELECT t0.name AS name_1, t0.url AS url_2, t0.description AS description_3, t0.type AS type_4, t0.position AS position_5, t0.status AS status_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.thumbnail_id AS thumbnail_id_15, t16.filename AS filename_17, t16.original_name AS original_name_18, t16.mime_type AS mime_type_19, t16.extension AS extension_20, t16.size AS size_21, t16.url AS url_22, t16.id AS id_23, t16.date_add AS date_add_24, t16.date_upd AS date_upd_25, t16.deleted AS deleted_26, t16.locked AS locked_27, t16.is_draft AS is_draft_28, t16.can_be_deleted AS can_be_deleted_29, t16.owner_organization_id AS owner_organization_id_30, t16.author_id AS author_id_31, t0.author_id AS author_id_32, t33.lastname AS lastname_34, t33.firstname AS firstname_35, t33.birth_place AS birth_place_36, t33.birth_date AS birth_date_37, t33.gender AS gender_38, t33.id AS id_39, t33.date_add AS date_add_40, t33.date_upd AS date_upd_41, t33.deleted AS deleted_42, t33.locked AS locked_43, t33.is_draft AS is_draft_44, t33.can_be_deleted AS can_be_deleted_45, t33.owner_organization_id AS owner_organization_id_46, t33.access_id AS access_id_47, t33.author_id AS author_id_48 FROM app_business_website t0 LEFT JOIN app_core_attachment t16 ON t0.thumbnail_id = t16.id LEFT JOIN app_core_user_actor t33 ON t0.author_id = t33.id WHERE t0.type = ? LIMIT 1
Parameters:
[
"code_qr"
]
|
|
0.53 ms (0.64%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'bank_insurance' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.53 ms (0.63%) |
1 |
SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'moral_person' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10
Parameters:
[] |
|
0.52 ms (0.62%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.51 ms (0.61%) |
1 |
SELECT DISTINCT id_11 FROM (SELECT DISTINCT id_11, position_9 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'moral_person' AND a0_.type_id IS NULL AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_9 ASC) dctrn_result LIMIT 10
Parameters:
[] |
|
0.51 ms (0.61%) |
1 |
SELECT t0.email AS email_1, t0.token AS token_2, t0.confirmation_token AS confirmation_token_3, t0.context_type AS context_type_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.is_blocked AS is_blocked_7, t0.roles AS roles_8, t0.id AS id_9, t0.date_add AS date_add_10, t0.date_upd AS date_upd_11, t0.deleted AS deleted_12, t0.locked AS locked_13, t0.is_draft AS is_draft_14, t0.can_be_deleted AS can_be_deleted_15, t0.owner_organization_id AS owner_organization_id_16, t17.lastname AS lastname_18, t17.firstname AS firstname_19, t17.birth_place AS birth_place_20, t17.birth_date AS birth_date_21, t17.gender AS gender_22, t17.id AS id_23, t17.date_add AS date_add_24, t17.date_upd AS date_upd_25, t17.deleted AS deleted_26, t17.locked AS locked_27, t17.is_draft AS is_draft_28, t17.can_be_deleted AS can_be_deleted_29, t17.owner_organization_id AS owner_organization_id_30, t17.access_id AS access_id_31, t17.author_id AS author_id_32, t0.author_id AS author_id_33, t34.lastname AS lastname_35, t34.firstname AS firstname_36, t34.birth_place AS birth_place_37, t34.birth_date AS birth_date_38, t34.gender AS gender_39, t34.id AS id_40, t34.date_add AS date_add_41, t34.date_upd AS date_upd_42, t34.deleted AS deleted_43, t34.locked AS locked_44, t34.is_draft AS is_draft_45, t34.can_be_deleted AS can_be_deleted_46, t34.owner_organization_id AS owner_organization_id_47, t34.access_id AS access_id_48, t34.author_id AS author_id_49 FROM app_core_user_access t0 LEFT JOIN app_core_user_actor t17 ON t17.access_id = t0.id LEFT JOIN app_core_user_actor t34 ON t0.author_id = t34.id WHERE t0.id IN (?)
Parameters:
[
1
]
|
|
0.50 ms (0.60%) |
1 |
SELECT t0.status AS status_1, t0.target AS target_2, t0.group_type AS group_type_3, t0.target_menu AS target_menu_4, t0.client_type AS client_type_5, t0.lend_type AS lend_type_6, t0.lend_types AS lend_types_7, t0.show_in_menu AS show_in_menu_8, t0.show_title AS show_title_9, t0.position AS position_10, t0.anchor AS anchor_11, t0.id AS id_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.deleted AS deleted_15, t0.locked AS locked_16, t0.is_draft AS is_draft_17, t0.can_be_deleted AS can_be_deleted_18, t0.owner_organization_id AS owner_organization_id_19, t0.type_id AS type_id_20, t21.color AS color_22, t21.bg_color AS bg_color_23, t21.type AS type_24, t21.target AS target_25, t21.target_menu AS target_menu_26, t21.client_type AS client_type_27, t21.position AS position_28, t21.status AS status_29, t21.id AS id_30, t21.date_add AS date_add_31, t21.date_upd AS date_upd_32, t21.deleted AS deleted_33, t21.locked AS locked_34, t21.is_draft AS is_draft_35, t21.can_be_deleted AS can_be_deleted_36, t21.owner_organization_id AS owner_organization_id_37, t21.author_id AS author_id_38, t0.parent_id AS parent_id_39, t40.status AS status_41, t40.target AS target_42, t40.group_type AS group_type_43, t40.target_menu AS target_menu_44, t40.client_type AS client_type_45, t40.lend_type AS lend_type_46, t40.lend_types AS lend_types_47, t40.show_in_menu AS show_in_menu_48, t40.show_title AS show_title_49, t40.position AS position_50, t40.anchor AS anchor_51, t40.id AS id_52, t40.date_add AS date_add_53, t40.date_upd AS date_upd_54, t40.deleted AS deleted_55, t40.locked AS locked_56, t40.is_draft AS is_draft_57, t40.can_be_deleted AS can_be_deleted_58, t40.owner_organization_id AS owner_organization_id_59, t40.type_id AS type_id_60, t40.parent_id AS parent_id_61, t40.thumbnail_id AS thumbnail_id_62, t40.author_id AS author_id_63, t0.thumbnail_id AS thumbnail_id_64, t65.filename AS filename_66, t65.original_name AS original_name_67, t65.mime_type AS mime_type_68, t65.extension AS extension_69, t65.size AS size_70, t65.url AS url_71, t65.id AS id_72, t65.date_add AS date_add_73, t65.date_upd AS date_upd_74, t65.deleted AS deleted_75, t65.locked AS locked_76, t65.is_draft AS is_draft_77, t65.can_be_deleted AS can_be_deleted_78, t65.owner_organization_id AS owner_organization_id_79, t65.author_id AS author_id_80, t0.author_id AS author_id_81, t82.lastname AS lastname_83, t82.firstname AS firstname_84, t82.birth_place AS birth_place_85, t82.birth_date AS birth_date_86, t82.gender AS gender_87, t82.id AS id_88, t82.date_add AS date_add_89, t82.date_upd AS date_upd_90, t82.deleted AS deleted_91, t82.locked AS locked_92, t82.is_draft AS is_draft_93, t82.can_be_deleted AS can_be_deleted_94, t82.owner_organization_id AS owner_organization_id_95, t82.access_id AS access_id_96, t82.author_id AS author_id_97 FROM app_business_product t0 LEFT JOIN app_business_category t21 ON t0.type_id = t21.id LEFT JOIN app_business_product t40 ON t0.parent_id = t40.id LEFT JOIN app_core_attachment t65 ON t0.thumbnail_id = t65.id LEFT JOIN app_core_user_actor t82 ON t0.author_id = t82.id WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ 29 30 19 20 21 22 ] |
|
0.49 ms (0.59%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_11 FROM (SELECT a0_.status AS status_0, a0_.target AS target_1, a0_.group_type AS group_type_2, a0_.target_menu AS target_menu_3, a0_.client_type AS client_type_4, a0_.lend_type AS lend_type_5, a0_.lend_types AS lend_types_6, a0_.show_in_menu AS show_in_menu_7, a0_.show_title AS show_title_8, a0_.position AS position_9, a0_.anchor AS anchor_10, a0_.id AS id_11, a0_.date_add AS date_add_12, a0_.date_upd AS date_upd_13, a0_.deleted AS deleted_14, a0_.locked AS locked_15, a0_.is_draft AS is_draft_16, a0_.can_be_deleted AS can_be_deleted_17, a0_.owner_organization_id AS owner_organization_id_18, a1_.sub_title AS sub_title_19, a1_.id AS id_20, a1_.locale AS locale_21, a1_.name AS name_22, a1_.description AS description_23, a1_.meta_description AS meta_description_24, a1_.work_keys AS work_keys_25, a1_.slug AS slug_26, a2_.color AS color_27, a2_.bg_color AS bg_color_28, a2_.type AS type_29, a2_.target AS target_30, a2_.target_menu AS target_menu_31, a2_.client_type AS client_type_32, a2_.position AS position_33, a2_.status AS status_34, a2_.id AS id_35, a2_.date_add AS date_add_36, a2_.date_upd AS date_upd_37, a2_.deleted AS deleted_38, a2_.locked AS locked_39, a2_.is_draft AS is_draft_40, a2_.can_be_deleted AS can_be_deleted_41, a2_.owner_organization_id AS owner_organization_id_42 FROM app_business_product a0_ INNER JOIN app_business_product_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_business_category a2_ ON a0_.type_id = a2_.id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.target_menu = 'bank_insurance' AND a0_.type_id IS NULL AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.48 ms (0.58%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_9 FROM (SELECT a0_.type AS type_0, a0_.publish_date AS publish_date_1, a0_.expiry_date AS expiry_date_2, a0_.source_url AS source_url_3, a0_.location AS location_4, a0_.status AS status_5, a0_.is_editor_choice AS is_editor_choice_6, a0_.hide_title AS hide_title_7, a0_.hide_excerpt AS hide_excerpt_8, a0_.id AS id_9, a0_.date_add AS date_add_10, a0_.date_upd AS date_upd_11, a0_.deleted AS deleted_12, a0_.locked AS locked_13, a0_.is_draft AS is_draft_14, a0_.can_be_deleted AS can_be_deleted_15, a0_.owner_organization_id AS owner_organization_id_16, a1_.excerpt AS excerpt_17, a1_.intro AS intro_18, a1_.id AS id_19, a1_.locale AS locale_20, a1_.name AS name_21, a1_.description AS description_22, a1_.meta_description AS meta_description_23, a1_.work_keys AS work_keys_24, a1_.slug AS slug_25, a2_.color AS color_26, a2_.bg_color AS bg_color_27, a2_.type AS type_28, a2_.target AS target_29, a2_.target_menu AS target_menu_30, a2_.client_type AS client_type_31, a2_.position AS position_32, a2_.status AS status_33, a2_.id AS id_34, a2_.date_add AS date_add_35, a2_.date_upd AS date_upd_36, a2_.deleted AS deleted_37, a2_.locked AS locked_38, a2_.is_draft AS is_draft_39, a2_.can_be_deleted AS can_be_deleted_40, a2_.owner_organization_id AS owner_organization_id_41 FROM app_blog_post a0_ INNER JOIN app_blog_post_i18n a1_ ON a0_.id = a1_.entity_id LEFT JOIN app_blog_post_category a3_ ON a0_.id = a3_.post_id LEFT JOIN app_business_category a2_ ON a2_.id = a3_.category_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'post' AND a0_.deleted = 0 ORDER BY a0_.publish_date DESC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.46 ms (0.55%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'moral_person' AND a0_.deleted = 0 ORDER BY a0_.position ASC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.46 ms (0.55%) |
1 |
SELECT t0.filename AS filename_1, t0.original_name AS original_name_2, t0.mime_type AS mime_type_3, t0.extension AS extension_4, t0.size AS size_5, t0.url AS url_6, t0.id AS id_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.deleted AS deleted_10, t0.locked AS locked_11, t0.is_draft AS is_draft_12, t0.can_be_deleted AS can_be_deleted_13, t0.owner_organization_id AS owner_organization_id_14, t0.author_id AS author_id_15, t16.lastname AS lastname_17, t16.firstname AS firstname_18, t16.birth_place AS birth_place_19, t16.birth_date AS birth_date_20, t16.gender AS gender_21, t16.id AS id_22, t16.date_add AS date_add_23, t16.date_upd AS date_upd_24, t16.deleted AS deleted_25, t16.locked AS locked_26, t16.is_draft AS is_draft_27, t16.can_be_deleted AS can_be_deleted_28, t16.owner_organization_id AS owner_organization_id_29, t16.access_id AS access_id_30, t16.author_id AS author_id_31 FROM app_core_attachment t0 LEFT JOIN app_core_user_actor t16 ON t0.author_id = t16.id WHERE t0.id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ 64 66 201 62 202 203 ] |
|
0.44 ms (0.53%) |
1 |
SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, position_6 FROM (SELECT a0_.color AS color_0, a0_.bg_color AS bg_color_1, a0_.type AS type_2, a0_.target AS target_3, a0_.target_menu AS target_menu_4, a0_.client_type AS client_type_5, a0_.position AS position_6, a0_.status AS status_7, a0_.id AS id_8, a0_.date_add AS date_add_9, a0_.date_upd AS date_upd_10, a0_.deleted AS deleted_11, a0_.locked AS locked_12, a0_.is_draft AS is_draft_13, a0_.can_be_deleted AS can_be_deleted_14, a0_.owner_organization_id AS owner_organization_id_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_business_category a0_ INNER JOIN app_business_category_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.status = 'published' AND a0_.type = 'product' AND a0_.target_menu = 'bank_insurance' AND a0_.deleted = 0) dctrn_result_inner ORDER BY position_6 ASC) dctrn_result LIMIT 10
Parameters:
[] |
|
0.42 ms (0.51%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT a0_.is_downloaded AS is_downloaded_0, a0_.is_show_page AS is_show_page_1, a0_.code AS code_2, a0_.type AS type_3, a0_.status AS status_4, a0_.id AS id_5, a0_.date_add AS date_add_6, a0_.date_upd AS date_upd_7, a0_.deleted AS deleted_8, a0_.locked AS locked_9, a0_.is_draft AS is_draft_10, a0_.can_be_deleted AS can_be_deleted_11, a0_.owner_organization_id AS owner_organization_id_12, a1_.title AS title_13, a1_.sub_title AS sub_title_14, a1_.excerpt AS excerpt_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_core_cms_page a0_ INNER JOIN app_core_cms_page_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.type = 'general_information' AND a0_.deleted = 0 ORDER BY a0_.date_add DESC) dctrn_result) dctrn_table
Parameters:
[] |
|
0.41 ms (0.49%) |
1 |
SELECT DISTINCT id_5 FROM (SELECT DISTINCT id_5, date_add_6 FROM (SELECT a0_.is_downloaded AS is_downloaded_0, a0_.is_show_page AS is_show_page_1, a0_.code AS code_2, a0_.type AS type_3, a0_.status AS status_4, a0_.id AS id_5, a0_.date_add AS date_add_6, a0_.date_upd AS date_upd_7, a0_.deleted AS deleted_8, a0_.locked AS locked_9, a0_.is_draft AS is_draft_10, a0_.can_be_deleted AS can_be_deleted_11, a0_.owner_organization_id AS owner_organization_id_12, a1_.title AS title_13, a1_.sub_title AS sub_title_14, a1_.excerpt AS excerpt_15, a1_.id AS id_16, a1_.locale AS locale_17, a1_.name AS name_18, a1_.description AS description_19, a1_.meta_description AS meta_description_20, a1_.work_keys AS work_keys_21, a1_.slug AS slug_22 FROM app_core_cms_page a0_ INNER JOIN app_core_cms_page_i18n a1_ ON a0_.id = a1_.entity_id WHERE a0_.deleted = 0 AND a0_.type = 'general_information' AND a0_.deleted = 0) dctrn_result_inner ORDER BY date_add_6 DESC) dctrn_result LIMIT 10
Parameters:
[] |
|
0.38 ms (0.45%) |
1 |
SELECT t0.is_downloaded AS is_downloaded_1, t0.is_show_page AS is_show_page_2, t0.code AS code_3, t0.type AS type_4, t0.status AS status_5, t0.id AS id_6, t0.date_add AS date_add_7, t0.date_upd AS date_upd_8, t0.deleted AS deleted_9, t0.locked AS locked_10, t0.is_draft AS is_draft_11, t0.can_be_deleted AS can_be_deleted_12, t0.owner_organization_id AS owner_organization_id_13, t0.attachment_id AS attachment_id_14, t15.filename AS filename_16, t15.original_name AS original_name_17, t15.mime_type AS mime_type_18, t15.extension AS extension_19, t15.size AS size_20, t15.url AS url_21, t15.id AS id_22, t15.date_add AS date_add_23, t15.date_upd AS date_upd_24, t15.deleted AS deleted_25, t15.locked AS locked_26, t15.is_draft AS is_draft_27, t15.can_be_deleted AS can_be_deleted_28, t15.owner_organization_id AS owner_organization_id_29, t15.author_id AS author_id_30, t0.author_id AS author_id_31, t32.lastname AS lastname_33, t32.firstname AS firstname_34, t32.birth_place AS birth_place_35, t32.birth_date AS birth_date_36, t32.gender AS gender_37, t32.id AS id_38, t32.date_add AS date_add_39, t32.date_upd AS date_upd_40, t32.deleted AS deleted_41, t32.locked AS locked_42, t32.is_draft AS is_draft_43, t32.can_be_deleted AS can_be_deleted_44, t32.owner_organization_id AS owner_organization_id_45, t32.access_id AS access_id_46, t32.author_id AS author_id_47 FROM app_core_cms_page t0 LEFT JOIN app_core_attachment t15 ON t0.attachment_id = t15.id LEFT JOIN app_core_user_actor t32 ON t0.author_id = t32.id WHERE t0.id = ?
Parameters:
[
33
]
|
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.