SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002564s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.58' , `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=60355&search=1' [ RunTime:0.005364s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002369s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000702s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002411s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.58' ) [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002580s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001184s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002212s ]
SELECT * FROM `stock_search` WHERE `partno` = '60355' LIMIT 1 [ RunTime:0.005453s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-07 02:07:17' WHERE `partno` = '60355' [ RunTime:0.005342s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002984s ]
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 '60355%' OR `brand` LIKE '60355%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008583s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200599 LIMIT 5 [ RunTime:0.006952s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200599 ORDER BY `minOrder` ASC [ RunTime:0.002333s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200599 ORDER BY `unit` DESC [ RunTime:0.012372s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200599 LIMIT 2 [ RunTime:0.006099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200599 ORDER BY `minOrder` ASC [ RunTime:0.000720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19582521 LIMIT 5 [ RunTime:0.002610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582521 ORDER BY `minOrder` ASC [ RunTime:0.010703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19582521 ORDER BY `unit` DESC [ RunTime:0.002289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19582521 LIMIT 2 [ RunTime:0.008214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19582521 ORDER BY `minOrder` ASC [ RunTime:0.009218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508506 LIMIT 5 [ RunTime:0.015286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19508506 ORDER BY `minOrder` ASC [ RunTime:0.018414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19508506 ORDER BY `unit` DESC [ RunTime:0.003807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19508506 LIMIT 2 [ RunTime:0.015310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19508506 ORDER BY `minOrder` ASC [ RunTime:0.002741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18787178 LIMIT 5 [ RunTime:0.013537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18787178 ORDER BY `minOrder` ASC [ RunTime:0.006847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18787178 ORDER BY `unit` DESC [ RunTime:0.005315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18787178 LIMIT 2 [ RunTime:0.011936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18787178 ORDER BY `minOrder` ASC [ RunTime:0.009103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780487 LIMIT 5 [ RunTime:0.014071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780487 ORDER BY `minOrder` ASC [ RunTime:0.003440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780487 ORDER BY `unit` DESC [ RunTime:0.005403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780487 LIMIT 2 [ RunTime:0.006843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780487 ORDER BY `minOrder` ASC [ RunTime:0.001477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780033 LIMIT 5 [ RunTime:0.001048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780033 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780033 ORDER BY `unit` DESC [ RunTime:0.011321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780033 LIMIT 2 [ RunTime:0.008133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780033 ORDER BY `minOrder` ASC [ RunTime:0.001081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780029 LIMIT 5 [ RunTime:0.004752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780029 ORDER BY `minOrder` ASC [ RunTime:0.012202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780029 ORDER BY `unit` DESC [ RunTime:0.005789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780029 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780029 ORDER BY `minOrder` ASC [ RunTime:0.001644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011530 LIMIT 5 [ RunTime:0.001108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011530 ORDER BY `minOrder` ASC [ RunTime:0.003423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17011530 ORDER BY `unit` DESC [ RunTime:0.006842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17011530 LIMIT 2 [ RunTime:0.002694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011530 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011386 LIMIT 5 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011386 ORDER BY `minOrder` ASC [ RunTime:0.000666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16011386 ORDER BY `unit` DESC [ RunTime:0.013711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16011386 LIMIT 2 [ RunTime:0.002866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011386 ORDER BY `minOrder` ASC [ RunTime:0.003151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224934 LIMIT 5 [ RunTime:0.001971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224934 ORDER BY `minOrder` ASC [ RunTime:0.005461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224934 ORDER BY `unit` DESC [ RunTime:0.002958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224934 LIMIT 2 [ RunTime:0.007326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224934 ORDER BY `minOrder` ASC [ RunTime:0.009595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224667 LIMIT 5 [ RunTime:0.005606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224667 ORDER BY `minOrder` ASC [ RunTime:0.006064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224667 ORDER BY `unit` DESC [ RunTime:0.009413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224667 LIMIT 2 [ RunTime:0.011696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224667 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14709403 LIMIT 5 [ RunTime:0.005214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709403 ORDER BY `minOrder` ASC [ RunTime:0.018094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14709403 ORDER BY `unit` DESC [ RunTime:0.008141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14709403 LIMIT 2 [ RunTime:0.003728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709403 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14708066 LIMIT 5 [ RunTime:0.003634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14708066 ORDER BY `minOrder` ASC [ RunTime:0.001435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14708066 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14708066 LIMIT 2 [ RunTime:0.022003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14708066 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13817389 LIMIT 5 [ RunTime:0.004744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13817389 ORDER BY `minOrder` ASC [ RunTime:0.007434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13817389 ORDER BY `unit` DESC [ RunTime:0.002062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13817389 LIMIT 2 [ RunTime:0.005288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13817389 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13803041 LIMIT 5 [ RunTime:0.016892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13803041 ORDER BY `minOrder` ASC [ RunTime:0.012894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13803041 ORDER BY `unit` DESC [ RunTime:0.004011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13803041 LIMIT 2 [ RunTime:0.003215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13803041 ORDER BY `minOrder` ASC [ RunTime:0.004638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288701 LIMIT 5 [ RunTime:0.001710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288701 ORDER BY `minOrder` ASC [ RunTime:0.003333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288701 ORDER BY `unit` DESC [ RunTime:0.009082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288701 LIMIT 2 [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288701 ORDER BY `minOrder` ASC [ RunTime:0.002448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286323 LIMIT 5 [ RunTime:0.004840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286323 ORDER BY `minOrder` ASC [ RunTime:0.010481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13286323 ORDER BY `unit` DESC [ RunTime:0.008260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13286323 LIMIT 2 [ RunTime:0.010741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286323 ORDER BY `minOrder` ASC [ RunTime:0.009523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286308 LIMIT 5 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286308 ORDER BY `minOrder` ASC [ RunTime:0.002220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13286308 ORDER BY `unit` DESC [ RunTime:0.002096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13286308 LIMIT 2 [ RunTime:0.003619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286308 ORDER BY `minOrder` ASC [ RunTime:0.005482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240033 LIMIT 5 [ RunTime:0.012172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12240033 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12240033 ORDER BY `unit` DESC [ RunTime:0.000721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12240033 LIMIT 2 [ RunTime:0.011677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12240033 ORDER BY `minOrder` ASC [ RunTime:0.006428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12017661 LIMIT 5 [ RunTime:0.004382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12017661 ORDER BY `minOrder` ASC [ RunTime:0.000886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12017661 ORDER BY `unit` DESC [ RunTime:0.009820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12017661 LIMIT 2 [ RunTime:0.006165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12017661 ORDER BY `minOrder` ASC [ RunTime:0.002771s ]
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 '60355%' OR `brand` LIKE '60355%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006194s ]
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 '60355%' OR `brand` LIKE '60355%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335085 LIMIT 5 [ RunTime:0.012931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335085 ORDER BY `minOrder` ASC [ RunTime:0.000962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335085 ORDER BY `unit` DESC [ RunTime:0.008891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335085 LIMIT 2 [ RunTime:0.004597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335085 ORDER BY `minOrder` ASC [ RunTime:0.003034s ]
select * from pdf where partno='6035582' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004053s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035582' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004280s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335085 AND `partno` = '6035582' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335086 LIMIT 5 [ RunTime:0.005815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335086 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335086 ORDER BY `unit` DESC [ RunTime:0.004787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335086 LIMIT 2 [ RunTime:0.002975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335086 ORDER BY `minOrder` ASC [ RunTime:0.002716s ]
select * from pdf where partno='6035583' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035583' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012796s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335086 AND `partno` = '6035583' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200599 [ RunTime:0.019103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63489893 LIMIT 5 [ RunTime:0.015713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63489893 ORDER BY `minOrder` ASC [ RunTime:0.005915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63489893 ORDER BY `unit` DESC [ RunTime:0.001305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63489893 LIMIT 2 [ RunTime:0.010393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63489893 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
select * from pdf where partno='60355' and brandshort='Desco' limit 1 [ RunTime:0.009798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60355' OR `brand` LIKE 'Desco%' ) ) LIMIT 1 [ RunTime:0.020421s ]
SELECT `id` FROM `stock` WHERE `id` <> 63489893 AND `partno` = '60355' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%desco%' ) [ RunTime:0.009199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508506 [ RunTime:0.013470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63345832 LIMIT 5 [ RunTime:0.008952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345832 ORDER BY `minOrder` ASC [ RunTime:0.003406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63345832 ORDER BY `unit` DESC [ RunTime:0.001770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63345832 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345832 ORDER BY `minOrder` ASC [ RunTime:0.002035s ]
select * from pdf where partno='6035500' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035500' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002028s ]
SELECT `id` FROM `stock` WHERE `id` <> 63345832 AND `partno` = '6035500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780487 [ RunTime:0.013773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63345098 LIMIT 5 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345098 ORDER BY `minOrder` ASC [ RunTime:0.009160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63345098 ORDER BY `unit` DESC [ RunTime:0.006456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63345098 LIMIT 2 [ RunTime:0.016331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345098 ORDER BY `minOrder` ASC [ RunTime:0.007969s ]
select * from pdf where partno='6035578' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035578' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001831s ]
SELECT `id` FROM `stock` WHERE `id` <> 63345098 AND `partno` = '6035578' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011530 [ RunTime:0.010361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63345094 LIMIT 5 [ RunTime:0.008931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345094 ORDER BY `minOrder` ASC [ RunTime:0.009063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63345094 ORDER BY `unit` DESC [ RunTime:0.000684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63345094 LIMIT 2 [ RunTime:0.013433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345094 ORDER BY `minOrder` ASC [ RunTime:0.005449s ]
select * from pdf where partno='6035579' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035579' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006718s ]
SELECT `id` FROM `stock` WHERE `id` <> 63345094 AND `partno` = '6035579' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780033 [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63345090 LIMIT 5 [ RunTime:0.003360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345090 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63345090 ORDER BY `unit` DESC [ RunTime:0.010122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63345090 LIMIT 2 [ RunTime:0.011327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345090 ORDER BY `minOrder` ASC [ RunTime:0.002661s ]
select * from pdf where partno='6035580' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035580' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010394s ]
SELECT `id` FROM `stock` WHERE `id` <> 63345090 AND `partno` = '6035580' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780029 [ RunTime:0.011627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63345085 LIMIT 5 [ RunTime:0.010697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345085 ORDER BY `minOrder` ASC [ RunTime:0.000804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63345085 ORDER BY `unit` DESC [ RunTime:0.026087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63345085 LIMIT 2 [ RunTime:0.018481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345085 ORDER BY `minOrder` ASC [ RunTime:0.003037s ]
select * from pdf where partno='6035581' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035581' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013250s ]
SELECT `id` FROM `stock` WHERE `id` <> 63345085 AND `partno` = '6035581' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011386 [ RunTime:0.006693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63345040 LIMIT 5 [ RunTime:0.005456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345040 ORDER BY `minOrder` ASC [ RunTime:0.012193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63345040 ORDER BY `unit` DESC [ RunTime:0.008842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63345040 LIMIT 2 [ RunTime:0.022110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345040 ORDER BY `minOrder` ASC [ RunTime:0.008130s ]
select * from pdf where partno='6035502' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035502' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002155s ]
SELECT `id` FROM `stock` WHERE `id` <> 63345040 AND `partno` = '6035502' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224934 [ RunTime:0.005800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63341043 LIMIT 5 [ RunTime:0.008582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63341043 ORDER BY `minOrder` ASC [ RunTime:0.007689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63341043 ORDER BY `unit` DESC [ RunTime:0.000670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63341043 LIMIT 2 [ RunTime:0.008792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63341043 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
select * from pdf where partno='6035501' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035501' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004270s ]
SELECT `id` FROM `stock` WHERE `id` <> 63341043 AND `partno` = '6035501' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18787178 [ RunTime:0.000760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63217338 LIMIT 5 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63217338 ORDER BY `minOrder` ASC [ RunTime:0.012361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63217338 ORDER BY `unit` DESC [ RunTime:0.006576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63217338 LIMIT 2 [ RunTime:0.002521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63217338 ORDER BY `minOrder` ASC [ RunTime:0.007470s ]
select * from pdf where partno='6035521' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035521' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002772s ]
SELECT `id` FROM `stock` WHERE `id` <> 63217338 AND `partno` = '6035521' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240033 [ RunTime:0.001565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62195471 LIMIT 5 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62195471 ORDER BY `minOrder` ASC [ RunTime:0.002441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62195471 ORDER BY `unit` DESC [ RunTime:0.005334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62195471 LIMIT 2 [ RunTime:0.005973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62195471 ORDER BY `minOrder` ASC [ RunTime:0.004884s ]
select * from pdf where partno='6035529' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035529' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001125s ]
SELECT `id` FROM `stock` WHERE `id` <> 62195471 AND `partno` = '6035529' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13803041 [ RunTime:0.006924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60617735 LIMIT 5 [ RunTime:0.005782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60617735 ORDER BY `minOrder` ASC [ RunTime:0.001912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60617735 ORDER BY `unit` DESC [ RunTime:0.002910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60617735 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60617735 ORDER BY `minOrder` ASC [ RunTime:0.005427s ]
select * from pdf where partno='6035520' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035520' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011884s ]
SELECT `id` FROM `stock` WHERE `id` <> 60617735 AND `partno` = '6035520' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11692257 [ RunTime:0.000973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58202996 LIMIT 5 [ RunTime:0.002227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58202996 ORDER BY `minOrder` ASC [ RunTime:0.003379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58202996 ORDER BY `unit` DESC [ RunTime:0.001903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58202996 LIMIT 2 [ RunTime:0.006691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58202996 ORDER BY `minOrder` ASC [ RunTime:0.003522s ]
select * from pdf where partno='60355' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.000833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60355' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.003393s ]
SELECT `id` FROM `stock` WHERE `id` <> 58202996 AND `partno` = '60355' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.003521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58202908 LIMIT 5 [ RunTime:0.004786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58202908 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58202908 ORDER BY `unit` DESC [ RunTime:0.001763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58202908 LIMIT 2 [ RunTime:0.004162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58202908 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='60355R' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.001733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60355R' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.002177s ]
SELECT `id` FROM `stock` WHERE `id` <> 58202908 AND `partno` = '60355R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.000862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14708066 [ RunTime:0.001479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58202757 LIMIT 5 [ RunTime:0.002529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58202757 ORDER BY `minOrder` ASC [ RunTime:0.001033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58202757 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58202757 LIMIT 2 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58202757 ORDER BY `minOrder` ASC [ RunTime:0.007466s ]
select * from pdf where partno='60355T' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.001638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60355T' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.011362s ]
SELECT `id` FROM `stock` WHERE `id` <> 58202757 AND `partno` = '60355T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.006697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13817389 [ RunTime:0.013277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32536797 LIMIT 5 [ RunTime:0.002781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32536797 ORDER BY `minOrder` ASC [ RunTime:0.004809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32536797 ORDER BY `unit` DESC [ RunTime:0.012340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32536797 LIMIT 2 [ RunTime:0.007028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32536797 ORDER BY `minOrder` ASC [ RunTime:0.017598s ]
select * from pdf where partno='6035533' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035533' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003403s ]
SELECT `id` FROM `stock` WHERE `id` <> 32536797 AND `partno` = '6035533' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288701 [ RunTime:0.008666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32421087 LIMIT 5 [ RunTime:0.002255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421087 ORDER BY `minOrder` ASC [ RunTime:0.002036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32421087 ORDER BY `unit` DESC [ RunTime:0.002904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32421087 LIMIT 2 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421087 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='6035571' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035571' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001547s ]
SELECT `id` FROM `stock` WHERE `id` <> 32421087 AND `partno` = '6035571' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12017661 [ RunTime:0.021479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32401093 LIMIT 5 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401093 ORDER BY `minOrder` ASC [ RunTime:0.009484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32401093 ORDER BY `unit` DESC [ RunTime:0.001531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32401093 LIMIT 2 [ RunTime:0.019953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401093 ORDER BY `minOrder` ASC [ RunTime:0.011003s ]
select * from pdf where partno='6035572' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035572' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001730s ]
SELECT `id` FROM `stock` WHERE `id` <> 32401093 AND `partno` = '6035572' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286323 [ RunTime:0.003034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32401054 LIMIT 5 [ RunTime:0.001116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401054 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32401054 ORDER BY `unit` DESC [ RunTime:0.005917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32401054 LIMIT 2 [ RunTime:0.006872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401054 ORDER BY `minOrder` ASC [ RunTime:0.011303s ]
select * from pdf where partno='6035570' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6035570' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002060s ]
SELECT `id` FROM `stock` WHERE `id` <> 32401054 AND `partno` = '6035570' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286308 [ RunTime:0.000761s ]
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 '60355%' OR `brand` LIKE '60355%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007421s ]
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 '60355%' OR `brand` LIKE '60355%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010104s ]
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 '60355%' OR `brand` LIKE '60355%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003525s ]
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 '60355%' OR `brand` LIKE '60355%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006793s ]
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 '60355%' OR `brand` LIKE '60355%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003065s ]
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 '60355%' OR `brand` LIKE '60355%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001226s ]
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 '60355%' OR `brand` LIKE '60355%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003867s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60355%' OR `brand` LIKE '60355%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010610s ]