GET https://teststonedeals.ionsis.co.uk/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CDefaultController%253A%253AproductRevie…

Response
200 OK
IP
198.244.168.55
Profiled on
Token
7a2fd8

Query Metrics

326 Database Queries
30 Different statements
456.73 ms Query time
33 Invalid entities
180 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.65 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
]
View formatted query    View runnable query    Explain query
2 1.45 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.status AS status_10, t0.title AS title_11, t0.title_seo AS title_seo_12, t0.footer_title AS footer_title_13, t0.meta_title AS meta_title_14, t0.meta_keywords AS meta_keywords_15, t0.meta_description AS meta_description_16, t0.seo_description AS seo_description_17, t0.group_name AS group_name_18, t0.group_status AS group_status_19, t0.meta_tickets AS meta_tickets_20, t0.site_id AS site_id_21, t0.category_id AS category_id_22 FROM web_category t0 WHERE t0.status = ? AND t0.title_seo = ? AND t0.del = ? AND t0.site_id = ? ORDER BY t0.sira ASC LIMIT 1
Parameters: 
[
  1
  "marble-floor-tiles"
  0
  2
]
View formatted query    View runnable query    Explain query
3 0.97 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.description AS description_11, t0.photo AS photo_12, t0.type AS type_13, t0.status AS status_14, t0.site_id AS site_id_15, t0.category_id AS category_id_16, t0.web_category_id AS web_category_id_17 FROM web_category_banner t0 WHERE t0.web_category_id = ? AND t0.type = ? AND t0.status = ? LIMIT 1
Parameters: 
[
  189
  0
  1
]
View formatted query    View runnable query    Explain query
4 48.29 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_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN web_item_detail_categories w2_ ON w0_.id = w2_.web_item_detail_id INNER JOIN web_item w3_ ON w0_.id = w3_.web_item_detail_id WHERE w1_.id = ? AND w2_.web_category_id = ? AND w3_.show_control = 1 AND w0_.show_control = 1 AND w0_.del = 0 AND w0_.item_id IS NOT NULL ORDER BY w2_.sira ASC
Parameters: 
[
  2
  189
]
View formatted query    View runnable query    Explain query
5 0.78 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_.titleSeo AS titleSeo_10, w0_.colour AS colour_11, w0_.filter AS filter_12, w0_.info_id AS info_id_13, w0_.site_id AS site_id_14 FROM web_item_info_option w0_ WHERE w0_.del = 0 AND w0_.filter = 1 AND w0_.info_id IS NULL AND w0_.site_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
6 6.45 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_.titleSeo AS titleSeo_10, w0_.colour AS colour_11, w0_.filter AS filter_12, w0_.info_id AS info_id_13, w0_.site_id AS site_id_14 FROM web_item_info_option w0_ INNER JOIN web_item_info w1_ ON w0_.id = w1_.web_item_info_options_id INNER JOIN web_item_detail w2_ ON w1_.web_item_detail_id = w2_.id INNER JOIN web_item_info_option w3_ ON w0_.info_id = w3_.id WHERE w0_.del = 0 AND w0_.filter = 1 AND w0_.info_id IS NOT NULL AND w0_.site_id = ? AND w2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY w0_.titleSeo ORDER BY w0_.title ASC
Parameters: 
[
  2
  120
  388
  98
  108
  130
  730
  87
  316
  346
  348
  350
  471
  610
  718
  875
  846
  60
  877
  62
  66
  64
  68
  70
  72
  77
  58
  56
  79
  83
  110
  116
  122
  124
  128
  308
  310
  318
  320
  338
  342
  356
  362
  370
  386
  465
  467
  483
  485
  512
  612
  608
  636
  638
  702
  358
  368
  481
  724
  728
  784
  786
  838
  818
  820
  822
  824
  364
  873
  842
  844
  850
  852
  858
  860
  866
  868
  870
]
View formatted query    View runnable query    Explain query
7 2.53 ms 
SELECT w0_.size_name AS size_name_0, w0_.id AS id_1 FROM web_item w0_ INNER JOIN web_item_detail w1_ ON w0_.web_item_detail_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id INNER JOIN item i3_ ON w0_.item_id = i3_.id WHERE w2_.id = ? AND i3_.status <> 2 AND w1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND w0_.show_control = 1 AND w0_.del = 0 AND w0_.size_name IS NOT NULL GROUP BY w0_.size_name ORDER BY w0_.size_name ASC
Parameters: 
[
  2
  120
  388
  98
  108
  130
  730
  87
  316
  346
  348
  350
  471
  610
  718
  875
  846
  60
  877
  62
  66
  64
  68
  70
  72
  77
  58
  56
  79
  83
  110
  116
  122
  124
  128
  308
  310
  318
  320
  338
  342
  356
  362
  370
  386
  465
  467
  483
  485
  512
  612
  608
  636
  638
  702
  358
  368
  481
  724
  728
  784
  786
  838
  818
  820
  822
  824
  364
  873
  842
  844
  850
  852
  858
  860
  866
  868
  870
]
View formatted query    View runnable query    Explain query
8 0.94 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.status AS status_10, t0.title AS title_11, t0.title_seo AS title_seo_12, t0.footer_title AS footer_title_13, t0.meta_title AS meta_title_14, t0.meta_keywords AS meta_keywords_15, t0.meta_description AS meta_description_16, t0.seo_description AS seo_description_17, t0.group_name AS group_name_18, t0.group_status AS group_status_19, t0.meta_tickets AS meta_tickets_20, t0.site_id AS site_id_21, t0.category_id AS category_id_22 FROM web_category t0 WHERE t0.id = ?
Parameters: 
[
  186
]
View formatted query    View runnable query    Explain query
9 0.97 ms 
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.title_seo AS title_seo_2 FROM web_category w0_ INNER JOIN web_category w1_ ON w0_.category_id = w1_.id LEFT JOIN web_category w2_ ON w1_.category_id = w2_.id INNER JOIN web_site w3_ ON w0_.site_id = w3_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w1_.status = 1 AND w3_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
Parameters: 
[
  2
  186
]
View formatted query    View runnable query    Explain query
10 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  120
]
View formatted query    View runnable query    Explain query
11 1.63 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  388
]
View formatted query    View runnable query    Explain query
12 1.65 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  98
]
View formatted query    View runnable query    Explain query
13 1.63 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  108
]
View formatted query    View runnable query    Explain query
14 1.74 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  130
]
View formatted query    View runnable query    Explain query
15 1.57 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  730
]
View formatted query    View runnable query    Explain query
16 1.44 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  87
]
View formatted query    View runnable query    Explain query
17 1.66 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  316
]
View formatted query    View runnable query    Explain query
18 1.50 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  346
]
View formatted query    View runnable query    Explain query
19 1.65 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  348
]
View formatted query    View runnable query    Explain query
20 1.46 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  350
]
View formatted query    View runnable query    Explain query
21 1.43 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  471
]
View formatted query    View runnable query    Explain query
22 1.52 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  610
]
View formatted query    View runnable query    Explain query
23 1.43 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  718
]
View formatted query    View runnable query    Explain query
24 1.63 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  875
]
View formatted query    View runnable query    Explain query
25 0.72 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  875
]
View formatted query    View runnable query    Explain query
26 1.38 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  846
]
View formatted query    View runnable query    Explain query
27 0.62 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  846
]
View formatted query    View runnable query    Explain query
28 1.48 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  60
]
View formatted query    View runnable query    Explain query
29 0.55 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  60
]
View formatted query    View runnable query    Explain query
30 1.36 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  877
]
View formatted query    View runnable query    Explain query
31 0.58 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  877
]
View formatted query    View runnable query    Explain query
32 1.29 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  62
]
View formatted query    View runnable query    Explain query
33 0.59 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  62
]
View formatted query    View runnable query    Explain query
34 1.47 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  66
]
View formatted query    View runnable query    Explain query
35 0.61 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  66
]
View formatted query    View runnable query    Explain query
36 1.38 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  64
]
View formatted query    View runnable query    Explain query
37 0.59 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query
38 2.07 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  68
]
View formatted query    View runnable query    Explain query
39 0.59 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  68
]
View formatted query    View runnable query    Explain query
40 1.36 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  70
]
View formatted query    View runnable query    Explain query
41 0.53 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  70
]
View formatted query    View runnable query    Explain query
42 1.47 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  72
]
View formatted query    View runnable query    Explain query
43 0.57 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  72
]
View formatted query    View runnable query    Explain query
44 1.34 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  77
]
View formatted query    View runnable query    Explain query
45 0.42 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  77
]
View formatted query    View runnable query    Explain query
46 1.24 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  58
]
View formatted query    View runnable query    Explain query
47 0.53 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  58
]
View formatted query    View runnable query    Explain query
48 1.30 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  56
]
View formatted query    View runnable query    Explain query
49 0.34 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  56
]
View formatted query    View runnable query    Explain query
50 1.32 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  79
]
View formatted query    View runnable query    Explain query
51 0.43 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  79
]
View formatted query    View runnable query    Explain query
52 1.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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  83
]
View formatted query    View runnable query    Explain query
53 0.58 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  83
]
View formatted query    View runnable query    Explain query
54 1.28 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  110
]
View formatted query    View runnable query    Explain query
55 0.41 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  110
]
View formatted query    View runnable query    Explain query
56 1.35 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  116
]
View formatted query    View runnable query    Explain query
57 0.37 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  116
]
View formatted query    View runnable query    Explain query
58 1.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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  122
]
View formatted query    View runnable query    Explain query
59 0.60 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  122
]
View formatted query    View runnable query    Explain query
60 1.32 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  124
]
View formatted query    View runnable query    Explain query
61 0.39 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  124
]
View formatted query    View runnable query    Explain query
62 1.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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  128
]
View formatted query    View runnable query    Explain query
63 0.61 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  128
]
View formatted query    View runnable query    Explain query
64 1.59 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  308
]
View formatted query    View runnable query    Explain query
65 0.58 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  308
]
View formatted query    View runnable query    Explain query
66 1.46 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  310
]
View formatted query    View runnable query    Explain query
67 0.58 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  310
]
View formatted query    View runnable query    Explain query
68 1.49 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  318
]
View formatted query    View runnable query    Explain query
69 0.47 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  318
]
View formatted query    View runnable query    Explain query
70 1.34 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  320
]
View formatted query    View runnable query    Explain query
71 0.36 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  320
]
View formatted query    View runnable query    Explain query
72 1.30 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  338
]
View formatted query    View runnable query    Explain query
73 0.42 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  338
]
View formatted query    View runnable query    Explain query
74 1.31 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  342
]
View formatted query    View runnable query    Explain query
75 0.59 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  342
]
View formatted query    View runnable query    Explain query
76 1.33 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  356
]
View formatted query    View runnable query    Explain query
77 0.57 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  356
]
View formatted query    View runnable query    Explain query
78 1.38 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  362
]
View formatted query    View runnable query    Explain query
79 0.49 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  362
]
View formatted query    View runnable query    Explain query
80 1.29 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  370
]
View formatted query    View runnable query    Explain query
81 0.52 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  370
]
View formatted query    View runnable query    Explain query
82 1.33 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  386
]
View formatted query    View runnable query    Explain query
83 0.56 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  386
]
View formatted query    View runnable query    Explain query
84 1.44 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  465
]
View formatted query    View runnable query    Explain query
85 0.57 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  465
]
View formatted query    View runnable query    Explain query
86 1.45 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  467
]
View formatted query    View runnable query    Explain query
87 0.64 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  467
]
View formatted query    View runnable query    Explain query
88 1.51 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  483
]
View formatted query    View runnable query    Explain query
89 0.55 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  483
]
View formatted query    View runnable query    Explain query
90 1.64 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  485
]
View formatted query    View runnable query    Explain query
91 0.57 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  485
]
View formatted query    View runnable query    Explain query
92 1.46 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  512
]
View formatted query    View runnable query    Explain query
93 0.58 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  512
]
View formatted query    View runnable query    Explain query
94 1.30 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  612
]
View formatted query    View runnable query    Explain query
95 0.54 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  612
]
View formatted query    View runnable query    Explain query
96 1.35 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  608
]
View formatted query    View runnable query    Explain query
97 0.41 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  608
]
View formatted query    View runnable query    Explain query
98 1.26 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  636
]
View formatted query    View runnable query    Explain query
99 0.38 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  636
]
View formatted query    View runnable query    Explain query
100 1.66 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  638
]
View formatted query    View runnable query    Explain query
101 0.54 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  638
]
View formatted query    View runnable query    Explain query
102 1.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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  702
]
View formatted query    View runnable query    Explain query
103 0.40 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  702
]
View formatted query    View runnable query    Explain query
104 1.28 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  358
]
View formatted query    View runnable query    Explain query
105 0.44 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  358
]
View formatted query    View runnable query    Explain query
106 1.29 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  368
]
View formatted query    View runnable query    Explain query
107 0.54 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  368
]
View formatted query    View runnable query    Explain query
108 1.39 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  481
]
View formatted query    View runnable query    Explain query
109 0.60 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  481
]
View formatted query    View runnable query    Explain query
110 1.40 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  724
]
View formatted query    View runnable query    Explain query
111 0.57 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  724
]
View formatted query    View runnable query    Explain query
112 1.50 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  728
]
View formatted query    View runnable query    Explain query
113 0.84 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  728
]
View formatted query    View runnable query    Explain query
114 2.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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  784
]
View formatted query    View runnable query    Explain query
115 0.86 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  784
]
View formatted query    View runnable query    Explain query
116 2.50 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  786
]
View formatted query    View runnable query    Explain query
117 0.89 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  786
]
View formatted query    View runnable query    Explain query
118 2.34 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  838
]
View formatted query    View runnable query    Explain query
119 0.88 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  838
]
View formatted query    View runnable query    Explain query
120 2.74 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  818
]
View formatted query    View runnable query    Explain query
121 0.92 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  818
]
View formatted query    View runnable query    Explain query
122 2.11 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  820
]
View formatted query    View runnable query    Explain query
123 0.64 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  820
]
View formatted query    View runnable query    Explain query
124 1.68 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  822
]
View formatted query    View runnable query    Explain query
125 0.57 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  822
]
View formatted query    View runnable query    Explain query
126 1.65 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  824
]
View formatted query    View runnable query    Explain query
127 0.57 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  824
]
View formatted query    View runnable query    Explain query
128 1.38 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  364
]
View formatted query    View runnable query    Explain query
129 0.53 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  364
]
View formatted query    View runnable query    Explain query
130 1.47 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  873
]
View formatted query    View runnable query    Explain query
131 0.43 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  873
]
View formatted query    View runnable query    Explain query
132 1.35 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  842
]
View formatted query    View runnable query    Explain query
133 0.58 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  842
]
View formatted query    View runnable query    Explain query
134 1.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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  844
]
View formatted query    View runnable query    Explain query
135 0.58 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  844
]
View formatted query    View runnable query    Explain query
136 1.60 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  850
]
View formatted query    View runnable query    Explain query
137 0.56 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  850
]
View formatted query    View runnable query    Explain query
138 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  852
]
View formatted query    View runnable query    Explain query
139 0.56 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  852
]
View formatted query    View runnable query    Explain query
140 1.53 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  858
]
View formatted query    View runnable query    Explain query
141 0.60 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  858
]
View formatted query    View runnable query    Explain query
142 1.46 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  860
]
View formatted query    View runnable query    Explain query
143 0.58 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  860
]
View formatted query    View runnable query    Explain query
144 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  866
]
View formatted query    View runnable query    Explain query
145 0.61 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  866
]
View formatted query    View runnable query    Explain query
146 1.57 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  868
]
View formatted query    View runnable query    Explain query
147 0.54 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  868
]
View formatted query    View runnable query    Explain query
148 1.68 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_item_detail_id = ? ORDER BY w0_.price + 0 ASC LIMIT 1
Parameters: 
[
  2
  870
]
View formatted query    View runnable query    Explain query
149 0.52 ms 
SELECT w0_.image AS image_0, w0_.location AS location_1, w0_.title AS title_2 FROM web_item_label w1_ INNER JOIN web_label w0_ ON w1_.web_label_id = w0_.id WHERE w1_.web_item_detail_id = ?
Parameters: 
[
  870
]
View formatted query    View runnable query    Explain query
150 0.54 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
151 5.53 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "dbs9323576"
]
View formatted query    View runnable query    Explain query
152 0.39 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
153 3.80 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "dbs9323576"
]
View formatted query    View runnable query    Explain query
154 0.64 ms 
SELECT @@character_set_database, @@collation_database
Parameters: 
[]
View formatted query    View runnable query    Explain query
155 0.66 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
156 4.30 ms 
SELECT c.TABLE_NAME,
       c.COLUMN_NAME,
           IF(
        c.DATA_TYPE = 'longtext'
        AND EXISTS(
            SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'dbs9323576'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.DATA_TYPE
    ),
       c.COLUMN_TYPE,
       c.CHARACTER_MAXIMUM_LENGTH,
       c.CHARACTER_OCTET_LENGTH,
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       c.IS_NULLABLE,
       c.COLUMN_DEFAULT,
       c.EXTRA,
       c.COLUMN_COMMENT,
       c.CHARACTER_SET_NAME,
       c.COLLATION_NAME
FROM information_schema.COLUMNS c
         INNER JOIN information_schema.TABLES t
                    ON t.TABLE_NAME = c.TABLE_NAME
WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY c.TABLE_NAME,
         c.ORDINAL_POSITION
Parameters: 
[
  "dbs9323576"
  "dbs9323576"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
157 0.55 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
158 1.75 ms 
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters: 
[
  "dbs9323576"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
159 0.52 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
160 5.73 ms 
SELECT tc.TABLE_NAME,
       tc.CONSTRAINT_NAME,
       kcu.COLUMN_NAME
FROM information_schema.TABLE_CONSTRAINTS tc
         INNER JOIN information_schema.KEY_COLUMN_USAGE kcu
                    ON kcu.TABLE_NAME = tc.TABLE_NAME
                        AND kcu.CONSTRAINT_NAME = tc.CONSTRAINT_NAME
WHERE tc.TABLE_SCHEMA = ? AND kcu.TABLE_SCHEMA = ? AND tc.TABLE_NAME = ?
  AND tc.CONSTRAINT_TYPE = 'PRIMARY KEY'
ORDER BY TABLE_NAME,
    kcu.ORDINAL_POSITION
Parameters: 
[
  "dbs9323576"
  "dbs9323576"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
161 0.53 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
162 0.68 ms 
SELECT TABLE_NAME,
       INDEX_NAME,
       INDEX_TYPE,
       NON_UNIQUE,
       COLUMN_NAME,
       SUB_PART
FROM information_schema.STATISTICS
WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?
  AND INDEX_NAME != 'PRIMARY'
ORDER BY TABLE_NAME,
    SEQ_IN_INDEX
Parameters: 
[
  "dbs9323576"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
163 0.22 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
164 3.45 ms 
SELECT k.TABLE_NAME,
       k.CONSTRAINT_NAME,
       k.REFERENCED_TABLE_NAME,
       c.UPDATE_RULE,
       c.DELETE_RULE,
       k.COLUMN_NAME,
       k.REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE k
         INNER JOIN information_schema.REFERENTIAL_CONSTRAINTS c
                    ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
                        AND c.TABLE_NAME = k.TABLE_NAME
WHERE k.TABLE_SCHEMA = ? AND c.CONSTRAINT_SCHEMA = ? AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
         k.CONSTRAINT_NAME,
         k.ORDINAL_POSITION
Parameters: 
[
  "dbs9323576"
  "dbs9323576"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
165 0.30 ms 
SELECT * FROM doctrine_migration_versions
Parameters: 
[]
View formatted query    View runnable query    Explain query
166 0.20 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
167 7.33 ms 
SELECT COUNT(w0_.id) AS sclr_0 FROM web_basket w0_ WHERE w0_.userSession = ?
Parameters: 
[
  "b13d94e37c7babf85d84d86e4fc651d6"
]
View formatted query    View runnable query    Explain query
168 15.71 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.userSession AS userSession_10, t0.quantity AS quantity_11, t0.sqm AS sqm_12, t0.price AS price_13, t0.free_sample AS free_sample_14, t0.user_id AS user_id_15, t0.item_id AS item_id_16, t0.show_item_id AS show_item_id_17, t0.item_detail_id AS item_detail_id_18 FROM web_basket t0 WHERE t0.userSession = ?
Parameters: 
[
  "b13d94e37c7babf85d84d86e4fc651d6"
]
View formatted query    View runnable query    Explain query
169 0.76 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.facebook AS facebook_10, t0.pinterest AS pinterest_11, t0.twitter AS twitter_12, t0.linkedin AS linkedin_13, t0.instagram AS instagram_14, t0.site_id AS site_id_15 FROM web_social t0 WHERE t0.site_id = ? LIMIT 1
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
170 1.12 ms 
SELECT w0_.id AS id_0, w0_.group_status AS group_status_1, w0_.group_name AS group_name_2, w0_.title AS title_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id INNER JOIN web_category w2_ ON w0_.category_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w1_.id = ? AND w2_.category_id IS NULL ORDER BY w0_.sira ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
171 0.83 ms 
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
Parameters: 
[
  2
  46
]
View formatted query    View runnable query    Explain query
172 0.69 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  101
]
View formatted query    View runnable query    Explain query
173 0.82 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  99
]
View formatted query    View runnable query    Explain query
174 0.38 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  104
]
View formatted query    View runnable query    Explain query
175 0.54 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  103
]
View formatted query    View runnable query    Explain query
176 0.50 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  116
]
View formatted query    View runnable query    Explain query
177 0.33 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  111
]
View formatted query    View runnable query    Explain query
178 0.34 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  102
]
View formatted query    View runnable query    Explain query
179 0.36 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  98
]
View formatted query    View runnable query    Explain query
180 0.43 ms 
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
Parameters: 
[
  2
  42
]
View formatted query    View runnable query    Explain query
181 0.43 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  115
]
View formatted query    View runnable query    Explain query
182 0.38 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  105
]
View formatted query    View runnable query    Explain query
183 0.42 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  106
]
View formatted query    View runnable query    Explain query
184 0.42 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  214
]
View formatted query    View runnable query    Explain query
185 0.39 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  211
]
View formatted query    View runnable query    Explain query
186 0.39 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  224
]
View formatted query    View runnable query    Explain query
187 0.36 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  114
]
View formatted query    View runnable query    Explain query
188 0.36 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  107
]
View formatted query    View runnable query    Explain query
189 0.52 ms 
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
Parameters: 
[
  2
  43
]
View formatted query    View runnable query    Explain query
190 0.40 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  154
]
View formatted query    View runnable query    Explain query
191 0.37 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  152
]
View formatted query    View runnable query    Explain query
192 0.56 ms 
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
Parameters: 
[
  2
  158
]
View formatted query    View runnable query    Explain query
193 0.39 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  218
]
View formatted query    View runnable query    Explain query
194 0.39 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  159
]
View formatted query    View runnable query    Explain query
195 0.36 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  160
]
View formatted query    View runnable query    Explain query
196 0.36 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  161
]
View formatted query    View runnable query    Explain query
197 0.38 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  162
]
View formatted query    View runnable query    Explain query
198 0.41 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  225
]
View formatted query    View runnable query    Explain query
199 0.45 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  163
]
View formatted query    View runnable query    Explain query
200 0.36 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  212
]
View formatted query    View runnable query    Explain query
201 0.36 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  221
]
View formatted query    View runnable query    Explain query
202 0.38 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  164
]
View formatted query    View runnable query    Explain query
203 0.39 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  165
]
View formatted query    View runnable query    Explain query
204 0.37 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  166
]
View formatted query    View runnable query    Explain query
205 0.38 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  167
]
View formatted query    View runnable query    Explain query
206 0.33 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  168
]
View formatted query    View runnable query    Explain query
207 0.48 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  169
]
View formatted query    View runnable query    Explain query
208 0.43 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  170
]
View formatted query    View runnable query    Explain query
209 0.39 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  171
]
View formatted query    View runnable query    Explain query
210 0.55 ms 
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
Parameters: 
[
  2
  172
]
View formatted query    View runnable query    Explain query
211 0.40 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  219
]
View formatted query    View runnable query    Explain query
212 0.40 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  173
]
View formatted query    View runnable query    Explain query
213 0.37 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  174
]
View formatted query    View runnable query    Explain query
214 0.41 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  175
]
View formatted query    View runnable query    Explain query
215 0.49 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  176
]
View formatted query    View runnable query    Explain query
216 0.41 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  226
]
View formatted query    View runnable query    Explain query
217 0.38 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  177
]
View formatted query    View runnable query    Explain query
218 0.36 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  213
]
View formatted query    View runnable query    Explain query
219 0.41 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  222
]
View formatted query    View runnable query    Explain query
220 0.42 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  178
]
View formatted query    View runnable query    Explain query
221 0.47 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  179
]
View formatted query    View runnable query    Explain query
222 0.46 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  180
]
View formatted query    View runnable query    Explain query
223 0.41 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  181
]
View formatted query    View runnable query    Explain query
224 0.39 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  182
]
View formatted query    View runnable query    Explain query
225 0.44 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  183
]
View formatted query    View runnable query    Explain query
226 0.40 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  184
]
View formatted query    View runnable query    Explain query
227 0.38 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  185
]
View formatted query    View runnable query    Explain query
228 0.59 ms 
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
Parameters: 
[
  2
  186
]
View formatted query    View runnable query    Explain query
229 0.45 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  187
]
View formatted query    View runnable query    Explain query
230 0.44 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  188
]
View formatted query    View runnable query    Explain query
231 0.39 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  189
]
View formatted query    View runnable query    Explain query
232 0.46 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  215
]
View formatted query    View runnable query    Explain query
233 0.59 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  190
]
View formatted query    View runnable query    Explain query
234 0.37 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  191
]
View formatted query    View runnable query    Explain query
235 0.32 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  192
]
View formatted query    View runnable query    Explain query
236 0.41 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  193
]
View formatted query    View runnable query    Explain query
237 0.39 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  194
]
View formatted query    View runnable query    Explain query
238 0.46 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  195
]
View formatted query    View runnable query    Explain query
239 0.39 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  196
]
View formatted query    View runnable query    Explain query
240 0.41 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  197
]
View formatted query    View runnable query    Explain query
241 0.55 ms 
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
Parameters: 
[
  2
  198
]
View formatted query    View runnable query    Explain query
242 0.47 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  220
]
View formatted query    View runnable query    Explain query
243 0.40 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  199
]
View formatted query    View runnable query    Explain query
244 0.46 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  227
]
View formatted query    View runnable query    Explain query
245 0.35 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  200
]
View formatted query    View runnable query    Explain query
246 0.43 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  216
]
View formatted query    View runnable query    Explain query
247 0.41 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  223
]
View formatted query    View runnable query    Explain query
248 0.49 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  202
]
View formatted query    View runnable query    Explain query
249 0.43 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  201
]
View formatted query    View runnable query    Explain query
250 0.47 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  203
]
View formatted query    View runnable query    Explain query
251 0.40 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  204
]
View formatted query    View runnable query    Explain query
252 0.37 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  205
]
View formatted query    View runnable query    Explain query
253 0.34 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  206
]
View formatted query    View runnable query    Explain query
254 0.45 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  207
]
View formatted query    View runnable query    Explain query
255 0.41 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  217
]
View formatted query    View runnable query    Explain query
256 0.41 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  209
]
View formatted query    View runnable query    Explain query
257 0.54 ms 
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.group_status AS group_status_2, w0_.group_name AS group_name_3, w0_.title_seo AS title_seo_4 FROM web_category w0_ LEFT JOIN web_category w1_ ON w0_.category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.del = 0 AND w2_.id = ? AND w1_.id = ? ORDER BY w0_.sira ASC
Parameters: 
[
  2
  49
]
View formatted query    View runnable query    Explain query
258 0.40 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  117
]
View formatted query    View runnable query    Explain query
259 0.40 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  120
]
View formatted query    View runnable query    Explain query
260 0.42 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  118
]
View formatted query    View runnable query    Explain query
261 0.36 ms 
SELECT w0_.photo AS photo_0 FROM web_category_banner w0_ INNER JOIN web_category w1_ ON w0_.web_category_id = w1_.id INNER JOIN web_site w2_ ON w0_.site_id = w2_.id WHERE w0_.status = 1 AND w0_.type = 2 AND w2_.id = ? AND w1_.id = ? LIMIT 1
Parameters: 
[
  2
  119
]
View formatted query    View runnable query    Explain query
262 0.63 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.description AS description_12, t0.type AS type_13, t0.upper_link AS upper_link_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.site_id AS site_id_17 FROM web_page t0 WHERE t0.site_id = ? AND t0.del = ? AND t0.upper_link = ?
Parameters: 
[
  2
  0
  "1"
]
View formatted query    View runnable query    Explain query
263 0.49 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.pallet_kg AS pallet_kg_10, t0.weight_limit AS weight_limit_11, t0.financial_year_start AS financial_year_start_12, t0.financial_year_end AS financial_year_end_13, t0.voidDay1 AS voidDay1_14, t0.voidDay2 AS voidDay2_15, t0.voidDay3 AS voidDay3_16, t0.voidDay4 AS voidDay4_17, t0.voidDay5 AS voidDay5_18, t0.kdv_value AS kdv_value_19, t0.default_tax AS default_tax_20 FROM settings t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
264 0.61 ms 
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_description AS company_description_3, t0.company_email AS company_email_4, t0.company_phone AS company_phone_5, t0.company_fax AS company_fax_6, t0.company_address AS company_address_7, t0.company_address_html AS company_address_html_8, t0.company_logo AS company_logo_9, t0.copyright AS copyright_10, t0.auto_allocate AS auto_allocate_11, t0.cronjob_auto_allocate AS cronjob_auto_allocate_12, t0.cronjob_credit_hold AS cronjob_credit_hold_13, t0.exchange_rate_api AS exchange_rate_api_14, t0.coming_soon AS coming_soon_15, t0.coming_soon_date AS coming_soon_date_16, t0.maintenance_mode AS maintenance_mode_17, t0.custom_transaction AS custom_transaction_18, t0.transaction_entries AS transaction_entries_19, t0.api AS api_20, t0.login_captcha_key AS login_captcha_key_21, t0.login_captcha_id AS login_captcha_id_22, t0.dev_mod AS dev_mod_23, t0.developer_email AS developer_email_24, t0.ftp_username AS ftp_username_25, t0.ftp_hostname AS ftp_hostname_26, t0.ftp_password AS ftp_password_27, t0.ftp_port AS ftp_port_28 FROM system_settings t0 WHERE t0.id = ?
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
265 2.80 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  875
  2
]
View formatted query    View runnable query    Explain query
266 2.60 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  846
  2
]
View formatted query    View runnable query    Explain query
267 2.70 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  60
  2
]
View formatted query    View runnable query    Explain query
268 3.24 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  877
  2
]
View formatted query    View runnable query    Explain query
269 4.64 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  62
  2
]
View formatted query    View runnable query    Explain query
270 1.75 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  66
  2
]
View formatted query    View runnable query    Explain query
271 2.75 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  64
  2
]
View formatted query    View runnable query    Explain query
272 5.09 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  68
  2
]
View formatted query    View runnable query    Explain query
273 2.15 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  70
  2
]
View formatted query    View runnable query    Explain query
274 5.38 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  72
  2
]
View formatted query    View runnable query    Explain query
275 2.63 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  77
  2
]
View formatted query    View runnable query    Explain query
276 1.31 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  58
  2
]
View formatted query    View runnable query    Explain query
277 4.63 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  56
  2
]
View formatted query    View runnable query    Explain query
278 1.19 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  79
  2
]
View formatted query    View runnable query    Explain query
279 1.73 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  83
  2
]
View formatted query    View runnable query    Explain query
280 1.90 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  110
  2
]
View formatted query    View runnable query    Explain query
281 1.90 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  116
  2
]
View formatted query    View runnable query    Explain query
282 2.61 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  122
  2
]
View formatted query    View runnable query    Explain query
283 1.23 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  124
  2
]
View formatted query    View runnable query    Explain query
284 1.50 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  128
  2
]
View formatted query    View runnable query    Explain query
285 2.26 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  308
  2
]
View formatted query    View runnable query    Explain query
286 1.47 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  310
  2
]
View formatted query    View runnable query    Explain query
287 1.54 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  318
  2
]
View formatted query    View runnable query    Explain query
288 4.21 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  320
  2
]
View formatted query    View runnable query    Explain query
289 2.83 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  338
  2
]
View formatted query    View runnable query    Explain query
290 3.05 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  342
  2
]
View formatted query    View runnable query    Explain query
291 1.73 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  356
  2
]
View formatted query    View runnable query    Explain query
292 2.26 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  362
  2
]
View formatted query    View runnable query    Explain query
293 2.11 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  370
  2
]
View formatted query    View runnable query    Explain query
294 1.38 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  386
  2
]
View formatted query    View runnable query    Explain query
295 2.95 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  465
  2
]
View formatted query    View runnable query    Explain query
296 3.13 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  467
  2
]
View formatted query    View runnable query    Explain query
297 2.25 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  483
  2
]
View formatted query    View runnable query    Explain query
298 3.95 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  485
  2
]
View formatted query    View runnable query    Explain query
299 1.27 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  512
  2
]
View formatted query    View runnable query    Explain query
300 1.71 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  612
  2
]
View formatted query    View runnable query    Explain query
301 2.96 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  608
  2
]
View formatted query    View runnable query    Explain query
302 2.30 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  636
  2
]
View formatted query    View runnable query    Explain query
303 2.01 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  638
  2
]
View formatted query    View runnable query    Explain query
304 2.64 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  702
  2
]
View formatted query    View runnable query    Explain query
305 3.48 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  358
  2
]
View formatted query    View runnable query    Explain query
306 1.75 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  368
  2
]
View formatted query    View runnable query    Explain query
307 2.42 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  481
  2
]
View formatted query    View runnable query    Explain query
308 2.66 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  724
  2
]
View formatted query    View runnable query    Explain query
309 5.53 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  728
  2
]
View formatted query    View runnable query    Explain query
310 0.94 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  784
  2
]
View formatted query    View runnable query    Explain query
311 0.94 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  786
  2
]
View formatted query    View runnable query    Explain query
312 1.04 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  838
  2
]
View formatted query    View runnable query    Explain query
313 0.98 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  818
  2
]
View formatted query    View runnable query    Explain query
314 0.98 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  820
  2
]
View formatted query    View runnable query    Explain query
315 0.93 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  822
  2
]
View formatted query    View runnable query    Explain query
316 1.15 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  824
  2
]
View formatted query    View runnable query    Explain query
317 1.47 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  364
  2
]
View formatted query    View runnable query    Explain query
318 1.92 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  873
  2
]
View formatted query    View runnable query    Explain query
319 2.44 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  842
  2
]
View formatted query    View runnable query    Explain query
320 2.38 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  844
  2
]
View formatted query    View runnable query    Explain query
321 2.56 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  850
  2
]
View formatted query    View runnable query    Explain query
322 2.56 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  852
  2
]
View formatted query    View runnable query    Explain query
323 1.37 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  858
  2
]
View formatted query    View runnable query    Explain query
324 1.71 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  860
  2
]
View formatted query    View runnable query    Explain query
325 1.03 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  866
  2
]
View formatted query    View runnable query    Explain query
326 3.32 ms 
SELECT count(w0_.id) AS sclr_0 FROM web_item_review w0_ INNER JOIN web_site w1_ ON w0_.site_id = w1_.id WHERE w0_.web_item_detail_id = ? AND w1_.id = ? AND w0_.status = 1
Parameters: 
[
  868
  2
]
View formatted query    View runnable query    Explain query

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 77
App\Entity\Item 77
App\Entity\WebItemInfoOption 19
App\Entity\WebCategory 3
App\Entity\WebSite 1
App\Entity\WebSocial 1
App\Entity\Settings 1
App\Entity\SystemSettings 1

