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.023261s ]
SELECT name,link FROM la_link [ RunTime:0.001058s ]
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.006796s ]
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.001521s ]
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.011826s ]
SELECT id,title FROM la_article WHERE delete_time IS NULL AND cid = 4 ORDER BY sort DESC LIMIT 5 [ RunTime:0.001306s ]
SELECT id,title FROM la_article WHERE delete_time IS NULL AND cid = 6 ORDER BY sort DESC LIMIT 5 [ RunTime:0.000822s ]
SELECT id,title FROM la_article WHERE delete_time IS NULL AND cid = 5 ORDER BY sort DESC LIMIT 5 [ RunTime:0.001083s ]
SELECT id,title FROM la_article WHERE delete_time IS NULL AND cid = 1 ORDER BY sort DESC LIMIT 5 [ RunTime:0.000847s ]
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.009976s ]
SELECT * FROM la_category WHERE la_category."delete_time" IS NULL ORDER BY rank [ RunTime:0.002454s ]
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.009259s ]
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.001726s ]
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.012408s ]
SELECT * FROM la_site WHERE is_show = 1 ORDER BY sort DESC [ RunTime:0.001449s ]
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_user_footprint'); [ RunTime:0.010224s ]
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.052040s ]
UPDATE la_goods SET hits = hits + 1 WHERE id = 597408 [ RunTime:0.002348s ]
SELECT * FROM la_goods WHERE ( id = 597408 ) AND la_goods."delete_time" IS NULL LIMIT 1 [ RunTime:0.002175s ]
SELECT title,pid,id FROM la_category WHERE ( id = 4125 ) AND la_category."delete_time" IS NULL LIMIT 1 [ RunTime:0.001135s ]
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.014663s ]
SELECT value FROM la_dict_data WHERE ( type_value = 'Image_domain' ) AND la_dict_data."delete_time" IS NULL LIMIT 1 [ RunTime:0.001681s ]
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.011155s ]
SELECT status FROM la_goods_collect WHERE user_id IS NULL AND goods_id = 597408 LIMIT 1 [ RunTime:0.001310s ]
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_muzzle'); [ RunTime:0.054896s ]
SELECT * FROM la_muzzle WHERE seller_id = 18672 LIMIT 1 [ RunTime:0.002237s ]
SELECT COUNT(*) AS think_count FROM la_goods WHERE ( muzzle_id = 18672 AND is_grounding = 1 ) AND la_goods."delete_time" IS NULL LIMIT 1 [ RunTime:1.280805s ]
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_user_muzzle'); [ RunTime:0.004729s ]
SELECT id FROM la_user_muzzle WHERE uid IS NULL AND mid = 1030 LIMIT 1 [ RunTime:0.000915s ]
SELECT id FROM la_category WHERE ( pid IN (4125,4100) ) AND la_category."delete_time" IS NULL [ RunTime:0.001131s ]
SELECT * FROM la_user_footprint WHERE uid IS NULL LIMIT 20 [ RunTime:0.000986s ]
SELECT id,title,image_url,price,article_number,muzzle_id FROM la_goods WHERE ( category_id IN (108,109,110,111,112,113,114,115,116,117,3893,3902,3910,4101,4107,4108,4109,4121,4122,4125,4126,4132,4147,4148,4151,4155,4158,4159,4161,4632,5170,5171,5172,5176,5177,5523,4100) AND is_grounding = 1 AND id <> 597408 AND is_duibi IN (1,4) OR id IN (16280,16167,23607,127029,18988,19169,50774,40989,18912) ) AND la_goods."delete_time" IS NULL ORDER BY hits DESC LIMIT 20 OFFSET 0 [ RunTime:1.364384s ]
SELECT shop_name,seller_id FROM la_muzzle WHERE seller_id IN (12569,890,115,392,8706,2290,11,979,437,629,819,889,18672,17,811) [ RunTime:0.002343s ]
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_platform'); [ RunTime:0.009250s ]
SELECT * FROM la_platform WHERE ( is_show = 1 ) AND la_platform."delete_time" IS NULL [ RunTime:0.001352s ]
SELECT value FROM la_config WHERE name = 'dispatch_process' LIMIT 1 [ RunTime:0.001118s ]
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_discount_coupon_erp'); [ RunTime:0.008558s ]
SELECT * FROM la_discount_coupon_erp WHERE is_ok = 1 AND status = 0 AND type = 0 AND applicable_scene = 0 AND end_time > 1770186168 AND uid IS NULL [ RunTime:0.001026s ]