In den Smarthome Guide-Artikeln berate ich dich in verschiedenen Bereichen rund ums Thema Smarthome. Dabei gebe ich dir wertvolle Informationen zu einem Produkt oder einem Thema oder helfe dir dabei, das richtige Smarthome System für dich zu wählen.
In den Smarthome Guide-Artikeln berate ich dich in verschiedenen Bereichen rund ums Thema Smarthome. Dabei gebe ich dir wertvolle Informationen zu einem Produkt oder einem Thema oder helfe dir dabei, das richtige Smarthome System für dich zu wählen.
372 Anfragen; Gesamtdauer: 282.83286094666 Millisekunden
| Query | Dauer (ms) |
|---|---|
| SELECT * FROM user__session where (session_key = "5adb6ca6886e85388af67f0c1cca5be3" and session_expires > CURRENT_TIMESTAMP()) | 0.59795379638672 |
| SELECT * FROM user__session where (session_key = "5adb6ca6886e85388af67f0c1cca5be3" and session_expires > CURRENT_TIMESTAMP()) | 0.37193298339844 |
| SELECT * FROM redirect | 0.24890899658203 |
| SELECT * FROM tracking_code | 0.94890594482422 |
| SELECT *, (page_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(page_date, "%d.%m.%Y") as formatted_date FROM page where permalink = "guide" LIMIT 1 | 1.1169910430908 |
| SELECT *, (post_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(post_date, "%d.%m.%Y") as formatted_date FROM post where permalink = "guide" LIMIT 1 | 1.3301372528076 |
| SELECT post__taxonomy.* FROM post__taxonomy where permalink = "guide"; | 1.3940334320068 |
| SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 | 3.2041072845459 |
| SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 | 0.33688545227051 |
| SELECT post.*, (post_date <= NOW() AND status = "publish") as is_already_published FROM post JOIN post__taxonomy_mapping ON post.post_id = post__taxonomy_mapping.post_id where (post_date <= NOW() AND status = "publish") and post__taxonomy_mapping.taxonomy_id = 7 ORDER BY post.post_date DESC | 6.4628124237061 |
| SELECT * FROM post__meta where post_id IN (119, 115, 106, 108, 113, 116, 112, 105, 102, 114, 107, 104, 109, 110, 98, 95, 86, 84, 77, 75, 73) | 1.66916847229 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 119 | 0.63395500183105 |
| SELECT * FROM stock_attachment where stock_attachment_id = 67 | 0.8549690246582 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (55) or product__taxonomy_virtual_mapping.taxonomy_id in (55))) group by product.product_id order by RAND() limit 4 | 16.013145446777 |
| SELECT * FROM product__meta where product_id IN (590, 293, 933) | 7.2941780090332 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 590 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.63419342041016 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 590 | 2.8059482574463 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 590 | 0.31685829162598 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 293 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.41890144348145 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 293 | 0.87380409240723 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 293 | 0.27918815612793 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 933 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.42009353637695 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 933 | 0.63514709472656 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 933 | 0.32401084899902 |
| SELECT * FROM product__taxonomy where (status = "publish") order by title ASC | 2.485990524292 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product.product_id in (540)) group by product.product_id order by RAND() limit 4 | 0.55384635925293 |
| SELECT * FROM product__meta where product_id IN (540) | 1.1718273162842 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 540 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.41818618774414 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 540 | 0.4119873046875 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 540 | 0.24008750915527 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (15) or product__taxonomy_virtual_mapping.taxonomy_id in (15))) group by product.product_id order by RAND() limit 4 | 5.1789283752441 |
| SELECT * FROM product__meta where product_id IN (1022, 871, 446, 1008) | 2.4781227111816 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1022 | 0.27298927307129 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1022 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.4119873046875 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1022 | 0.39100646972656 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1022 | 0.2739429473877 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1022 and smarthome_system.status = "publish")) | 0.77986717224121 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 871 | 0.24604797363281 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 871 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.43702125549316 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 871 | 0.3511905670166 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 871 | 0.26512145996094 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 871 and smarthome_system.status = "publish")) | 0.3349781036377 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 446 | 0.21696090698242 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 446 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.34880638122559 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 446 | 0.62108039855957 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 446 | 0.26583671569824 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 446 and smarthome_system.status = "publish")) | 0.26297569274902 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1008 | 0.20384788513184 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1008 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.37002563476562 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1008 | 0.34594535827637 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1008 | 0.50592422485352 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1008 and smarthome_system.status = "publish")) | 0.26512145996094 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (18) or product__taxonomy_virtual_mapping.taxonomy_id in (18))) group by product.product_id order by RAND() limit 4 | 5.5279731750488 |
| SELECT * FROM product__meta where product_id IN (490, 14, 208) | 4.1720867156982 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 490 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.46205520629883 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 490 | 0.33116340637207 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 490 | 0.25701522827148 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 14 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.28705596923828 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 14 | 0.24795532226562 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 14 | 0.23198127746582 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 208 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.35595893859863 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 208 | 0.4880428314209 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 208 | 0.1990795135498 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product.product_id in (859)) group by product.product_id order by RAND() limit 4 | 0.51188468933105 |
| SELECT * FROM product__meta where product_id IN (859) | 0.69999694824219 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 859 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.3659725189209 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 859 | 0.53977966308594 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 859 | 0.24986267089844 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 115 | 0.32687187194824 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product.product_id in (437,103,248,251,249,252,598,607,356,353,279,285,282,432,359,352,79,83,102,101,354,435,532,189,361,358,187,78,355,226,636,458,634,90,357,362)) group by product.product_id order by RAND() limit 4 | 1.3048648834229 |
| SELECT * FROM product__meta where product_id IN (90, 248, 252, 607) | 4.0528774261475 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 90 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.36811828613281 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 90 | 0.33903121948242 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 90 | 0.2288818359375 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 248 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.33211708068848 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 | 0.29802322387695 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 | 0.20408630371094 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 252 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.31685829162598 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 | 0.32615661621094 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 252 | 0.21004676818848 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 607 | 0.21696090698242 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 607 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.33998489379883 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 607 | 0.33116340637207 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 607 | 0.20480155944824 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 607 and smarthome_system.status = "publish")) | 0.26106834411621 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (56) or product__taxonomy_virtual_mapping.taxonomy_id in (56))) group by product.product_id order by RAND() limit 4 | 4.8019886016846 |
| SELECT * FROM product__meta where product_id IN (75) | 1.30295753479 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 75 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.43797492980957 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 75 | 0.42009353637695 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 75 | 0.22792816162109 |
| SELECT * FROM stock_attachment where stock_attachment_id = 61 | 0.21910667419434 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (18,50,16,21) or product__taxonomy_virtual_mapping.taxonomy_id in (18,50,16,21))) group by product.product_id order by RAND() limit 4 | 4.8611164093018 |
| SELECT * FROM product__meta where product_id IN (209, 1028, 490, 980) | 1.8398761749268 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 209 | 0.25701522827148 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 209 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.32615661621094 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 209 | 0.38909912109375 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 209 | 0.26988983154297 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 209 and smarthome_system.status = "publish")) | 0.52309036254883 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1028 | 0.22482872009277 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1028 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.36096572875977 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1028 | 0.30708312988281 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1028 | 0.26297569274902 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1028 and smarthome_system.status = "publish")) | 0.2448558807373 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 490 | 0.23198127746582 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 980 | 0.17809867858887 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 980 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.28681755065918 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 980 | 0.34904479980469 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 980 | 0.24294853210449 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 980 and smarthome_system.status = "publish")) | 0.34403800964355 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 106 | 0.38003921508789 |
| SELECT * FROM stock_attachment where stock_attachment_id = 44 | 0.28800964355469 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 108 | 0.26178359985352 |
| SELECT file_path FROM attachment where attachment_id = 874 | 0.59604644775391 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (29) or product__taxonomy_virtual_mapping.taxonomy_id in (29))) group by product.product_id order by RAND() limit 4 | 5.2258968353271 |
| SELECT * FROM product__meta where product_id IN (772, 768, 771) | 0.74505805969238 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 772 | 0.37097930908203 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 772 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.75793266296387 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 772 | 0.3049373626709 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 772 | 0.24890899658203 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 772 and smarthome_system.status = "publish")) | 0.25510787963867 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 768 | 0.19121170043945 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 768 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.29897689819336 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 768 | 0.40721893310547 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 768 | 0.21600723266602 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 768 and smarthome_system.status = "publish")) | 0.25510787963867 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 771 | 0.24700164794922 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 771 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.31495094299316 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 771 | 0.23007392883301 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 771 | 0.22101402282715 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 771 and smarthome_system.status = "publish")) | 0.32711029052734 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (71) or product__taxonomy_virtual_mapping.taxonomy_id in (71))) group by product.product_id order by RAND() limit 4 | 6.4229965209961 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (54) or product__taxonomy_virtual_mapping.taxonomy_id in (54))) group by product.product_id order by RAND() limit 4 | 4.9059391021729 |
| SELECT * FROM product__meta where product_id IN (250, 936, 1010, 1009) | 2.2890567779541 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 250 | 0.28014183044434 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 250 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 1.2860298156738 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 250 | 0.52499771118164 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 250 | 0.37598609924316 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 250 and smarthome_system.status = "publish")) | 0.46801567077637 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 936 | 0.27203559875488 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 936 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.35905838012695 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 936 | 0.52809715270996 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 936 | 0.27704238891602 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 936 and smarthome_system.status = "publish")) | 0.3049373626709 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1010 | 0.25105476379395 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1010 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.34785270690918 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1010 | 0.42104721069336 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1010 | 0.35810470581055 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1010 and smarthome_system.status = "publish")) | 0.28705596923828 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1009 | 0.23078918457031 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1009 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.4429817199707 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1009 | 0.41103363037109 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1009 | 0.23794174194336 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1009 and smarthome_system.status = "publish")) | 0.38385391235352 |
| SELECT file_path FROM attachment where attachment_id = 1015 | 0.5650520324707 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 113 | 0.37598609924316 |
| SELECT file_path FROM attachment where attachment_id = 897 | 0.53191184997559 |
| SELECT * FROM stock_attachment where stock_attachment_id = 53 | 0.2291202545166 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 490 | 0.30517578125 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 14 | 0.28610229492188 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 208 | 0.3199577331543 |
| SELECT * FROM stock_attachment where stock_attachment_id = 19 | 0.60200691223145 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (50) or product__taxonomy_virtual_mapping.taxonomy_id in (50))) group by product.product_id order by RAND() limit 4 | 5.1338672637939 |
| SELECT * FROM product__meta where product_id IN (1044, 961, 1030, 1028) | 1.568078994751 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1044 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.40483474731445 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1044 | 0.35595893859863 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1044 | 0.24890899658203 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 961 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.31208992004395 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 961 | 0.34093856811523 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 961 | 0.26392936706543 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1030 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.32401084899902 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1030 | 0.31590461730957 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1030 | 0.30303001403809 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1030 and smarthome_system.status = "publish")) | 0.28181076049805 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1028 | 0.2601146697998 |
| SELECT * FROM stock_attachment where stock_attachment_id = 38 | 0.24580955505371 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (23) or product__taxonomy_virtual_mapping.taxonomy_id in (23))) group by product.product_id order by RAND() limit 4 | 4.4682025909424 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 116 | 0.37908554077148 |
| SELECT file_path FROM attachment where attachment_id = 1002 | 0.18596649169922 |
| SELECT * FROM attachment where attachment_id = 1003 | 0.24294853210449 |
| SELECT * FROM attachment where attachment_id = 986 | 0.1678466796875 |
| SELECT * FROM attachment where attachment_id = 982 | 0.16617774963379 |
| SELECT * FROM attachment where attachment_id = 983 | 0.14710426330566 |
| SELECT * FROM attachment where attachment_id = 984 | 0.14686584472656 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id join brand__product_mapping on brand__product_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (2) or product__taxonomy_virtual_mapping.taxonomy_id in (2)) and brand__product_mapping.brand_id in (47)) group by product.product_id order by RAND() limit 4 | 2.720832824707 |
| SELECT * FROM product__meta where product_id IN (540, 880, 843) | 1.0020732879639 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 540 | 0.29301643371582 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 880 | 0.22196769714355 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 880 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.35810470581055 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 880 | 0.27108192443848 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 880 | 0.23698806762695 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 880 and smarthome_system.status = "publish")) | 0.25200843811035 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 843 | 0.16498565673828 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 843 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.28014183044434 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 843 | 0.27704238891602 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 843 | 0.27704238891602 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 843 and smarthome_system.status = "publish")) | 0.23508071899414 |
| SELECT file_path FROM attachment where attachment_id = 1014 | 0.26202201843262 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 112 | 0.29802322387695 |
| SELECT file_path FROM attachment where attachment_id = 896 | 0.20098686218262 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1022 | 0.27203559875488 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 871 | 0.24294853210449 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 871 and smarthome_system.status = "publish")) | 0.26297569274902 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 446 | 0.23198127746582 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 446 and smarthome_system.status = "publish")) | 0.25391578674316 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1008 | 0.22292137145996 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1008 and smarthome_system.status = "publish")) | 0.2281665802002 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (56,55) or product__taxonomy_virtual_mapping.taxonomy_id in (56,55))) group by product.product_id order by RAND() limit 4 | 4.53782081604 |
| SELECT * FROM product__meta where product_id IN (293, 75, 933, 590) | 0.8089542388916 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 293 | 0.32305717468262 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 75 | 0.33092498779297 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 933 | 0.27203559875488 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 590 | 0.28681755065918 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (40) or product__taxonomy_virtual_mapping.taxonomy_id in (40))) group by product.product_id order by RAND() limit 4 | 6.6919326782227 |
| SELECT * FROM stock_attachment where stock_attachment_id = 7 | 0.28395652770996 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 105 | 0.30708312988281 |
| SELECT file_path FROM attachment where attachment_id = 871 | 0.22506713867188 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (12) or product__taxonomy_virtual_mapping.taxonomy_id in (12))) group by product.product_id order by RAND() limit 4 | 5.1350593566895 |
| SELECT * FROM product__meta where product_id IN (1014, 251, 945, 607) | 1.0659694671631 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1014 | 0.23007392883301 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1014 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.45299530029297 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1014 | 0.45895576477051 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1014 | 0.29897689819336 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1014 and smarthome_system.status = "publish")) | 0.3511905670166 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 251 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.37717819213867 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 | 0.37693977355957 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 | 0.26988983154297 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 945 | 0.1988410949707 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 945 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.33783912658691 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 945 | 0.32591819763184 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 945 | 0.24318695068359 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 945 and smarthome_system.status = "publish")) | 0.27108192443848 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 607 | 0.22792816162109 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 102 | 0.28777122497559 |
| SELECT file_path FROM attachment where attachment_id = 869 | 0.25796890258789 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1014 | 0.2748966217041 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 | 0.22101402282715 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 945 | 0.26297569274902 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 607 | 0.24104118347168 |
| SELECT * FROM stock_attachment where stock_attachment_id = 39 | 0.27108192443848 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 114 | 0.29587745666504 |
| SELECT file_path FROM attachment where attachment_id = 898 | 0.18191337585449 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (1) or product__taxonomy_virtual_mapping.taxonomy_id in (1))) group by product.product_id order by RAND() limit 4 | 4.342794418335 |
| SELECT * FROM product__meta where product_id IN (1000, 531, 23, 292) | 2.0220279693604 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1000 | 0.24795532226562 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1000 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.35595893859863 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1000 | 0.30899047851562 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1000 | 0.28586387634277 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1000 and smarthome_system.status = "publish")) | 0.37193298339844 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 531 | 0.26202201843262 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 531 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.51784515380859 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 531 | 0.31900405883789 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 531 | 0.60701370239258 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 531 and smarthome_system.status = "publish")) | 0.26702880859375 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 23 | 0.18000602722168 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 23 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.31185150146484 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 23 | 0.31495094299316 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 23 | 0.21791458129883 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 23 and smarthome_system.status = "publish")) | 0.25105476379395 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 292 | 0.2140998840332 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 292 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.31614303588867 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 292 | 0.32401084899902 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 292 | 0.26917457580566 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 292 and smarthome_system.status = "publish")) | 0.30398368835449 |
| SELECT file_path FROM attachment where attachment_id = 1018 | 0.23984909057617 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (53) or product__taxonomy_virtual_mapping.taxonomy_id in (53))) group by product.product_id order by RAND() limit 4 | 4.6930313110352 |
| SELECT * FROM product__meta where product_id IN (79, 251, 1015, 248) | 2.4988651275635 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 79 | 0.34213066101074 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 79 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.4880428314209 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 79 | 0.45418739318848 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 79 | 0.27704238891602 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 79 and smarthome_system.status = "publish")) | 0.29397010803223 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 | 0.2751350402832 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1015 | 0.20694732666016 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1015 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.40292739868164 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1015 | 0.46300888061523 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1015 | 0.4279613494873 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1015 and smarthome_system.status = "publish")) | 0.32401084899902 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 248 | 0.24795532226562 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 590 | 0.28491020202637 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 293 | 0.2448558807373 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 933 | 0.2601146697998 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 107 | 0.3199577331543 |
| SELECT file_path FROM attachment where attachment_id = 873 | 0.20599365234375 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (13) or product__taxonomy_virtual_mapping.taxonomy_id in (13))) group by product.product_id order by RAND() limit 4 | 4.5061111450195 |
| SELECT * FROM product__meta where product_id IN (210) | 1.36399269104 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 210 | 0.23913383483887 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 210 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.32711029052734 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 210 | 0.41913986206055 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 210 | 0.26798248291016 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 210 and smarthome_system.status = "publish")) | 0.28800964355469 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product.product_id in (300)) group by product.product_id order by RAND() limit 4 | 0.39291381835938 |
| SELECT * FROM product__meta where product_id IN (300) | 1.838207244873 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 300 | 0.25200843811035 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 300 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.31900405883789 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 300 | 0.33116340637207 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 300 | 0.30207633972168 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 300 and smarthome_system.status = "publish")) | 0.27704238891602 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 104 | 0.31208992004395 |
| SELECT file_path FROM attachment where attachment_id = 870 | 0.21004676818848 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (19) or product__taxonomy_virtual_mapping.taxonomy_id in (19))) group by product.product_id order by RAND() limit 4 | 6.3650608062744 |
| SELECT * FROM product__meta where product_id IN (993, 1020, 250, 74) | 2.3820400238037 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 993 | 0.42200088500977 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 993 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.51307678222656 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 993 | 0.43416023254395 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 993 | 0.32520294189453 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 993 and smarthome_system.status = "publish")) | 0.3209114074707 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1020 | 0.19097328186035 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 1020 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.45490264892578 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1020 | 0.36907196044922 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1020 | 0.26202201843262 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1020 and smarthome_system.status = "publish")) | 0.29206275939941 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 250 | 0.31614303588867 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 74 | 0.19097328186035 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 74 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.33807754516602 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 74 | 0.31614303588867 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 74 | 0.23508071899414 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 74 and smarthome_system.status = "publish")) | 0.28896331787109 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id left join product__taxonomy_mapping on product__taxonomy_mapping.product_id = product.product_id left join product__taxonomy_virtual_mapping on product__taxonomy_virtual_mapping.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and (product__taxonomy_mapping.taxonomy_id in (20) or product__taxonomy_virtual_mapping.taxonomy_id in (20))) group by product.product_id order by RAND() limit 4 | 6.3819885253906 |
| SELECT * FROM product__meta where product_id IN (494, 231, 936, 873) | 3.1769275665283 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 494 | 0.31089782714844 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 494 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.41699409484863 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 494 | 0.41508674621582 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 494 | 0.32806396484375 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 494 and smarthome_system.status = "publish")) | 0.31280517578125 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 231 | 0.21004676818848 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 231 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.62394142150879 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 231 | 0.3821849822998 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 231 | 0.32401084899902 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 231 and smarthome_system.status = "publish")) | 0.28419494628906 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 936 | 0.26893615722656 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 873 | 0.23198127746582 |
| SELECT product__link.*, product__shop.sort_order as shop_sort_order, product__shop.product__shop_id as product__shop_id, product__feed.product__feed_id as product__feed_id, product__shop.title as product_shop_title, product__shop.button_text as product_shop_button_text, product__feed.title as product_feed_title FROM product__link LEFT join product__shop on product__shop.product__shop_id = product__link.product__shop_id LEFT join product__feed on product__feed.product__feed_id = product__link.product__feed_id where (product_id = 873 and product__link.is_active = 1) order by product__link.sort_order ASC, product__link.product__shop_id is not NULL DESC, product__shop.sort_order ASC | 0.29182434082031 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 873 | 0.32496452331543 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 873 | 0.53000450134277 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 873 and smarthome_system.status = "publish")) | 0.29993057250977 |
| SELECT file_path FROM attachment where attachment_id = 1016 | 0.28014183044434 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 109 | 0.31185150146484 |
| SELECT file_path FROM attachment where attachment_id = 899 | 0.20599365234375 |
| SELECT * FROM stock_attachment where stock_attachment_id = 43 | 0.18715858459473 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1014 | 0.25796890258789 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 251 | 0.29182434082031 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 945 | 0.26202201843262 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 607 | 0.24008750915527 |
| SELECT * FROM stock_attachment where stock_attachment_id = 7 | 0.24700164794922 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1044 | 0.32687187194824 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 961 | 0.26297569274902 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1030 | 0.28800964355469 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 1030 and smarthome_system.status = "publish")) | 0.30112266540527 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1028 | 0.25010108947754 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 110 | 0.35595893859863 |
| SELECT file_path FROM attachment where attachment_id = 885 | 0.18715858459473 |
| SELECT product.*, AVG(review_value) as avg_rating FROM product join product__link on product__link.product_id = product.product_id left join product__review on product__review.product_id = product.product_id where (( product.status = "publish" and product.product_date <= NOW() ) and product.hide_in_search = 0 and ( product.is_fake = 0 or product__link.is_available = 1 ) and product.product_id in (874,877,875,876)) group by product.product_id order by RAND() limit 4 | 0.53811073303223 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 98 | 0.27084350585938 |
| SELECT file_path FROM attachment where attachment_id = 866 | 0.21481513977051 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 95 | 0.69093704223633 |
| SELECT file_path FROM attachment where attachment_id = 900 | 0.22697448730469 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 294 | 0.31614303588867 |
| SELECT * FROM smarthome_system join smarthome_system__product_mapping on smarthome_system__product_mapping.smarthome_system_id = smarthome_system.smarthome_system_id where ((smarthome_system__product_mapping.product_id = 294 and smarthome_system.status = "publish")) | 0.31495094299316 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B06Y1ZPNMS") limit 1 | 0.3509521484375 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 21 | 0.27799606323242 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B071P98VTG") limit 1 | 0.2899169921875 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 3 | 0.23913383483887 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B06Y1ZPNMS") limit 1 | 0.32806396484375 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 21 | 0.25606155395508 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B071P98VTG") limit 1 | 0.2748966217041 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 3 | 0.2281665802002 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 77 | 0.27108192443848 |
| SELECT file_path FROM attachment where attachment_id = 412 | 0.18000602722168 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B075RLRGDM") limit 1 | 2.0749568939209 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B075RLRGDM") limit 1 | 2.0310878753662 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 75 | 0.45585632324219 |
| SELECT file_path FROM attachment where attachment_id = 379 | 0.27108192443848 |
Wird geladen...
