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.023595s ]
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.001260s ]
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.009094s ]
SELECT * FROM la_category WHERE ( pid = 40 ) AND la_category."delete_time" IS NULL [ RunTime:0.001516s ]
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.033704s ]
SELECT id,title,price,image_url,is_grounding,create_time FROM la_goods WHERE ( category_id = 40 AND is_grounding = 1 ) AND la_goods."delete_time" IS NULL ORDER BY id DESC LIMIT 24 OFFSET 0 [ RunTime:0.161754s ]
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.005480s ]
SELECT status,goods_id FROM la_goods_collect WHERE user_id IS NULL AND goods_id IN (1461412,1461287,1460976,1459491,1459486,1459191,1458868,1458863,1458858,1458853,1458848,1458311,1456108,1456053,1455647,1451937,1451782,1451741,1451436,1450972,1450941,1450856,1450707,1450535) [ RunTime:0.001180s ]
SELECT COUNT(*) AS think_count FROM la_goods WHERE ( category_id = 40 AND is_grounding = 1 ) AND la_goods."delete_time" IS NULL LIMIT 1 [ RunTime:1.145211s ]
SELECT title FROM la_category WHERE ( id = 40 ) AND la_category."delete_time" IS NULL LIMIT 1 [ RunTime:0.001148s ]