SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001420s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=12199&search=1' [ RunTime:0.003898s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001369s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000673s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001548s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001270s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000261s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001367s ]
SELECT * FROM `stock_search` WHERE `partno` = '12199' LIMIT 1 [ RunTime:0.001128s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 14:16:14' WHERE `partno` = '12199' [ RunTime:0.009131s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002575s ]
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 '12199%' OR `brand` LIKE '12199%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011123s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349279 LIMIT 5 [ RunTime:0.014461s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349279 ORDER BY `minOrder` ASC [ RunTime:0.014761s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349279 ORDER BY `unit` DESC [ RunTime:0.007606s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349279 LIMIT 2 [ RunTime:0.008038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349279 ORDER BY `minOrder` ASC [ RunTime:0.012907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17148261 LIMIT 5 [ RunTime:0.009289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17148261 ORDER BY `minOrder` ASC [ RunTime:0.012060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17148261 ORDER BY `unit` DESC [ RunTime:0.014197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17148261 LIMIT 2 [ RunTime:0.002145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17148261 ORDER BY `minOrder` ASC [ RunTime:0.012903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19274696 LIMIT 5 [ RunTime:0.018668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274696 ORDER BY `minOrder` ASC [ RunTime:0.006240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19274696 ORDER BY `unit` DESC [ RunTime:0.006591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19274696 LIMIT 2 [ RunTime:0.004924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274696 ORDER BY `minOrder` ASC [ RunTime:0.002220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19274661 LIMIT 5 [ RunTime:0.011832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274661 ORDER BY `minOrder` ASC [ RunTime:0.008841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19274661 ORDER BY `unit` DESC [ RunTime:0.005599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19274661 LIMIT 2 [ RunTime:0.011273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274661 ORDER BY `minOrder` ASC [ RunTime:0.004189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19274656 LIMIT 5 [ RunTime:0.012574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274656 ORDER BY `minOrder` ASC [ RunTime:0.012463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19274656 ORDER BY `unit` DESC [ RunTime:0.009803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19274656 LIMIT 2 [ RunTime:0.013768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274656 ORDER BY `minOrder` ASC [ RunTime:0.012997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19274570 LIMIT 5 [ RunTime:0.005359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274570 ORDER BY `minOrder` ASC [ RunTime:0.011732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19274570 ORDER BY `unit` DESC [ RunTime:0.012355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19274570 LIMIT 2 [ RunTime:0.018438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274570 ORDER BY `minOrder` ASC [ RunTime:0.013271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982190 LIMIT 5 [ RunTime:0.009261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982190 ORDER BY `minOrder` ASC [ RunTime:0.019942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982190 ORDER BY `unit` DESC [ RunTime:0.010648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982190 LIMIT 2 [ RunTime:0.028727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982190 ORDER BY `minOrder` ASC [ RunTime:0.011890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981994 LIMIT 5 [ RunTime:0.014056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981994 ORDER BY `minOrder` ASC [ RunTime:0.012710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981994 ORDER BY `unit` DESC [ RunTime:0.004742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981994 LIMIT 2 [ RunTime:0.013521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981994 ORDER BY `minOrder` ASC [ RunTime:0.010660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981974 LIMIT 5 [ RunTime:0.008653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981974 ORDER BY `minOrder` ASC [ RunTime:0.013914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981974 ORDER BY `unit` DESC [ RunTime:0.017859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981974 LIMIT 2 [ RunTime:0.019481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981974 ORDER BY `minOrder` ASC [ RunTime:0.030103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981971 LIMIT 5 [ RunTime:0.018850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981971 ORDER BY `minOrder` ASC [ RunTime:0.013183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981971 ORDER BY `unit` DESC [ RunTime:0.020507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981971 LIMIT 2 [ RunTime:0.010598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981971 ORDER BY `minOrder` ASC [ RunTime:0.013639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981486 LIMIT 5 [ RunTime:0.031614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981486 ORDER BY `minOrder` ASC [ RunTime:0.038109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981486 ORDER BY `unit` DESC [ RunTime:0.025247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981486 LIMIT 2 [ RunTime:0.026934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981486 ORDER BY `minOrder` ASC [ RunTime:0.021651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981425 LIMIT 5 [ RunTime:0.019486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981425 ORDER BY `minOrder` ASC [ RunTime:0.008469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981425 ORDER BY `unit` DESC [ RunTime:0.021810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981425 LIMIT 2 [ RunTime:0.019692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981425 ORDER BY `minOrder` ASC [ RunTime:0.011133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18976690 LIMIT 5 [ RunTime:0.007276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18976690 ORDER BY `minOrder` ASC [ RunTime:0.019611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18976690 ORDER BY `unit` DESC [ RunTime:0.012458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18976690 LIMIT 2 [ RunTime:0.002503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18976690 ORDER BY `minOrder` ASC [ RunTime:0.007532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18976674 LIMIT 5 [ RunTime:0.000868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18976674 ORDER BY `minOrder` ASC [ RunTime:0.015586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18976674 ORDER BY `unit` DESC [ RunTime:0.011131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18976674 LIMIT 2 [ RunTime:0.011632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18976674 ORDER BY `minOrder` ASC [ RunTime:0.004799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835656 LIMIT 5 [ RunTime:0.001502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835656 ORDER BY `minOrder` ASC [ RunTime:0.005134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835656 ORDER BY `unit` DESC [ RunTime:0.000866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835656 LIMIT 2 [ RunTime:0.004734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835656 ORDER BY `minOrder` ASC [ RunTime:0.002076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17144292 LIMIT 5 [ RunTime:0.001623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17144292 ORDER BY `minOrder` ASC [ RunTime:0.004625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17144292 ORDER BY `unit` DESC [ RunTime:0.000732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17144292 LIMIT 2 [ RunTime:0.002756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17144292 ORDER BY `minOrder` ASC [ RunTime:0.001254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17144291 LIMIT 5 [ RunTime:0.003809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17144291 ORDER BY `minOrder` ASC [ RunTime:0.005151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17144291 ORDER BY `unit` DESC [ RunTime:0.008626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17144291 LIMIT 2 [ RunTime:0.011008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17144291 ORDER BY `minOrder` ASC [ RunTime:0.006878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17144170 LIMIT 5 [ RunTime:0.005687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17144170 ORDER BY `minOrder` ASC [ RunTime:0.010494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17144170 ORDER BY `unit` DESC [ RunTime:0.000726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17144170 LIMIT 2 [ RunTime:0.001315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17144170 ORDER BY `minOrder` ASC [ RunTime:0.002169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15367650 LIMIT 5 [ RunTime:0.004841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15367650 ORDER BY `minOrder` ASC [ RunTime:0.004985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15367650 ORDER BY `unit` DESC [ RunTime:0.010757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15367650 LIMIT 2 [ RunTime:0.009717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15367650 ORDER BY `minOrder` ASC [ RunTime:0.013878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266428 LIMIT 5 [ RunTime:0.017817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266428 ORDER BY `minOrder` ASC [ RunTime:0.007650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15266428 ORDER BY `unit` DESC [ RunTime:0.016313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15266428 LIMIT 2 [ RunTime:0.026439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266428 ORDER BY `minOrder` ASC [ RunTime:0.005459s ]
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 '12199%' OR `brand` LIKE '12199%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001861s ]
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 '12199%' OR `brand` LIKE '12199%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57740043 LIMIT 5 [ RunTime:0.004096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57740043 ORDER BY `minOrder` ASC [ RunTime:0.006001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57740043 ORDER BY `unit` DESC [ RunTime:0.000806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57740043 LIMIT 2 [ RunTime:0.010007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57740043 ORDER BY `minOrder` ASC [ RunTime:0.006305s ]
select * from pdf where partno='12199CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.014582s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12199CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010751s ]
SELECT `id` FROM `stock` WHERE `id` <> 57740043 AND `partno` = '12199CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.011122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349279 [ RunTime:0.000740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43762053 LIMIT 5 [ RunTime:0.001610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43762053 ORDER BY `minOrder` ASC [ RunTime:0.007867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43762053 ORDER BY `unit` DESC [ RunTime:0.003715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43762053 LIMIT 2 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43762053 ORDER BY `minOrder` ASC [ RunTime:0.005082s ]
select * from pdf where partno='1219950000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219950000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008740s ]
SELECT `id` FROM `stock` WHERE `id` <> 43762053 AND `partno` = '1219950000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17148261 [ RunTime:0.005083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199139 LIMIT 5 [ RunTime:0.002624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199139 ORDER BY `minOrder` ASC [ RunTime:0.012792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199139 ORDER BY `unit` DESC [ RunTime:0.009621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199139 LIMIT 2 [ RunTime:0.013805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199139 ORDER BY `minOrder` ASC [ RunTime:0.002806s ]
select * from pdf where partno='1219926' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219926' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006527s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199139 AND `partno` = '1219926' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981994 [ RunTime:0.006157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199122 LIMIT 5 [ RunTime:0.004830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199122 ORDER BY `minOrder` ASC [ RunTime:0.007646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199122 ORDER BY `unit` DESC [ RunTime:0.004336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199122 LIMIT 2 [ RunTime:0.007007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199122 ORDER BY `minOrder` ASC [ RunTime:0.000907s ]
select * from pdf where partno='1219932' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219932' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000985s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199122 AND `partno` = '1219932' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266428 [ RunTime:0.002569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199110 LIMIT 5 [ RunTime:0.006114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199110 ORDER BY `minOrder` ASC [ RunTime:0.003744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199110 ORDER BY `unit` DESC [ RunTime:0.003297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199110 LIMIT 2 [ RunTime:0.005122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199110 ORDER BY `minOrder` ASC [ RunTime:0.010437s ]
select * from pdf where partno='1219942' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219942' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005304s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199110 AND `partno` = '1219942' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981974 [ RunTime:0.008635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199105 LIMIT 5 [ RunTime:0.009271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199105 ORDER BY `minOrder` ASC [ RunTime:0.006493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199105 ORDER BY `unit` DESC [ RunTime:0.004110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199105 LIMIT 2 [ RunTime:0.007102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199105 ORDER BY `minOrder` ASC [ RunTime:0.001376s ]
select * from pdf where partno='1219921' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219921' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016765s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199105 AND `partno` = '1219921' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981971 [ RunTime:0.030086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198737 LIMIT 5 [ RunTime:0.010306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198737 ORDER BY `minOrder` ASC [ RunTime:0.005586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198737 ORDER BY `unit` DESC [ RunTime:0.012202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198737 LIMIT 2 [ RunTime:0.006688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198737 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='1219939' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219939' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002097s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198737 AND `partno` = '1219939' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196895 [ RunTime:0.006817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198732 LIMIT 5 [ RunTime:0.005337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198732 ORDER BY `minOrder` ASC [ RunTime:0.012192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198732 ORDER BY `unit` DESC [ RunTime:0.003462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198732 LIMIT 2 [ RunTime:0.002099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198732 ORDER BY `minOrder` ASC [ RunTime:0.003312s ]
select * from pdf where partno='1219927' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219927' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023479s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198732 AND `partno` = '1219927' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196894 [ RunTime:0.004020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198570 LIMIT 5 [ RunTime:0.001637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198570 ORDER BY `minOrder` ASC [ RunTime:0.001431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198570 ORDER BY `unit` DESC [ RunTime:0.004205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198570 LIMIT 2 [ RunTime:0.007270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198570 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
select * from pdf where partno='1219923' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219923' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005762s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198570 AND `partno` = '1219923' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981486 [ RunTime:0.010427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60595162 LIMIT 5 [ RunTime:0.001622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60595162 ORDER BY `minOrder` ASC [ RunTime:0.012255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60595162 ORDER BY `unit` DESC [ RunTime:0.006527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60595162 LIMIT 2 [ RunTime:0.007999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60595162 ORDER BY `minOrder` ASC [ RunTime:0.002859s ]
select * from pdf where partno='12199.3' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.005605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12199.3' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.011501s ]
SELECT `id` FROM `stock` WHERE `id` <> 60595162 AND `partno` = '12199.3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.010660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58549476 LIMIT 5 [ RunTime:0.005977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58549476 ORDER BY `minOrder` ASC [ RunTime:0.006781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58549476 ORDER BY `unit` DESC [ RunTime:0.001731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58549476 LIMIT 2 [ RunTime:0.001531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58549476 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
select * from pdf where partno='12199' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.002906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12199' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.016615s ]
SELECT `id` FROM `stock` WHERE `id` <> 58549476 AND `partno` = '12199' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.007361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12183629 [ RunTime:0.009278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57653305 LIMIT 5 [ RunTime:0.004078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57653305 ORDER BY `minOrder` ASC [ RunTime:0.015290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57653305 ORDER BY `unit` DESC [ RunTime:0.002290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57653305 LIMIT 2 [ RunTime:0.007231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57653305 ORDER BY `minOrder` ASC [ RunTime:0.005984s ]
select * from pdf where partno='1219999' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219999' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014915s ]
SELECT `id` FROM `stock` WHERE `id` <> 57653305 AND `partno` = '1219999' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198264 [ RunTime:0.007163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57653065 LIMIT 5 [ RunTime:0.002543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57653065 ORDER BY `minOrder` ASC [ RunTime:0.016006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57653065 ORDER BY `unit` DESC [ RunTime:0.015079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57653065 LIMIT 2 [ RunTime:0.022707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57653065 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
select * from pdf where partno='1219966' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219966' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009013s ]
SELECT `id` FROM `stock` WHERE `id` <> 57653065 AND `partno` = '1219966' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198146 [ RunTime:0.004910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57652833 LIMIT 5 [ RunTime:0.032062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57652833 ORDER BY `minOrder` ASC [ RunTime:0.038450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57652833 ORDER BY `unit` DESC [ RunTime:0.014470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57652833 LIMIT 2 [ RunTime:0.034917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57652833 ORDER BY `minOrder` ASC [ RunTime:0.014697s ]
select * from pdf where partno='1219903' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.019212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219903' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008732s ]
SELECT `id` FROM `stock` WHERE `id` <> 57652833 AND `partno` = '1219903' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.023681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198028 [ RunTime:0.025372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57652772 LIMIT 5 [ RunTime:0.006787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57652772 ORDER BY `minOrder` ASC [ RunTime:0.020123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57652772 ORDER BY `unit` DESC [ RunTime:0.035065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57652772 LIMIT 2 [ RunTime:0.006971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57652772 ORDER BY `minOrder` ASC [ RunTime:0.003595s ]
select * from pdf where partno='1219996' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219996' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017997s ]
SELECT `id` FROM `stock` WHERE `id` <> 57652772 AND `partno` = '1219996' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206992 [ RunTime:0.006922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57652180 LIMIT 5 [ RunTime:0.002164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57652180 ORDER BY `minOrder` ASC [ RunTime:0.004362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57652180 ORDER BY `unit` DESC [ RunTime:0.006431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57652180 LIMIT 2 [ RunTime:0.012142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57652180 ORDER BY `minOrder` ASC [ RunTime:0.007091s ]
select * from pdf where partno='1219997' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219997' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007876s ]
SELECT `id` FROM `stock` WHERE `id` <> 57652180 AND `partno` = '1219997' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.023244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206779 [ RunTime:0.001025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57651708 LIMIT 5 [ RunTime:0.002767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57651708 ORDER BY `minOrder` ASC [ RunTime:0.004858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57651708 ORDER BY `unit` DESC [ RunTime:0.012823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57651708 LIMIT 2 [ RunTime:0.004351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57651708 ORDER BY `minOrder` ASC [ RunTime:0.001872s ]
select * from pdf where partno='1219995' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219995' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006259s ]
SELECT `id` FROM `stock` WHERE `id` <> 57651708 AND `partno` = '1219995' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206612 [ RunTime:0.009033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57651164 LIMIT 5 [ RunTime:0.018995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57651164 ORDER BY `minOrder` ASC [ RunTime:0.030032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57651164 ORDER BY `unit` DESC [ RunTime:0.006708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57651164 LIMIT 2 [ RunTime:0.034324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57651164 ORDER BY `minOrder` ASC [ RunTime:0.008371s ]
select * from pdf where partno='1219974' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219974' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039173s ]
SELECT `id` FROM `stock` WHERE `id` <> 57651164 AND `partno` = '1219974' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.033376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57645333 LIMIT 5 [ RunTime:0.016407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57645333 ORDER BY `minOrder` ASC [ RunTime:0.035690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57645333 ORDER BY `unit` DESC [ RunTime:0.042367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57645333 LIMIT 2 [ RunTime:0.026331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57645333 ORDER BY `minOrder` ASC [ RunTime:0.023918s ]
select * from pdf where partno='1219920' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219920' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015184s ]
SELECT `id` FROM `stock` WHERE `id` <> 57645333 AND `partno` = '1219920' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835656 [ RunTime:0.009769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43775241 LIMIT 5 [ RunTime:0.003252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43775241 ORDER BY `minOrder` ASC [ RunTime:0.018731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43775241 ORDER BY `unit` DESC [ RunTime:0.007862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43775241 LIMIT 2 [ RunTime:0.009812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43775241 ORDER BY `minOrder` ASC [ RunTime:0.008216s ]
select * from pdf where partno='1219980000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1219980000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.013512s ]
SELECT `id` FROM `stock` WHERE `id` <> 43775241 AND `partno` = '1219980000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.020165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19274696 [ RunTime:0.032452s ]
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 '12199%' OR `brand` LIKE '12199%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020468s ]
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 '12199%' OR `brand` LIKE '12199%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011270s ]
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 '12199%' OR `brand` LIKE '12199%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009006s ]
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 '12199%' OR `brand` LIKE '12199%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009988s ]
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 '12199%' OR `brand` LIKE '12199%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003171s ]
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 '12199%' OR `brand` LIKE '12199%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016653s ]
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 '12199%' OR `brand` LIKE '12199%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009726s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12199%' OR `brand` LIKE '12199%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012567s ]