[ DB ] CONNECT:[ UseTime:0.093783s ] mysql:host=xdm718713477.my3w.com;dbname=xdm718713477_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.003298s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 469 LIMIT 1 [ RunTime:0.086959s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 1 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.055154s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 2 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.022828s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 3 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.027569s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 4 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.017761s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 5 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.054822s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 6 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.014833s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 7 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.018452s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 8 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 1000 [ RunTime:0.138715s ]
[ DB ] CONNECT:[ UseTime:0.017333s ] mysql:host=xdm718713477.my3w.com;dbname=xdm718713477_db;charset=utf8
[ SQL ] SELECT * FROM `yzn_category` WHERE `id` = 462 LIMIT 1 [ RunTime:0.015644s ]
[ SQL ] SELECT * FROM `yzn_category` WHERE ( `status`=1 AND `parentid` = 462 AND `language` = 'default' ) ORDER BY `listorder` ASC LIMIT 100 [ RunTime:0.013253s ]
[ SQL ] SHOW COLUMNS FROM `yzn_prop` [ RunTime:0.016740s ]
[ 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.058729s ]
[ 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.017269s ]
[ 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.015760s ]
[ 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.017505s ]
[ SQL ] SHOW COLUMNS FROM `yzn_img` [ RunTime:0.013447s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_img` WHERE ( `status`=1 AND `catid` = 27 ) [ RunTime:0.026426s ]
[ SQL ] SELECT * FROM `yzn_img` WHERE ( `status`=1 AND `catid` = 27 ) ORDER BY `listorder` ASC LIMIT 0,10 [ RunTime:0.002610s ]