SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001374s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.251' , `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=2156&search=1' [ RunTime:0.011353s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001170s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009023s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001390s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.251' ) [ RunTime:0.000316s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001177s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.022066s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001155s ]
SELECT * FROM `stock_search` WHERE `partno` = '2156' LIMIT 1 [ RunTime:0.050375s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 03:02:57' WHERE `partno` = '2156' [ RunTime:0.018004s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002245s ]
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 '2156%' OR `brand` LIKE '2156%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045074s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315045 LIMIT 5 [ RunTime:0.027784s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315045 ORDER BY `minOrder` ASC [ RunTime:0.062117s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315045 ORDER BY `unit` DESC [ RunTime:0.015316s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315045 LIMIT 2 [ RunTime:0.010638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315045 ORDER BY `minOrder` ASC [ RunTime:0.013410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19577506 LIMIT 5 [ RunTime:0.013187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577506 ORDER BY `minOrder` ASC [ RunTime:0.032009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19577506 ORDER BY `unit` DESC [ RunTime:0.039094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19577506 LIMIT 2 [ RunTime:0.024753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19577506 ORDER BY `minOrder` ASC [ RunTime:0.015189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588234 LIMIT 5 [ RunTime:0.036586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588234 ORDER BY `minOrder` ASC [ RunTime:0.038605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18588234 ORDER BY `unit` DESC [ RunTime:0.048941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18588234 LIMIT 2 [ RunTime:0.053657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18588234 ORDER BY `minOrder` ASC [ RunTime:0.026083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427140 LIMIT 5 [ RunTime:0.070039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427140 ORDER BY `minOrder` ASC [ RunTime:0.032776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427140 ORDER BY `unit` DESC [ RunTime:0.087141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427140 LIMIT 2 [ RunTime:0.014883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427140 ORDER BY `minOrder` ASC [ RunTime:0.012029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19576764 LIMIT 5 [ RunTime:0.054671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19576764 ORDER BY `minOrder` ASC [ RunTime:0.033926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19576764 ORDER BY `unit` DESC [ RunTime:0.042249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19576764 LIMIT 2 [ RunTime:0.031803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19576764 ORDER BY `minOrder` ASC [ RunTime:0.025303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19576567 LIMIT 5 [ RunTime:0.039634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19576567 ORDER BY `minOrder` ASC [ RunTime:0.062262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19576567 ORDER BY `unit` DESC [ RunTime:0.080606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19576567 LIMIT 2 [ RunTime:0.092552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19576567 ORDER BY `minOrder` ASC [ RunTime:0.030910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17047730 LIMIT 5 [ RunTime:0.061221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17047730 ORDER BY `minOrder` ASC [ RunTime:0.093934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17047730 ORDER BY `unit` DESC [ RunTime:0.072140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17047730 LIMIT 2 [ RunTime:0.083161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17047730 ORDER BY `minOrder` ASC [ RunTime:0.034512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439941 LIMIT 5 [ RunTime:0.086674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439941 ORDER BY `minOrder` ASC [ RunTime:0.051722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15439941 ORDER BY `unit` DESC [ RunTime:0.062546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15439941 LIMIT 2 [ RunTime:0.019266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439941 ORDER BY `minOrder` ASC [ RunTime:0.052908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414996 LIMIT 5 [ RunTime:0.032369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414996 ORDER BY `minOrder` ASC [ RunTime:0.146668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14414996 ORDER BY `unit` DESC [ RunTime:0.099854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14414996 LIMIT 2 [ RunTime:0.061675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414996 ORDER BY `minOrder` ASC [ RunTime:0.036578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414942 LIMIT 5 [ RunTime:0.038909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414942 ORDER BY `minOrder` ASC [ RunTime:0.020420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14414942 ORDER BY `unit` DESC [ RunTime:0.087514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14414942 LIMIT 2 [ RunTime:0.037053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414942 ORDER BY `minOrder` ASC [ RunTime:0.008118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414793 LIMIT 5 [ RunTime:0.109379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414793 ORDER BY `minOrder` ASC [ RunTime:0.040015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14414793 ORDER BY `unit` DESC [ RunTime:0.022062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14414793 LIMIT 2 [ RunTime:0.012952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414793 ORDER BY `minOrder` ASC [ RunTime:0.023319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400196 LIMIT 5 [ RunTime:0.045294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400196 ORDER BY `minOrder` ASC [ RunTime:0.034042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400196 ORDER BY `unit` DESC [ RunTime:0.063181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400196 LIMIT 2 [ RunTime:0.040576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400196 ORDER BY `minOrder` ASC [ RunTime:0.026042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400195 LIMIT 5 [ RunTime:0.029552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400195 ORDER BY `minOrder` ASC [ RunTime:0.040723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400195 ORDER BY `unit` DESC [ RunTime:0.019589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400195 LIMIT 2 [ RunTime:0.023715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400195 ORDER BY `minOrder` ASC [ RunTime:0.012943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400194 LIMIT 5 [ RunTime:0.022927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400194 ORDER BY `minOrder` ASC [ RunTime:0.019882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400194 ORDER BY `unit` DESC [ RunTime:0.053748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400194 LIMIT 2 [ RunTime:0.049532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400194 ORDER BY `minOrder` ASC [ RunTime:0.019577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400193 LIMIT 5 [ RunTime:0.020586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400193 ORDER BY `minOrder` ASC [ RunTime:0.028639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400193 ORDER BY `unit` DESC [ RunTime:0.010572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400193 LIMIT 2 [ RunTime:0.033073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400193 ORDER BY `minOrder` ASC [ RunTime:0.019867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400192 LIMIT 5 [ RunTime:0.034634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400192 ORDER BY `minOrder` ASC [ RunTime:0.033315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400192 ORDER BY `unit` DESC [ RunTime:0.063878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400192 LIMIT 2 [ RunTime:0.021978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400192 ORDER BY `minOrder` ASC [ RunTime:0.026057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400191 LIMIT 5 [ RunTime:0.005778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400191 ORDER BY `minOrder` ASC [ RunTime:0.016789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400191 ORDER BY `unit` DESC [ RunTime:0.037600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400191 LIMIT 2 [ RunTime:0.030401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400191 ORDER BY `minOrder` ASC [ RunTime:0.013193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400190 LIMIT 5 [ RunTime:0.018529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400190 ORDER BY `minOrder` ASC [ RunTime:0.012610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400190 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400190 LIMIT 2 [ RunTime:0.003157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400190 ORDER BY `minOrder` ASC [ RunTime:0.028576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400189 LIMIT 5 [ RunTime:0.010731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400189 ORDER BY `minOrder` ASC [ RunTime:0.036624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400189 ORDER BY `unit` DESC [ RunTime:0.012798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400189 LIMIT 2 [ RunTime:0.024621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400189 ORDER BY `minOrder` ASC [ RunTime:0.003020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400188 LIMIT 5 [ RunTime:0.024028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400188 ORDER BY `minOrder` ASC [ RunTime:0.017866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400188 ORDER BY `unit` DESC [ RunTime:0.017452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400188 LIMIT 2 [ RunTime:0.036352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400188 ORDER BY `minOrder` ASC [ RunTime:0.014272s ]
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 '2156%' OR `brand` LIKE '2156%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32309137 LIMIT 5 [ RunTime:0.011808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309137 ORDER BY `minOrder` ASC [ RunTime:0.024902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32309137 ORDER BY `unit` DESC [ RunTime:0.007925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32309137 LIMIT 2 [ RunTime:0.036045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309137 ORDER BY `minOrder` ASC [ RunTime:0.013283s ]
select * from pdf where partno='2156' and brandshort='tinkerforge' limit 1 [ RunTime:0.042643s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156' OR `brand` LIKE 'tinkerforge%' ) ) LIMIT 1 [ RunTime:0.009468s ]
SELECT `id` FROM `stock` WHERE `id` <> 32309137 AND `partno` = '2156' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tinkerforge%' ) [ RunTime:0.021073s ]
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 '2156%' OR `brand` LIKE '2156%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56580449 LIMIT 5 [ RunTime:0.028726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56580449 ORDER BY `minOrder` ASC [ RunTime:0.006110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56580449 ORDER BY `unit` DESC [ RunTime:0.022490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56580449 LIMIT 2 [ RunTime:0.044458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56580449 ORDER BY `minOrder` ASC [ RunTime:0.026012s ]
select * from pdf where partno='2156' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.034196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.023129s ]
SELECT `id` FROM `stock` WHERE `id` <> 56580449 AND `partno` = '2156' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.045726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315045 [ RunTime:0.045558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51645083 LIMIT 5 [ RunTime:0.036948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51645083 ORDER BY `minOrder` ASC [ RunTime:0.047884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51645083 ORDER BY `unit` DESC [ RunTime:0.023893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51645083 LIMIT 2 [ RunTime:0.014690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51645083 ORDER BY `minOrder` ASC [ RunTime:0.015685s ]
select * from pdf where partno='2156-4-7320' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.026623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156-4-7320' OR `brand` LIKE 'ebm-papst Inc.%' ) ) LIMIT 1 [ RunTime:0.022924s ]
SELECT `id` FROM `stock` WHERE `id` <> 51645083 AND `partno` = '2156-4-7320' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ebm-papst inc.%' ) [ RunTime:0.019983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18588234 [ RunTime:0.013089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51225639 LIMIT 5 [ RunTime:0.035378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51225639 ORDER BY `minOrder` ASC [ RunTime:0.078848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51225639 ORDER BY `unit` DESC [ RunTime:0.035471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51225639 LIMIT 2 [ RunTime:0.014505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51225639 ORDER BY `minOrder` ASC [ RunTime:0.019914s ]
select * from pdf where partno='2156' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.019318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.008664s ]
SELECT `id` FROM `stock` WHERE `id` <> 51225639 AND `partno` = '2156' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.041261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17047730 [ RunTime:0.016572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56357627 LIMIT 5 [ RunTime:0.003020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56357627 ORDER BY `minOrder` ASC [ RunTime:0.039867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56357627 ORDER BY `unit` DESC [ RunTime:0.045171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56357627 LIMIT 2 [ RunTime:0.038767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56357627 ORDER BY `minOrder` ASC [ RunTime:0.019661s ]
select * from pdf where partno='2156 NA005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.017769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156 NA005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002994s ]
SELECT `id` FROM `stock` WHERE `id` <> 56357627 AND `partno` = '2156 NA005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.066511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427140 [ RunTime:0.030054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56598718 LIMIT 5 [ RunTime:0.020270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56598718 ORDER BY `minOrder` ASC [ RunTime:0.006216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56598718 ORDER BY `unit` DESC [ RunTime:0.019924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56598718 LIMIT 2 [ RunTime:0.025361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56598718 ORDER BY `minOrder` ASC [ RunTime:0.007333s ]
select * from pdf where partno='2156' and brandshort='80/20, LLC' limit 1 [ RunTime:0.016226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.057626s ]
SELECT `id` FROM `stock` WHERE `id` <> 56598718 AND `partno` = '2156' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.021802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349786 LIMIT 5 [ RunTime:0.027359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349786 ORDER BY `minOrder` ASC [ RunTime:0.019558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349786 ORDER BY `unit` DESC [ RunTime:0.012425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349786 LIMIT 2 [ RunTime:0.006741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349786 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='2156.0420' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.009565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0420' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.013021s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349786 AND `partno` = '2156.0420' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.022411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349785 LIMIT 5 [ RunTime:0.015639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349785 ORDER BY `minOrder` ASC [ RunTime:0.010243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349785 ORDER BY `unit` DESC [ RunTime:0.005542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349785 LIMIT 2 [ RunTime:0.014094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349785 ORDER BY `minOrder` ASC [ RunTime:0.008686s ]
select * from pdf where partno='2156.0419' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.010158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0419' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.016205s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349785 AND `partno` = '2156.0419' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.001826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349784 LIMIT 5 [ RunTime:0.010475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349784 ORDER BY `minOrder` ASC [ RunTime:0.037710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349784 ORDER BY `unit` DESC [ RunTime:0.029268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349784 LIMIT 2 [ RunTime:0.016706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349784 ORDER BY `minOrder` ASC [ RunTime:0.019503s ]
select * from pdf where partno='2156.0408' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.020587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0408' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.062809s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349784 AND `partno` = '2156.0408' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.044396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349783 LIMIT 5 [ RunTime:0.046655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349783 ORDER BY `minOrder` ASC [ RunTime:0.008226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349783 ORDER BY `unit` DESC [ RunTime:0.022589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349783 LIMIT 2 [ RunTime:0.022871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349783 ORDER BY `minOrder` ASC [ RunTime:0.004623s ]
select * from pdf where partno='2156.0407' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.025740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0407' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.059054s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349783 AND `partno` = '2156.0407' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.019767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349782 LIMIT 5 [ RunTime:0.006551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349782 ORDER BY `minOrder` ASC [ RunTime:0.043803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349782 ORDER BY `unit` DESC [ RunTime:0.023323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349782 LIMIT 2 [ RunTime:0.017504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349782 ORDER BY `minOrder` ASC [ RunTime:0.020714s ]
select * from pdf where partno='2156.0406' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.026594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0406' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.013583s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349782 AND `partno` = '2156.0406' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.035110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349781 LIMIT 5 [ RunTime:0.026097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349781 ORDER BY `minOrder` ASC [ RunTime:0.001806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349781 ORDER BY `unit` DESC [ RunTime:0.058039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349781 LIMIT 2 [ RunTime:0.059281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349781 ORDER BY `minOrder` ASC [ RunTime:0.052753s ]
select * from pdf where partno='2156.0405' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.026672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0405' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.048577s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349781 AND `partno` = '2156.0405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.024981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349780 LIMIT 5 [ RunTime:0.048026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349780 ORDER BY `minOrder` ASC [ RunTime:0.018628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349780 ORDER BY `unit` DESC [ RunTime:0.010710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349780 LIMIT 2 [ RunTime:0.022747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349780 ORDER BY `minOrder` ASC [ RunTime:0.008286s ]
select * from pdf where partno='2156.0404' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.008909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0404' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.021955s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349780 AND `partno` = '2156.0404' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.009022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349779 LIMIT 5 [ RunTime:0.018822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349779 ORDER BY `minOrder` ASC [ RunTime:0.055244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349779 ORDER BY `unit` DESC [ RunTime:0.007947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349779 LIMIT 2 [ RunTime:0.005649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349779 ORDER BY `minOrder` ASC [ RunTime:0.004202s ]
select * from pdf where partno='2156.0403' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.050347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0403' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.023622s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349779 AND `partno` = '2156.0403' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.033224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349778 LIMIT 5 [ RunTime:0.055912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349778 ORDER BY `minOrder` ASC [ RunTime:0.003695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349778 ORDER BY `unit` DESC [ RunTime:0.020202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349778 LIMIT 2 [ RunTime:0.001887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349778 ORDER BY `minOrder` ASC [ RunTime:0.012371s ]
select * from pdf where partno='2156.0401' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.027971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0401' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.016106s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349778 AND `partno` = '2156.0401' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.014740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349777 LIMIT 5 [ RunTime:0.019432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349777 ORDER BY `minOrder` ASC [ RunTime:0.010075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349777 ORDER BY `unit` DESC [ RunTime:0.026038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349777 LIMIT 2 [ RunTime:0.006336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349777 ORDER BY `minOrder` ASC [ RunTime:0.010865s ]
select * from pdf where partno='2156.0324' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.012338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0324' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.005767s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349777 AND `partno` = '2156.0324' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.031514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349776 LIMIT 5 [ RunTime:0.008422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349776 ORDER BY `minOrder` ASC [ RunTime:0.008822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349776 ORDER BY `unit` DESC [ RunTime:0.040121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349776 LIMIT 2 [ RunTime:0.026445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349776 ORDER BY `minOrder` ASC [ RunTime:0.028140s ]
select * from pdf where partno='2156.0323' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.062179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0323' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.023455s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349776 AND `partno` = '2156.0323' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.031134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349775 LIMIT 5 [ RunTime:0.011532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349775 ORDER BY `minOrder` ASC [ RunTime:0.037561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349775 ORDER BY `unit` DESC [ RunTime:0.023064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349775 LIMIT 2 [ RunTime:0.003301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349775 ORDER BY `minOrder` ASC [ RunTime:0.022504s ]
select * from pdf where partno='2156.0321' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.031864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0321' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.011102s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349775 AND `partno` = '2156.0321' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.017408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349774 LIMIT 5 [ RunTime:0.025744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349774 ORDER BY `minOrder` ASC [ RunTime:0.011755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349774 ORDER BY `unit` DESC [ RunTime:0.012138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349774 LIMIT 2 [ RunTime:0.007100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349774 ORDER BY `minOrder` ASC [ RunTime:0.029072s ]
select * from pdf where partno='2156.0320' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.007584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0320' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.028381s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349774 AND `partno` = '2156.0320' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.004578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349773 LIMIT 5 [ RunTime:0.013872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349773 ORDER BY `minOrder` ASC [ RunTime:0.017512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349773 ORDER BY `unit` DESC [ RunTime:0.068550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349773 LIMIT 2 [ RunTime:0.056846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349773 ORDER BY `minOrder` ASC [ RunTime:0.010084s ]
select * from pdf where partno='2156.0319' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.033860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0319' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.013835s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349773 AND `partno` = '2156.0319' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.020837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56349772 LIMIT 5 [ RunTime:0.045324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349772 ORDER BY `minOrder` ASC [ RunTime:0.040330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56349772 ORDER BY `unit` DESC [ RunTime:0.038834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56349772 LIMIT 2 [ RunTime:0.038703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56349772 ORDER BY `minOrder` ASC [ RunTime:0.013529s ]
select * from pdf where partno='2156.0318' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.026649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2156.0318' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.051939s ]
SELECT `id` FROM `stock` WHERE `id` <> 56349772 AND `partno` = '2156.0318' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.066682s ]
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 '2156%' OR `brand` LIKE '2156%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010044s ]
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 '2156%' OR `brand` LIKE '2156%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068773s ]
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 '2156%' OR `brand` LIKE '2156%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011954s ]
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 '2156%' OR `brand` LIKE '2156%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030455s ]
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 '2156%' OR `brand` LIKE '2156%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038693s ]
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 '2156%' OR `brand` LIKE '2156%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044399s ]
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 '2156%' OR `brand` LIKE '2156%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049454s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2156%' OR `brand` LIKE '2156%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041037s ]