SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.010283s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.134' , `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=4222&search=1' [ RunTime:0.009046s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002046s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011531s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003453s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.134' ) [ RunTime:0.004606s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001498s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001842s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001358s ]
SELECT * FROM `stock_search` WHERE `partno` = '4222' LIMIT 1 [ RunTime:0.022470s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-12 04:03:41' WHERE `partno` = '4222' [ RunTime:0.003981s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003622s ]
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 '4222%' OR `brand` LIKE '4222%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026748s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18961623 LIMIT 5 [ RunTime:0.005332s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961623 ORDER BY `minOrder` ASC [ RunTime:0.001168s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18961623 ORDER BY `unit` DESC [ RunTime:0.001709s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18961623 LIMIT 2 [ RunTime:0.006035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961623 ORDER BY `minOrder` ASC [ RunTime:0.002448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845315 LIMIT 5 [ RunTime:0.004286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845315 ORDER BY `minOrder` ASC [ RunTime:0.003177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845315 ORDER BY `unit` DESC [ RunTime:0.006246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845315 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845315 ORDER BY `minOrder` ASC [ RunTime:0.003222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845314 LIMIT 5 [ RunTime:0.003575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845314 ORDER BY `minOrder` ASC [ RunTime:0.014701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845314 ORDER BY `unit` DESC [ RunTime:0.000563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845314 LIMIT 2 [ RunTime:0.003268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845314 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405597 LIMIT 5 [ RunTime:0.005926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405597 ORDER BY `minOrder` ASC [ RunTime:0.004444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16405597 ORDER BY `unit` DESC [ RunTime:0.004649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16405597 LIMIT 2 [ RunTime:0.010428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405597 ORDER BY `minOrder` ASC [ RunTime:0.002100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405596 LIMIT 5 [ RunTime:0.004327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405596 ORDER BY `minOrder` ASC [ RunTime:0.003015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16405596 ORDER BY `unit` DESC [ RunTime:0.001666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16405596 LIMIT 2 [ RunTime:0.005377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405596 ORDER BY `minOrder` ASC [ RunTime:0.012606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405595 LIMIT 5 [ RunTime:0.010806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405595 ORDER BY `minOrder` ASC [ RunTime:0.015929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16405595 ORDER BY `unit` DESC [ RunTime:0.000731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16405595 LIMIT 2 [ RunTime:0.001767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405595 ORDER BY `minOrder` ASC [ RunTime:0.001251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405509 LIMIT 5 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405509 ORDER BY `minOrder` ASC [ RunTime:0.006158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16405509 ORDER BY `unit` DESC [ RunTime:0.015253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16405509 LIMIT 2 [ RunTime:0.015267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405509 ORDER BY `minOrder` ASC [ RunTime:0.007046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405508 LIMIT 5 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405508 ORDER BY `minOrder` ASC [ RunTime:0.004747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16405508 ORDER BY `unit` DESC [ RunTime:0.004772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16405508 LIMIT 2 [ RunTime:0.007151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405508 ORDER BY `minOrder` ASC [ RunTime:0.011368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405507 LIMIT 5 [ RunTime:0.000877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405507 ORDER BY `minOrder` ASC [ RunTime:0.000932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16405507 ORDER BY `unit` DESC [ RunTime:0.007396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16405507 LIMIT 2 [ RunTime:0.015453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405507 ORDER BY `minOrder` ASC [ RunTime:0.002204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405506 LIMIT 5 [ RunTime:0.005863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405506 ORDER BY `minOrder` ASC [ RunTime:0.003119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16405506 ORDER BY `unit` DESC [ RunTime:0.025044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16405506 LIMIT 2 [ RunTime:0.012955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405506 ORDER BY `minOrder` ASC [ RunTime:0.017493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405440 LIMIT 5 [ RunTime:0.002663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405440 ORDER BY `minOrder` ASC [ RunTime:0.000894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16405440 ORDER BY `unit` DESC [ RunTime:0.018264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16405440 LIMIT 2 [ RunTime:0.011022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16405440 ORDER BY `minOrder` ASC [ RunTime:0.005540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15238059 LIMIT 5 [ RunTime:0.014664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15238059 ORDER BY `minOrder` ASC [ RunTime:0.025572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15238059 ORDER BY `unit` DESC [ RunTime:0.022632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15238059 LIMIT 2 [ RunTime:0.020396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15238059 ORDER BY `minOrder` ASC [ RunTime:0.003760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396646 LIMIT 5 [ RunTime:0.001776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396646 ORDER BY `minOrder` ASC [ RunTime:0.007258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14396646 ORDER BY `unit` DESC [ RunTime:0.016269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14396646 LIMIT 2 [ RunTime:0.008766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14396646 ORDER BY `minOrder` ASC [ RunTime:0.001822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393816 LIMIT 5 [ RunTime:0.014815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393816 ORDER BY `minOrder` ASC [ RunTime:0.002678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14393816 ORDER BY `unit` DESC [ RunTime:0.003858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14393816 LIMIT 2 [ RunTime:0.007904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393816 ORDER BY `minOrder` ASC [ RunTime:0.004811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393812 LIMIT 5 [ RunTime:0.003266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393812 ORDER BY `minOrder` ASC [ RunTime:0.010463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14393812 ORDER BY `unit` DESC [ RunTime:0.021834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14393812 LIMIT 2 [ RunTime:0.000739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393812 ORDER BY `minOrder` ASC [ RunTime:0.002547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368991 LIMIT 5 [ RunTime:0.003729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368991 ORDER BY `minOrder` ASC [ RunTime:0.004929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14368991 ORDER BY `unit` DESC [ RunTime:0.002964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14368991 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368991 ORDER BY `minOrder` ASC [ RunTime:0.001802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368990 LIMIT 5 [ RunTime:0.003455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368990 ORDER BY `minOrder` ASC [ RunTime:0.011636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14368990 ORDER BY `unit` DESC [ RunTime:0.014039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14368990 LIMIT 2 [ RunTime:0.017157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368990 ORDER BY `minOrder` ASC [ RunTime:0.005387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368989 LIMIT 5 [ RunTime:0.004504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368989 ORDER BY `minOrder` ASC [ RunTime:0.011334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14368989 ORDER BY `unit` DESC [ RunTime:0.022127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14368989 LIMIT 2 [ RunTime:0.005111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368989 ORDER BY `minOrder` ASC [ RunTime:0.008822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368988 LIMIT 5 [ RunTime:0.002630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368988 ORDER BY `minOrder` ASC [ RunTime:0.009731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14368988 ORDER BY `unit` DESC [ RunTime:0.003789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14368988 LIMIT 2 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368988 ORDER BY `minOrder` ASC [ RunTime:0.003114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368987 LIMIT 5 [ RunTime:0.002338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368987 ORDER BY `minOrder` ASC [ RunTime:0.002674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14368987 ORDER BY `unit` DESC [ RunTime:0.015785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14368987 LIMIT 2 [ RunTime:0.024272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368987 ORDER BY `minOrder` ASC [ RunTime:0.009577s ]
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 '4222%' OR `brand` LIKE '4222%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036214s ]
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 '4222%' OR `brand` LIKE '4222%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64516083 LIMIT 5 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64516083 ORDER BY `minOrder` ASC [ RunTime:0.001174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64516083 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64516083 LIMIT 2 [ RunTime:0.002517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64516083 ORDER BY `minOrder` ASC [ RunTime:0.008146s ]
select * from pdf where partno='42221' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008905s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42221' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004349s ]
SELECT `id` FROM `stock` WHERE `id` <> 64516083 AND `partno` = '42221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.007027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396646 [ RunTime:0.002497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508736 LIMIT 5 [ RunTime:0.010015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508736 ORDER BY `minOrder` ASC [ RunTime:0.006296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508736 ORDER BY `unit` DESC [ RunTime:0.010295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508736 LIMIT 2 [ RunTime:0.011273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508736 ORDER BY `minOrder` ASC [ RunTime:0.007123s ]
select * from pdf where partno='42229' and brandshort='Brady Corporation' limit 1 [ RunTime:0.007819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42229' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.018449s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508736 AND `partno` = '42229' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.018671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393816 [ RunTime:0.007070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64508728 LIMIT 5 [ RunTime:0.003242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508728 ORDER BY `minOrder` ASC [ RunTime:0.027454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64508728 ORDER BY `unit` DESC [ RunTime:0.004124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64508728 LIMIT 2 [ RunTime:0.016077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64508728 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='42228' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '42228' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.014218s ]
SELECT `id` FROM `stock` WHERE `id` <> 64508728 AND `partno` = '42228' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.009684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393812 [ RunTime:0.002111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64147028 LIMIT 5 [ RunTime:0.005853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64147028 ORDER BY `minOrder` ASC [ RunTime:0.005626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64147028 ORDER BY `unit` DESC [ RunTime:0.002714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64147028 LIMIT 2 [ RunTime:0.008024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64147028 ORDER BY `minOrder` ASC [ RunTime:0.002700s ]
select * from pdf where partno='4222' and brandshort='Delevan' limit 1 [ RunTime:0.007398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4222' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.002342s ]
SELECT `id` FROM `stock` WHERE `id` <> 64147028 AND `partno` = '4222' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.000587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11940450 [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64145575 LIMIT 5 [ RunTime:0.003964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64145575 ORDER BY `minOrder` ASC [ RunTime:0.007076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64145575 ORDER BY `unit` DESC [ RunTime:0.001023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64145575 LIMIT 2 [ RunTime:0.002135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64145575 ORDER BY `minOrder` ASC [ RunTime:0.005710s ]
select * from pdf where partno='4222R' and brandshort='Delevan' limit 1 [ RunTime:0.005329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4222R' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.011830s ]
SELECT `id` FROM `stock` WHERE `id` <> 64145575 AND `partno` = '4222R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.006613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11940188 [ RunTime:0.005491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63129204 LIMIT 5 [ RunTime:0.006114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63129204 ORDER BY `minOrder` ASC [ RunTime:0.014466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63129204 ORDER BY `unit` DESC [ RunTime:0.012570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63129204 LIMIT 2 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63129204 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='4222F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4222F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.012566s ]
SELECT `id` FROM `stock` WHERE `id` <> 63129204 AND `partno` = '4222F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.020014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63129037 LIMIT 5 [ RunTime:0.014805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63129037 ORDER BY `minOrder` ASC [ RunTime:0.010502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63129037 ORDER BY `unit` DESC [ RunTime:0.006419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63129037 LIMIT 2 [ RunTime:0.000983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63129037 ORDER BY `minOrder` ASC [ RunTime:0.012144s ]
select * from pdf where partno='4222' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.010936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4222' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.007879s ]
SELECT `id` FROM `stock` WHERE `id` <> 63129037 AND `partno` = '4222' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.001942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063171 LIMIT 5 [ RunTime:0.001301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063171 ORDER BY `minOrder` ASC [ RunTime:0.019838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063171 ORDER BY `unit` DESC [ RunTime:0.015707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063171 LIMIT 2 [ RunTime:0.014709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063171 ORDER BY `minOrder` ASC [ RunTime:0.009373s ]
select * from pdf where partno='422207 GY013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 GY013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.019388s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063171 AND `partno` = '422207 GY013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.004427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405597 [ RunTime:0.008656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063170 LIMIT 5 [ RunTime:0.002913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063170 ORDER BY `minOrder` ASC [ RunTime:0.000669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063170 ORDER BY `unit` DESC [ RunTime:0.004561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063170 LIMIT 2 [ RunTime:0.006998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063170 ORDER BY `minOrder` ASC [ RunTime:0.007896s ]
select * from pdf where partno='422207 GV013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.015886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 GV013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.007705s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063170 AND `partno` = '422207 GV013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405596 [ RunTime:0.003049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063169 LIMIT 5 [ RunTime:0.025584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063169 ORDER BY `minOrder` ASC [ RunTime:0.002170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063169 ORDER BY `unit` DESC [ RunTime:0.004291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063169 LIMIT 2 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063169 ORDER BY `minOrder` ASC [ RunTime:0.002725s ]
select * from pdf where partno='422207 GU013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 GU013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.005309s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063169 AND `partno` = '422207 GU013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.006200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405595 [ RunTime:0.002276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063036 LIMIT 5 [ RunTime:0.015033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063036 ORDER BY `minOrder` ASC [ RunTime:0.011043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063036 ORDER BY `unit` DESC [ RunTime:0.001437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063036 LIMIT 2 [ RunTime:0.011372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063036 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
select * from pdf where partno='422207 YL013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 YL013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.008032s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063036 AND `partno` = '422207 YL013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.012345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368991 [ RunTime:0.002355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063035 LIMIT 5 [ RunTime:0.011681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063035 ORDER BY `minOrder` ASC [ RunTime:0.015317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063035 ORDER BY `unit` DESC [ RunTime:0.036578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063035 LIMIT 2 [ RunTime:0.028572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063035 ORDER BY `minOrder` ASC [ RunTime:0.013056s ]
select * from pdf where partno='422207 WH013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.024279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 WH013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.006547s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063035 AND `partno` = '422207 WH013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.019429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368990 [ RunTime:0.017579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063034 LIMIT 5 [ RunTime:0.010718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063034 ORDER BY `minOrder` ASC [ RunTime:0.021605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063034 ORDER BY `unit` DESC [ RunTime:0.032946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063034 LIMIT 2 [ RunTime:0.003190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063034 ORDER BY `minOrder` ASC [ RunTime:0.004355s ]
select * from pdf where partno='422207 VI013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.005733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 VI013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.030555s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063034 AND `partno` = '422207 VI013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.017264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368989 [ RunTime:0.016875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063033 LIMIT 5 [ RunTime:0.050553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063033 ORDER BY `minOrder` ASC [ RunTime:0.013106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063033 ORDER BY `unit` DESC [ RunTime:0.008729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063033 LIMIT 2 [ RunTime:0.011344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063033 ORDER BY `minOrder` ASC [ RunTime:0.022512s ]
select * from pdf where partno='422207 SL013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 SL013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.014931s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063033 AND `partno` = '422207 SL013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.023171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368988 [ RunTime:0.016198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063032 LIMIT 5 [ RunTime:0.022130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063032 ORDER BY `minOrder` ASC [ RunTime:0.010532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063032 ORDER BY `unit` DESC [ RunTime:0.017942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063032 LIMIT 2 [ RunTime:0.022543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063032 ORDER BY `minOrder` ASC [ RunTime:0.007393s ]
select * from pdf where partno='422207 RD013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 RD013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.014263s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063032 AND `partno` = '422207 RD013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.029798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368987 [ RunTime:0.012966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063031 LIMIT 5 [ RunTime:0.013723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063031 ORDER BY `minOrder` ASC [ RunTime:0.000867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063031 ORDER BY `unit` DESC [ RunTime:0.007013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063031 LIMIT 2 [ RunTime:0.017014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063031 ORDER BY `minOrder` ASC [ RunTime:0.008582s ]
select * from pdf where partno='422207 OR013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 OR013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.005840s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063031 AND `partno` = '422207 OR013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405509 [ RunTime:0.015599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063030 LIMIT 5 [ RunTime:0.002074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063030 ORDER BY `minOrder` ASC [ RunTime:0.000777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063030 ORDER BY `unit` DESC [ RunTime:0.002189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063030 LIMIT 2 [ RunTime:0.001008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063030 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='422207 GR013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 GR013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.006751s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063030 AND `partno` = '422207 GR013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.005510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405508 [ RunTime:0.000904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063029 LIMIT 5 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063029 ORDER BY `minOrder` ASC [ RunTime:0.001261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063029 ORDER BY `unit` DESC [ RunTime:0.006108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063029 LIMIT 2 [ RunTime:0.004184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063029 ORDER BY `minOrder` ASC [ RunTime:0.003652s ]
select * from pdf where partno='422207 BR013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 BR013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001369s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063029 AND `partno` = '422207 BR013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405507 [ RunTime:0.000670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63063028 LIMIT 5 [ RunTime:0.001057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063028 ORDER BY `minOrder` ASC [ RunTime:0.009635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63063028 ORDER BY `unit` DESC [ RunTime:0.002655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63063028 LIMIT 2 [ RunTime:0.008684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63063028 ORDER BY `minOrder` ASC [ RunTime:0.002148s ]
select * from pdf where partno='422207 BK013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422207 BK013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.003595s ]
SELECT `id` FROM `stock` WHERE `id` <> 63063028 AND `partno` = '422207 BK013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16405506 [ RunTime:0.000848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63062825 LIMIT 5 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63062825 ORDER BY `minOrder` ASC [ RunTime:0.000973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63062825 ORDER BY `unit` DESC [ RunTime:0.003128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63062825 LIMIT 2 [ RunTime:0.006861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63062825 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
select * from pdf where partno='422201 WH013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '422201 WH013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000906s ]
SELECT `id` FROM `stock` WHERE `id` <> 63062825 AND `partno` = '422201 WH013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368906 [ RunTime:0.007921s ]
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 '4222%' OR `brand` LIKE '4222%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006252s ]
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 '4222%' OR `brand` LIKE '4222%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013444s ]
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 '4222%' OR `brand` LIKE '4222%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001955s ]
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 '4222%' OR `brand` LIKE '4222%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002358s ]
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 '4222%' OR `brand` LIKE '4222%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001380s ]
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 '4222%' OR `brand` LIKE '4222%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002936s ]
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 '4222%' OR `brand` LIKE '4222%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001576s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4222%' OR `brand` LIKE '4222%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015970s ]