SHOW FULL COLUMNS FROM `shops` [ RunTime:0.000626s ]
SELECT * FROM `shops` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000366s ]
SHOW FULL COLUMNS FROM `shop_records` [ RunTime:0.000487s ]
SELECT `sr`.`id`,`sr`.`shop_id`,`sr`.`record_id`,`sr`.`shop_price`,`sr`.`postage`,`s`.`shop_name`,r.title as record_title,`r`.`thumb`,`r`.`cover_image` FROM `shop_records` `sr` INNER JOIN `shops` `s` ON `s`.`id`=`sr`.`shop_id` LEFT JOIN `records` `r` ON r.`key`=`sr`.`record_id` WHERE `sr`.`status` = '1' AND `s`.`status` = '1' ORDER BY `sr`.`id` DESC LIMIT 16 [ RunTime:0.000443s ]