Entities Mapping

Class Mapping errors
App\Entity\BaseEntity No errors.
App\Entity\WebSite
  • The mappings App\Entity\WebSite#webCategoryShows and App\Entity\WebCategoryBanner#webSite are inconsistent with each other.
App\Entity\Samples No errors.
App\Entity\CustomerOrder No errors.
App\Entity\CustomerProforma
  • The association App\Entity\CustomerProforma#customer refers to the inverse side field App\Entity\Customer#proforma which does not exist.
  • The association App\Entity\CustomerProforma#paymentTerm refers to the inverse side field App\Entity\PaymentTerm#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#shippingMethod refers to the inverse side field App\Entity\ShippingMethod#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#orderStage refers to the inverse side field App\Entity\OrderStage#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#warehouse refers to the inverse side field App\Entity\Warehouse#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#contact refers to the inverse side field App\Entity\CustomerContact#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#multiCurrency refers to the inverse side field App\Entity\MultiCurrency#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#shipToList refers to the inverse side field App\Entity\CustomerShipToList#customerProforma which does not exist.
  • The association App\Entity\CustomerProforma#postCode refers to the inverse side field App\Entity\PostCode#customerProforma which does not exist.
App\Entity\CustomerInvoice No errors.
App\Entity\WebOrder No errors.
App\Entity\WebCategoryBanner
  • The association App\Entity\WebCategoryBanner#category refers to the inverse side field App\Entity\Category#webCategoryBanners which does not exist.
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
  • The association App\Entity\WebItem#categories refers to the inverse side field App\Entity\Category#webItems which does not exist.
