SHOW FULL COLUMNS FROM `dlm_user` [ RunTime:0.000639s ]
SELECT * FROM `dlm_user` WHERE `status` = 1 AND `token` = 'HOJfrmjUimELZTwDGwCtPFpSe' LIMIT 1 [ RunTime:0.000407s ]
SHOW FULL COLUMNS FROM `dlm_site` [ RunTime:0.000479s ]
SELECT * FROM `dlm_site` WHERE `site_url` LIKE '%https://en.ideabuy.com.hk%' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `dlm_nav` [ RunTime:0.000440s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000231s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 8 ORDER BY `sort` ASC [ RunTime:0.000198s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 2 ORDER BY `sort` ASC [ RunTime:0.000195s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 3 ORDER BY `sort` ASC [ RunTime:0.000199s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 6 ORDER BY `sort` ASC [ RunTime:0.000177s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 7 ORDER BY `sort` ASC [ RunTime:0.000172s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 1 ORDER BY `sort` ASC [ RunTime:0.000184s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `parent_id` = 0 ORDER BY `sort` ASC [ RunTime:0.000217s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 8 ORDER BY `sort` ASC [ RunTime:0.000197s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 2 ORDER BY `sort` ASC [ RunTime:0.000172s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 3 ORDER BY `sort` ASC [ RunTime:0.000188s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 6 ORDER BY `sort` ASC [ RunTime:0.000174s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 7 ORDER BY `sort` ASC [ RunTime:0.000173s ]
SELECT `id`,name as cn,`linkurl`,`thumb_url`,name_en as name,`status` FROM `dlm_nav` WHERE `status` = 1 AND `parent_id` = 1 ORDER BY `sort` ASC [ RunTime:0.000189s ]
SHOW FULL COLUMNS FROM `dlm_goods_cat` [ RunTime:0.000415s ]
SELECT `catid`,catname_en as catname,`content`,`thumb`,`en` FROM `dlm_goods_cat` WHERE `state` = 1 AND `display` = 1 ORDER BY `sort` ASC LIMIT 8 [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `dlm_goods` [ RunTime:0.000537s ]
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_en 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_en as description,g_ad_en as ad,g_sub_en 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.000356s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10026 AND `g_state` = 2 [ RunTime:0.000215s ]
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_en 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_en as description,g_ad_en as ad,g_sub_en 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.000287s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10030 AND `g_state` = 2 [ RunTime:0.000205s ]
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_en 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_en as description,g_ad_en as ad,g_sub_en 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.000302s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10037 AND `g_state` = 2 [ RunTime:0.000201s ]
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_en 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_en as description,g_ad_en as ad,g_sub_en 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.000276s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10039 AND `g_state` = 2 [ RunTime:0.000197s ]
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_en 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_en as description,g_ad_en as ad,g_sub_en 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.000260s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10027 AND `g_state` = 2 [ RunTime:0.000205s ]
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_en 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_en as description,g_ad_en as ad,g_sub_en 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.000280s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10028 AND `g_state` = 2 [ RunTime:0.000222s ]
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_en 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_en as description,g_ad_en as ad,g_sub_en 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.000303s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` WHERE `g_cat2` = 10040 AND `g_state` = 2 [ RunTime:0.000210s ]
SHOW FULL COLUMNS FROM `dlm_base_page` [ RunTime:0.000416s ]
SELECT `id`,title_en as title FROM `dlm_base_page` ORDER BY `id` ASC [ RunTime:0.000157s ]
SHOW FULL COLUMNS FROM `dlm_score` [ RunTime:0.000365s ]
SELECT * FROM `dlm_score` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000214s ]
SELECT `catid`,catname_en as catname,`content`,`thumb`,`en` FROM `dlm_goods_cat` WHERE `state` = 1 AND `display` = 1 ORDER BY `sort` ASC LIMIT 36 [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `dlm_goods_brand` [ RunTime:0.000412s ]
SELECT id as bid,name_en as name,`description`,`thumb` FROM `dlm_goods_brand` WHERE `state` = 1 ORDER BY `listorder` ASC,`id` ASC LIMIT 36 [ RunTime:0.000215s ]
SELECT * FROM `dlm_goods_cat` WHERE `state` = 1 AND `en` = 'pet-specific' AND `display` = 1 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000257s ]
SELECT COUNT(*) AS think_count FROM `dlm_goods` `a` LEFT JOIN `dlm_goods_cat` `b` ON `b`.`catid`=`a`.`g_cat2` WHERE `g_state` = 2 AND `g_catids` LIKE '%10037%' AND `g_price` >= '0' AND ( `g_catids` LIKE '%10037%' ) [ RunTime:0.000330s ]
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_en 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_en as description,g_ad_en as ad,g_sub_en as sub,g_score as score,b.catname_en as catname FROM `dlm_goods` `a` LEFT JOIN `dlm_goods_cat` `b` ON `b`.`catid`=`a`.`g_cat2` WHERE `g_state` = 2 AND `g_catids` LIKE '%10037%' AND `g_price` >= '0' AND ( `g_catids` LIKE '%10037%' ) ORDER BY `g_sell` DESC LIMIT 12,12 [ RunTime:0.000397s ]
SELECT `catid`,catname_en as catname,`content`,`thumb`,`en` FROM `dlm_goods_cat` ORDER BY `sort` ASC LIMIT 36 [ RunTime:0.000267s ]
