Query Metrics
13
Database Queries
7
Different statements
4.62 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.65 ms |
SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.slug AS slug_2, p0_.name AS name_3, p0_.short_description AS short_description_4, p0_.description AS description_5, p0_.model AS model_6, p0_.price AS price_7, p0_.old_price AS old_price_8, p0_.currency AS currency_9, p0_.status AS status_10, p0_.`condition` AS condition_11, p0_.availability AS availability_12, p0_.stock_quantity AS stock_quantity_13, p0_.main_image AS main_image_14, p0_.surface AS surface_15, p0_.length AS length_16, p0_.width AS width_17, p0_.height AS height_18, p0_.weight AS weight_19, p0_.bedrooms AS bedrooms_20, p0_.bathrooms AS bathrooms_21, p0_.sleeping_places AS sleeping_places_22, p0_.year AS year_23, p0_.location AS location_24, p0_.manufacturer AS manufacturer_25, p0_.mpn AS mpn_26, p0_.gtin AS gtin_27, p0_.google_product_category AS google_product_category_28, p0_.product_type AS product_type_29, p0_.item_group_id AS item_group_id_30, p0_.is_featured AS is_featured_31, p0_.views_count AS views_count_32, p0_.meta_title AS meta_title_33, p0_.meta_description AS meta_description_34, p0_.canonical_url AS canonical_url_35, p0_.robots AS robots_36, p0_.structured_data_enabled AS structured_data_enabled_37, p0_.created_at AS created_at_38, p0_.updated_at AS updated_at_39, b1_.id AS id_40, b1_.name AS name_41, b1_.slug AS slug_42, b1_.description AS description_43, b1_.logo AS logo_44, b1_.website AS website_45, b1_.country AS country_46, b1_.is_active AS is_active_47, b1_.display_order AS display_order_48, c2_.id AS id_49, c2_.name AS name_50, c2_.slug AS slug_51, c2_.description AS description_52, c2_.subtitle AS subtitle_53, c2_.image AS image_54, c2_.icon AS icon_55, c2_.display_order AS display_order_56, c2_.is_active AS is_active_57, p3_.id AS id_58, p3_.filename AS filename_59, p3_.alt_text AS alt_text_60, p3_.title AS title_61, p3_.display_order AS display_order_62, p3_.is_main AS is_main_63, p0_.brand_id AS brand_id_64, p0_.category_id AS category_id_65, p3_.product_id AS product_id_66 FROM product p0_ LEFT JOIN brand b1_ ON p0_.brand_id = b1_.id LEFT JOIN category c2_ ON p0_.category_id = c2_.id LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id WHERE p0_.status = ? AND p0_.is_featured = ? ORDER BY p0_.created_at DESC, p3_.display_order ASC, p3_.id ASC LIMIT 6
Parameters:
[ "active" 1 ] |
| 2 | 0.32 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.subtitle AS subtitle_4, c0_.image AS image_5, c0_.icon AS icon_6, c0_.display_order AS display_order_7, c0_.is_active AS is_active_8 FROM category c0_ WHERE c0_.is_active = ? ORDER BY c0_.display_order ASC, c0_.name ASC
Parameters:
[
1
]
|
| 3 | 0.35 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.excerpt AS excerpt_3, a0_.content AS content_4, a0_.image AS image_5, a0_.author AS author_6, a0_.reading_time AS reading_time_7, a0_.is_published AS is_published_8, a0_.published_at AS published_at_9, a0_.meta_title AS meta_title_10, a0_.meta_description AS meta_description_11, a0_.views_count AS views_count_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14 FROM article a0_ WHERE a0_.is_published = ? ORDER BY a0_.published_at DESC LIMIT 3
Parameters:
[
1
]
|
| 4 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.logo AS logo_5, t0.website AS website_6, t0.country AS country_7, t0.is_active AS is_active_8, t0.display_order AS display_order_9 FROM brand t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 5 | 0.36 ms |
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.canonical_url AS canonical_url_5, t0.og_title AS og_title_6, t0.og_description AS og_description_7, t0.og_image AS og_image_8, t0.twitter_card AS twitter_card_9, t0.robots AS robots_10 FROM seo_setting t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
"app_home"
]
|
| 6 | 0.32 ms |
SELECT t0.id AS id_1, t0.merchant_center_id AS merchant_center_id_2, t0.merchant_account_id AS merchant_account_id_3, t0.api_client_id AS api_client_id_4, t0.api_client_secret AS api_client_secret_5, t0.refresh_token AS refresh_token_6, t0.feed_url AS feed_url_7, t0.ga_measurement_id AS ga_measurement_id_8, t0.ga_property_id AS ga_property_id_9, t0.gsc_property AS gsc_property_10, t0.gsc_verification_method AS gsc_verification_method_11, t0.gsc_verification_code AS gsc_verification_code_12, t0.gtm_id AS gtm_id_13, t0.google_site_verification_meta AS google_site_verification_meta_14, t0.is_connected AS is_connected_15, t0.last_tested_at AS last_tested_at_16, t0.last_sync_at AS last_sync_at_17, t0.last_sync_status AS last_sync_status_18, t0.updated_at AS updated_at_19 FROM google_integration t0 LIMIT 1
Parameters:
[] |
| 7 | 0.17 ms |
SELECT t0.id AS id_1, t0.merchant_center_id AS merchant_center_id_2, t0.merchant_account_id AS merchant_account_id_3, t0.api_client_id AS api_client_id_4, t0.api_client_secret AS api_client_secret_5, t0.refresh_token AS refresh_token_6, t0.feed_url AS feed_url_7, t0.ga_measurement_id AS ga_measurement_id_8, t0.ga_property_id AS ga_property_id_9, t0.gsc_property AS gsc_property_10, t0.gsc_verification_method AS gsc_verification_method_11, t0.gsc_verification_code AS gsc_verification_code_12, t0.gtm_id AS gtm_id_13, t0.google_site_verification_meta AS google_site_verification_meta_14, t0.is_connected AS is_connected_15, t0.last_tested_at AS last_tested_at_16, t0.last_sync_at AS last_sync_at_17, t0.last_sync_status AS last_sync_status_18, t0.updated_at AS updated_at_19 FROM google_integration t0 LIMIT 1
Parameters:
[] |
| 8 | 0.30 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"contact_phone"
]
|
| 9 | 0.16 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"contact_phone"
]
|
| 10 | 0.21 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"opening_hours"
]
|
| 11 | 0.15 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"contact_phone"
]
|
| 12 | 0.14 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"contact_phone"
]
|
| 13 | 0.19 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.description AS description_4, t0.group_name AS group_name_5 FROM site_setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"contact_phone"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Product | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\ProductImage | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\SeoSetting | No errors. |
| App\Entity\GoogleIntegration | No errors. |
| App\Entity\SiteSetting | No errors. |