SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001478s ]
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=5026&search=1' [ RunTime:0.004395s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001325s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000596s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001218s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.004597s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001889s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008481s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000977s ]
SELECT * FROM `stock_search` WHERE `partno` = '5026' LIMIT 1 [ RunTime:0.009201s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-19 02:16:03' WHERE `partno` = '5026' [ RunTime:0.011299s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002939s ]
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 '5026%' OR `brand` LIKE '5026%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052762s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19816392 LIMIT 5 [ RunTime:0.019258s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19816392 ORDER BY `minOrder` ASC [ RunTime:0.031777s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19816392 ORDER BY `unit` DESC [ RunTime:0.013892s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19816392 LIMIT 2 [ RunTime:0.011790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19816392 ORDER BY `minOrder` ASC [ RunTime:0.008953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313619 LIMIT 5 [ RunTime:0.030700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313619 ORDER BY `minOrder` ASC [ RunTime:0.025976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17313619 ORDER BY `unit` DESC [ RunTime:0.027225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17313619 LIMIT 2 [ RunTime:0.025804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17313619 ORDER BY `minOrder` ASC [ RunTime:0.017312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371279 LIMIT 5 [ RunTime:0.024774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371279 ORDER BY `minOrder` ASC [ RunTime:0.012281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17371279 ORDER BY `unit` DESC [ RunTime:0.044838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17371279 LIMIT 2 [ RunTime:0.032160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17371279 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077385 LIMIT 5 [ RunTime:0.034321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077385 ORDER BY `minOrder` ASC [ RunTime:0.053720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077385 ORDER BY `unit` DESC [ RunTime:0.019218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077385 LIMIT 2 [ RunTime:0.070540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077385 ORDER BY `minOrder` ASC [ RunTime:0.034693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077384 LIMIT 5 [ RunTime:0.024530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077384 ORDER BY `minOrder` ASC [ RunTime:0.035760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20077384 ORDER BY `unit` DESC [ RunTime:0.025625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20077384 LIMIT 2 [ RunTime:0.054571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20077384 ORDER BY `minOrder` ASC [ RunTime:0.009759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19671513 LIMIT 5 [ RunTime:0.029498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671513 ORDER BY `minOrder` ASC [ RunTime:0.067182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19671513 ORDER BY `unit` DESC [ RunTime:0.041138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19671513 LIMIT 2 [ RunTime:0.055031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19671513 ORDER BY `minOrder` ASC [ RunTime:0.019064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669452 LIMIT 5 [ RunTime:0.016463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669452 ORDER BY `minOrder` ASC [ RunTime:0.029201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19669452 ORDER BY `unit` DESC [ RunTime:0.040384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19669452 LIMIT 2 [ RunTime:0.039600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669452 ORDER BY `minOrder` ASC [ RunTime:0.003784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19669449 LIMIT 5 [ RunTime:0.032425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669449 ORDER BY `minOrder` ASC [ RunTime:0.009465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19669449 ORDER BY `unit` DESC [ RunTime:0.012153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19669449 LIMIT 2 [ RunTime:0.009654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19669449 ORDER BY `minOrder` ASC [ RunTime:0.018519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18708790 LIMIT 5 [ RunTime:0.013308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18708790 ORDER BY `minOrder` ASC [ RunTime:0.002081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18708790 ORDER BY `unit` DESC [ RunTime:0.012565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18708790 LIMIT 2 [ RunTime:0.006087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18708790 ORDER BY `minOrder` ASC [ RunTime:0.008682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17387114 LIMIT 5 [ RunTime:0.014539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17387114 ORDER BY `minOrder` ASC [ RunTime:0.027784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17387114 ORDER BY `unit` DESC [ RunTime:0.016049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17387114 LIMIT 2 [ RunTime:0.015765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17387114 ORDER BY `minOrder` ASC [ RunTime:0.000570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16414470 LIMIT 5 [ RunTime:0.009342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16414470 ORDER BY `minOrder` ASC [ RunTime:0.002812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16414470 ORDER BY `unit` DESC [ RunTime:0.036771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16414470 LIMIT 2 [ RunTime:0.008982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16414470 ORDER BY `minOrder` ASC [ RunTime:0.008371s ]
select * from pdf where partno='5026D1424-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.017414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16414138 LIMIT 5 [ RunTime:0.026445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16414138 ORDER BY `minOrder` ASC [ RunTime:0.008436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16414138 ORDER BY `unit` DESC [ RunTime:0.009602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16414138 LIMIT 2 [ RunTime:0.008692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16414138 ORDER BY `minOrder` ASC [ RunTime:0.012497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16413896 LIMIT 5 [ RunTime:0.002709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16413896 ORDER BY `minOrder` ASC [ RunTime:0.002383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16413896 ORDER BY `unit` DESC [ RunTime:0.000551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16413896 LIMIT 2 [ RunTime:0.007531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16413896 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='5026D5314-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.003018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16413749 LIMIT 5 [ RunTime:0.007681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16413749 ORDER BY `minOrder` ASC [ RunTime:0.013343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16413749 ORDER BY `unit` DESC [ RunTime:0.002523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16413749 LIMIT 2 [ RunTime:0.010127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16413749 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='5026A1311-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.001517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16413673 LIMIT 5 [ RunTime:0.001405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16413673 ORDER BY `minOrder` ASC [ RunTime:0.003125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16413673 ORDER BY `unit` DESC [ RunTime:0.006904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16413673 LIMIT 2 [ RunTime:0.003029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16413673 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
select * from pdf where partno='5026A1137-9' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.007152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16194701 LIMIT 5 [ RunTime:0.018403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194701 ORDER BY `minOrder` ASC [ RunTime:0.004615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16194701 ORDER BY `unit` DESC [ RunTime:0.002667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16194701 LIMIT 2 [ RunTime:0.009595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16194701 ORDER BY `minOrder` ASC [ RunTime:0.010561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454937 LIMIT 5 [ RunTime:0.005854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454937 ORDER BY `minOrder` ASC [ RunTime:0.007403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454937 ORDER BY `unit` DESC [ RunTime:0.007586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454937 LIMIT 2 [ RunTime:0.014972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454937 ORDER BY `minOrder` ASC [ RunTime:0.034409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14392915 LIMIT 5 [ RunTime:0.020084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14392915 ORDER BY `minOrder` ASC [ RunTime:0.010741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14392915 ORDER BY `unit` DESC [ RunTime:0.028249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14392915 LIMIT 2 [ RunTime:0.005017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14392915 ORDER BY `minOrder` ASC [ RunTime:0.004228s ]
select * from pdf where partno='5026A1318-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379928 LIMIT 5 [ RunTime:0.005931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379928 ORDER BY `minOrder` ASC [ RunTime:0.013161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14379928 ORDER BY `unit` DESC [ RunTime:0.010650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14379928 LIMIT 2 [ RunTime:0.008631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379928 ORDER BY `minOrder` ASC [ RunTime:0.010255s ]
select * from pdf where partno='5026C SL199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.031201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379927 LIMIT 5 [ RunTime:0.010384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379927 ORDER BY `minOrder` ASC [ RunTime:0.020048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14379927 ORDER BY `unit` DESC [ RunTime:0.015804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14379927 LIMIT 2 [ RunTime:0.009239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379927 ORDER BY `minOrder` ASC [ RunTime:0.015814s ]
select * from pdf where partno='5026C BK199' and brandshort='Alpha Wire' limit 1 [ RunTime:0.026130s ]
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 '5026%' OR `brand` LIKE '5026%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32271401 LIMIT 5 [ RunTime:0.027243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32271401 ORDER BY `minOrder` ASC [ RunTime:0.068963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32271401 ORDER BY `unit` DESC [ RunTime:0.022081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32271401 LIMIT 2 [ RunTime:0.019563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32271401 ORDER BY `minOrder` ASC [ RunTime:0.003244s ]
select * from pdf where partno='50260002-521' and brandshort='amphenol audio' limit 1 [ RunTime:0.016484s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50260002-521' OR `brand` LIKE 'amphenol audio%' ) ) LIMIT 1 [ RunTime:0.050119s ]
SELECT `id` FROM `stock` WHERE `id` <> 32271401 AND `partno` = '50260002-521' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol audio%' ) [ RunTime:0.037339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20077384 [ RunTime:0.000426s ]
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 '5026%' OR `brand` LIKE '5026%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59347078 LIMIT 5 [ RunTime:0.012450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347078 ORDER BY `minOrder` ASC [ RunTime:0.027198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59347078 ORDER BY `unit` DESC [ RunTime:0.034469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59347078 LIMIT 2 [ RunTime:0.006122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347078 ORDER BY `minOrder` ASC [ RunTime:0.011279s ]
select * from pdf where partno='5026' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.026347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.018112s ]
SELECT `id` FROM `stock` WHERE `id` <> 59347078 AND `partno` = '5026' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.050219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17313619 [ RunTime:0.013888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60374969 LIMIT 5 [ RunTime:0.037169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374969 ORDER BY `minOrder` ASC [ RunTime:0.008379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60374969 ORDER BY `unit` DESC [ RunTime:0.017450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60374969 LIMIT 2 [ RunTime:0.037969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374969 ORDER BY `minOrder` ASC [ RunTime:0.010338s ]
select * from pdf where partno='50260003-521' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.022830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50260003-521' OR `brand` LIKE 'Amphenol Sine Systems Corp%' ) ) LIMIT 1 [ RunTime:0.013661s ]
SELECT `id` FROM `stock` WHERE `id` <> 60374969 AND `partno` = '50260003-521' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sine systems corp%' ) [ RunTime:0.025469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17371279 [ RunTime:0.028608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64812998 LIMIT 5 [ RunTime:0.089235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812998 ORDER BY `minOrder` ASC [ RunTime:0.020145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64812998 ORDER BY `unit` DESC [ RunTime:0.088973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64812998 LIMIT 2 [ RunTime:0.055158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812998 ORDER BY `minOrder` ASC [ RunTime:0.005245s ]
select * from pdf where partno='50265200SP' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.020512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50265200SP' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.049038s ]
SELECT `id` FROM `stock` WHERE `id` <> 64812998 AND `partno` = '50265200SP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.026623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12187080 [ RunTime:0.057510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521268 LIMIT 5 [ RunTime:0.026600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521268 ORDER BY `minOrder` ASC [ RunTime:0.032134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521268 ORDER BY `unit` DESC [ RunTime:0.063972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521268 LIMIT 2 [ RunTime:0.064426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521268 ORDER BY `minOrder` ASC [ RunTime:0.016967s ]
select * from pdf where partno='50265' and brandshort='Brady Corporation' limit 1 [ RunTime:0.025629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50265' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.048749s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521268 AND `partno` = '50265' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.104638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458158 [ RunTime:0.045327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521267 LIMIT 5 [ RunTime:0.078960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521267 ORDER BY `minOrder` ASC [ RunTime:0.046372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521267 ORDER BY `unit` DESC [ RunTime:0.050032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521267 LIMIT 2 [ RunTime:0.037078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521267 ORDER BY `minOrder` ASC [ RunTime:0.036169s ]
select * from pdf where partno='50266' and brandshort='Brady Corporation' limit 1 [ RunTime:0.036027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50266' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.035573s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521267 AND `partno` = '50266' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.085655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458157 [ RunTime:0.074512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520503 LIMIT 5 [ RunTime:0.019805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520503 ORDER BY `minOrder` ASC [ RunTime:0.047672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520503 ORDER BY `unit` DESC [ RunTime:0.069535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520503 LIMIT 2 [ RunTime:0.014969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520503 ORDER BY `minOrder` ASC [ RunTime:0.008245s ]
select * from pdf where partno='50261' and brandshort='Brady Corporation' limit 1 [ RunTime:0.069322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50261' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.070883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64429093 LIMIT 5 [ RunTime:0.049077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64429093 ORDER BY `minOrder` ASC [ RunTime:0.068157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64429093 ORDER BY `unit` DESC [ RunTime:0.122446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64429093 LIMIT 2 [ RunTime:0.040065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64429093 ORDER BY `minOrder` ASC [ RunTime:0.016376s ]
select * from pdf where partno='5026' and brandshort='3M' limit 1 [ RunTime:0.025536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.074466s ]
SELECT `id` FROM `stock` WHERE `id` <> 64429093 AND `partno` = '5026' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.042773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18708790 [ RunTime:0.024372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63067260 LIMIT 5 [ RunTime:0.017798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63067260 ORDER BY `minOrder` ASC [ RunTime:0.044844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63067260 ORDER BY `unit` DESC [ RunTime:0.028740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63067260 LIMIT 2 [ RunTime:0.047790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63067260 ORDER BY `minOrder` ASC [ RunTime:0.022096s ]
select * from pdf where partno='5026R042A-9X' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.035167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026R042A-9X' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.055016s ]
SELECT `id` FROM `stock` WHERE `id` <> 63067260 AND `partno` = '5026R042A-9X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.052338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16414138 [ RunTime:0.055377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066848 LIMIT 5 [ RunTime:0.022200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066848 ORDER BY `minOrder` ASC [ RunTime:0.052955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066848 ORDER BY `unit` DESC [ RunTime:0.046642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066848 LIMIT 2 [ RunTime:0.039321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066848 ORDER BY `minOrder` ASC [ RunTime:0.019626s ]
select * from pdf where partno='5026A1317-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026A1317-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.038136s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066848 AND `partno` = '5026A1317-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.072777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066674 LIMIT 5 [ RunTime:0.019683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066674 ORDER BY `minOrder` ASC [ RunTime:0.029646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066674 ORDER BY `unit` DESC [ RunTime:0.021779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066674 LIMIT 2 [ RunTime:0.061483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066674 ORDER BY `minOrder` ASC [ RunTime:0.014718s ]
select * from pdf where partno='5026D5314-9' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.010848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026D5314-9' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.009430s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066674 AND `partno` = '5026D5314-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.012369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13520455 [ RunTime:0.034939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066654 LIMIT 5 [ RunTime:0.022434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066654 ORDER BY `minOrder` ASC [ RunTime:0.015048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066654 ORDER BY `unit` DESC [ RunTime:0.056846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066654 LIMIT 2 [ RunTime:0.039418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066654 ORDER BY `minOrder` ASC [ RunTime:0.009491s ]
select * from pdf where partno='5026D5314-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.013109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026D5314-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.013148s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066654 AND `partno` = '5026D5314-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.011185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16413896 [ RunTime:0.034559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066622 LIMIT 5 [ RunTime:0.030520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066622 ORDER BY `minOrder` ASC [ RunTime:0.023860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066622 ORDER BY `unit` DESC [ RunTime:0.022058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066622 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066622 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
select * from pdf where partno='5026A1317-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.002555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026A1317-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.019220s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066622 AND `partno` = '5026A1317-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.017702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13520875 [ RunTime:0.007712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066554 LIMIT 5 [ RunTime:0.017205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066554 ORDER BY `minOrder` ASC [ RunTime:0.005702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066554 ORDER BY `unit` DESC [ RunTime:0.023823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066554 LIMIT 2 [ RunTime:0.003910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066554 ORDER BY `minOrder` ASC [ RunTime:0.011037s ]
select * from pdf where partno='5026A1664-9' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.004042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026A1664-9' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.000862s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066554 AND `partno` = '5026A1664-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.000914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13520407 [ RunTime:0.000992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066341 LIMIT 5 [ RunTime:0.013617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066341 ORDER BY `minOrder` ASC [ RunTime:0.005971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066341 ORDER BY `unit` DESC [ RunTime:0.022834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066341 LIMIT 2 [ RunTime:0.004064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066341 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='5026A1137-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026A1137-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007742s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066341 AND `partno` = '5026A1137-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.008609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066300 LIMIT 5 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066300 ORDER BY `minOrder` ASC [ RunTime:0.002009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066300 ORDER BY `unit` DESC [ RunTime:0.009211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066300 LIMIT 2 [ RunTime:0.012396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066300 ORDER BY `minOrder` ASC [ RunTime:0.001939s ]
select * from pdf where partno='5026A1311-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.000639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026A1311-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.001988s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066300 AND `partno` = '5026A1311-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.006991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16413749 [ RunTime:0.009836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066259 LIMIT 5 [ RunTime:0.001963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066259 ORDER BY `minOrder` ASC [ RunTime:0.010824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066259 ORDER BY `unit` DESC [ RunTime:0.000685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066259 LIMIT 2 [ RunTime:0.004342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066259 ORDER BY `minOrder` ASC [ RunTime:0.001174s ]
select * from pdf where partno='5026A1314-9' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.008208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026A1314-9' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.013336s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066259 AND `partno` = '5026A1314-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.004780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13520312 [ RunTime:0.013836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066249 LIMIT 5 [ RunTime:0.010734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066249 ORDER BY `minOrder` ASC [ RunTime:0.015866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066249 ORDER BY `unit` DESC [ RunTime:0.012108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066249 LIMIT 2 [ RunTime:0.027867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066249 ORDER BY `minOrder` ASC [ RunTime:0.002361s ]
select * from pdf where partno='5026A1314-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026A1314-0' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.032092s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066249 AND `partno` = '5026A1314-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.039527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13520234 [ RunTime:0.024307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066200 LIMIT 5 [ RunTime:0.006910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066200 ORDER BY `minOrder` ASC [ RunTime:0.002217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066200 ORDER BY `unit` DESC [ RunTime:0.022214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066200 LIMIT 2 [ RunTime:0.012281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066200 ORDER BY `minOrder` ASC [ RunTime:0.002659s ]
select * from pdf where partno='5026A1334-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.019109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026A1334-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.007225s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066200 AND `partno` = '5026A1334-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.013333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13520297 [ RunTime:0.004444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066098 LIMIT 5 [ RunTime:0.006650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066098 ORDER BY `minOrder` ASC [ RunTime:0.010359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066098 ORDER BY `unit` DESC [ RunTime:0.014828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066098 LIMIT 2 [ RunTime:0.023022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066098 ORDER BY `minOrder` ASC [ RunTime:0.020904s ]
select * from pdf where partno='5026E1111-0' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.009309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026E1111-0' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.024500s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066098 AND `partno` = '5026E1111-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.029598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13520264 [ RunTime:0.017759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066076 LIMIT 5 [ RunTime:0.003384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066076 ORDER BY `minOrder` ASC [ RunTime:0.005123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066076 ORDER BY `unit` DESC [ RunTime:0.009101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066076 LIMIT 2 [ RunTime:0.037695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066076 ORDER BY `minOrder` ASC [ RunTime:0.004497s ]
select * from pdf where partno='5026A1311-9' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.029482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5026A1311-9' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.015900s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066076 AND `partno` = '5026A1311-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.005881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13520216 [ RunTime:0.035444s ]
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 '5026%' OR `brand` LIKE '5026%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014105s ]
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 '5026%' OR `brand` LIKE '5026%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030515s ]
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 '5026%' OR `brand` LIKE '5026%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027638s ]
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 '5026%' OR `brand` LIKE '5026%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034547s ]
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 '5026%' OR `brand` LIKE '5026%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029479s ]
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 '5026%' OR `brand` LIKE '5026%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031342s ]
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 '5026%' OR `brand` LIKE '5026%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013728s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5026%' OR `brand` LIKE '5026%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015931s ]