Oklahoma Elevator manufacturer Gradually developed from the Oklahoma region into a large-scale comprehensive enterprise integrating industries such as Oklahoma lifting platforms, Oklahoma elevators, and Oklahoma hydraulic lifting platforms
基本文件流程错误SQL调试
请求信息 : 2024-05-08 23:30:43 HTTP/1.1 GET : en.jstg7.com/oklahoma-en.htm
[ SQL ] SELECT * FROM `hp_world_phone` [ RunTime:0.000653s ]
[ SQL ] SELECT `id` FROM `hp_channeltype` WHERE `ctl_name` = 'Lists' LIMIT 1 [ RunTime:0.000339s ]
[ 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.000284s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000496s ]
[ 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.000422s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000418s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000527s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000290s ]
[ 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.000421s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000459s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000497s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000336s ]
[ 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.000418s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000453s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000505s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000336s ]
[ 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.000421s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000468s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000510s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000352s ]
[ 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.000437s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000475s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000483s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000326s ]
[ 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.000409s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000457s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000577s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000350s ]
[ 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.000456s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000423s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000465s ]
[ SQL ] SELECT * FROM `hp_ad_position` WHERE `lang_id` = 1 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000359s ]
[ SQL ] SELECT * FROM `hp_language` WHERE `is_home_default` = 1 LIMIT 1 [ RunTime:0.000386s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE `status` = 1 AND `is_del` = 0 [ RunTime:0.003653s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000677s ]
[ 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.000354s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000372s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000359s ]
[ SQL ] SELECT `id` FROM `hp_channeltype` WHERE `ctl_name` = 'Lists' LIMIT 1 [ RunTime:0.000266s ]
[ 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.000281s ]
[ SQL ] SELECT * FROM `hp_arctype` WHERE `lang_id` = 7 AND `lang` = 'en' LIMIT 1 [ RunTime:0.000325s ]
[ SQL ] SELECT `id`,`current_channel` FROM `hp_arctype` WHERE `id` = 160 LIMIT 1 [ RunTime:0.000243s ]
[ 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.000411s ]
[ 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.000423s ]
[ SQL ] SELECT * FROM `hp_language` WHERE `status` = 1 [ RunTime:0.000390s ]