ප්රවේශනය, City in Puerto Rico USA ලිෆ්ටර්, City in Puerto Rico USA හයිඩ්රාලික් ලිෆ්ටර් ප්ලේටර්, නියම ප්රවේශනය, සාමාන්ය විශේෂණය, සාමාන්ය විශේෂණය, සාමාන්ය විශේෂණය
基本文件流程错误SQL调试
请求信息 : 2024-05-15 02:22:07 HTTP/1.1 GET : sin.jstg7.com/sanjose-sin.html
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'web' AND `lang` = 'cn' [ RunTime:0.000620s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'web' AND `lang` = 'sin' [ RunTime:0.000530s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'seo' AND `lang` = 'cn' [ RunTime:0.000743s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'seo' AND `lang` = 'sin' [ RunTime:0.000512s ]
[ SQL ] SELECT * FROM `hp_world_phone` [ RunTime:0.001245s ]
[ SQL ] SELECT * FROM `hp_language` WHERE `status` = 1 [ RunTime:0.000638s ]
[ SQL ] SELECT `id` FROM `hp_channeltype` WHERE `ctl_name` = 'Lists' LIMIT 1 [ RunTime:0.000567s ]
[ 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.000534s ]
[ 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` = 'sin' GROUP BY `c`.`id` ORDER BY `c`.`parent_id` ASC,`c`.`sort_order` ASC,`c`.`id` [ RunTime:0.037085s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.001094s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000445s ]
[ 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` = 'sin' ORDER BY `sort_order` ASC [ RunTime:0.000648s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000623s ]
[ 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` = 'sin' GROUP BY `c`.`id` ORDER BY `c`.`parent_id` ASC,`c`.`sort_order` ASC,`c`.`id` [ RunTime:0.058258s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000602s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000596s ]
[ 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` = 'sin' ORDER BY `sort_order` ASC [ RunTime:0.000589s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000552s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000742s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000564s ]
[ 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` = 'sin' ORDER BY `sort_order` ASC [ RunTime:0.000552s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000572s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000561s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000420s ]
[ 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` = 'sin' ORDER BY `sort_order` ASC [ RunTime:0.000513s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000544s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000607s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000415s ]
[ 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` = 'sin' ORDER BY `sort_order` ASC [ RunTime:0.001356s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000490s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.001590s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000444s ]
[ 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` = 'sin' ORDER BY `sort_order` ASC [ RunTime:0.000519s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000593s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000620s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.000449s ]
[ 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` = 'sin' ORDER BY `sort_order` ASC [ RunTime:0.000548s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000498s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000561s ]
[ SQL ] SELECT * FROM `hp_ad_position` WHERE `lang_id` = 1 AND `lang` = 'sin' LIMIT 1 [ RunTime:0.000608s ]
[ SQL ] SELECT * FROM `hp_ad` WHERE ( pid=1 and status = 1 ) AND `lang` = 'sin' ORDER BY sort_order asc, id desc [ RunTime:0.000851s ]
[ SQL ] SELECT * FROM `hp_language` WHERE `is_home_default` = 1 LIMIT 1 [ RunTime:0.002196s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'basic' AND `lang` = 'cn' [ RunTime:0.000453s ]
[ SQL ] SELECT * FROM `hp_config` WHERE `inc_type` = 'basic' AND `lang` = 'sin' [ RunTime:0.000436s ]
[ SQL ] SELECT *,id as typeid FROM `hp_arctype` WHERE `status` = 1 AND `is_del` = 0 [ RunTime:0.003870s ]
[ SQL ] SELECT `attr_name` FROM `hp_language_attr` WHERE `attr_value` IN ('7') AND `attr_group` = 'arctype' [ RunTime:0.001434s ]
[ 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` = 'sin' ORDER BY `sort_order` ASC [ RunTime:0.000712s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.001094s ]
[ SQL ] SELECT * FROM `hp_channelfield` WHERE `channel_id` = -99 ORDER BY `sort_order` ASC,`channel_id` DESC,`id` DESC [ RunTime:0.000809s ]
[ SQL ] SELECT `id` FROM `hp_channeltype` WHERE `ctl_name` = 'Lists' LIMIT 1 [ RunTime:0.000536s ]
[ 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.000482s ]
[ SQL ] SELECT * FROM `hp_arctype` WHERE `lang_id` = 7 AND `lang` = 'sin' LIMIT 1 [ RunTime:0.000566s ]
[ SQL ] SELECT `id`,`current_channel` FROM `hp_arctype` WHERE `id` = 750 LIMIT 1 [ RunTime:0.000651s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `hp_archives` `a` LEFT JOIN `hp_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (750,1326,1327,1328,1329,1330,1331,1332,1333,750) AND a.channel IN (2) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) AND `a`.`lang` = 'sin' LIMIT 1 [ RunTime:0.001151s ]
[ SQL ] SELECT `b`.*,`a`.* FROM `hp_archives` `a` LEFT JOIN `hp_arctype` `b` ON `b`.`id`=`a`.`typeid` WHERE ( a.typeid IN (750,1326,1327,1328,1329,1330,1331,1332,1333,750) AND a.channel IN (2) AND a.arcrank > -1 AND a.status = 1 AND a.is_del = 0 ) AND `a`.`lang` = 'sin' ORDER BY a.is_recom desc,a.add_time desc LIMIT 0,12 [ RunTime:0.001536s ]
[ SQL ] SELECT * FROM `hp_language` WHERE `status` = 1 [ RunTime:0.000704s ]