App\Entity\WebItemDetail
  • The association App\Entity\WebItemDetail#item refers to the inverse side field App\Entity\Item#webItemDetails which does not exist.
  • The association App\Entity\WebItemDetail#zoneCourier refers to the inverse side field App\Entity\ZoneCourier#webItemDetails which does not exist.
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
  • The mappings App\Entity\CustomerContact#customerNotes and App\Entity\CustomerNotes#contact are inconsistent with each other.
App\Entity\WebCategory
  • The association App\Entity\WebCategory#webSite refers to the inverse side field App\Entity\WebSite#webCategories which does not exist.
App\Entity\WebItemDetailCategories No errors.
App\Entity\WebCategoryShow
  • The association App\Entity\WebCategoryShow#category refers to the inverse side field App\Entity\Category#webCategoryShows which does not exist.
App\Entity\Category No errors.
App\Entity\Item
  • The mappings App\Entity\Item#stockTakeItem and App\Entity\StockTransferItem#item are inconsistent with each other.
  • The mappings App\Entity\Item#corporateItems and App\Entity\CorporateItem#item are inconsistent with each other.
  • The association App\Entity\Item#defaultWarehouse refers to the inverse side field App\Entity\Warehouse#defaultWarehouseItem which does not exist.
  • The association App\Entity\Item#accessoryItem refers to the inverse side field App\Entity\Item#accessoryItems which does not exist.
  • The association App\Entity\Item#substituteItem refers to the inverse side field App\Entity\Item#substituteItems which does not exist.
