SHOW FULL COLUMNS FROM `country` [ RunTime:0.002725s ]
SELECT * FROM `country` WHERE `pid` = 0 [ RunTime:0.000936s ]
SHOW FULL COLUMNS FROM `region` [ RunTime:0.002546s ]
SELECT city as name,city_code as code FROM `region` GROUP BY `city_code` [ RunTime:0.001818s ]
SELECT country as name,country_code as code FROM `region` GROUP BY `country_code` [ RunTime:0.001075s ]
SHOW FULL COLUMNS FROM `region_product` [ RunTime:0.002504s ]
SELECT `cpu` FROM `region_product` GROUP BY `cpu` ORDER BY `cpu` [ RunTime:0.004322s ]
SELECT `ram` FROM `region_product` GROUP BY `ram` ORDER BY `ram` [ RunTime:0.003512s ]
SELECT COUNT(*) AS think_count FROM `region_product` `product` LEFT JOIN `region` `region` ON `region`.`id`=`product`.`region_id` WHERE `region`.`status` = '1' AND `product`.`status` = '1' LIMIT 1 [ RunTime:0.004651s ]
SELECT `region`.*,`product`.* FROM `region_product` `product` LEFT JOIN `region` `region` ON `region`.`id`=`product`.`region_id` WHERE `region`.`status` = '1' AND `product`.`status` = '1' LIMIT 0,15 [ RunTime:0.001151s ]