SHOW FULL COLUMNS FROM `vehicle_cat` [ RunTime:0.002019s ]
SELECT * FROM `vehicle_cat` WHERE `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.001709s ]
SHOW FULL COLUMNS FROM `vehicle` [ RunTime:0.001367s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 12 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.001407s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 13 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.001127s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 14 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.001384s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 15 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.001055s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 16 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.001195s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 17 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.001087s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 18 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.000971s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 19 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.000979s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 20 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.001241s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 21 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.001190s ]
SELECT * FROM `vehicle` WHERE `cat_id` = 22 AND `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.001026s ]
SHOW FULL COLUMNS FROM `accessory_cat` [ RunTime:0.001243s ]
SELECT * FROM `accessory_cat` WHERE `lang` = 'fr' AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000807s ]
SHOW FULL COLUMNS FROM `subito_page` [ RunTime:0.001379s ]
SELECT * FROM `subito_page` WHERE `lang` = 'fr' LIMIT 1 [ RunTime:0.000841s ]
SELECT * FROM `subito_page` WHERE `lang` = 'fr' LIMIT 1 [ RunTime:0.000963s ]
SELECT `v`.*,c.name as cat_name FROM `vehicle` `v` LEFT JOIN `vehicle_cat` `c` ON `v`.`cat_id`=`c`.`id` WHERE `v`.`lang` = 'fr' AND `v`.`status` = '1' AND `v`.`is_del` = '0' ORDER BY `v`.`price_num` DESC,`v`.`sort` DESC,`v`.`id` DESC LIMIT 0,500 [ RunTime:0.001400s ]
SHOW FULL COLUMNS FROM `dealer_region` [ RunTime:0.001299s ]
SELECT * FROM `dealer_region` WHERE `lang` = 'fr' AND `parent_id` = 0 AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000892s ]
SELECT `name` FROM `dealer_region` WHERE `lang` = 'fr' AND `parent_id` = 21 AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000822s ]
SELECT `name` FROM `dealer_region` WHERE `lang` = 'fr' AND `parent_id` = 22 AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000855s ]
SELECT `name` FROM `dealer_region` WHERE `lang` = 'fr' AND `parent_id` = 23 AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000951s ]
SELECT `name` FROM `dealer_region` WHERE `lang` = 'fr' AND `parent_id` = 24 AND `status` = 1 AND `is_del` = 0 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000971s ]