App\Entity\WebBasket
  • The association App\Entity\WebBasket#user refers to the inverse side field App\Entity\User#webBaskets which does not exist.
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\CustomerReceipt No errors.
App\Entity\CustomerShipToList No errors.
App\Entity\WebPalletZone
  • The association App\Entity\WebPalletZone#accountCode refers to the inverse side field App\Entity\AccountCode#webPalletZone which does not exist.
App\Entity\CustomerOrderItem No errors.
App\Entity\CustomerOrderAddress No errors.
App\Entity\CustomerOrderDelivery No errors.
App\Entity\CustomerOrderImages No errors.
App\Entity\StockTransferItem No errors.
App\Entity\PurchaseOrder No errors.
App\Entity\User
  • The association App\Entity\User#warehouse refers to the inverse side field App\Entity\Warehouse#user which does not exist.
  • The association App\Entity\User#logs refers to the owning side field App\Entity\Log#user which is not defined as association, but as field.
  • The association App\Entity\User#logs refers to the owning side field App\Entity\Log#user which does not exist.
App\Entity\StockTransfer No errors.
App\Entity\PaymentTerm No errors.
App\Entity\ShippingMethod No errors.
App\Entity\OrderStage
  • The association App\Entity\OrderStage#customerInvoice refers to the owning side field App\Entity\CustomerInvoice#orderStage which does not exist.
