SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001638s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.227' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=WTDXA40SJT&search=1' [ RunTime:0.015596s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001552s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005521s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002001s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.227' ) [ RunTime:0.001149s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002388s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005303s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001092s ]
SELECT * FROM `stock_search` WHERE `partno` = 'WTDXA40SJT' LIMIT 1 [ RunTime:0.048620s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-27 04:37:40' WHERE `partno` = 'WTDXA40SJT' [ RunTime:0.010783s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002530s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025851s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292656 LIMIT 5 [ RunTime:0.039555s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292656 ORDER BY `minOrder` ASC [ RunTime:0.014500s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13292656 ORDER BY `unit` DESC [ RunTime:0.015311s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13292656 LIMIT 2 [ RunTime:0.023518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292656 ORDER BY `minOrder` ASC [ RunTime:0.044313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288445 LIMIT 5 [ RunTime:0.032283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288445 ORDER BY `minOrder` ASC [ RunTime:0.069376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288445 ORDER BY `unit` DESC [ RunTime:0.064362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288445 LIMIT 2 [ RunTime:0.056760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288445 ORDER BY `minOrder` ASC [ RunTime:0.080575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12797739 LIMIT 5 [ RunTime:0.028196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12797739 ORDER BY `minOrder` ASC [ RunTime:0.019858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12797739 ORDER BY `unit` DESC [ RunTime:0.100761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12797739 LIMIT 2 [ RunTime:0.053670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12797739 ORDER BY `minOrder` ASC [ RunTime:0.017939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12021684 LIMIT 5 [ RunTime:0.050992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12021684 ORDER BY `minOrder` ASC [ RunTime:0.042054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12021684 ORDER BY `unit` DESC [ RunTime:0.042925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12021684 LIMIT 2 [ RunTime:0.061153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12021684 ORDER BY `minOrder` ASC [ RunTime:0.051522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12020275 LIMIT 5 [ RunTime:0.052858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12020275 ORDER BY `minOrder` ASC [ RunTime:0.024818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12020275 ORDER BY `unit` DESC [ RunTime:0.110814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12020275 LIMIT 2 [ RunTime:0.089012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12020275 ORDER BY `minOrder` ASC [ RunTime:0.032110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12020274 LIMIT 5 [ RunTime:0.023376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12020274 ORDER BY `minOrder` ASC [ RunTime:0.032435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12020274 ORDER BY `unit` DESC [ RunTime:0.026047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12020274 LIMIT 2 [ RunTime:0.013341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12020274 ORDER BY `minOrder` ASC [ RunTime:0.021428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11614347 LIMIT 5 [ RunTime:0.080757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11614347 ORDER BY `minOrder` ASC [ RunTime:0.034730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11614347 ORDER BY `unit` DESC [ RunTime:0.059381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11614347 LIMIT 2 [ RunTime:0.065423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11614347 ORDER BY `minOrder` ASC [ RunTime:0.020255s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032991s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53063881 LIMIT 5 [ RunTime:0.049252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063881 ORDER BY `minOrder` ASC [ RunTime:0.037150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53063881 ORDER BY `unit` DESC [ RunTime:0.052544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53063881 LIMIT 2 [ RunTime:0.076069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063881 ORDER BY `minOrder` ASC [ RunTime:0.036530s ]
select * from pdf where partno='WTDXA40SJTL' and brandshort='AirBorn, a Molex company' limit 1 [ RunTime:0.049634s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTDXA40SJTL' OR `brand` LIKE 'AirBorn, a Molex company%' ) ) LIMIT 1 [ RunTime:0.063047s ]
SELECT `id` FROM `stock` WHERE `id` <> 53063881 AND `partno` = 'WTDXA40SJTL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%airborn, a molex company%' ) [ RunTime:0.040573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12021684 [ RunTime:0.062129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53063617 LIMIT 5 [ RunTime:0.050847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063617 ORDER BY `minOrder` ASC [ RunTime:0.028577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53063617 ORDER BY `unit` DESC [ RunTime:0.025739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53063617 LIMIT 2 [ RunTime:0.044813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063617 ORDER BY `minOrder` ASC [ RunTime:0.014721s ]
select * from pdf where partno='WTDXA40SJTA-C45' and brandshort='Molex' limit 1 [ RunTime:0.042294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTDXA40SJTA-C45' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.103851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53063397 LIMIT 5 [ RunTime:0.030486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063397 ORDER BY `minOrder` ASC [ RunTime:0.082848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53063397 ORDER BY `unit` DESC [ RunTime:0.083491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53063397 LIMIT 2 [ RunTime:0.033857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063397 ORDER BY `minOrder` ASC [ RunTime:0.029939s ]
select * from pdf where partno='WTDXA40SJT' and brandshort='AirBorn, a Molex company' limit 1 [ RunTime:0.070753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTDXA40SJT' OR `brand` LIKE 'AirBorn, a Molex company%' ) ) LIMIT 1 [ RunTime:0.018453s ]
SELECT `id` FROM `stock` WHERE `id` <> 53063397 AND `partno` = 'WTDXA40SJT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%airborn, a molex company%' ) [ RunTime:0.060809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11614347 [ RunTime:0.066408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53063396 LIMIT 5 [ RunTime:0.066374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063396 ORDER BY `minOrder` ASC [ RunTime:0.040293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53063396 ORDER BY `unit` DESC [ RunTime:0.039435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53063396 LIMIT 2 [ RunTime:0.018512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063396 ORDER BY `minOrder` ASC [ RunTime:0.013331s ]
select * from pdf where partno='WTDXA40SJTB-C45' and brandshort='AirBorn, a Molex company' limit 1 [ RunTime:0.042523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTDXA40SJTB-C45' OR `brand` LIKE 'AirBorn, a Molex company%' ) ) LIMIT 1 [ RunTime:0.044357s ]
SELECT `id` FROM `stock` WHERE `id` <> 53063396 AND `partno` = 'WTDXA40SJTB-C45' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%airborn, a molex company%' ) [ RunTime:0.052745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12020275 [ RunTime:0.055024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53063395 LIMIT 5 [ RunTime:0.053659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063395 ORDER BY `minOrder` ASC [ RunTime:0.082133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53063395 ORDER BY `unit` DESC [ RunTime:0.014415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53063395 LIMIT 2 [ RunTime:0.061348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063395 ORDER BY `minOrder` ASC [ RunTime:0.013856s ]
select * from pdf where partno='WTDXA40SJTB' and brandshort='AirBorn, a Molex company' limit 1 [ RunTime:0.029667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTDXA40SJTB' OR `brand` LIKE 'AirBorn, a Molex company%' ) ) LIMIT 1 [ RunTime:0.035634s ]
SELECT `id` FROM `stock` WHERE `id` <> 53063395 AND `partno` = 'WTDXA40SJTB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%airborn, a molex company%' ) [ RunTime:0.058835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12020274 [ RunTime:0.040530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53063252 LIMIT 5 [ RunTime:0.034976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063252 ORDER BY `minOrder` ASC [ RunTime:0.010955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53063252 ORDER BY `unit` DESC [ RunTime:0.032176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53063252 LIMIT 2 [ RunTime:0.040334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53063252 ORDER BY `minOrder` ASC [ RunTime:0.008633s ]
select * from pdf where partno='WTDXA40SJTA' and brandshort='AirBorn, a Molex company' limit 1 [ RunTime:0.026702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTDXA40SJTA' OR `brand` LIKE 'AirBorn, a Molex company%' ) ) LIMIT 1 [ RunTime:0.020932s ]
SELECT `id` FROM `stock` WHERE `id` <> 53063252 AND `partno` = 'WTDXA40SJTA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%airborn, a molex company%' ) [ RunTime:0.039798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12797739 [ RunTime:0.038707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32636908 LIMIT 5 [ RunTime:0.078286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32636908 ORDER BY `minOrder` ASC [ RunTime:0.045614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32636908 ORDER BY `unit` DESC [ RunTime:0.062019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32636908 LIMIT 2 [ RunTime:0.010324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32636908 ORDER BY `minOrder` ASC [ RunTime:0.026263s ]
select * from pdf where partno='WTDXA40SJT-A53' and brandshort='AirBorn, a Molex company' limit 1 [ RunTime:0.043136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'WTDXA40SJT-A53' OR `brand` LIKE 'AirBorn, a Molex company%' ) ) LIMIT 1 [ RunTime:0.013242s ]
SELECT `id` FROM `stock` WHERE `id` <> 32636908 AND `partno` = 'WTDXA40SJT-A53' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%airborn, a molex company%' ) [ RunTime:0.117517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292656 [ RunTime:0.033236s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032004s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011144s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029155s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032655s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022477s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037128s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037637s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'WTDXA40SJT%' OR `brand` LIKE 'WTDXA40SJT%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.084546s ]