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.030550s ]
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.001856s ]
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.010258s ]
SELECT * FROM la_category WHERE ( pid = 95 ) AND la_category."delete_time" IS NULL [ RunTime:0.002061s ]
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.041531s ]
SELECT id,title,price,image_url,is_grounding,create_time FROM la_goods WHERE ( category_id IN (96,97,98,99,105,3754,5360,5361,5362,5363,5364,5365,5366,5367,5368,5369,5370,5371,5372,5373,5374,5375,5376,5377,5378,5379,5380,5385,5390,95) AND is_grounding = 1 ) AND la_goods."delete_time" IS NULL ORDER BY id DESC LIMIT 24 OFFSET 0 [ RunTime:0.258935s ]
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.007430s ]
SELECT status,goods_id FROM la_goods_collect WHERE user_id IS NULL AND goods_id IN (1455942,1454735,1454731,1451427,1451422,1451417,1451413,1451352,1451349,1451318,1450702,1450227,1450192,1450187,1450182,1450177,1450167,1450131,1450125,1450092,1449565,1437998,1437996,1437984) [ RunTime:0.001668s ]
SELECT COUNT(*) AS think_count FROM la_goods WHERE ( category_id IN (96,97,98,99,105,3754,5360,5361,5362,5363,5364,5365,5366,5367,5368,5369,5370,5371,5372,5373,5374,5375,5376,5377,5378,5379,5380,5385,5390,95) AND is_grounding = 1 ) AND la_goods."delete_time" IS NULL LIMIT 1 [ RunTime:1.270678s ]
SELECT title FROM la_category WHERE ( id = 95 ) AND la_category."delete_time" IS NULL LIMIT 1 [ RunTime:0.000938s ]