App\Entity\Warehouse
  • The association App\Entity\Warehouse#stockAdjustment refers to the owning side field App\Entity\StockAdjustment#warehouse which does not exist.
App\Entity\MultiCurrency
  • The mappings App\Entity\MultiCurrency#suppliers and App\Entity\Supplier#multiCurrency are inconsistent with each other.
App\Entity\PostCode No errors.
App\Entity\CustomerProformaItem No errors.
App\Entity\CustomerProformaAddress No errors.
App\Entity\CustomerProformaDelivery No errors.
App\Entity\CustomerInvoiceItem No errors.
App\Entity\CustomerInvoiceAddress No errors.
App\Entity\CustomerInvoiceDelivery No errors.
App\Entity\CustomerAllocate No errors.
App\Entity\Journal No errors.
App\Entity\CustomerRma No errors.
App\Entity\CustomerCreditMemo No errors.
App\Entity\PurchaseInvoice No errors.
App\Entity\WebOrderQuestionAnswers No errors.
App\Entity\EmailSended No errors.
App\Entity\CustomerAuthorizedPerson No errors.
App\Entity\CustomerNotes
  • The association App\Entity\CustomerNotes#contact refers to the inverse side field App\Entity\CustomerContact#notes which does not exist.
App\Entity\CustomerExNotes No errors.
App\Entity\SpecialPricing No errors.
App\Entity\CustomerRefund
  • The association App\Entity\CustomerRefund#pettyCashAccount refers to the inverse side field App\Entity\PettyCashAccount#customerRefund which does not exist.
