Query Metrics
10
Database Queries
10
Different statements
4.96 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.49 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.sku AS sku_2, p0_.barcode AS barcode_3, p0_.description AS description_4, p0_.images AS images_5, p0_.videos AS videos_6, p0_.documents AS documents_7, p0_.price AS price_8, p0_.compare_at_price AS compare_at_price_9, p0_.stock AS stock_10, p0_.min_stock_alert AS min_stock_alert_11, p0_.manage_stock AS manage_stock_12, p0_.allow_backorders AS allow_backorders_13, p0_.stock_status AS stock_status_14, p0_.weight AS weight_15, p0_.length AS length_16, p0_.width AS width_17, p0_.height AS height_18, p0_.is_digital AS is_digital_19, p0_.digital_file AS digital_file_20, p0_.attributes AS attributes_21, p0_.variations AS variations_22, p0_.is_active AS is_active_23, p0_.is_featured AS is_featured_24, p0_.published_at AS published_at_25, p0_.available_from AS available_from_26, p0_.available_to AS available_to_27, p0_.meta_title AS meta_title_28, p0_.meta_description AS meta_description_29, p0_.meta_keywords AS meta_keywords_30, p0_.view_count AS view_count_31, p0_.sales_count AS sales_count_32, p0_.average_rating AS average_rating_33, p0_.review_count AS review_count_34, p0_.tier_prices AS tier_prices_35, p0_.has_tier_pricing AS has_tier_pricing_36, p0_.name AS name_37, s1_.id AS id_38, s1_.name AS name_39, s1_.slug AS slug_40, s1_.description AS description_41, s1_.logo AS logo_42, s1_.address AS address_43, s1_.phone_number AS phone_number_44, s1_.email AS email_45, s1_.is_active AS is_active_46, s1_.created_at AS created_at_47, s1_.updated_at AS updated_at_48, s1_.current_products AS current_products_49, s1_.current_employees AS current_employees_50, s1_.current_orders AS current_orders_51, s1_.current_revenue AS current_revenue_52, s1_.current_storage AS current_storage_53, s1_.current_ca_limit AS current_ca_limit_54, s1_.siret_nif AS siret_nif_55, s1_.iban AS iban_56, s1_.website AS website_57, s1_.facebook AS facebook_58, s1_.instagram AS instagram_59, s1_.twitter AS twitter_60, s1_.youtube AS youtube_61, s1_.tiktok AS tiktok_62, s1_.whatsapp AS whatsapp_63, s1_.telegram AS telegram_64, s1_.banner_images AS banner_images_65, s1_.view_count AS view_count_66, s1_.follower_count AS follower_count_67, s1_.average_rating AS average_rating_68, s1_.review_count AS review_count_69, s1_.status AS status_70, s1_.verification_status AS verification_status_71, s1_.verified_at AS verified_at_72, s1_.business_hours AS business_hours_73, s1_.delivery_areas AS delivery_areas_74, s1_.payment_methods AS payment_methods_75, s1_.return_policy AS return_policy_76, s1_.shipping_policy AS shipping_policy_77, s1_.privacy_policy AS privacy_policy_78, s1_.is_verified AS is_verified_79, s1_.is_premium AS is_premium_80, s1_.allow_reviews AS allow_reviews_81, s1_.allow_messages AS allow_messages_82, s1_.show_contact_info AS show_contact_info_83, s1_.show_social_links AS show_social_links_84, c2_.id AS id_85, c2_.name AS name_86, c2_.slug AS slug_87, c2_.description AS description_88, c2_.image AS image_89, c2_.banner_image AS banner_image_90, c2_.meta_title AS meta_title_91, c2_.meta_description AS meta_description_92, c2_.meta_keywords AS meta_keywords_93, c2_.is_active AS is_active_94, c2_.product_count AS product_count_95, c2_.view_count AS view_count_96, c2_.created_at AS created_at_97, c2_.updated_at AS updated_at_98, p0_.shop_id AS shop_id_99, p0_.category_id AS category_id_100, p0_.brand_id AS brand_id_101, p0_.condition_id AS condition_id_102, s1_.shop_category_id AS shop_category_id_103, s1_.plan_id AS plan_id_104 FROM product p0_ LEFT JOIN shop s1_ ON p0_.shop_id = s1_.id LEFT JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.is_featured = ? AND p0_.is_active = ? ORDER BY p0_.published_at DESC LIMIT 10
Parameters:
[ 1 1 ] |
| 2 | 0.67 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.sku AS sku_2, p0_.barcode AS barcode_3, p0_.description AS description_4, p0_.images AS images_5, p0_.videos AS videos_6, p0_.documents AS documents_7, p0_.price AS price_8, p0_.compare_at_price AS compare_at_price_9, p0_.stock AS stock_10, p0_.min_stock_alert AS min_stock_alert_11, p0_.manage_stock AS manage_stock_12, p0_.allow_backorders AS allow_backorders_13, p0_.stock_status AS stock_status_14, p0_.weight AS weight_15, p0_.length AS length_16, p0_.width AS width_17, p0_.height AS height_18, p0_.is_digital AS is_digital_19, p0_.digital_file AS digital_file_20, p0_.attributes AS attributes_21, p0_.variations AS variations_22, p0_.is_active AS is_active_23, p0_.is_featured AS is_featured_24, p0_.published_at AS published_at_25, p0_.available_from AS available_from_26, p0_.available_to AS available_to_27, p0_.meta_title AS meta_title_28, p0_.meta_description AS meta_description_29, p0_.meta_keywords AS meta_keywords_30, p0_.view_count AS view_count_31, p0_.sales_count AS sales_count_32, p0_.average_rating AS average_rating_33, p0_.review_count AS review_count_34, p0_.tier_prices AS tier_prices_35, p0_.has_tier_pricing AS has_tier_pricing_36, p0_.name AS name_37, s1_.id AS id_38, s1_.name AS name_39, s1_.slug AS slug_40, s1_.description AS description_41, s1_.logo AS logo_42, s1_.address AS address_43, s1_.phone_number AS phone_number_44, s1_.email AS email_45, s1_.is_active AS is_active_46, s1_.created_at AS created_at_47, s1_.updated_at AS updated_at_48, s1_.current_products AS current_products_49, s1_.current_employees AS current_employees_50, s1_.current_orders AS current_orders_51, s1_.current_revenue AS current_revenue_52, s1_.current_storage AS current_storage_53, s1_.current_ca_limit AS current_ca_limit_54, s1_.siret_nif AS siret_nif_55, s1_.iban AS iban_56, s1_.website AS website_57, s1_.facebook AS facebook_58, s1_.instagram AS instagram_59, s1_.twitter AS twitter_60, s1_.youtube AS youtube_61, s1_.tiktok AS tiktok_62, s1_.whatsapp AS whatsapp_63, s1_.telegram AS telegram_64, s1_.banner_images AS banner_images_65, s1_.view_count AS view_count_66, s1_.follower_count AS follower_count_67, s1_.average_rating AS average_rating_68, s1_.review_count AS review_count_69, s1_.status AS status_70, s1_.verification_status AS verification_status_71, s1_.verified_at AS verified_at_72, s1_.business_hours AS business_hours_73, s1_.delivery_areas AS delivery_areas_74, s1_.payment_methods AS payment_methods_75, s1_.return_policy AS return_policy_76, s1_.shipping_policy AS shipping_policy_77, s1_.privacy_policy AS privacy_policy_78, s1_.is_verified AS is_verified_79, s1_.is_premium AS is_premium_80, s1_.allow_reviews AS allow_reviews_81, s1_.allow_messages AS allow_messages_82, s1_.show_contact_info AS show_contact_info_83, s1_.show_social_links AS show_social_links_84, c2_.id AS id_85, c2_.name AS name_86, c2_.slug AS slug_87, c2_.description AS description_88, c2_.image AS image_89, c2_.banner_image AS banner_image_90, c2_.meta_title AS meta_title_91, c2_.meta_description AS meta_description_92, c2_.meta_keywords AS meta_keywords_93, c2_.is_active AS is_active_94, c2_.product_count AS product_count_95, c2_.view_count AS view_count_96, c2_.created_at AS created_at_97, c2_.updated_at AS updated_at_98, p0_.shop_id AS shop_id_99, p0_.category_id AS category_id_100, p0_.brand_id AS brand_id_101, p0_.condition_id AS condition_id_102, s1_.shop_category_id AS shop_category_id_103, s1_.plan_id AS plan_id_104 FROM product p0_ LEFT JOIN shop s1_ ON p0_.shop_id = s1_.id LEFT JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.is_active = ? ORDER BY p0_.published_at DESC LIMIT 12
Parameters:
[
1
]
|
| 3 | 1.00 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.image AS image_4, c0_.banner_image AS banner_image_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.meta_keywords AS meta_keywords_8, c0_.is_active AS is_active_9, c0_.product_count AS product_count_10, c0_.view_count AS view_count_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, COUNT(p1_.id) AS sclr_14 FROM category c0_ LEFT JOIN product p1_ ON c0_.id = p1_.category_id AND (p1_.is_active = ?) WHERE c0_.is_active = ? GROUP BY c0_.id ORDER BY sclr_14 DESC, c0_.name ASC LIMIT 8
Parameters:
[ 1 1 ] |
| 4 | 0.19 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.is_active = ?
Parameters:
[
1
]
|
| 5 | 0.18 ms |
SELECT COUNT(s0_.id) AS sclr_0 FROM shop s0_ WHERE s0_.is_active = ?
Parameters:
[
1
]
|
| 6 | 0.16 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM category c0_ WHERE c0_.is_active = ?
Parameters:
[
1
]
|
| 7 | 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.banner_image AS banner_image_5, t0.position AS position_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM shop_category t0 WHERE t0.is_active = ? AND t0.parent_id IS NULL ORDER BY t0.position ASC LIMIT 6
Parameters:
[
1
]
|
| 8 | 0.50 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.sku AS sku_2, p0_.barcode AS barcode_3, p0_.description AS description_4, p0_.images AS images_5, p0_.videos AS videos_6, p0_.documents AS documents_7, p0_.price AS price_8, p0_.compare_at_price AS compare_at_price_9, p0_.stock AS stock_10, p0_.min_stock_alert AS min_stock_alert_11, p0_.manage_stock AS manage_stock_12, p0_.allow_backorders AS allow_backorders_13, p0_.stock_status AS stock_status_14, p0_.weight AS weight_15, p0_.length AS length_16, p0_.width AS width_17, p0_.height AS height_18, p0_.is_digital AS is_digital_19, p0_.digital_file AS digital_file_20, p0_.attributes AS attributes_21, p0_.variations AS variations_22, p0_.is_active AS is_active_23, p0_.is_featured AS is_featured_24, p0_.published_at AS published_at_25, p0_.available_from AS available_from_26, p0_.available_to AS available_to_27, p0_.meta_title AS meta_title_28, p0_.meta_description AS meta_description_29, p0_.meta_keywords AS meta_keywords_30, p0_.view_count AS view_count_31, p0_.sales_count AS sales_count_32, p0_.average_rating AS average_rating_33, p0_.review_count AS review_count_34, p0_.tier_prices AS tier_prices_35, p0_.has_tier_pricing AS has_tier_pricing_36, p0_.name AS name_37, s1_.id AS id_38, s1_.name AS name_39, s1_.slug AS slug_40, s1_.description AS description_41, s1_.logo AS logo_42, s1_.address AS address_43, s1_.phone_number AS phone_number_44, s1_.email AS email_45, s1_.is_active AS is_active_46, s1_.created_at AS created_at_47, s1_.updated_at AS updated_at_48, s1_.current_products AS current_products_49, s1_.current_employees AS current_employees_50, s1_.current_orders AS current_orders_51, s1_.current_revenue AS current_revenue_52, s1_.current_storage AS current_storage_53, s1_.current_ca_limit AS current_ca_limit_54, s1_.siret_nif AS siret_nif_55, s1_.iban AS iban_56, s1_.website AS website_57, s1_.facebook AS facebook_58, s1_.instagram AS instagram_59, s1_.twitter AS twitter_60, s1_.youtube AS youtube_61, s1_.tiktok AS tiktok_62, s1_.whatsapp AS whatsapp_63, s1_.telegram AS telegram_64, s1_.banner_images AS banner_images_65, s1_.view_count AS view_count_66, s1_.follower_count AS follower_count_67, s1_.average_rating AS average_rating_68, s1_.review_count AS review_count_69, s1_.status AS status_70, s1_.verification_status AS verification_status_71, s1_.verified_at AS verified_at_72, s1_.business_hours AS business_hours_73, s1_.delivery_areas AS delivery_areas_74, s1_.payment_methods AS payment_methods_75, s1_.return_policy AS return_policy_76, s1_.shipping_policy AS shipping_policy_77, s1_.privacy_policy AS privacy_policy_78, s1_.is_verified AS is_verified_79, s1_.is_premium AS is_premium_80, s1_.allow_reviews AS allow_reviews_81, s1_.allow_messages AS allow_messages_82, s1_.show_contact_info AS show_contact_info_83, s1_.show_social_links AS show_social_links_84, c2_.id AS id_85, c2_.name AS name_86, c2_.slug AS slug_87, c2_.description AS description_88, c2_.image AS image_89, c2_.banner_image AS banner_image_90, c2_.meta_title AS meta_title_91, c2_.meta_description AS meta_description_92, c2_.meta_keywords AS meta_keywords_93, c2_.is_active AS is_active_94, c2_.product_count AS product_count_95, c2_.view_count AS view_count_96, c2_.created_at AS created_at_97, c2_.updated_at AS updated_at_98, p0_.shop_id AS shop_id_99, p0_.category_id AS category_id_100, p0_.brand_id AS brand_id_101, p0_.condition_id AS condition_id_102, s1_.shop_category_id AS shop_category_id_103, s1_.plan_id AS plan_id_104 FROM product p0_ LEFT JOIN shop s1_ ON p0_.shop_id = s1_.id LEFT JOIN category c2_ ON p0_.category_id = c2_.id WHERE p0_.is_active = ? ORDER BY p0_.view_count DESC, p0_.sales_count DESC LIMIT 8
Parameters:
[
1
]
|
| 9 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.banner_image AS banner_image_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.is_active AS is_active_10, t0.product_count AS product_count_11, t0.view_count AS view_count_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM category t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 10 | 0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.banner_image AS banner_image_5, t0.position AS position_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.parent_id AS parent_id_10 FROM shop_category t0 WHERE t0.is_active = ? AND t0.parent_id IS NULL ORDER BY t0.position ASC
Parameters:
[
1
]
|
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\Shop | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\ProductCondition | No errors. |
| App\Entity\ShopCategory | No errors. |
| App\Entity\ShopPlan | No errors. |
| App\Entity\ProductRanking | No errors. |
| App\Entity\ProductVariant | No errors. |
| App\Entity\ProductDetail | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\ShopFollow | No errors. |
| App\Entity\ShopReview | No errors. |
| App\Entity\User | No errors. |