Query Metrics
22
Database Queries
7
Different statements
43.92 ms
Query time
9
Invalid entities
42
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.91 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.name AS name_10, t0.url AS url_11, t0.short_name AS short_name_12, t0.site_title AS site_title_13, t0.site_description AS site_description_14 FROM web_site t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 2 | 1.25 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.title_seo AS title_seo_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.site_id AS site_id_14 FROM web_blog_category t0 WHERE t0.site_id = ? AND t0.del = ? ORDER BY t0.title ASC
Parameters:
[ 2 0 ] |
| 3 | 0.85 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.titleSeo AS titleSeo_11, t0.little_description AS little_description_12, t0.description AS description_13, t0.photo AS photo_14, t0.date AS date_15, t0.show_control AS show_control_16, t0.default_category AS default_category_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.site_id AS site_id_20 FROM web_blog t0 WHERE t0.id = ? AND t0.titleSeo = ? AND t0.del = ? LIMIT 1
Parameters:
[ "42" "journey-of-all-orders" 0 ] |
| 4 | 1.20 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.u_date AS u_date_5, t0.id AS id_6, t0.sira AS sira_7, t0.code AS code_8, t0.del AS del_9, t0.title AS title_10, t0.title_seo AS title_seo_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.site_id AS site_id_14 FROM web_blog_category t0 INNER JOIN web_blogs_categories ON t0.id = web_blogs_categories.category_id WHERE web_blogs_categories.blog_id = ?
Parameters:
[
42
]
|
| 5 | 0.72 ms |
SELECT w0_.created_at AS created_at_0, w0_.updated_at AS updated_at_1, w0_.created_by AS created_by_2, w0_.updated_by AS updated_by_3, w0_.u_date AS u_date_4, w0_.id AS id_5, w0_.sira AS sira_6, w0_.code AS code_7, w0_.del AS del_8, w0_.title AS title_9, w0_.title_seo AS title_seo_10, w0_.meta_title AS meta_title_11, w0_.meta_description AS meta_description_12, w0_.site_id AS site_id_13 FROM web_blog_category w0_ WHERE w0_.del = 0 AND w0_.id IN (?)
Parameters:
[
28
]
|
| 6 | 4.63 ms |
SELECT w0_.created_at AS created_at_0, w0_.updated_at AS updated_at_1, w0_.created_by AS created_by_2, w0_.updated_by AS updated_by_3, w0_.u_date AS u_date_4, w0_.id AS id_5, w0_.sira AS sira_6, w0_.code AS code_7, w0_.del AS del_8, w0_.freeSample AS freeSample_9, w0_.gap AS gap_10, w0_.projects_slab AS projects_slab_11, w0_.dummy AS dummy_12, w0_.title AS title_13, w0_.brand AS brand_14, w0_.product_type AS product_type_15, w0_.sub_title AS sub_title_16, w0_.title_seo AS title_seo_17, w0_.web_group_name AS web_group_name_18, w0_.photo AS photo_19, w0_.photo_title AS photo_title_20, w0_.photo_sub_title AS photo_sub_title_21, w0_.little_description AS little_description_22, w0_.description AS description_23, w0_.meta_title AS meta_title_24, w0_.meta_keywords AS meta_keywords_25, w0_.meta_description AS meta_description_26, w0_.special_offer AS special_offer_27, w0_.most_popular AS most_popular_28, w0_.best_sellers AS best_sellers_29, w0_.suggested_fixing AS suggested_fixing_30, w0_.review_average AS review_average_31, w0_.free_delivery AS free_delivery_32, w0_.new_item AS new_item_33, w0_.last_id AS last_id_34, w0_.last_url AS last_url_35, w0_.rss_xml AS rss_xml_36, w0_.price AS price_37, w0_.show_control AS show_control_38, w0_.courier_option AS courier_option_39, w0_.show_first AS show_first_40, w0_.tile_sealer AS tile_sealer_41, w0_.tile_adhesive AS tile_adhesive_42, w0_.samples_weight AS samples_weight_43, w0_.default_category AS default_category_44, w0_.default_alt_category AS default_alt_category_45, w0_.type AS type_46, w0_.per AS per_47, w0_.site_id AS site_id_48, w0_.item_id AS item_id_49 FROM web_item_detail w0_ LEFT JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w1_.id = ? AND w0_.show_control = 1 AND w0_.best_sellers = 1
Parameters:
[
2
]
|
| 7 | 2.69 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "LYDIA CLASSICO HONED & FILLED TRAVERTINE" "LYDIA CLASSICO HONED & FILLED TRAVERTINE" ] |
| 8 | 2.17 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "CARRARA WHITE HONED MARBLE" "CARRARA WHITE HONED MARBLE" ] |
| 9 | 2.00 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "VENEZIA BROWN WOOD EFFECT MATT PORCELAIN" "VENEZIA BROWN WOOD EFFECT MATT PORCELAIN" ] |
| 10 | 1.97 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "BRAZILIAN BLACK CALIBRATED RIVEN SLATE" "BRAZILIAN BLACK CALIBRATED RIVEN SLATE" ] |
| 11 | 1.93 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "LYDIA CLASSICO TUMBLED TRAVERTINE MOSAIC BROKEN CHIPS" "LYDIA CLASSICO TUMBLED TRAVERTINE MOSAIC BROKEN CHIPS" ] |
| 12 | 1.70 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "MARBELLA WAVE POLISHED RECTIFIED PORCELAIN" "MARBELLA WAVE POLISHED RECTIFIED PORCELAIN" ] |
| 13 | 1.71 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "TOLEDO BIANCO MATT PORCELAIN" "TOLEDO BIANCO MATT PORCELAIN" ] |
| 14 | 1.75 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "CALACATTA VIOLET POLISHED MARBLE HERRINGBONE" "CALACATTA VIOLET POLISHED MARBLE HERRINGBONE" ] |
| 15 | 1.82 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "MOLEANOS CREAM HONED LIMESTONE" "MOLEANOS CREAM HONED LIMESTONE" ] |
| 16 | 1.83 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "FORM MONOCHROME STELLAR MATT PRESSED GLAZED PORCELAIN" "FORM MONOCHROME STELLAR MATT PRESSED GLAZED PORCELAIN" ] |
| 17 | 2.37 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "CARRARA ROYALE HONED MARBLE" "CARRARA ROYALE HONED MARBLE" ] |
| 18 | 1.96 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "CARRARA MIX POLISHED MARBLE" "CARRARA MIX POLISHED MARBLE" ] |
| 19 | 3.42 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "BRAZILIAN GREY MATT R11 RECTIFIED EXTERIOR PORCELAIN" "BRAZILIAN GREY MATT R11 RECTIFIED EXTERIOR PORCELAIN" ] |
| 20 | 2.54 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "ASH BLUE TUMBLED MARBLE" "ASH BLUE TUMBLED MARBLE" ] |
| 21 | 2.96 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "CARRARA WHITE HONED MARBLE KIT KAT MOSAIC" "CARRARA WHITE HONED MARBLE KIT KAT MOSAIC" ] |
| 22 | 1.56 ms |
SELECT w0_.price AS price_0, w0_.old_price AS old_price_1, w0_.discount AS discount_2, w0_.show_control AS show_control_3 FROM web_item w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN item i2_ ON w0_.item_id = i2_.id WHERE w0_.show_control = 1 AND i2_.status <> 2 AND w0_.del = 0 AND w1_.id = ? AND w0_.web_group_name = ? AND i2_.web_group_name = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters:
[ 2 "CARRARA WHITE HONED MARBLE PENNY MOSAIC" "CARRARA WHITE HONED MARBLE PENNY MOSAIC" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| logging | doctrine.dbal.logging_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\WebItemDetail | 16 |
| App\Entity\WebBlogCategory | 12 |
| App\Entity\Item | 12 |
| App\Entity\WebSite | 1 |
| App\Entity\WebBlog | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\BaseEntity | No errors. |
| App\Entity\WebSite |
|
| App\Entity\Samples | No errors. |
| App\Entity\CustomerOrder | No errors. |
| App\Entity\CustomerProforma |
|
| App\Entity\CustomerInvoice | No errors. |
| App\Entity\WebOrder | No errors. |
| App\Entity\WebCategoryBanner |
|
| App\Entity\WebFaq | No errors. |
| App\Entity\WebPageSource | No errors. |
| App\Entity\WebContactForm | No errors. |
| App\Entity\WebBanner | No errors. |
| App\Entity\WebBlogCategory | No errors. |
| App\Entity\WebBlog | No errors. |
| App\Entity\WebSocial | No errors. |
| App\Entity\WebItem |
|
| App\Entity\WebItemDetail |
|
| App\Entity\WebItemInfoOption | No errors. |
| App\Entity\WebLabel | No errors. |
| App\Entity\WebCareDelivery | No errors. |
| App\Entity\WebItemReview | No errors. |
| App\Entity\WebItemQuestion | No errors. |
| App\Entity\WebPage | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\CustomerContact |
|
| App\Entity\Item |
|
| App\Entity\WebBasket |
|
| App\Entity\WebCategory |
|
| App\Entity\ZoneCourier | No errors. |
| App\Entity\WebItemPhoto | No errors. |
| App\Entity\WebOrderItem | No errors. |
| App\Entity\SamplesItem | No errors. |
| App\Entity\WebItemInfo | No errors. |
| App\Entity\WebItemLabel | No errors. |
| App\Entity\WebItemCareDelivery | No errors. |
| App\Entity\WebItemDetailCategories | No errors. |