[ DB ] CONNECT:[ UseTime:0.092839s ] mysql:host=xdm718713477.my3w.com;dbname=xdm718713477_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.017467s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 470 LIMIT 1 [ RunTime:0.020229s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.178457s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.331004s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.147265s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.009628s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.006281s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.009308s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 7 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.008727s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.009393s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 462 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 100 [ RunTime:0.005924s ]
[ SQL ] SHOW COLUMNS FROM `yzn_prop` [ RunTime:0.003102s ]
[ 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.002573s ]
[ 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.010256s ]
[ 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.126699s ]
[ 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.010165s ]
[ SQL ] SHOW COLUMNS FROM `yzn_img` [ RunTime:0.007215s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_img` WHERE ( `status`=1 AND `catid` = 27 ) [ RunTime:0.005400s ]
[ SQL ] SELECT * FROM `yzn_img` WHERE ( `status`=1 AND `catid` = 27 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.007346s ]