(default) 3 queries took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Region`.`id`, `Region`.`name`, `Region`.`slug`, `Region`.`content`, `Region`.`contenu` FROM `drives`.`regions` AS `Region` WHERE `Region`.`slug` = 'pays-de-la-loire' LIMIT 1110
2SELECT `Drive`.`id`, `Drive`.`store_id`, `Drive`.`adresse`, `Drive`.`code_postal`, `Drive`.`ville`, `Drive`.`slug_ville`, `Drive`.`telephone`, `Drive`.`horaire`, `Drive`.`department_id`, `Department`.`slug`, `Store`.`name`, `Store`.`slug`, `Store`.`url` FROM `drives`.`drives` AS `Drive` inner JOIN `drives`.`departments` AS `Dep` ON (`Dep`.`id` = `Drive`.`department_id`) inner JOIN `drives`.`regions` AS `Region` ON (`Region`.`id` = `Dep`.`region_id`) LEFT JOIN `drives`.`departments` AS `Department` ON (`Drive`.`department_id` = `Department`.`id`) LEFT JOIN `drives`.`stores` AS `Store` ON (`Drive`.`store_id` = `Store`.`id`) WHERE `Region`.`slug` = 'pays-de-la-loire' LIMIT 30, 3030302
3SELECT COUNT(*) AS `count` FROM `drives`.`drives` AS `Drive` inner JOIN `drives`.`departments` AS `Dep` ON (`Dep`.`id` = `Drive`.`department_id`) inner JOIN `drives`.`regions` AS `Region` ON (`Region`.`id` = `Dep`.`region_id`) LEFT JOIN `drives`.`departments` AS `Department` ON (`Drive`.`department_id` = `Department`.`id`) LEFT JOIN `drives`.`stores` AS `Store` ON (`Drive`.`store_id` = `Store`.`id`) WHERE `Region`.`slug` = 'pays-de-la-loire'113