SHOW FULL COLUMNS FROM `dlm_site` [ RunTime:0.000684s ]
SELECT * FROM `dlm_site` WHERE `site_url` LIKE '%https://ideabuy.com.hk%' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `dlm_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `dlm_nav` [ RunTime:0.000545s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000321s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 8 ORDER BY `sort` ASC [ RunTime:0.000264s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 2 ORDER BY `sort` ASC [ RunTime:0.000246s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 3 ORDER BY `sort` ASC [ RunTime:0.000251s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 6 ORDER BY `sort` ASC [ RunTime:0.000248s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 7 ORDER BY `sort` ASC [ RunTime:0.000269s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 1 ORDER BY `sort` ASC [ RunTime:0.000240s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000262s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 8 ORDER BY `sort` ASC [ RunTime:0.000253s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 2 ORDER BY `sort` ASC [ RunTime:0.000244s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 3 ORDER BY `sort` ASC [ RunTime:0.000251s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 6 ORDER BY `sort` ASC [ RunTime:0.000272s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 7 ORDER BY `sort` ASC [ RunTime:0.000241s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 1 ORDER BY `sort` ASC [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `dlm_goods_cat` [ RunTime:0.000512s ]
SELECT `catid`,catname as catname,`content`,`thumb`,`en` FROM `dlm_goods_cat` WHERE `state` = 1 AND `display` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `dlm_goods` [ RunTime:0.000625s ]
SELECT g_code as sku,g_imgs as imgs,g_posid as posid,g_tag as tag,g_type as type,g_rule as rule,g_cat as cat,g_name as name,g_id as id,g_thumb as thumb,g_price as price,g_price2 as price2,g_discount_per as discount_per,g_description as description,g_ad as ad,g_sub as sub,g_score as score FROM `dlm_goods` WHERE `g_state` = 2 AND `g_posid` LIKE '%1%' AND `g_cat2` = 10026 ORDER BY `g_sell` DESC LIMIT 4 [ RunTime:0.000398s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10026 AND `g_state` = 2 [ RunTime:0.000274s ]
SELECT g_code as sku,g_imgs as imgs,g_posid as posid,g_tag as tag,g_type as type,g_rule as rule,g_cat as cat,g_name as name,g_id as id,g_thumb as thumb,g_price as price,g_price2 as price2,g_discount_per as discount_per,g_description as description,g_ad as ad,g_sub as sub,g_score as score FROM `dlm_goods` WHERE `g_state` = 2 AND `g_posid` LIKE '%1%' AND `g_cat2` = 10030 ORDER BY `g_sell` DESC LIMIT 4 [ RunTime:0.000380s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10030 AND `g_state` = 2 [ RunTime:0.000254s ]
SELECT g_code as sku,g_imgs as imgs,g_posid as posid,g_tag as tag,g_type as type,g_rule as rule,g_cat as cat,g_name as name,g_id as id,g_thumb as thumb,g_price as price,g_price2 as price2,g_discount_per as discount_per,g_description as description,g_ad as ad,g_sub as sub,g_score as score FROM `dlm_goods` WHERE `g_state` = 2 AND `g_posid` LIKE '%1%' AND `g_cat2` = 10037 ORDER BY `g_sell` DESC LIMIT 4 [ RunTime:0.000386s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10037 AND `g_state` = 2 [ RunTime:0.000263s ]
SELECT g_code as sku,g_imgs as imgs,g_posid as posid,g_tag as tag,g_type as type,g_rule as rule,g_cat as cat,g_name as name,g_id as id,g_thumb as thumb,g_price as price,g_price2 as price2,g_discount_per as discount_per,g_description as description,g_ad as ad,g_sub as sub,g_score as score FROM `dlm_goods` WHERE `g_state` = 2 AND `g_posid` LIKE '%1%' AND `g_cat2` = 10039 ORDER BY `g_sell` DESC LIMIT 4 [ RunTime:0.000362s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10039 AND `g_state` = 2 [ RunTime:0.000286s ]
SELECT g_code as sku,g_imgs as imgs,g_posid as posid,g_tag as tag,g_type as type,g_rule as rule,g_cat as cat,g_name as name,g_id as id,g_thumb as thumb,g_price as price,g_price2 as price2,g_discount_per as discount_per,g_description as description,g_ad as ad,g_sub as sub,g_score as score FROM `dlm_goods` WHERE `g_state` = 2 AND `g_posid` LIKE '%1%' AND `g_cat2` = 10027 ORDER BY `g_sell` DESC LIMIT 4 [ RunTime:0.000344s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10027 AND `g_state` = 2 [ RunTime:0.000282s ]
SELECT g_code as sku,g_imgs as imgs,g_posid as posid,g_tag as tag,g_type as type,g_rule as rule,g_cat as cat,g_name as name,g_id as id,g_thumb as thumb,g_price as price,g_price2 as price2,g_discount_per as discount_per,g_description as description,g_ad as ad,g_sub as sub,g_score as score FROM `dlm_goods` WHERE `g_state` = 2 AND `g_posid` LIKE '%1%' AND `g_cat2` = 10028 ORDER BY `g_sell` DESC LIMIT 4 [ RunTime:0.000383s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10028 AND `g_state` = 2 [ RunTime:0.000277s ]
SELECT g_code as sku,g_imgs as imgs,g_posid as posid,g_tag as tag,g_type as type,g_rule as rule,g_cat as cat,g_name as name,g_id as id,g_thumb as thumb,g_price as price,g_price2 as price2,g_discount_per as discount_per,g_description as description,g_ad as ad,g_sub as sub,g_score as score FROM `dlm_goods` WHERE `g_state` = 2 AND `g_posid` LIKE '%1%' AND `g_cat2` = 10040 ORDER BY `g_sell` DESC LIMIT 4 [ RunTime:0.000427s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10040 AND `g_state` = 2 [ RunTime:0.000290s ]
SHOW FULL COLUMNS FROM `dlm_base_page` [ RunTime:0.000448s ]
SELECT `id`,title as title FROM `dlm_base_page` ORDER BY `id` ASC [ RunTime:0.000203s ]
SHOW FULL COLUMNS FROM `dlm_score` [ RunTime:0.000473s ]
SELECT * FROM `dlm_score` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000246s ]
SHOW FULL COLUMNS FROM `dlm_community` [ RunTime:0.000560s ]
SELECT `cid`,name as name,address as address FROM `dlm_community` WHERE `state` = 1 ORDER BY `cid` DESC [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `dlm_city` [ RunTime:0.000495s ]
SELECT `id`,title_name as name,`fee` FROM `dlm_city` WHERE `parent_id` = 2 ORDER BY `id` ASC [ RunTime:0.000240s ]