https://uat.postroyka.by/ajax/get-products-ecommerce/ Return to referer URL

Query Metrics

9 Database Queries
7 Different statements
3.52 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.31 ms
(37.34%)
3
SELECT t0.id AS id_1, t0.url AS url_2, t0.tag AS tag_3, t0.is_directory AS is_directory_4, t0.title AS title_5, t0.description AS description_6, t0.is_deleted AS is_deleted_7, t0.is_enabled AS is_enabled_8, t0.html_title AS html_title_9, t0.html_meta_description AS html_meta_description_10, t0.html_meta_keywords AS html_meta_keywords_11, t0.cached_values AS cached_values_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.published_at AS published_at_15, t0.image_path AS image_path_16, t0.image_path_fid AS image_path_fid_17, t0.count_comments AS count_comments_18, t0.allowed_comments AS allowed_comments_19, t0.moderated_comments AS moderated_comments_20, t0.price AS price_21, t0.multiple_dimensions AS multiple_dimensions_22, t0.product_id AS product_id_23, t0.b24id AS b24id_24, t0.count_products AS count_products_25, t0.is_available AS is_available_26, t0.is_discount AS is_discount_27, t0.product_status AS product_status_28, t0.image_mobile_menu AS image_mobile_menu_29, t0.vendor_code AS vendor_code_30, t0.type_id AS type_id_31, t0.body_id AS body_id_32, t33.id AS id_34, t33.reason AS reason_35, t33.cost AS cost_36, t33.max_count AS max_count_37, t33.is_active AS is_active_38, t33.updated_at AS updated_at_39, t33.b24id AS b24id_40, t33.b24time_info_update AS b24time_info_update_41, t33.b24status_update AS b24status_update_42, t33.b24price_update AS b24price_update_43, t33.page_id AS page_id_44, t45.id AS id_46, t45.b24status_update AS b24status_update_47, t45.b24price_update AS b24price_update_48, t45.page_id AS page_id_49 FROM submarine_pages t0 LEFT JOIN page_defected t33 ON t33.page_id = t0.id LEFT JOIN page_b24update_time t45 ON t45.page_id = t0.id WHERE t0.id = ?
Parameters:
[
  "6042"
]
0.75 ms
(21.31%)
1
SELECT s0_.id AS id_0, s0_.entity_name AS entity_name_1, s0_.entity_id AS entity_id_2, s0_.value AS value_3, s0_.value_number AS value_number_4, s1_.id AS id_5, s1_.title AS title_6, s1_.description AS description_7, s1_.value_type AS value_type_8, s1_.value_postfix AS value_postfix_9, s1_.values_choice AS values_choice_10, s1_.value_default AS value_default_11, s1_.position AS position_12, s2_.id AS id_13, s2_.title AS title_14, s2_.position AS position_15, s0_.property_id AS property_id_16, s1_.group_id AS group_id_17 FROM submarine_properties_values s0_ INNER JOIN submarine_properties s1_ ON s0_.property_id = s1_.id INNER JOIN submarine_properties_group s2_ ON s1_.group_id = s2_.id WHERE s0_.entity_name = ? AND s0_.entity_id = ? ORDER BY s2_.position ASC, s1_.position ASC
Parameters:
[
  "Submarine\PagesBundle\Entity\Page"
  6042
]
0.34 ms
(9.76%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM submarine_auth_groups t0 INNER JOIN submarine_auth_groups_map ON t0.id = submarine_auth_groups_map.group_id WHERE submarine_auth_groups_map.user_id = ?
Parameters:
[
  17997
]
0.32 ms
(9.13%)
1
SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.salt AS salt_2, s0_.password AS password_3, s0_.email AS email_4, s0_.is_active AS is_active_5, s0_.is_confirmed AS is_confirmed_6, s0_.description AS description_7, s0_.date_time_created AS date_time_created_8, s0_.image AS image_9 FROM submarine_auth_users s0_ WHERE s0_.email = ?
Parameters:
[
  "sergeymarky09@tut.by"
]
0.30 ms
(8.50%)
1
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirect_url AS redirect_url_3, t0.code AS code_4, t0.active AS active_5, t0.comment AS comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM submarine_redirects_redirects t0 WHERE t0.original_url = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "/ajax/get-products-ecommerce/"
  1
]
0.27 ms
(7.79%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.parent_id AS parent_id_3, t0.page_id AS page_id_4 FROM submarine_pages_relations t0 WHERE t0.page_id = ?
Parameters:
[
  6042
]
0.22 ms
(6.17%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.block_way AS block_way_3, t0.ip AS ip_4 FROM blacklist t0 WHERE t0.ip = ?
Parameters:
[
  "37.215.5.150"
]

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.