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.
258 Anfragen; Gesamtdauer: 228.5590171814 Millisekunden
| Query | Dauer (ms) |
|---|---|
| SELECT * FROM user__session where (session_key = "c17395b0185fdd101ff06ceab41cca14" and session_expires > CURRENT_TIMESTAMP()) | 0.46706199645996 |
| SELECT * FROM user__session where (session_key = "c17395b0185fdd101ff06ceab41cca14" and session_expires > CURRENT_TIMESTAMP()) | 0.19598007202148 |
| 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 | 0.61917304992676 |
| 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 | 0.89716911315918 |
| SELECT post__taxonomy.* FROM post__taxonomy where permalink = "guide"; | 1.0771751403809 |
| SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 | 0.84185600280762 |
| SELECT * FROM post__taxonomy where (status = "publish") order by title ASC | 0.51593780517578 |
| SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 | 0.27799606323242 |
| 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 | 5.8469772338867 |
| 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) | 2.9351711273193 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 119 | 0.49304962158203 |
| SELECT file_path FROM attachment where attachment_id = 1051 | 0.44107437133789 |
| SELECT * FROM stock_attachment where stock_attachment_id = 67 | 0.9758472442627 |
| 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 | 5.5880546569824 |
| SELECT * FROM product__meta where product_id IN (590, 293, 933) | 0.57291984558105 |
| 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.32782554626465 |
| 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.51784515380859 |
| 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.53215026855469 |
| 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.71907043457031 |
| SELECT * FROM product__meta where product_id IN (540) | 0.36406517028809 |
| 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 | 2.9749870300293 |
| 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 | 7.5900554656982 |
| SELECT * FROM product__meta where product_id IN (1037, 1034, 1035, 288) | 0.69594383239746 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1037 | 0.23889541625977 |
| 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 = 1037 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.37407875061035 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1037 | 0.36096572875977 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1037 | 0.26702880859375 |
| 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 = 1037 and smarthome_system.status = "publish")) | 0.2901554107666 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1034 | 0.26702880859375 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1035 | 0.20718574523926 |
| 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 = 1035 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.34999847412109 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1035 | 0.27799606323242 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1035 | 0.30708312988281 |
| 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 = 1035 and smarthome_system.status = "publish")) | 0.26798248291016 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 288 | 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 = 288 and smarthome_system.status = "publish")) | 0.25200843811035 |
| 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.0070285797119 |
| SELECT * FROM product__meta where product_id IN (14, 208, 490) | 2.4981498718262 |
| 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.33688545227051 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 208 | 0.2291202545166 |
| 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.41103363037109 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 208 | 0.2901554107666 |
| 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.49090385437012 |
| 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 = 208 and smarthome_system.status = "publish")) | 0.30088424682617 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 490 | 0.20003318786621 |
| 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.29611587524414 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 490 | 0.26798248291016 |
| 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.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 = 490 and smarthome_system.status = "publish")) | 0.25296211242676 |
| 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.47802925109863 |
| SELECT * FROM product__meta where product_id IN (859) | 0.26106834411621 |
| 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.25486946105957 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 115 | 0.29110908508301 |
| SELECT file_path FROM attachment where attachment_id = 921 | 0.47707557678223 |
| 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.3229846954346 |
| SELECT * FROM product__meta where product_id IN (607, 249, 252, 248) | 1.2619495391846 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 607 | 0.26583671569824 |
| 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.44703483581543 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 607 | 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 = 607 | 0.32496452331543 |
| 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.3209114074707 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 | 0.2288818359375 |
| 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.66614151000977 |
| 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.26607513427734 |
| 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.8658847808838 |
| SELECT * FROM product__meta where product_id IN (75) | 0.53596496582031 |
| 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.29277801513672 |
| SELECT * FROM stock_attachment where stock_attachment_id = 61 | 0.26202201843262 |
| 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 | 5.3749084472656 |
| SELECT * FROM product__meta where product_id IN (209, 208, 980, 14) | 1.0731220245361 |
| 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.32901763916016 |
| 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.29897689819336 |
| 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.2739429473877 |
| 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.23388862609863 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 106 | 0.39100646972656 |
| SELECT file_path FROM attachment where attachment_id = 872 | 0.52309036254883 |
| SELECT * FROM stock_attachment where stock_attachment_id = 44 | 0.25486946105957 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 108 | 0.26297569274902 |
| SELECT file_path FROM attachment where attachment_id = 874 | 0.16093254089355 |
| 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 | 4.6999454498291 |
| SELECT * FROM product__meta where product_id IN (768, 771, 772) | 0.42080879211426 |
| 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.30803680419922 |
| 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.33307075500488 |
| 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.25820732116699 |
| 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 | 7.1768760681152 |
| 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 | 6.7169666290283 |
| SELECT * FROM product__meta where product_id IN (759, 606, 937, 938) | 0.6251335144043 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 759 | 0.42390823364258 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 606 | 0.38814544677734 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 937 | 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 = 938 | 0.29301643371582 |
| 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 = 938 and smarthome_system.status = "publish")) | 0.30088424682617 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 113 | 0.39815902709961 |
| SELECT file_path FROM attachment where attachment_id = 897 | 0.22578239440918 |
| SELECT * FROM stock_attachment where stock_attachment_id = 53 | 0.22602081298828 |
| 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.27608871459961 |
| 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.21004676818848 |
| 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.23293495178223 |
| SELECT * FROM stock_attachment where stock_attachment_id = 19 | 0.52404403686523 |
| 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.1329135894775 |
| SELECT * FROM product__meta where product_id IN (1028, 1044, 1030, 988) | 0.72312355041504 |
| 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.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 = 1044 | 0.2281665802002 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 1030 | 0.23388862609863 |
| 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.38599967956543 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1030 | 0.28109550476074 |
| 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.2601146697998 |
| 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.23293495178223 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 988 | 0.2281665802002 |
| 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 = 988 and smarthome_system.status = "publish")) | 0.24104118347168 |
| SELECT * FROM stock_attachment where stock_attachment_id = 38 | 0.26297569274902 |
| 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 | 8.6658000946045 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 116 | 0.50616264343262 |
| SELECT file_path FROM attachment where attachment_id = 1002 | 0.31208992004395 |
| SELECT * FROM attachment where attachment_id = 1003 | 0.3659725189209 |
| SELECT * FROM attachment where attachment_id = 986 | 0.26106834411621 |
| SELECT * FROM attachment where attachment_id = 982 | 0.20980834960938 |
| SELECT * FROM attachment where attachment_id = 983 | 0.21004676818848 |
| SELECT * FROM attachment where attachment_id = 984 | 0.20503997802734 |
| 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 | 1.2459754943848 |
| 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.34999847412109 |
| 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.38790702819824 |
| 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.30899047851562 |
| 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.31018257141113 |
| 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.29206275939941 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 112 | 0.40888786315918 |
| SELECT file_path FROM attachment where attachment_id = 896 | 0.21719932556152 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1037 | 0.32186508178711 |
| 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 = 1037 and smarthome_system.status = "publish")) | 0.32901763916016 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1034 | 0.32997131347656 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1035 | 0.29587745666504 |
| 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 = 1035 and smarthome_system.status = "publish")) | 0.33998489379883 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 288 | 0.28491020202637 |
| 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 = 288 and smarthome_system.status = "publish")) | 0.30708312988281 |
| 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 | 9.9809169769287 |
| SELECT * FROM product__meta where product_id IN (590, 293, 933, 75) | 1.0721683502197 |
| 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.34308433532715 |
| 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.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 = 933 | 0.28014183044434 |
| 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.23484230041504 |
| 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 | 5.3980350494385 |
| SELECT * FROM stock_attachment where stock_attachment_id = 7 | 0.2591609954834 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 105 | 0.29993057250977 |
| SELECT file_path FROM attachment where attachment_id = 871 | 0.18310546875 |
| 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 | 4.8179626464844 |
| SELECT * FROM product__meta where product_id IN (249, 1009, 781, 648) | 0.59199333190918 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 | 0.29516220092773 |
| 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.26583671569824 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 781 | 0.26202201843262 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 648 | 0.20790100097656 |
| 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 = 648 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.32997131347656 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 648 | 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 = 648 | 0.26893615722656 |
| 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 = 648 and smarthome_system.status = "publish")) | 0.34308433532715 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 102 | 0.46515464782715 |
| SELECT file_path FROM attachment where attachment_id = 869 | 0.27799606323242 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 | 0.35905838012695 |
| 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.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 = 781 | 0.36787986755371 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 648 | 0.3659725189209 |
| 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 = 648 and smarthome_system.status = "publish")) | 0.33998489379883 |
| SELECT * FROM stock_attachment where stock_attachment_id = 39 | 0.75602531433105 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 114 | 0.37002563476562 |
| SELECT file_path FROM attachment where attachment_id = 898 | 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 (1) or product__taxonomy_virtual_mapping.taxonomy_id in (1))) group by product.product_id order by RAND() limit 4 | 7.227897644043 |
| SELECT * FROM product__meta where product_id IN (1000, 292, 23, 253) | 2.3260116577148 |
| 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.3819465637207 |
| 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.33402442932129 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 23 | 0.23889541625977 |
| 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.44798851013184 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 23 | 0.40483474731445 |
| 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.3669261932373 |
| 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.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 = 253 | 0.32901763916016 |
| 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 | 7.6911449432373 |
| SELECT * FROM product__meta where product_id IN (90, 249, 1012, 252) | 2.0921230316162 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 90 | 0.36191940307617 |
| 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.50115585327148 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 90 | 0.4730224609375 |
| 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.33116340637207 |
| 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 = 90 and smarthome_system.status = "publish")) | 0.37407875061035 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 | 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 = 1012 | 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 = 252 | 0.31018257141113 |
| 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.35810470581055 |
| 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.30183792114258 |
| 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.34117698669434 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 107 | 1.0280609130859 |
| SELECT file_path FROM attachment where attachment_id = 873 | 0.25200843811035 |
| 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 | 5.1038265228271 |
| 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.39410591125488 |
| 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.49400329589844 |
| SELECT * FROM product__meta where product_id IN (300) | 0.74005126953125 |
| 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.35405158996582 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 104 | 0.4880428314209 |
| SELECT file_path FROM attachment where attachment_id = 870 | 0.24700164794922 |
| 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 | 8.080005645752 |
| SELECT * FROM product__meta where product_id IN (531, 590, 1070, 1022) | 0.58984756469727 |
| 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.54097175598145 |
| 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.45585632324219 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1070 | 0.33712387084961 |
| 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 = 1070 and smarthome_system.status = "publish")) | 0.37097930908203 |
| 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.34308433532715 |
| 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 | 7.5681209564209 |
| SELECT * FROM product__meta where product_id IN (538, 75, 258, 946) | 1.3890266418457 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 538 | 0.41389465332031 |
| 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.37717819213867 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 258 | 0.37813186645508 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 946 | 0.67782402038574 |
| 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 = 946 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.46300888061523 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_mapping ON product__taxonomy_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 946 | 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 = 946 | 0.30803680419922 |
| 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 = 946 and smarthome_system.status = "publish")) | 0.38504600524902 |
| SELECT file_path FROM attachment where attachment_id = 1017 | 0.29397010803223 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 109 | 0.44393539428711 |
| SELECT file_path FROM attachment where attachment_id = 899 | 0.26702880859375 |
| SELECT * FROM stock_attachment where stock_attachment_id = 43 | 0.28896331787109 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 249 | 0.38886070251465 |
| 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.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 = 781 | 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 = 648 | 0.39792060852051 |
| 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 = 648 and smarthome_system.status = "publish")) | 0.39100646972656 |
| SELECT * FROM stock_attachment where stock_attachment_id = 7 | 0.29897689819336 |
| 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.33307075500488 |
| 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.31709671020508 |
| 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.38599967956543 |
| 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.31805038452148 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 988 | 0.32186508178711 |
| 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 = 988 and smarthome_system.status = "publish")) | 0.30612945556641 |
| 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.77915191650391 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 98 | 0.36191940307617 |
| SELECT file_path FROM attachment where attachment_id = 866 | 0.22196769714355 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 95 | 0.8399486541748 |
| SELECT file_path FROM attachment where attachment_id = 900 | 0.29206275939941 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 86 | 0.37598609924316 |
| SELECT file_path FROM attachment where attachment_id = 792 | 0.23102760314941 |
| SELECT * FROM product where status = "publish" and product_id_old IN (5228) | 1.9180774688721 |
| SELECT * FROM product__meta where product_id IN (294) | 0.64396858215332 |
| 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.3659725189209 |
| 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.38409233093262 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 84 | 0.34999847412109 |
| SELECT file_path FROM attachment where attachment_id = 613 | 0.22292137145996 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B06Y1ZPNMS") limit 1 | 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 = 21 | 0.27298927307129 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B071P98VTG") limit 1 | 0.30398368835449 |
| 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.27108192443848 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B06Y1ZPNMS") limit 1 | 0.43010711669922 |
| 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.28491020202637 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B071P98VTG") limit 1 | 0.32281875610352 |
| 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.30899047851562 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 77 | 0.31900405883789 |
| SELECT file_path FROM attachment where attachment_id = 412 | 0.21481513977051 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B075RLRGDM") limit 1 | 0.52380561828613 |
| SELECT product.* FROM product LEFT join product__link on product__link.product_id = product.product_id where (external_id = "B075RLRGDM") limit 1 | 1.1460781097412 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 75 | 0.42295455932617 |
| SELECT file_path FROM attachment where attachment_id = 379 | 0.22792816162109 |
| SELECT * FROM post__taxonomy JOIN post__taxonomy_mapping ON post__taxonomy_mapping.taxonomy_id = post__taxonomy.post__taxonomy_id where post_id = 73 | 0.31399726867676 |
| SELECT file_path FROM attachment where attachment_id = 230 | 0.4880428314209 |
Wird geladen...
