SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001355s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=33100&search=1' [ RunTime:0.035256s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001283s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.037018s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002118s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.027553s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001447s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001199s ]
SELECT * FROM `stock_search` WHERE `partno` = '33100' LIMIT 1 [ RunTime:0.088199s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-24 03:42:02' WHERE `partno` = '33100' [ RunTime:0.030184s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003812s ]
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 '33100%' OR `brand` LIKE '33100%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.162806s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13276376 LIMIT 5 [ RunTime:0.073277s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13276376 ORDER BY `minOrder` ASC [ RunTime:0.085709s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13276376 ORDER BY `unit` DESC [ RunTime:0.173532s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.090828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13276376 LIMIT 2 [ RunTime:0.085556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13276376 ORDER BY `minOrder` ASC [ RunTime:0.064843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13276382 LIMIT 5 [ RunTime:0.114664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13276382 ORDER BY `minOrder` ASC [ RunTime:0.098504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13276382 ORDER BY `unit` DESC [ RunTime:0.104113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13276382 LIMIT 2 [ RunTime:0.220294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13276382 ORDER BY `minOrder` ASC [ RunTime:0.077257s ]
select * from pdf where partno='331001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.106392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17052018 LIMIT 5 [ RunTime:0.052178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17052018 ORDER BY `minOrder` ASC [ RunTime:0.030327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17052018 ORDER BY `unit` DESC [ RunTime:0.054865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17052018 LIMIT 2 [ RunTime:0.090754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17052018 ORDER BY `minOrder` ASC [ RunTime:0.076845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14277860 LIMIT 5 [ RunTime:0.078411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14277860 ORDER BY `minOrder` ASC [ RunTime:0.118086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14277860 ORDER BY `unit` DESC [ RunTime:0.052725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14277860 LIMIT 2 [ RunTime:0.101358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14277860 ORDER BY `minOrder` ASC [ RunTime:0.069546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14252899 LIMIT 5 [ RunTime:0.075985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14252899 ORDER BY `minOrder` ASC [ RunTime:0.098563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14252899 ORDER BY `unit` DESC [ RunTime:0.087133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14252899 LIMIT 2 [ RunTime:0.059976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14252899 ORDER BY `minOrder` ASC [ RunTime:0.033954s ]
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 '33100%' OR `brand` LIKE '33100%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.126303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105192 LIMIT 5 [ RunTime:0.050825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105192 ORDER BY `minOrder` ASC [ RunTime:0.150996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105192 ORDER BY `unit` DESC [ RunTime:0.115715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105192 LIMIT 2 [ RunTime:0.095445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105192 ORDER BY `minOrder` ASC [ RunTime:0.018902s ]
select * from pdf where partno='331001' and brandshort='wurth elektronik' limit 1 [ RunTime:0.130847s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '331001' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.053363s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105192 AND `partno` = '331001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.053280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13276382 [ RunTime:0.200824s ]
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 '33100%' OR `brand` LIKE '33100%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.106733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40496506 LIMIT 5 [ RunTime:0.168129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40496506 ORDER BY `minOrder` ASC [ RunTime:0.050625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40496506 ORDER BY `unit` DESC [ RunTime:0.161269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40496506 LIMIT 2 [ RunTime:0.050708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40496506 ORDER BY `minOrder` ASC [ RunTime:0.031643s ]
select * from pdf where partno='33100C' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.069592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33100C' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.083366s ]
SELECT `id` FROM `stock` WHERE `id` <> 40496506 AND `partno` = '33100C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata power solutions inc.%' ) [ RunTime:0.051806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14277860 [ RunTime:0.170931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63532566 LIMIT 5 [ RunTime:0.098249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63532566 ORDER BY `minOrder` ASC [ RunTime:0.060586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63532566 ORDER BY `unit` DESC [ RunTime:0.050667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63532566 LIMIT 2 [ RunTime:0.084205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63532566 ORDER BY `minOrder` ASC [ RunTime:0.147573s ]
select * from pdf where partno='331001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.053269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '331001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.051189s ]
SELECT `id` FROM `stock` WHERE `id` <> 63532566 AND `partno` = '331001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.247430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13276382 [ RunTime:0.112842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64290953 LIMIT 5 [ RunTime:0.114164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64290953 ORDER BY `minOrder` ASC [ RunTime:0.230993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64290953 ORDER BY `unit` DESC [ RunTime:0.123776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64290953 LIMIT 2 [ RunTime:0.118175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64290953 ORDER BY `minOrder` ASC [ RunTime:0.050613s ]
select * from pdf where partno='33100' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.164389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33100' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.045927s ]
SELECT `id` FROM `stock` WHERE `id` <> 64290953 AND `partno` = '33100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.222211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14252899 [ RunTime:0.174992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63532576 LIMIT 5 [ RunTime:0.078606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63532576 ORDER BY `minOrder` ASC [ RunTime:0.193639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63532576 ORDER BY `unit` DESC [ RunTime:0.159697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63532576 LIMIT 2 [ RunTime:0.063477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63532576 ORDER BY `minOrder` ASC [ RunTime:0.031864s ]
select * from pdf where partno='331003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.075801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '331003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.014385s ]
SELECT `id` FROM `stock` WHERE `id` <> 63532576 AND `partno` = '331003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.105953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13276376 [ RunTime:0.102126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63458385 LIMIT 5 [ RunTime:0.113601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63458385 ORDER BY `minOrder` ASC [ RunTime:0.027884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63458385 ORDER BY `unit` DESC [ RunTime:0.042990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63458385 LIMIT 2 [ RunTime:0.033941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63458385 ORDER BY `minOrder` ASC [ RunTime:0.021139s ]
select * from pdf where partno='33100050SP' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.014728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '33100050SP' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.027516s ]
SELECT `id` FROM `stock` WHERE `id` <> 63458385 AND `partno` = '33100050SP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.035112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17052018 [ RunTime:0.044593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32478918 LIMIT 5 [ RunTime:0.041901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32478918 ORDER BY `minOrder` ASC [ RunTime:0.052449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32478918 ORDER BY `unit` DESC [ RunTime:0.013279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32478918 LIMIT 2 [ RunTime:0.022121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32478918 ORDER BY `minOrder` ASC [ RunTime:0.009524s ]
select * from pdf where partno='331005' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.014973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '331005' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.007614s ]
SELECT `id` FROM `stock` WHERE `id` <> 32478918 AND `partno` = '331005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.008760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32439882 LIMIT 5 [ RunTime:0.012786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32439882 ORDER BY `minOrder` ASC [ RunTime:0.037586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32439882 ORDER BY `unit` DESC [ RunTime:0.007172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32439882 LIMIT 2 [ RunTime:0.005502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32439882 ORDER BY `minOrder` ASC [ RunTime:0.008133s ]
select * from pdf where partno='331003' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.008001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '331003' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.005473s ]
SELECT `id` FROM `stock` WHERE `id` <> 32439882 AND `partno` = '331003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.012442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32426480 LIMIT 5 [ RunTime:0.021826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32426480 ORDER BY `minOrder` ASC [ RunTime:0.009309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32426480 ORDER BY `unit` DESC [ RunTime:0.006122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32426480 LIMIT 2 [ RunTime:0.004117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32426480 ORDER BY `minOrder` ASC [ RunTime:0.004846s ]
select * from pdf where partno='331000' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.014483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '331000' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.014922s ]
SELECT `id` FROM `stock` WHERE `id` <> 32426480 AND `partno` = '331000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.006848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32418440 LIMIT 5 [ RunTime:0.004597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32418440 ORDER BY `minOrder` ASC [ RunTime:0.022689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32418440 ORDER BY `unit` DESC [ RunTime:0.009067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32418440 LIMIT 2 [ RunTime:0.005545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32418440 ORDER BY `minOrder` ASC [ RunTime:0.008974s ]
select * from pdf where partno='331002' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.006128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '331002' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.002045s ]
SELECT `id` FROM `stock` WHERE `id` <> 32418440 AND `partno` = '331002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.013766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32395524 LIMIT 5 [ RunTime:0.004522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32395524 ORDER BY `minOrder` ASC [ RunTime:0.007993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32395524 ORDER BY `unit` DESC [ RunTime:0.009513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32395524 LIMIT 2 [ RunTime:0.005882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32395524 ORDER BY `minOrder` ASC [ RunTime:0.005588s ]
select * from pdf where partno='331001' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.006842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '331001' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.010614s ]
SELECT `id` FROM `stock` WHERE `id` <> 32395524 AND `partno` = '331001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.002903s ]
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 '33100%' OR `brand` LIKE '33100%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005523s ]
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 '33100%' OR `brand` LIKE '33100%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014152s ]
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 '33100%' OR `brand` LIKE '33100%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019984s ]
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 '33100%' OR `brand` LIKE '33100%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011079s ]
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 '33100%' OR `brand` LIKE '33100%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015872s ]
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 '33100%' OR `brand` LIKE '33100%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006110s ]
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 '33100%' OR `brand` LIKE '33100%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007802s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '33100%' OR `brand` LIKE '33100%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021006s ]