X-Wf-dibi-1-1-d1 | |[{"Type":"TABLE","Label":"Database profiler (8 dotaz\u016f zabralo 12.916 ms)"},[["Time","SQL Statement","Rows"],["0.267 ms","SELECT it.title, it.text, i.position\r\n FROM infoboxes i\r\n JOIN infoboxes_text it ON it.infobox = i.id\r\n WHERE i.published = 1 AND position=2\r\n\t\t\t\tORDER BY i.id DESC LIMIT 1",1],["0.177 ms","SELECT it.title, it.text, i.position\r\n FROM infoboxes i\r\n JOIN infoboxes_text it ON it.infobox = i.id\r\n WHERE i.published = 1 AND position=1\r\n\t\t\t\tORDER BY i.id DESC LIMIT 1",0],["0.208 ms","SELECT it.title, it.text, i.position\r\n FROM infoboxes i\r\n JOIN infoboxes_text it ON it.infobox = i.id\r\n WHERE i.published = 1 AND position=2\r\n\t\t\t\tORDER BY i.id DESC LIMIT 1",1],["0.423 ms","SELECT it.title, it.text, i.position\r\n FROM infoboxes i\r\n JOIN infoboxes_text it ON it.infobox = i.id\r\n WHERE i.published = 1 AND position=3\r\n\t\t\t\tORDER BY i.id DESC LIMIT 1",0],["0.270 ms","SELECT m.*, mt.`title`, at.`title` AS `aTitle`\r\n FROM `menu` m\r\n JOIN `menu_text` mt ON mt.`menu` = m.`id`\r\n LEFT JOIN `articles_text` at ON at.`article` = m.`article` AND at.`language` = \"cs\"\r\n WHERE m.`visible` = 1 AND `group` = 0\r\n ORDER BY `position`",5],["0.820 ms","SELECT t.id, tt.title as title, tt.text as description,t.*,tt.title as `aTitle`, i.id as image, i.*\n\t\t FROM infoboxes t\n\t\t JOIN infoboxes_text tt ON t.id = tt.infobox\n\t\t JOIN images i ON i.id = t.perex_img\n\t\t LEFT JOIN images_text it ON it.image = i.id\n\t\t WHERE t.published = 1\n\t\t ORDER BY t.priority",2],["10.465 ms","SELECT SQL_CALC_FOUND_ROWS a.*, at.*,i.*, a.perex_img as image, a.advert_id as url,\n\t\t\t u.name, u.surname, u.phone, u.mobile, u.email\n\t\t\tFROM advert a\n\t\t\tJOIN advert_text at ON at.advert_id=a.advert_id\n\t\t\tLEFT JOIN images i ON a.perex_img = i.id\n\t\t\tLEFT JOIN images_text it ON it.image = a.perex_img\n\t\t\tLEFT JOIN users u ON u.id = a.seller_id\n\t\t\tWHERE a.homepage = \"y\"\n\t\t\tORDER BY a.homepage_priority DESC, a.advert_id DESC LIMIT 0, 3",3],["0.286 ms","SELECT m.*, mt.`title`, at.`title` AS `aTitle`\r\n FROM `menu` m\r\n JOIN `menu_text` mt ON mt.`menu` = m.`id`\r\n LEFT JOIN `articles_text` at ON at.`article` = m.`article` AND at.`language` = \"cs\"\r\n WHERE m.`visible` = 1 AND `group` = 2\r\n ORDER BY `position`",19]]]| |