App\Entity\CustomerAllocation No errors.
App\Entity\CustomerMerchandising No errors.
App\Entity\ApiUser No errors.
App\Entity\CustomerType No errors.
App\Entity\Country No errors.
App\Entity\SalesRepresentative No errors.
App\Entity\TaxDescription
  • The association App\Entity\TaxDescription#pettyCashPaymentExpenses refers to the owning side field App\Entity\PettyCashPaymentExpenses#tax which is not defined as association, but as field.
  • The association App\Entity\TaxDescription#pettyCashPaymentExpenses refers to the owning side field App\Entity\PettyCashPaymentExpenses#tax which does not exist.
  • The association App\Entity\TaxDescription#pettyCashReceiptExpenses refers to the owning side field App\Entity\PettyCashReceiptExpenses#tax which is not defined as association, but as field.
  • The association App\Entity\TaxDescription#pettyCashReceiptExpenses refers to the owning side field App\Entity\PettyCashReceiptExpenses#tax which does not exist.
App\Entity\AccountCode
  • The mappings App\Entity\AccountCode#pettyCashReceiptExpenses and App\Entity\PettyCashPaymentExpenses#accountCode are inconsistent with each other.
App\Entity\JobTitle No errors.
App\Entity\ItemSupplier No errors.
App\Entity\PurchaseOrderRequisitionItem No errors.
App\Entity\PurchaseOrderItem No errors.
App\Entity\GoodsReceivedItem No errors.
App\Entity\ReturnToSupplierItem No errors.
App\Entity\CustomerRmaItem No errors.
App\Entity\CustomerCreditMemoItem No errors.
App\Entity\GroupItem No errors.
App\Entity\StockAdjustmentItem No errors.
App\Entity\PurchaseInvoiceItem No errors.
App\Entity\DebitMemoItem No errors.
App\Entity\ItemWarehouse No errors.
App\Entity\ItemCosts No errors.
App\Entity\CorporateItem No errors.
App\Entity\CorporateItemDetail No errors.
App\Entity\UnitMeasure No errors.
App\Entity\UnitType No errors.
App\Entity\CostingMethod No errors.
App\Entity\ServiceLevel No errors.
App\Entity\Settings No errors.
App\Entity\SystemSettings No errors.
App\Entity\BankAccount No errors.
App\Entity\PettyCashAccount No errors.
App\Entity\PaymentType No errors.
App\Entity\BankReconciliation No errors.
App\Entity\DepositReceipts
  • The association App\Entity\DepositReceipts#bankAccount refers to the inverse side field App\Entity\BankAccount#depositReceipts which does not exist.
  • The association App\Entity\DepositReceipts#multiCurrency refers to the inverse side field App\Entity\MultiCurrency#depositReceipts which does not exist.
