SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002237s ]
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=2265&search=1' [ RunTime:0.003453s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002339s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010946s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002993s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.227' ) [ RunTime:0.019248s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002248s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.031805s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001908s ]
SELECT * FROM `stock_search` WHERE `partno` = '2265' LIMIT 1 [ RunTime:0.043914s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-27 12:14:53' WHERE `partno` = '2265' [ RunTime:0.016922s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001200s ]
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 '2265%' OR `brand` LIKE '2265%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050710s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.009439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348210 LIMIT 5 [ RunTime:0.017652s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348210 ORDER BY `minOrder` ASC [ RunTime:0.028222s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14348210 ORDER BY `unit` DESC [ RunTime:0.016017s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14348210 LIMIT 2 [ RunTime:0.007862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348210 ORDER BY `minOrder` ASC [ RunTime:0.015496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577901 LIMIT 5 [ RunTime:0.012954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577901 ORDER BY `minOrder` ASC [ RunTime:0.005649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577901 ORDER BY `unit` DESC [ RunTime:0.045700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577901 LIMIT 2 [ RunTime:0.109636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577901 ORDER BY `minOrder` ASC [ RunTime:0.023858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19600659 LIMIT 5 [ RunTime:0.033306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19600659 ORDER BY `minOrder` ASC [ RunTime:0.012879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19600659 ORDER BY `unit` DESC [ RunTime:0.042537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19600659 LIMIT 2 [ RunTime:0.029265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19600659 ORDER BY `minOrder` ASC [ RunTime:0.026807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578116 LIMIT 5 [ RunTime:0.046134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578116 ORDER BY `minOrder` ASC [ RunTime:0.030258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578116 ORDER BY `unit` DESC [ RunTime:0.055926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578116 LIMIT 2 [ RunTime:0.015187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578116 ORDER BY `minOrder` ASC [ RunTime:0.007757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578112 LIMIT 5 [ RunTime:0.035132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578112 ORDER BY `minOrder` ASC [ RunTime:0.017537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578112 ORDER BY `unit` DESC [ RunTime:0.005417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578112 LIMIT 2 [ RunTime:0.024863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578112 ORDER BY `minOrder` ASC [ RunTime:0.003386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267758 LIMIT 5 [ RunTime:0.012595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267758 ORDER BY `minOrder` ASC [ RunTime:0.032600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17267758 ORDER BY `unit` DESC [ RunTime:0.014789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17267758 LIMIT 2 [ RunTime:0.016218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17267758 ORDER BY `minOrder` ASC [ RunTime:0.006235s ]
select * from pdf where partno='22659' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.017041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431780 LIMIT 5 [ RunTime:0.015712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431780 ORDER BY `minOrder` ASC [ RunTime:0.013768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431780 ORDER BY `unit` DESC [ RunTime:0.032501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431780 LIMIT 2 [ RunTime:0.050271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431780 ORDER BY `minOrder` ASC [ RunTime:0.057658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431393 LIMIT 5 [ RunTime:0.022366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431393 ORDER BY `minOrder` ASC [ RunTime:0.019250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431393 ORDER BY `unit` DESC [ RunTime:0.056017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431393 LIMIT 2 [ RunTime:0.033869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431393 ORDER BY `minOrder` ASC [ RunTime:0.039443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431392 LIMIT 5 [ RunTime:0.086688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431392 ORDER BY `minOrder` ASC [ RunTime:0.019883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431392 ORDER BY `unit` DESC [ RunTime:0.038394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431392 LIMIT 2 [ RunTime:0.011235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431392 ORDER BY `minOrder` ASC [ RunTime:0.011413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15440619 LIMIT 5 [ RunTime:0.043258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440619 ORDER BY `minOrder` ASC [ RunTime:0.096512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15440619 ORDER BY `unit` DESC [ RunTime:0.091283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15440619 LIMIT 2 [ RunTime:0.089253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15440619 ORDER BY `minOrder` ASC [ RunTime:0.106728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423563 LIMIT 5 [ RunTime:0.021423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423563 ORDER BY `minOrder` ASC [ RunTime:0.019821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14423563 ORDER BY `unit` DESC [ RunTime:0.028147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14423563 LIMIT 2 [ RunTime:0.045099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423563 ORDER BY `minOrder` ASC [ RunTime:0.014783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422210 LIMIT 5 [ RunTime:0.059029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422210 ORDER BY `minOrder` ASC [ RunTime:0.051397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14422210 ORDER BY `unit` DESC [ RunTime:0.026086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14422210 LIMIT 2 [ RunTime:0.030977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422210 ORDER BY `minOrder` ASC [ RunTime:0.022899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422200 LIMIT 5 [ RunTime:0.018944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422200 ORDER BY `minOrder` ASC [ RunTime:0.068274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14422200 ORDER BY `unit` DESC [ RunTime:0.035598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14422200 LIMIT 2 [ RunTime:0.022819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422200 ORDER BY `minOrder` ASC [ RunTime:0.013126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14418122 LIMIT 5 [ RunTime:0.040096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14418122 ORDER BY `minOrder` ASC [ RunTime:0.042773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14418122 ORDER BY `unit` DESC [ RunTime:0.015894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14418122 LIMIT 2 [ RunTime:0.021600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14418122 ORDER BY `minOrder` ASC [ RunTime:0.013387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14418120 LIMIT 5 [ RunTime:0.003705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14418120 ORDER BY `minOrder` ASC [ RunTime:0.019591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14418120 ORDER BY `unit` DESC [ RunTime:0.028882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14418120 LIMIT 2 [ RunTime:0.028673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14418120 ORDER BY `minOrder` ASC [ RunTime:0.008782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417602 LIMIT 5 [ RunTime:0.008208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417602 ORDER BY `minOrder` ASC [ RunTime:0.013590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417602 ORDER BY `unit` DESC [ RunTime:0.028479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417602 LIMIT 2 [ RunTime:0.060208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417602 ORDER BY `minOrder` ASC [ RunTime:0.017937s ]
select * from pdf where partno='22652.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.038118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417601 LIMIT 5 [ RunTime:0.021133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417601 ORDER BY `minOrder` ASC [ RunTime:0.014972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417601 ORDER BY `unit` DESC [ RunTime:0.016645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417601 LIMIT 2 [ RunTime:0.022642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417601 ORDER BY `minOrder` ASC [ RunTime:0.015529s ]
select * from pdf where partno='22650.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.034370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14405358 LIMIT 5 [ RunTime:0.004603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405358 ORDER BY `minOrder` ASC [ RunTime:0.007531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14405358 ORDER BY `unit` DESC [ RunTime:0.016338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14405358 LIMIT 2 [ RunTime:0.022246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14405358 ORDER BY `minOrder` ASC [ RunTime:0.011295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554219 LIMIT 5 [ RunTime:0.025462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554219 ORDER BY `minOrder` ASC [ RunTime:0.028770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554219 ORDER BY `unit` DESC [ RunTime:0.002486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554219 LIMIT 2 [ RunTime:0.021975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554219 ORDER BY `minOrder` ASC [ RunTime:0.007143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554216 LIMIT 5 [ RunTime:0.005690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554216 ORDER BY `minOrder` ASC [ RunTime:0.016849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13554216 ORDER BY `unit` DESC [ RunTime:0.044355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13554216 LIMIT 2 [ RunTime:0.011549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13554216 ORDER BY `minOrder` ASC [ RunTime:0.013854s ]
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 '2265%' OR `brand` LIKE '2265%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020840s ]
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 '2265%' OR `brand` LIKE '2265%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56318262 LIMIT 5 [ RunTime:0.015797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56318262 ORDER BY `minOrder` ASC [ RunTime:0.016674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56318262 ORDER BY `unit` DESC [ RunTime:0.009929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56318262 LIMIT 2 [ RunTime:0.009123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56318262 ORDER BY `minOrder` ASC [ RunTime:0.019060s ]
select * from pdf where partno='2265' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.006246s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2265' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.010317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51413220 LIMIT 5 [ RunTime:0.031654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51413220 ORDER BY `minOrder` ASC [ RunTime:0.025795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51413220 ORDER BY `unit` DESC [ RunTime:0.014732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51413220 LIMIT 2 [ RunTime:0.001586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51413220 ORDER BY `minOrder` ASC [ RunTime:0.008896s ]
select * from pdf where partno='2265' and brandshort='Pololu' limit 1 [ RunTime:0.032821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2265' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.026787s ]
SELECT `id` FROM `stock` WHERE `id` <> 51413220 AND `partno` = '2265' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.022691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348210 [ RunTime:0.024035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57710403 LIMIT 5 [ RunTime:0.033183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57710403 ORDER BY `minOrder` ASC [ RunTime:0.040412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57710403 ORDER BY `unit` DESC [ RunTime:0.077811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57710403 LIMIT 2 [ RunTime:0.086190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57710403 ORDER BY `minOrder` ASC [ RunTime:0.055386s ]
select * from pdf where partno='22651' and brandshort='Brady Corporation' limit 1 [ RunTime:0.051306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22651' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.046409s ]
SELECT `id` FROM `stock` WHERE `id` <> 57710403 AND `partno` = '22651' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.031327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554219 [ RunTime:0.017380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57710399 LIMIT 5 [ RunTime:0.027630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57710399 ORDER BY `minOrder` ASC [ RunTime:0.031329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57710399 ORDER BY `unit` DESC [ RunTime:0.055640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57710399 LIMIT 2 [ RunTime:0.006463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57710399 ORDER BY `minOrder` ASC [ RunTime:0.015631s ]
select * from pdf where partno='22655' and brandshort='Brady Corporation' limit 1 [ RunTime:0.022721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22655' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.042271s ]
SELECT `id` FROM `stock` WHERE `id` <> 57710399 AND `partno` = '22655' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.028958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554216 [ RunTime:0.025725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57710374 LIMIT 5 [ RunTime:0.036640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57710374 ORDER BY `minOrder` ASC [ RunTime:0.018121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57710374 ORDER BY `unit` DESC [ RunTime:0.025704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57710374 LIMIT 2 [ RunTime:0.017314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57710374 ORDER BY `minOrder` ASC [ RunTime:0.001806s ]
select * from pdf where partno='22659' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22659' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.015322s ]
SELECT `id` FROM `stock` WHERE `id` <> 57710374 AND `partno` = '22659' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.011984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423563 [ RunTime:0.028061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57707467 LIMIT 5 [ RunTime:0.013223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57707467 ORDER BY `minOrder` ASC [ RunTime:0.039676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57707467 ORDER BY `unit` DESC [ RunTime:0.044219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57707467 LIMIT 2 [ RunTime:0.094462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57707467 ORDER BY `minOrder` ASC [ RunTime:0.047044s ]
select * from pdf where partno='22650' and brandshort='Brady Corporation' limit 1 [ RunTime:0.030358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22650' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.189882s ]
SELECT `id` FROM `stock` WHERE `id` <> 57707467 AND `partno` = '22650' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.080372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422210 [ RunTime:0.027766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57707444 LIMIT 5 [ RunTime:0.008374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57707444 ORDER BY `minOrder` ASC [ RunTime:0.049829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57707444 ORDER BY `unit` DESC [ RunTime:0.048980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57707444 LIMIT 2 [ RunTime:0.030434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57707444 ORDER BY `minOrder` ASC [ RunTime:0.045645s ]
select * from pdf where partno='22654' and brandshort='Brady Corporation' limit 1 [ RunTime:0.093311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22654' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.013232s ]
SELECT `id` FROM `stock` WHERE `id` <> 57707444 AND `partno` = '22654' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.051541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422200 [ RunTime:0.047313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57707417 LIMIT 5 [ RunTime:0.065706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57707417 ORDER BY `minOrder` ASC [ RunTime:0.025816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57707417 ORDER BY `unit` DESC [ RunTime:0.025535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57707417 LIMIT 2 [ RunTime:0.018069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57707417 ORDER BY `minOrder` ASC [ RunTime:0.012561s ]
select * from pdf where partno='22656' and brandshort='Brady Corporation' limit 1 [ RunTime:0.041221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22656' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.033637s ]
SELECT `id` FROM `stock` WHERE `id` <> 57707417 AND `partno` = '22656' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.022581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552306 [ RunTime:0.033191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57212212 LIMIT 5 [ RunTime:0.043760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57212212 ORDER BY `minOrder` ASC [ RunTime:0.031304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57212212 ORDER BY `unit` DESC [ RunTime:0.041407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57212212 LIMIT 2 [ RunTime:0.048252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57212212 ORDER BY `minOrder` ASC [ RunTime:0.015563s ]
select * from pdf where partno='22659' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.041023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22659' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.044543s ]
SELECT `id` FROM `stock` WHERE `id` <> 57212212 AND `partno` = '22659' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.030091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17267758 [ RunTime:0.046265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56601611 LIMIT 5 [ RunTime:0.013787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56601611 ORDER BY `minOrder` ASC [ RunTime:0.023097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56601611 ORDER BY `unit` DESC [ RunTime:0.017286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56601611 LIMIT 2 [ RunTime:0.024966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56601611 ORDER BY `minOrder` ASC [ RunTime:0.008772s ]
select * from pdf where partno='2265-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.067504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2265-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.007036s ]
SELECT `id` FROM `stock` WHERE `id` <> 56601611 AND `partno` = '2265-BLACK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.012780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56601080 LIMIT 5 [ RunTime:0.023509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56601080 ORDER BY `minOrder` ASC [ RunTime:0.024322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56601080 ORDER BY `unit` DESC [ RunTime:0.013627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56601080 LIMIT 2 [ RunTime:0.009635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56601080 ORDER BY `minOrder` ASC [ RunTime:0.036297s ]
select * from pdf where partno='2265' and brandshort='80/20, LLC' limit 1 [ RunTime:0.026832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2265' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.022926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56333970 LIMIT 5 [ RunTime:0.006819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56333970 ORDER BY `minOrder` ASC [ RunTime:0.045476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56333970 ORDER BY `unit` DESC [ RunTime:0.020597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56333970 LIMIT 2 [ RunTime:0.025302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56333970 ORDER BY `minOrder` ASC [ RunTime:0.013137s ]
select * from pdf where partno='22658.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.036758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22658.6' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.043083s ]
SELECT `id` FROM `stock` WHERE `id` <> 56333970 AND `partno` = '22658.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.041699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431780 [ RunTime:0.047098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56333969 LIMIT 5 [ RunTime:0.024422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56333969 ORDER BY `minOrder` ASC [ RunTime:0.006610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56333969 ORDER BY `unit` DESC [ RunTime:0.047525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56333969 LIMIT 2 [ RunTime:0.019445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56333969 ORDER BY `minOrder` ASC [ RunTime:0.003253s ]
select * from pdf where partno='22657.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.029773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22657.6' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.046612s ]
SELECT `id` FROM `stock` WHERE `id` <> 56333969 AND `partno` = '22657.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.040709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14418122 [ RunTime:0.007801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56333967 LIMIT 5 [ RunTime:0.011505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56333967 ORDER BY `minOrder` ASC [ RunTime:0.044254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56333967 ORDER BY `unit` DESC [ RunTime:0.080111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56333967 LIMIT 2 [ RunTime:0.072954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56333967 ORDER BY `minOrder` ASC [ RunTime:0.011729s ]
select * from pdf where partno='22659.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.102028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22659.6' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.038842s ]
SELECT `id` FROM `stock` WHERE `id` <> 56333967 AND `partno` = '22659.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.060698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14418120 [ RunTime:0.021398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56332560 LIMIT 5 [ RunTime:0.044662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56332560 ORDER BY `minOrder` ASC [ RunTime:0.007950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56332560 ORDER BY `unit` DESC [ RunTime:0.010558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56332560 LIMIT 2 [ RunTime:0.025253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56332560 ORDER BY `minOrder` ASC [ RunTime:0.015566s ]
select * from pdf where partno='22652.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.014828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22652.6' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.003878s ]
SELECT `id` FROM `stock` WHERE `id` <> 56332560 AND `partno` = '22652.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.029482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417602 [ RunTime:0.021157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56332559 LIMIT 5 [ RunTime:0.005527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56332559 ORDER BY `minOrder` ASC [ RunTime:0.043711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56332559 ORDER BY `unit` DESC [ RunTime:0.038186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56332559 LIMIT 2 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56332559 ORDER BY `minOrder` ASC [ RunTime:0.015200s ]
select * from pdf where partno='22650.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.008167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22650.6' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.017169s ]
SELECT `id` FROM `stock` WHERE `id` <> 56332559 AND `partno` = '22650.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.042629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417601 [ RunTime:0.022117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56332558 LIMIT 5 [ RunTime:0.021427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56332558 ORDER BY `minOrder` ASC [ RunTime:0.038104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56332558 ORDER BY `unit` DESC [ RunTime:0.070769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56332558 LIMIT 2 [ RunTime:0.029560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56332558 ORDER BY `minOrder` ASC [ RunTime:0.023586s ]
select * from pdf where partno='22656.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.052136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22656.6' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.101438s ]
SELECT `id` FROM `stock` WHERE `id` <> 56332558 AND `partno` = '22656.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.026638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431393 [ RunTime:0.084698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56332557 LIMIT 5 [ RunTime:0.033693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56332557 ORDER BY `minOrder` ASC [ RunTime:0.060317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56332557 ORDER BY `unit` DESC [ RunTime:0.051268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56332557 LIMIT 2 [ RunTime:0.039509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56332557 ORDER BY `minOrder` ASC [ RunTime:0.094674s ]
select * from pdf where partno='22654.6' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.104716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22654.6' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.042232s ]
SELECT `id` FROM `stock` WHERE `id` <> 56332557 AND `partno` = '22654.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.071965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431392 [ RunTime:0.043760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53810003 LIMIT 5 [ RunTime:0.025884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53810003 ORDER BY `minOrder` ASC [ RunTime:0.057810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53810003 ORDER BY `unit` DESC [ RunTime:0.032160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53810003 LIMIT 2 [ RunTime:0.012239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53810003 ORDER BY `minOrder` ASC [ RunTime:0.022073s ]
select * from pdf where partno='2265.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.016386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2265.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.023352s ]
SELECT `id` FROM `stock` WHERE `id` <> 53810003 AND `partno` = '2265.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.008474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53554111 LIMIT 5 [ RunTime:0.016022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53554111 ORDER BY `minOrder` ASC [ RunTime:0.018468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53554111 ORDER BY `unit` DESC [ RunTime:0.015359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53554111 LIMIT 2 [ RunTime:0.003050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53554111 ORDER BY `minOrder` ASC [ RunTime:0.002884s ]
select * from pdf where partno='226599-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '226599-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009186s ]
SELECT `id` FROM `stock` WHERE `id` <> 53554111 AND `partno` = '226599-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11675923 [ RunTime:0.007249s ]
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 '2265%' OR `brand` LIKE '2265%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003933s ]
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 '2265%' OR `brand` LIKE '2265%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013515s ]
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 '2265%' OR `brand` LIKE '2265%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019905s ]
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 '2265%' OR `brand` LIKE '2265%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005532s ]
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 '2265%' OR `brand` LIKE '2265%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004954s ]
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 '2265%' OR `brand` LIKE '2265%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007617s ]
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 '2265%' OR `brand` LIKE '2265%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009649s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2265%' OR `brand` LIKE '2265%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014939s ]