1146:Table 'yatas2.y_common' doesn't exist
[ SQL语句 ] : SHOW COLUMNS FROM `y_common`
1146:Table 'yatas2.y_order' doesn't exist
[ SQL语句 ] : SHOW COLUMNS FROM `y_order`
1146:Table 'yatas2.y_goods' doesn't exist
[ SQL语句 ] : SHOW COLUMNS FROM `y_goods`
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as g' at line 1
[ SQL语句 ] : SHOW COLUMNS FROM v_lines_goods as g
1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as d' at line 1
[ SQL语句 ] : SHOW COLUMNS FROM y_line_dateprice as d
[2] mysql_free_result() expects parameter 1 to be resource, object given /home/wwwroot/Dyata/App/ThinkPHP/Lib/Driver/Db/DbMysqli.class.php 第 71 行.
[8] Use of undefined constant MODEL_PATH - assumed 'MODEL_PATH' /home/wwwroot/Dyata/App/ThinkPHP/Common/common.php 第 390 行.
[8] Use of undefined constant MODEL_PATH - assumed 'MODEL_PATH' /home/wwwroot/Dyata/App/ThinkPHP/Common/common.php 第 390 行.
[8] Use of undefined constant MODEL_PATH - assumed 'MODEL_PATH' /home/wwwroot/Dyata/App/ThinkPHP/Common/common.php 第 390 行.
[8] Use of undefined constant MODEL_PATH - assumed 'MODEL_PATH' /home/wwwroot/Dyata/App/ThinkPHP/Common/common.php 第 390 行.
[8] Use of undefined constant MODEL_PATH - assumed 'MODEL_PATH' /home/wwwroot/Dyata/App/ThinkPHP/Common/common.php 第 390 行.
[8] Use of undefined constant MODEL_PATH - assumed 'MODEL_PATH' /home/wwwroot/Dyata/App/ThinkPHP/Common/common.php 第 390 行.
[8] Use of undefined constant MODEL_PATH - assumed 'MODEL_PATH' /home/wwwroot/Dyata/App/ThinkPHP/Common/common.php 第 390 行.
[8] Use of undefined constant MODEL_PATH - assumed 'MODEL_PATH' /home/wwwroot/Dyata/App/ThinkPHP/Common/common.php 第 390 行.
SELECT `user_name`,`email`,`mobile_phone` FROM `y_users` WHERE ( `user_id` = 0 ) LIMIT 1 [ RunTime:0.000098s ]
SHOW COLUMNS FROM `y_common` [ RunTime:0.000273s ]
SHOW COLUMNS FROM `y_order` [ RunTime:0.000286s ]
SHOW COLUMNS FROM `y_goods` [ RunTime:0.000293s ]
SHOW COLUMNS FROM `y_region` [ RunTime:0.000379s ]
SELECT `region_id` FROM `y_region` WHERE ( `region_type` = 2 ) AND ( `region_name` LIKE '%上海%' ) LIMIT 1 [ RunTime:0.000086s ]
SHOW COLUMNS FROM `y_region` [ RunTime:0.000381s ]
SELECT `pinyin_all` FROM `y_region` WHERE ( `region_id` = 321 ) LIMIT 1 [ RunTime:0.000094s ]
SELECT `user_name`,`email`,`mobile_phone` FROM `y_users` WHERE ( `user_id` = 0 ) LIMIT 1 [ RunTime:0.000091s ]
SHOW COLUMNS FROM `v_scenery_goods` [ RunTime:0.001179s ]
SELECT `region_id` FROM `y_region` WHERE ( `region_type` = 2 ) AND ( `region_name` LIKE '%上海%' ) LIMIT 1 [ RunTime:0.000091s ]
SELECT `goods_id`,`goods_name` FROM `v_scenery_goods` WHERE ( `is_delete` = 0 ) AND ( (`is_on_sale` = 1) AND (`activated` = 1) ) AND ( `is_best` = 1 ) ORDER BY goods_id DESC LIMIT 5 [ RunTime:0.000085s ]
SELECT `region_id`,`pinyin_all`,`region_name` FROM `y_region` WHERE ( `region_name` IN ('北京','上海','广州','深圳','成都','三亚') ) AND ( `region_type` = 2 ) GROUP BY region_name ORDER BY region_id asc,region_name asc [ RunTime:0.000105s ]
SHOW COLUMNS FROM `y_friend_link` [ RunTime:0.000349s ]
SELECT `link_logo`,`link_name`,`link_url` FROM `y_friend_link` ORDER BY show_order DESC [ RunTime:0.000088s ]
SELECT `region_id` FROM `y_region` WHERE ( `region_type` = 2 ) AND ( `region_name` LIKE '%上海%' ) LIMIT 1 [ RunTime:0.000082s ]
SELECT `pinyin_all` FROM `y_region` WHERE ( `region_id` = 321 ) LIMIT 1 [ RunTime:0.000076s ]
SHOW COLUMNS FROM `y_left_search` [ RunTime:0.000411s ]
SELECT `id`,`parent_id`,`title`,`url`,`icon`,`istop`,`is_merge`,`type_id` FROM `y_left_search` WHERE ( city_id = 321 or city_id = 0 and istop=1 ) ORDER BY sort desc [ RunTime:0.000479s ]
SELECT `parent_id` FROM `y_region` WHERE ( region_type = 2 and region_id = 321 ) LIMIT 1 [ RunTime:0.000125s ]
SELECT `id`,`parent_id`,`title`,`url`,`istop` FROM `y_left_search` WHERE ( istop = 1 ) [ RunTime:0.000900s ]
SELECT `id`,`parent_id`,`title`,`url`,`istop` FROM `y_left_search` WHERE ( istop = 1 ) [ RunTime:0.000942s ]
SHOW COLUMNS FROM `y_line_goods` [ RunTime:0.000745s ]
SHOW COLUMNS FROM v_lines_goods as g [ RunTime:0.000110s ]
SELECT `region_name` FROM `y_region` WHERE ( region_id = 321 ) LIMIT 1 [ RunTime:0.000088s ]
SELECT g.goods_id,g.goods_img,g.goods_thumb as small_img,IF(g.goods_alias<>'',g.goods_alias,g.goods_name) as goods_name,g.goods_brief,g.shop_prepaid_price as shop_price,g.end_addr,`region_1`,g.region_3,`joinNum`,d.price FROM v_lines_goods as g right JOIN (select goods_id,max(date_day) as date_day,MIN(price) AS price from y_line_dateprice WHERE stockpile>0 and is_delete=0 group by goods_id) as d ON d.goods_id = g.goods_id WHERE ( g.is_delete = 0 ) AND ( (g.is_on_sale = 1) AND (g.activated = 1) ) AND ( g.city = 321 ) AND ( g.cat_id = 15 ) AND ( g.is_best = 1 ) ORDER BY g.is_all asc LIMIT 8 [ RunTime:0.205123s ]
SELECT g.goods_id,g.goods_img,g.goods_thumb as small_img,IF(g.goods_alias<>'',g.goods_alias,g.goods_name) as goods_name,g.goods_brief,g.shop_prepaid_price as shop_price,g.end_addr,`region_1`,g.region_3,`joinNum`,d.price FROM v_lines_goods as g right JOIN (select goods_id,max(date_day) as date_day,MIN(price) AS price from y_line_dateprice WHERE stockpile>0 and is_delete=0 group by goods_id) as d ON d.goods_id = g.goods_id WHERE ( g.is_delete = 0 ) AND ( (g.is_on_sale = 1) AND (g.activated = 1) ) AND ( g.city = 321 or g.is_all = 1 or FIND_IN_SET(321, g.is_all) ) AND ( g.cat_id = 4 ) AND ( g.is_best = 1 ) ORDER BY g.is_all asc LIMIT 5 [ RunTime:0.213692s ]
SELECT g.goods_id,g.goods_img,g.goods_thumb as small_img,IF(g.goods_alias<>'',g.goods_alias,g.goods_name) as goods_name,g.goods_brief,g.shop_prepaid_price as shop_price,g.end_addr,`region_1`,g.region_3,`joinNum`,d.price FROM v_lines_goods as g right JOIN (select goods_id,max(date_day) as date_day,MIN(price) AS price from y_line_dateprice WHERE stockpile>0 and is_delete=0 group by goods_id) as d ON d.goods_id = g.goods_id WHERE ( g.is_delete = 0 ) AND ( (g.is_on_sale = 1) AND (g.activated = 1) ) AND ( g.city = 321 or g.is_all = 1 or FIND_IN_SET(321, g.is_all) ) AND ( g.cat_id = 5 ) AND ( g.is_best = 1 ) ORDER BY g.is_all asc LIMIT 5 [ RunTime:0.210657s ]
SHOW COLUMNS FROM y_line_dateprice as d [ RunTime:0.000111s ]
SELECT d.price,d.market_price,d.goods_id,d.date_day,l.goods_name,l.cat_id,l.goods_thumb,l.goods_alias,l.shop_prepaid_price,m.icon,l.goods_brief FROM y_line_dateprice as d left join y_line_goods as l on d.goods_id = l.goods_id left join y_sys_hotproduct as h on l.goods_id = h.goods_id right join y_sys_hotmodel as m on h.model_id = m.id WHERE ( is_end = 1 ) GROUP BY d.goods_id ORDER BY h.id desc LIMIT 0,4 [ RunTime:0.002180s ]
SHOW COLUMNS FROM `y_ad` [ RunTime:0.000422s ]
SELECT ad_name as title,ad_link as url,ad_code as img,`ad_id` FROM `y_ad` WHERE ( `type` = 'index_v3' ) AND ( `enabled` = 1 ) AND ( (`is_all` = 1) OR (`city` = '321') ) ORDER BY is_all desc,sort asc [ RunTime:0.000101s ]
SELECT ad_name as title,ad_link as url,ad_code as img,`ad_id` FROM `y_ad` WHERE ( `type` = 'index_rt_v' ) AND ( `enabled` = 1 ) AND ( (`is_all` = 1) OR (`city` = '321') ) ORDER BY is_all desc,sort asc [ RunTime:0.000079s ]
SELECT ad_name as title,ad_link as url,ad_code as img,`ad_id` FROM `y_ad` WHERE ( `type` = 'fx_lx_v3' ) AND ( `enabled` = 1 ) AND ( (`is_all` = 1) OR (`city` = '321') ) ORDER BY is_all desc,sort asc [ RunTime:0.000079s ]
SELECT ad_name as title,ad_link as url,ad_code as img,`ad_id` FROM `y_ad` WHERE ( `type` = 'home_hotel' ) AND ( `enabled` = 1 ) AND ( (`is_all` = 1) OR (`city` = '321') ) ORDER BY is_all desc,sort asc [ RunTime:0.000076s ]
SHOW COLUMNS FROM `y_sys_features` [ RunTime:0.000322s ]
SELECT `title`,`img_url`,`link` FROM `y_sys_features` WHERE ( is_del = 1 ) ORDER BY id desc LIMIT 6 [ RunTime:0.000082s ]
上海周边游
