| Typ | Neubau, Nachrüstung |
| Ohne Cloud nutzbar | |
| Übertragungsart | Kabellos |
| Kompatible Sprachassistenten | Amazon Alexa, Google Assistant |
| Verfügbare Gerätetypen | Beleuchtung, Bewegungsmelder, Überwachungskameras, Türschlösser, Audio-Steuerung, Rolladen, Heizungen |
103 Anfragen; Gesamtdauer: 53.525447845459 Millisekunden
| Query | Dauer (ms) |
|---|---|
| SELECT * FROM user__session where (session_key = "1d41ef2c45c94d75f490c976ee92a394" and session_expires > CURRENT_TIMESTAMP()) | 0.47898292541504 |
| SELECT * FROM user__session where (session_key = "1d41ef2c45c94d75f490c976ee92a394" and session_expires > CURRENT_TIMESTAMP()) | 0.19502639770508 |
| 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 = "wlan" LIMIT 1 | 0.58698654174805 |
| SELECT *, (smarthome_system_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(smarthome_system_date, "%d.%m.%Y") as formatted_date FROM smarthome_system where permalink = "wlan" LIMIT 1 | 0.38409233093262 |
| SELECT * FROM smarthome_system__meta where smarthome_system_id = 6 | 0.38290023803711 |
| 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 join smarthome_system__product_mapping on smarthome_system__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 smarthome_system__product_mapping.smarthome_system_id in (6)) group by product.product_id | 6.6308975219727 |
| SELECT * FROM product__meta where product_id IN (12, 14, 19, 21, 32, 62, 90, 97, 156, 162, 208, 225, 240, 292, 293, 301, 490, 492, 494, 496, 531, 538, 540, 590, 601, 603, 605, 606, 607, 750, 780, 781, 838, 858, 859, 918, 935, 936, 937, 940, 945, 946, 980, 990, 992, 993, 995, 1002, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1025, 1026, 1027, 1034, 1046, 1075, 1083) | 11.373043060303 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 12 | 0.68211555480957 |
| 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.81300735473633 |
| 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.39315223693848 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 19 | 0.64587593078613 |
| 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.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 = 32 | 0.37002563476562 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 62 | 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 = 90 | 0.23818016052246 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 97 | 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 = 156 | 0.24986267089844 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 162 | 0.24008750915527 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 208 | 0.24080276489258 |
| 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.45990943908691 |
| 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.36001205444336 |
| 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.72193145751953 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 225 | 0.27012825012207 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 240 | 0.53095817565918 |
| 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.49281120300293 |
| 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.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 = 293 | 0.39482116699219 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 301 | 0.30899047851562 |
| SELECT AVG(review_value) as avg_review FROM `product__review` WHERE product_id = 490 | 0.3199577331543 |
| 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.40316581726074 |
| 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.57601928710938 |
| 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")) | 1.2130737304688 |
| 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 = 492 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.70786476135254 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 492 | 0.56695938110352 |
| 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 product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 496 | 0.39505958557129 |
| 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.30303001403809 |
| 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.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 = 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.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 = 540 | 0.25796890258789 |
| 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.28300285339355 |
| 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.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 = 590 and smarthome_system.status = "publish")) | 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 = 601 | 0.25010108947754 |
| 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 = 601 and smarthome_system.status = "publish")) | 0.25701522827148 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 603 | 0.31089782714844 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 605 | 0.23913383483887 |
| 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.21505355834961 |
| 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.26702880859375 |
| 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.23412704467773 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 750 | 0.25701522827148 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 780 | 0.20885467529297 |
| 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.25701522827148 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 838 | 0.26488304138184 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 858 | 0.23603439331055 |
| 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.30207633972168 |
| 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.2598762512207 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 918 | 0.22292137145996 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 935 | 0.22292137145996 |
| 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.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 = 937 | 0.21195411682129 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 940 | 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 = 945 | 0.25200843811035 |
| 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.40507316589355 |
| 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.26297569274902 |
| 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 = 990 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_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 990 | 0.2741813659668 |
| 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 = 992 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.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 = 992 | 0.23603439331055 |
| 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 = 992 and smarthome_system.status = "publish")) | 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 = 993 | 0.26512145996094 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 995 | 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 = 1002 | 0.2598762512207 |
| 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.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 = 1010 | 0.3049373626709 |
| 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.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 = 1011 | 0.51498413085938 |
| 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 = 1011 and smarthome_system.status = "publish")) | 0.37002563476562 |
| 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.3359317779541 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1013 | 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 = 1014 | 0.35405158996582 |
| 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.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 = 1015 | 0.34999847412109 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1016 | 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 = 1017 | 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 = 1017 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 = 1018 | 0.32305717468262 |
| 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 = 1018 and smarthome_system.status = "publish")) | 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 = 1019 | 0.3669261932373 |
| 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.28705596923828 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1021 | 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 = 1022 | 0.73504447937012 |
| 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 = 1025 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.5950927734375 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1025 | 0.35500526428223 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1026 | 0.29993057250977 |
| SELECT * FROM product__taxonomy JOIN product__taxonomy_virtual_mapping ON product__taxonomy_virtual_mapping.taxonomy_id = product__taxonomy.product__taxonomy_id where product_id = 1027 | 0.28705596923828 |
| 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.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 = 1046 | 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 = 1075 | 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 = 1083 | 0.27608871459961 |
| SELECT * FROM vg_wort_pixel where vg_wort_pixel_id = 0 LIMIT 1 | 0.19502639770508 |
| SELECT *, (smarthome_system_date <= NOW() AND status = "publish") as is_already_published, DATE_FORMAT(smarthome_system_date, "%d.%m.%Y") as formatted_date FROM smarthome_system where smarthome_system_id = 6 LIMIT 1 | 0.27990341186523 |
| SELECT smarthome_system__data_field.smarthome_system__data_field_id, field_name, field_type, field_prefix, field_suffix, value FROM smarthome_system__data_field LEFT JOIN smarthome_system__data on smarthome_system__data.smarthome_system__data_field_id = smarthome_system__data_field.smarthome_system__data_field_id where smarthome_system__data.smarthome_system_id = 6 order by field_order asc | 0.29397010803223 |
Wird geladen...