SHOW FULL COLUMNS FROM `application` [ RunTime:0.000936s ]
SELECT `app`.`sn`,`app`.`name`,`top_type_id`,date_format(from_unixtime(app.updated), "%Y-%m-%d") as update_time,`second_type_id`,group_concat(t.name separator ",") as tags FROM `application` `app` LEFT JOIN `application_version` `v` ON `v`.`app_sn`=`app`.`sn` LEFT JOIN `application_tag_binding` `b` ON `b`.`app_id`=app.id and b.version_id = v.id LEFT JOIN `application_tag` `t` ON `t`.`id`=b.tag_id and t.status = 1 WHERE `app`.`status` = '1' AND `app`.`category` = 'app' GROUP BY `app`.`id` ORDER BY `app`.`sort`,`app`.`id` DESC [ RunTime:0.001073s ]
SHOW FULL COLUMNS FROM `application_version` [ RunTime:0.000823s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 'YEaM5UeY' AND `status` = 1 ORDER BY `id` [ RunTime:0.000508s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 't96w7uZD' AND `status` = 1 ORDER BY `id` [ RunTime:0.000455s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = '1StKoddu' AND `status` = 1 ORDER BY `id` [ RunTime:0.000485s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 'Oquds0Ng' AND `status` = 1 ORDER BY `id` [ RunTime:0.000403s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 'wIj4Di2x' AND `status` = 1 ORDER BY `id` [ RunTime:0.000365s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 'bgko0ltg' AND `status` = 1 ORDER BY `id` [ RunTime:0.000351s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 'sfr46y8i' AND `status` = 1 ORDER BY `id` [ RunTime:0.000434s ]
SHOW FULL COLUMNS FROM `application_type` [ RunTime:0.000673s ]
SELECT `id`,`sn`,`name` FROM `application_type` WHERE `status` = 1 AND `parent_id` = 0 AND `id` IN (25,15,1) ORDER BY `sort` [ RunTime:0.000500s ]
SELECT `id`,`sn`,`name` FROM `application_type` WHERE `status` = 1 AND `parent_id` = 15 AND `id` IN (39,17,9) ORDER BY `sort` [ RunTime:0.000429s ]
SELECT `id`,`sn`,`name` FROM `application_type` WHERE `status` = 1 AND `parent_id` = 25 AND `id` IN (39,17,9) ORDER BY `sort` [ RunTime:0.000402s ]
SELECT `id`,`sn`,`name` FROM `application_type` WHERE `status` = 1 AND `parent_id` = 1 AND `id` IN (39,17,9) ORDER BY `sort` [ RunTime:0.000466s ]