[ DB ] CONNECT:[ UseTime:0.004892s ] mysql:host=xdm718713477.my3w.com;dbname=xdm718713477_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.003118s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 470 LIMIT 1 [ RunTime:0.002792s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002700s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002706s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002698s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002597s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002586s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002547s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 7 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002581s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.093769s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 462 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 100 [ RunTime:0.009287s ]
[ SQL ] SHOW COLUMNS FROM `yzn_prop` [ RunTime:0.003262s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_prop` `Prop` LEFT JOIN `yzn_prop_data` `Prop_data` ON `Prop`.`id`=`Prop_data`.`did` WHERE ( `status`=1 AND (FIND_IN_SET('1', flag)) AND `catid` = 470 ) [ RunTime:0.002731s ]
[ SQL ] SELECT `Prop`.*,`Prop_data`.* FROM `yzn_prop` `Prop` LEFT JOIN `yzn_prop_data` `Prop_data` ON `Prop`.`id`=`Prop_data`.`did` WHERE ( `status`=1 AND (FIND_IN_SET('1', flag)) AND `catid` = 470 ) ORDER BY `listorder` ASC LIMIT 0,100000 [ RunTime:0.006157s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_prop` `Prop` LEFT JOIN `yzn_prop_data` `Prop_data` ON `Prop`.`id`=`Prop_data`.`did` WHERE ( flag != 1 AND `status`=1 AND `catid` = 470 ) [ RunTime:0.005407s ]
[ SQL ] SELECT `Prop`.*,`Prop_data`.* FROM `yzn_prop` `Prop` LEFT JOIN `yzn_prop_data` `Prop_data` ON `Prop`.`id`=`Prop_data`.`did` WHERE ( flag != 1 AND `status`=1 AND `catid` = 470 ) ORDER BY `listorder` ASC LIMIT 0,100000 [ RunTime:0.008048s ]
[ SQL ] SHOW COLUMNS FROM `yzn_img` [ RunTime:0.004895s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_img` WHERE ( `status`=1 AND `catid` = 27 ) [ RunTime:0.005827s ]
[ SQL ] SELECT * FROM `yzn_img` WHERE ( `status`=1 AND `catid` = 27 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.006398s ]