[ DB ] CONNECT:[ UseTime:0.009875s ] mysql:host=xdm718713477.my3w.com;dbname=xdm718713477_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.005949s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.010117s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002261s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002178s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002133s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002117s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002158s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 7 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002176s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.002235s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 462 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 100 [ RunTime:0.003970s ]
[ SQL ] SHOW COLUMNS FROM `yzn_prop` [ RunTime:0.014932s ]
[ 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` = 469 ) [ RunTime:0.268767s ]
[ 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` = 469 ) ORDER BY `listorder` ASC LIMIT 0,100000 [ RunTime:0.043920s ]
[ 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` = 469 ) [ RunTime:0.005489s ]
[ 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` = 469 ) ORDER BY `listorder` ASC LIMIT 0,100000 [ RunTime:0.005793s ]
[ SQL ] SHOW COLUMNS FROM `yzn_img` [ RunTime:0.008871s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_img` WHERE ( `status`=1 AND `catid` = 27 ) [ RunTime:0.009314s ]
[ SQL ] SELECT * FROM `yzn_img` WHERE ( `status`=1 AND `catid` = 27 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.010507s ]