SHOW FULL COLUMNS FROM `application` [ RunTime:0.001224s ]
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.001437s ]
SHOW FULL COLUMNS FROM `application_version` [ RunTime:0.000973s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 'YEaM5UeY' AND `status` = 1 ORDER BY `id` [ RunTime:0.000558s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 't96w7uZD' AND `status` = 1 ORDER BY `id` [ RunTime:0.000517s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = '1StKoddu' AND `status` = 1 ORDER BY `id` [ RunTime:0.000500s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 'Oquds0Ng' AND `status` = 1 ORDER BY `id` [ RunTime:0.000451s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 'bgko0ltg' AND `status` = 1 ORDER BY `id` [ RunTime:0.000406s ]
SELECT `intro`,`cover` FROM `application_version` WHERE `app_sn` = 'sfr46y8i' AND `status` = 1 ORDER BY `id` [ RunTime:0.000464s ]
SHOW FULL COLUMNS FROM `application_type` [ RunTime:0.000713s ]
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.000564s ]
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.000515s ]
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.000478s ]
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.000426s ]