App\Entity\PurchaseOrderRequisition No errors.
App\Entity\GoodsReceived No errors.
App\Entity\Supplier
  • The association App\Entity\Supplier#multiCurrency refers to the inverse side field App\Entity\MultiCurrency#supplier which does not exist.
App\Entity\SupplierContact
  • The association App\Entity\SupplierContact#country refers to the inverse side field App\Entity\Country#supplierDefaultContact which does not exist.
App\Entity\LogKayitlari No errors.
App\Entity\UserRole No errors.
App\Entity\Log No errors.
App\Entity\ReturnToSupplier No errors.
App\Entity\DebitMemo No errors.
App\Entity\SupplierPayment No errors.
App\Entity\SupplierRefund No errors.
App\Entity\ShippingMethodType No errors.
App\Entity\WarehouseAuthorizedPerson No errors.
App\Entity\CustomerRmaDelivery No errors.
App\Entity\CustomerCreditMemoDelivery No errors.
App\Entity\StockAdjustment No errors.
App\Entity\StockTake No errors.
App\Entity\OpeningBalanceCustomer
  • The association App\Entity\OpeningBalanceCustomer#customer refers to the inverse side field App\Entity\Customer#openingBalance which does not exist.
App\Entity\OpeningBalanceSupplier No errors.
App\Entity\OpeningBalanceBank No errors.
App\Entity\JournalItems No errors.
App\Entity\BankPayment No errors.
App\Entity\BankReceipt No errors.
App\Entity\PettyCashPayment No errors.
App\Entity\PettyCashReceipt No errors.
App\Entity\TransferFund No errors.
App\Entity\ZonePallet No errors.
App\Entity\JournalType No errors.
App\Entity\OpeningBalanceStocks
  • The association App\Entity\OpeningBalanceStocks#multiCurrency refers to the inverse side field App\Entity\MultiCurrency#openingBalanceStocks which does not exist.
