SHOW FULL COLUMNS FROM `lay_tcm_yaowu` [ RunTime:0.000789s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `lay_tcm_yaowu` `tcm_yaowu` LEFT JOIN `lay_tcm_yaowu_attr` `tcm_yaowu_attr` ON `tcm_yaowu_attr`.`yaowu_id`=`tcm_yaowu`.`id` GROUP BY `tcm_yaowu`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.502613s ]
SELECT `tcm_yaowu`.*,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='nature' THEN attr_value END) AS nature,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='taste' THEN attr_value END) AS taste,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='meridian' THEN attr_value END) AS meridian FROM `lay_tcm_yaowu` `tcm_yaowu` LEFT JOIN `lay_tcm_yaowu_attr` `tcm_yaowu_attr` ON `tcm_yaowu_attr`.`yaowu_id`=`tcm_yaowu`.`id` GROUP BY `tcm_yaowu`.`id` LIMIT 100,20 [ RunTime:0.397686s ]
SELECT COUNT(*) AS think_count FROM ( SELECT `tcm_yaowu`.*,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='nature' THEN attr_value END) AS nature,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='taste' THEN attr_value END) AS taste,GROUP_CONCAT(DISTINCT CASE WHEN attr_type='meridian' THEN attr_value END) AS meridian,count(*) AS think_count FROM `lay_tcm_yaowu` `tcm_yaowu` LEFT JOIN `lay_tcm_yaowu_attr` `tcm_yaowu_attr` ON `tcm_yaowu_attr`.`yaowu_id`=`tcm_yaowu`.`id` GROUP BY `tcm_yaowu`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.559282s ]
