[ DB ] CONNECT:[ UseTime:0.005078s ] mysql:host=xdm718713477.my3w.com;dbname=xdm718713477_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.003443s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 470 LIMIT 1 [ RunTime:0.002936s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.003026s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002908s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002958s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002859s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.119860s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.006244s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 7 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.005659s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.003185s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 462 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 100 [ RunTime:0.005676s ]
[ SQL ] SHOW COLUMNS FROM `yzn_prop` [ RunTime:0.005281s ]
[ 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.007395s ]
[ 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.008141s ]
[ 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.005651s ]
[ 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.008093s ]
[ SQL ] SHOW COLUMNS FROM `yzn_img` [ RunTime:0.003823s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_img` WHERE ( `status`=1 AND `catid` = 27 ) [ RunTime:0.002702s ]
[ SQL ] SELECT * FROM `yzn_img` WHERE ( `status`=1 AND `catid` = 27 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.003215s ]