Pittsburgh Elevator manufacturer Gradually developed from the Pittsburgh region into a large-scale comprehensive enterprise integrating industries such as Pittsburgh lifting platforms, Pittsburgh elevators, and Pittsburgh hydraulic lifting platforms
基本文件流程错误SQL调试
请求信息 : 2024-05-09 05:14:21 HTTP/1.1 GET : en.jstg7.com/pittsburgh-en.htm
[ SQL ] SELECT * FROM `hp_world_phone` [ RunTime:0.000717s ]
[ SQL ] SELECT `id` FROM `hp_channeltype` WHERE `ctl_name` = 'Lists' LIMIT 1 [ RunTime:0.000333s ]
[ 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.000340s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000528s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000374s ]
[ 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.000515s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000503s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000509s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000358s ]
[ 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.000545s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000469s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000519s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000408s ]
[ 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.000516s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000483s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000591s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000354s ]
[ 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.000494s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000555s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000619s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000379s ]
[ 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.000534s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000471s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000511s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000380s ]
[ 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.000542s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000990s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000504s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000339s ]
[ 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.000547s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000470s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000533s ]
[ SQL ] SELECT * FROM `hp_ad_position` WHERE `lang_id` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000412s ]
[ SQL ] SELECT * FROM `hp_language` WHERE `is_home_default` = 1 LIMIT 1 [ RunTime:0.000382s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE `status` = 1 AND `is_del` = 0 [ RunTime:0.003731s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000632s ]
[ 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.000395s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000563s ]
[ SQL ] SELECT `id` FROM `hp_channeltype` WHERE `ctl_name` = 'Lists' LIMIT 1 [ RunTime:0.000366s ]
[ 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.000399s ]
[ SQL ] SELECT * FROM `hp_arctype` WHERE `lang_id` = 7 AND `lang` = 'en' LIMIT 1 [ RunTime:0.002289s ]
[ SQL ] SELECT `id`,`current_channel` FROM `hp_arctype` WHERE `id` = 160 LIMIT 1 [ RunTime:0.000311s ]
[ 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.000399s ]
[ 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.000461s ]
[ SQL ] SELECT * FROM `hp_language` WHERE `status` = 1 [ RunTime:0.000459s ]