SELECT `id`,`pid`,`name`,`target`,`url` FROM `ze_dev_navigation` WHERE `is_disable` = 0 AND `is_delete` = 0 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000401s ]
SHOW FULL COLUMNS FROM `ze_ycy_activities` [ RunTime:0.025002s ]
SELECT `activity`.`id`,`name`,`createtime`,`policy`,`number`,`logo`,`city`,`applysize`,`bak`,`money`,`inventory`,`shopid`,`starttime`,`endtime`,`teacher`,`brif` FROM `ze_ycy_activities` `activity` WHERE `id` = 1993 LIMIT 1 [ RunTime:0.000525s ]
SHOW FULL COLUMNS FROM `ze_ycy_shop` [ RunTime:0.017819s ]
SHOW FULL COLUMNS FROM `ze_ycy_shop_activity_rel` [ RunTime:0.000441s ]
SELECT `shop`.`id`,`shopname`,`address`,`shop_logo`,`tel`,`shop`.`shopname`,`shop`.`address`,`shop`.`shop_logo`,`shop`.`tel`,`pivot`.`id` AS `pivot__id`,`pivot`.`shopid` AS `pivot__shopid`,`pivot`.`activityid` AS `pivot__activityid` FROM `ze_ycy_shop` `shop` INNER JOIN `ze_ycy_shop_activity_rel` `pivot` ON `pivot`.`shopid`=`shop`.`id` WHERE `pivot`.`activityid` = '1993' [ RunTime:0.000359s ]
SELECT `id`,`name` FROM `ze_ycy_activities` WHERE `id` < 1993 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000259s ]
SELECT `id`,`name` FROM `ze_ycy_activities` WHERE `id` > 1993 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000247s ]
SELECT `id`,`name`,`createtime`,`policy` FROM `ze_ycy_activities` ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000365s ]
SELECT `id`,`name`,`createtime`,`policy` FROM `ze_ycy_activities` ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000400s ]
SHOW FULL COLUMNS FROM `ze_ycy_orders` [ RunTime:0.000501s ]
SELECT `id`,`clientname`,`tel`,`audi` FROM `ze_ycy_orders` WHERE `activityid` = '1993' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000795s ]