App\Entity\CustomerRmaAddress No errors.
App\Entity\CustomerCreditMemoAddress No errors.
App\Entity\Allocate No errors.
App\Entity\PurchaseInvoiceExpenses No errors.
App\Entity\PurchaseInvoiceAddress No errors.
App\Entity\WebOrderQuestions No errors.
App\Entity\EmailSendedAttachments No errors.
App\Entity\Merchandising No errors.
App\Entity\SubCrm
  • The association App\Entity\SubCrm#webSite refers to the inverse side field App\Entity\WebSite#subCrm which does not exist.
App\Entity\ApiUserRole No errors.
App\Entity\Shipping No errors.
App\Entity\Bank No errors.
App\Entity\DebitMemoExpenses No errors.
App\Entity\PettyCashPaymentExpenses
  • The mappings App\Entity\PettyCashPaymentExpenses#taxCode and App\Entity\TaxDescription#pettyCashPaymentExpenses are inconsistent with each other.
App\Entity\PettyCashReceiptExpenses
  • The mappings App\Entity\PettyCashReceiptExpenses#taxCode and App\Entity\TaxDescription#pettyCashReceiptExpenses are inconsistent with each other.
App\Entity\BankPaymentExpenses
  • The association App\Entity\BankPaymentExpenses#taxCode refers to the inverse side field App\Entity\TaxDescription#bankPaymentExpenses which does not exist.
App\Entity\BankReceiptExpenses
  • The association App\Entity\BankReceiptExpenses#taxCode refers to the inverse side field App\Entity\TaxDescription#bankReceiptExpenses which does not exist.
App\Entity\AccountGroup No errors.
App\Entity\AccountSubGroup No errors.
App\Entity\AccountType No errors.
App\Entity\CorporateItemPhoto No errors.
App\Entity\CorporateLanguage No errors.
App\Entity\CorporateCategory
  • The association App\Entity\CorporateCategory#corporateItems refers to the owning side field App\Entity\CorporateItem#categories which does not exist.
App\Entity\CorporateItemInfo No errors.
App\Entity\CorporateItemTechnical No errors.
App\Entity\CorporateItemSize No errors.
App\Entity\EmailSettings No errors.
App\Entity\Allocation No errors.
App\Entity\SupplierNotes No errors.
App\Entity\LogIslemleri No errors.
App\Entity\RoutePermissions
  • The association App\Entity\RoutePermissions#route refers to the inverse side field App\Entity\Routes#role which does not exist.
App\Entity\Routes
  • The mappings App\Entity\Routes#permissions and App\Entity\RoutePermissions#route are inconsistent with each other.
App\Entity\StockTakeItem No errors.
App\Entity\CorporateItemInfoOption No errors.
App\Entity\CorporateCategoryBanner
  • The association App\Entity\CorporateCategoryBanner#category refers to the inverse side field App\Entity\Category#corporateCategoryBanners which does not exist.
App\Entity\IonicCrmCollections No errors.
App\Entity\IonicCrmTeam No errors.
App\Entity\IonicCrmTeamPage No errors.
App\Entity\IonicCrmMenu No errors.
App\Entity\IonicCrmCollectionBanner No errors.
App\Entity\IonicCrmBanner No errors.
App\Entity\IonicCrmStories No errors.
App\Entity\IonicCrmTags No errors.
App\Entity\IonicCrmPages No errors.
App\Entity\IonicCrmFooter No errors.
App\Entity\CorporateSize No errors.
App\Entity\EmailAttachments No errors.
App\Entity\RouteGroups No errors.
App\Entity\IonicCrmCollectionImages No errors.
App\Entity\IonicCrmStoryImages No errors.
App\Entity\IonicCrmPageImages No errors.