select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg('la_link'); [ RunTime:0.024219s ]
SELECT name,link FROM la_link [ RunTime:0.001392s ]
select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg('la_article_cate'); [ RunTime:0.007439s ]
SELECT id,name FROM la_article_cate WHERE ( is_show = 1 AND delete_time IS NULL ) AND la_article_cate."delete_time" IS NULL ORDER BY sort DESC [ RunTime:0.001590s ]
select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg('la_article'); [ RunTime:0.012381s ]
SELECT id,title FROM la_article WHERE delete_time IS NULL AND cid = 4 ORDER BY sort DESC LIMIT 5 [ RunTime:0.001412s ]
SELECT id,title FROM la_article WHERE delete_time IS NULL AND cid = 6 ORDER BY sort DESC LIMIT 5 [ RunTime:0.000957s ]
SELECT id,title FROM la_article WHERE delete_time IS NULL AND cid = 5 ORDER BY sort DESC LIMIT 5 [ RunTime:0.000848s ]
SELECT id,title FROM la_article WHERE delete_time IS NULL AND cid = 1 ORDER BY sort DESC LIMIT 5 [ RunTime:0.001094s ]
select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg('la_category'); [ RunTime:0.010265s ]
SELECT * FROM la_category WHERE la_category."delete_time" IS NULL ORDER BY rank [ RunTime:0.002703s ]
select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg('la_config'); [ RunTime:0.009741s ]
SELECT value,name FROM la_config WHERE name IN ('pc_logo','pc_title','pc_ico','kefu_ewm','pc_desc','pc_keywords','pc_phone','pc_address','pc_email','ke_sh_biaoshi','zx_kf','qq','weixin','search_keyword') [ RunTime:0.001782s ]
select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg('la_site'); [ RunTime:0.012422s ]
SELECT * FROM la_site WHERE is_show = 1 ORDER BY sort DESC [ RunTime:0.001892s ]
SELECT * FROM la_category WHERE ( pid = 0 ) AND la_category."delete_time" IS NULL [ RunTime:0.001560s ]
SELECT * FROM la_category WHERE ( pid = 4100 ) AND la_category."delete_time" IS NULL [ RunTime:0.001533s ]
select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg('la_dict_data'); [ RunTime:0.015101s ]
SELECT value FROM la_dict_data WHERE ( type_value = 'Image_domain' ) AND la_dict_data."delete_time" IS NULL LIMIT 1 [ RunTime:0.001904s ]
select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg('la_goods'); [ RunTime:0.052092s ]
SELECT id,title,price,image_url,is_grounding,create_time FROM la_goods WHERE ( category_id = 116 AND is_grounding = 1 ) AND la_goods."delete_time" IS NULL ORDER BY id DESC LIMIT 24 OFFSET 0 [ RunTime:0.323363s ]
select fields_name as "field",fields_type as "type",fields_not_null as "null",fields_key_name as "key",fields_default as "default",fields_default as "extra" from table_msg('la_goods_collect'); [ RunTime:0.008040s ]
SELECT status,goods_id FROM la_goods_collect WHERE user_id IS NULL AND goods_id IN (1433963,1418117,1418111,1418101,1418091,1418090,1418083,1418081,1418078,1418075,1418068,1418065,1418061,1418056,1418052,1418048,1418040,1418035,1418031,1418027,1418022,1418015,1418013,1418006) [ RunTime:0.001686s ]
SELECT COUNT(*) AS think_count FROM la_goods WHERE ( category_id = 116 AND is_grounding = 1 ) AND la_goods."delete_time" IS NULL LIMIT 1 [ RunTime:1.267751s ]
SELECT title FROM la_category WHERE ( id = 4100 ) AND la_category."delete_time" IS NULL LIMIT 1 [ RunTime:0.001161s ]
SELECT title FROM la_category WHERE ( id = 116 ) AND la_category."delete_time" IS NULL LIMIT 1 [ RunTime:0.000703s ]