Oak Elevator manufacturer Gradually developed from the Oak region into a large-scale comprehensive enterprise integrating industries such as Oak lifting platforms, Oak elevators, and Oak hydraulic lifting platforms
基本文件流程错误SQL调试
请求信息 : 2024-05-09 00:01:58 HTTP/1.1 GET : en.jstg7.com/oak-en.htm
[ SQL ] SELECT `mark` FROM `hp_language` WHERE `url` = 'http://en.jstg7.com' AND `status` = 1 LIMIT 1 [ RunTime:0.000285s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'web' AND `lang` = 'cn' [ RunTime:0.000548s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'web' AND `lang` = 'en' [ RunTime:0.000386s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'seo' AND `lang` = 'cn' [ RunTime:0.000325s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'seo' AND `lang` = 'en' [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `hp_world_phone` [ RunTime:0.000465s ]
[ SQL ] SELECT `id` FROM `hp_channeltype` WHERE `ctl_name` = 'Lists' LIMIT 1 [ RunTime:0.000326s ]
[ SQL ] SELECT `id` FROM `hp_arctype` WHERE `channeltype` IS NULL AND `parent_id` = 0 AND `is_hidden` = 0 AND `status` = 1 ORDER BY `sort_order` ASC LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] SELECT c.*, c.id as typeid, count(s.id) as has_children, '' as children FROM `hp_arctype` `c` LEFT JOIN `hp_arctype` `s` ON `s`.`parent_id`=`c`.`id` WHERE `c`.`status` = 1 AND `c`.`is_hidden` = 0 AND `c`.`is_del` = 0 AND `c`.`lang` = 'en' GROUP BY `c`.`id` ORDER BY `c`.`parent_id` ASC,`c`.`sort_order` ASC,`c`.`id` [ RunTime:0.017120s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000391s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000307s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE ( `id` IN (7) OR `lang_id` IN (7) ) AND `is_hidden` = 0 AND `status` = 1 AND `is_del` = 0 AND `lang` = 'en' ORDER BY `sort_order` ASC [ RunTime:0.000381s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000447s ]
[ SQL ] SELECT c.*, c.id as typeid, count(s.id) as has_children, '' as children FROM `hp_arctype` `c` LEFT JOIN `hp_arctype` `s` ON `s`.`parent_id`=`c`.`id` WHERE `c`.`is_hidden` = 0 AND `c`.`status` = 1 AND `c`.`is_del` = 0 AND `c`.`lang` = 'en' GROUP BY `c`.`id` ORDER BY `c`.`parent_id` ASC,`c`.`sort_order` ASC,`c`.`id` [ RunTime:0.018456s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000428s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000282s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE ( `id` IN (7) OR `lang_id` IN (7) ) AND `is_hidden` = 0 AND `status` = 1 AND `is_del` = 0 AND `lang` = 'en' ORDER BY `sort_order` ASC [ RunTime:0.000423s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000409s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000415s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000285s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE ( `id` IN (7) OR `lang_id` IN (7) ) AND `is_hidden` = 0 AND `status` = 1 AND `is_del` = 0 AND `lang` = 'en' ORDER BY `sort_order` ASC [ RunTime:0.000373s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000346s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000394s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000343s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE ( `id` IN (7) OR `lang_id` IN (7) ) AND `is_hidden` = 0 AND `status` = 1 AND `is_del` = 0 AND `lang` = 'en' ORDER BY `sort_order` ASC [ RunTime:0.000374s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000396s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000411s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000313s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE ( `id` IN (7) OR `lang_id` IN (7) ) AND `is_hidden` = 0 AND `status` = 1 AND `is_del` = 0 AND `lang` = 'en' ORDER BY `sort_order` ASC [ RunTime:0.000370s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000352s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000410s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000275s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE ( `id` IN (7) OR `lang_id` IN (7) ) AND `is_hidden` = 0 AND `status` = 1 AND `is_del` = 0 AND `lang` = 'en' ORDER BY `sort_order` ASC [ RunTime:0.000363s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000403s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000383s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000325s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE ( `id` IN (7) OR `lang_id` IN (7) ) AND `is_hidden` = 0 AND `status` = 1 AND `is_del` = 0 AND `lang` = 'en' ORDER BY `sort_order` ASC [ RunTime:0.000379s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000375s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000502s ]
[ SQL ] SELECT * FROM `hp_ad_position` WHERE `lang_id` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000326s ]
[ SQL ] SELECT * FROM `hp_ad` WHERE ( pid=1 and status = 1 ) AND `lang` = 'en' ORDER BY sort_order asc, id desc [ RunTime:0.000580s ]
[ SQL ] SELECT * FROM `hp_language` WHERE `is_home_default` = 1 LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'basic' AND `lang` = 'cn' [ RunTime:0.000361s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'basic' AND `lang` = 'en' [ RunTime:0.000299s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE `status` = 1 AND `is_del` = 0 [ RunTime:0.003183s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000715s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE ( `id` IN (7) OR `lang_id` IN (7) ) AND `is_hidden` = 0 AND `status` = 1 AND `is_del` = 0 AND `lang` = 'en' ORDER BY `sort_order` ASC [ RunTime:0.000377s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000470s ]
[ SQL ] SELECT `id` FROM `hp_channeltype` WHERE `ctl_name` = 'Lists' LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SELECT `id` FROM `hp_arctype` WHERE `channeltype` IS NULL AND `parent_id` = 0 AND `is_hidden` = 0 AND `status` = 1 ORDER BY `sort_order` ASC LIMIT 1 [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `hp_arctype` WHERE `lang_id` = 7 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000339s ]
[ SQL ] SELECT `id`,`current_channel` FROM `hp_arctype` WHERE `id` = 160 LIMIT 1 [ RunTime:0.000244s ]
[ SQL ] SELECT c.*, count(s.id) as has_children FROM `hp_arctype` `c` LEFT JOIN `hp_arctype` `s` ON `s`.`parent_id`=`c`.`id` WHERE `c`.`status` = 1 AND `c`.`lang` = 'en' AND `c`.`is_del` = 0 GROUP BY `c`.`id` ORDER BY `c`.`parent_id` ASC,`c`.`sort_order` ASC,`c`.`id` [ RunTime:0.018317s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hp_archives` `a` LEFT JOIN `hp_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (160,886,887,888,889,890,891,892,893,160) AND a.channel IN (2) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) AND `a`.`lang` = 'en' LIMIT 1 [ RunTime:0.000332s ]
[ SQL ] SELECT `b`.*,`a`.* FROM `hp_archives` `a` LEFT JOIN `hp_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (160,886,887,888,889,890,891,892,893,160) AND a.channel IN (2) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) AND `a`.`lang` = 'en' ORDER BY a.is_recom desc,a.add_time desc LIMIT 0,12 [ RunTime:0.000417s ]
[ SQL ] SELECT * FROM `hp_language` WHERE `status` = 1 [ RunTime:0.000365s ]