SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001260s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=22000&search=1' [ RunTime:0.016382s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001265s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001965s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.003279s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001130s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003620s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001442s ]
SELECT * FROM `stock_search` WHERE `partno` = '22000' LIMIT 1 [ RunTime:0.019552s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-19 08:16:28' WHERE `partno` = '22000' [ RunTime:0.040530s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001251s ]
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 '22000%' OR `brand` LIKE '22000%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083676s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11233672 LIMIT 5 [ RunTime:0.034335s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11233672 ORDER BY `minOrder` ASC [ RunTime:0.044836s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.020728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11233672 ORDER BY `unit` DESC [ RunTime:0.048939s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11233672 LIMIT 2 [ RunTime:0.034281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11233672 ORDER BY `minOrder` ASC [ RunTime:0.070044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14199805 LIMIT 5 [ RunTime:0.098992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14199805 ORDER BY `minOrder` ASC [ RunTime:0.074285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14199805 ORDER BY `unit` DESC [ RunTime:0.083488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14199805 LIMIT 2 [ RunTime:0.054873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14199805 ORDER BY `minOrder` ASC [ RunTime:0.013125s ]
select * from pdf where partno='2200072' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11234358 LIMIT 5 [ RunTime:0.028685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11234358 ORDER BY `minOrder` ASC [ RunTime:0.084834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11234358 ORDER BY `unit` DESC [ RunTime:0.034706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11234358 LIMIT 2 [ RunTime:0.048661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11234358 ORDER BY `minOrder` ASC [ RunTime:0.017843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11234907 LIMIT 5 [ RunTime:0.060706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11234907 ORDER BY `minOrder` ASC [ RunTime:0.080964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11234907 ORDER BY `unit` DESC [ RunTime:0.036783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11234907 LIMIT 2 [ RunTime:0.018990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11234907 ORDER BY `minOrder` ASC [ RunTime:0.005427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705957 LIMIT 5 [ RunTime:0.056495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705957 ORDER BY `minOrder` ASC [ RunTime:0.033430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18705957 ORDER BY `unit` DESC [ RunTime:0.008291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18705957 LIMIT 2 [ RunTime:0.020688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705957 ORDER BY `minOrder` ASC [ RunTime:0.005759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11234624 LIMIT 5 [ RunTime:0.024027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11234624 ORDER BY `minOrder` ASC [ RunTime:0.045320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11234624 ORDER BY `unit` DESC [ RunTime:0.017925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11234624 LIMIT 2 [ RunTime:0.059714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11234624 ORDER BY `minOrder` ASC [ RunTime:0.022747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19628311 LIMIT 5 [ RunTime:0.030077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19628311 ORDER BY `minOrder` ASC [ RunTime:0.041974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19628311 ORDER BY `unit` DESC [ RunTime:0.053017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19628311 LIMIT 2 [ RunTime:0.041300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19628311 ORDER BY `minOrder` ASC [ RunTime:0.026330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266374 LIMIT 5 [ RunTime:0.028017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266374 ORDER BY `minOrder` ASC [ RunTime:0.007180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19266374 ORDER BY `unit` DESC [ RunTime:0.030182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19266374 LIMIT 2 [ RunTime:0.018571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266374 ORDER BY `minOrder` ASC [ RunTime:0.016297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266334 LIMIT 5 [ RunTime:0.056279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266334 ORDER BY `minOrder` ASC [ RunTime:0.022684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19266334 ORDER BY `unit` DESC [ RunTime:0.031072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19266334 LIMIT 2 [ RunTime:0.014972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266334 ORDER BY `minOrder` ASC [ RunTime:0.006577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266322 LIMIT 5 [ RunTime:0.023937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266322 ORDER BY `minOrder` ASC [ RunTime:0.005501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19266322 ORDER BY `unit` DESC [ RunTime:0.062299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19266322 LIMIT 2 [ RunTime:0.041002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266322 ORDER BY `minOrder` ASC [ RunTime:0.066618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266318 LIMIT 5 [ RunTime:0.015550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266318 ORDER BY `minOrder` ASC [ RunTime:0.086880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19266318 ORDER BY `unit` DESC [ RunTime:0.127938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19266318 LIMIT 2 [ RunTime:0.136499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266318 ORDER BY `minOrder` ASC [ RunTime:0.009219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266305 LIMIT 5 [ RunTime:0.058802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266305 ORDER BY `minOrder` ASC [ RunTime:0.142516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19266305 ORDER BY `unit` DESC [ RunTime:0.083850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19266305 LIMIT 2 [ RunTime:0.069253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266305 ORDER BY `minOrder` ASC [ RunTime:0.014290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266298 LIMIT 5 [ RunTime:0.033846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266298 ORDER BY `minOrder` ASC [ RunTime:0.054866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19266298 ORDER BY `unit` DESC [ RunTime:0.077566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19266298 LIMIT 2 [ RunTime:0.075511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266298 ORDER BY `minOrder` ASC [ RunTime:0.038231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266279 LIMIT 5 [ RunTime:0.073148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266279 ORDER BY `minOrder` ASC [ RunTime:0.042287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19266279 ORDER BY `unit` DESC [ RunTime:0.070336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19266279 LIMIT 2 [ RunTime:0.120148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266279 ORDER BY `minOrder` ASC [ RunTime:0.055055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266263 LIMIT 5 [ RunTime:0.076138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266263 ORDER BY `minOrder` ASC [ RunTime:0.074719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19266263 ORDER BY `unit` DESC [ RunTime:0.074409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19266263 LIMIT 2 [ RunTime:0.079246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19266263 ORDER BY `minOrder` ASC [ RunTime:0.061176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18997278 LIMIT 5 [ RunTime:0.038763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997278 ORDER BY `minOrder` ASC [ RunTime:0.071455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18997278 ORDER BY `unit` DESC [ RunTime:0.078205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18997278 LIMIT 2 [ RunTime:0.021782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18997278 ORDER BY `minOrder` ASC [ RunTime:0.088436s ]
select * from pdf where partno='2200027' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.030446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991572 LIMIT 5 [ RunTime:0.035064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991572 ORDER BY `minOrder` ASC [ RunTime:0.038734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991572 ORDER BY `unit` DESC [ RunTime:0.066489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991572 LIMIT 2 [ RunTime:0.044037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991572 ORDER BY `minOrder` ASC [ RunTime:0.028399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991431 LIMIT 5 [ RunTime:0.113974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991431 ORDER BY `minOrder` ASC [ RunTime:0.077682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18991431 ORDER BY `unit` DESC [ RunTime:0.012122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18991431 LIMIT 2 [ RunTime:0.034486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18991431 ORDER BY `minOrder` ASC [ RunTime:0.011640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18983927 LIMIT 5 [ RunTime:0.009748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18983927 ORDER BY `minOrder` ASC [ RunTime:0.011079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18983927 ORDER BY `unit` DESC [ RunTime:0.003379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18983927 LIMIT 2 [ RunTime:0.009196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18983927 ORDER BY `minOrder` ASC [ RunTime:0.010006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18983926 LIMIT 5 [ RunTime:0.031550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18983926 ORDER BY `minOrder` ASC [ RunTime:0.015240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18983926 ORDER BY `unit` DESC [ RunTime:0.012973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18983926 LIMIT 2 [ RunTime:0.013478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18983926 ORDER BY `minOrder` ASC [ RunTime:0.016286s ]
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 '22000%' OR `brand` LIKE '22000%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134506 LIMIT 5 [ RunTime:0.032331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134506 ORDER BY `minOrder` ASC [ RunTime:0.022839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134506 ORDER BY `unit` DESC [ RunTime:0.005779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134506 LIMIT 2 [ RunTime:0.003920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134506 ORDER BY `minOrder` ASC [ RunTime:0.008512s ]
select * from pdf where partno='2200000621' and brandshort='basler' limit 1 [ RunTime:0.007983s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000621' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.007741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32310803 LIMIT 5 [ RunTime:0.022939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310803 ORDER BY `minOrder` ASC [ RunTime:0.013954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32310803 ORDER BY `unit` DESC [ RunTime:0.001932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32310803 LIMIT 2 [ RunTime:0.001065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310803 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='2200000959' and brandshort='basler' limit 1 [ RunTime:0.001141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000959' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.011348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32289981 LIMIT 5 [ RunTime:0.004705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32289981 ORDER BY `minOrder` ASC [ RunTime:0.005359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32289981 ORDER BY `unit` DESC [ RunTime:0.011737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32289981 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32289981 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='2200000998' and brandshort='basler' limit 1 [ RunTime:0.000921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000998' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.005245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134511 LIMIT 5 [ RunTime:0.006039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134511 ORDER BY `minOrder` ASC [ RunTime:0.003548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134511 ORDER BY `unit` DESC [ RunTime:0.000948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134511 LIMIT 2 [ RunTime:0.001225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134511 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
select * from pdf where partno='2200000625' and brandshort='basler' limit 1 [ RunTime:0.002838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000625' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.001387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134541 LIMIT 5 [ RunTime:0.009795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134541 ORDER BY `minOrder` ASC [ RunTime:0.004075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134541 ORDER BY `unit` DESC [ RunTime:0.004585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134541 LIMIT 2 [ RunTime:0.005122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134541 ORDER BY `minOrder` ASC [ RunTime:0.002727s ]
select * from pdf where partno='2200000315' and brandshort='basler' limit 1 [ RunTime:0.004034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000315' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.015014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235606 LIMIT 5 [ RunTime:0.011570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235606 ORDER BY `minOrder` ASC [ RunTime:0.012335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235606 ORDER BY `unit` DESC [ RunTime:0.016672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235606 LIMIT 2 [ RunTime:0.005752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235606 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='2200000568' and brandshort='basler' limit 1 [ RunTime:0.007774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000568' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.009002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32261946 LIMIT 5 [ RunTime:0.014964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32261946 ORDER BY `minOrder` ASC [ RunTime:0.006569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32261946 ORDER BY `unit` DESC [ RunTime:0.003580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32261946 LIMIT 2 [ RunTime:0.002633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32261946 ORDER BY `minOrder` ASC [ RunTime:0.004965s ]
select * from pdf where partno='2200000620' and brandshort='basler' limit 1 [ RunTime:0.001017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000620' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.005934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32260926 LIMIT 5 [ RunTime:0.002686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32260926 ORDER BY `minOrder` ASC [ RunTime:0.017649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32260926 ORDER BY `unit` DESC [ RunTime:0.010052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32260926 LIMIT 2 [ RunTime:0.003984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32260926 ORDER BY `minOrder` ASC [ RunTime:0.005457s ]
select * from pdf where partno='2200000620' and brandshort='basler' limit 1 [ RunTime:0.004241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000620' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32167809 LIMIT 5 [ RunTime:0.001732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32167809 ORDER BY `minOrder` ASC [ RunTime:0.006540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32167809 ORDER BY `unit` DESC [ RunTime:0.002716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32167809 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32167809 ORDER BY `minOrder` ASC [ RunTime:0.008725s ]
select * from pdf where partno='2200000620' and brandshort='basler' limit 1 [ RunTime:0.000403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000620' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.000316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32204930 LIMIT 5 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32204930 ORDER BY `minOrder` ASC [ RunTime:0.000878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32204930 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32204930 LIMIT 2 [ RunTime:0.002606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32204930 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='2200000620' and brandshort='basler' limit 1 [ RunTime:0.000405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000620' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077132 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077132 ORDER BY `minOrder` ASC [ RunTime:0.001107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077132 ORDER BY `unit` DESC [ RunTime:0.005639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077132 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077132 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='2200072' and brandshort='phoenix contact' limit 1 [ RunTime:0.000593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200072' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.003266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235700 LIMIT 5 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235700 ORDER BY `minOrder` ASC [ RunTime:0.003390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235700 ORDER BY `unit` DESC [ RunTime:0.002013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235700 LIMIT 2 [ RunTime:0.012095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235700 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='2200000589' and brandshort='basler' limit 1 [ RunTime:0.001344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000589' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.000709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131678 LIMIT 5 [ RunTime:0.006354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131678 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51131678 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51131678 LIMIT 2 [ RunTime:0.002315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131678 ORDER BY `minOrder` ASC [ RunTime:0.008158s ]
select * from pdf where partno='2200001807' and brandshort='basler' limit 1 [ RunTime:0.002280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200001807' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.006781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078648 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078648 ORDER BY `minOrder` ASC [ RunTime:0.002633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078648 ORDER BY `unit` DESC [ RunTime:0.006414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078648 LIMIT 2 [ RunTime:0.008526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078648 ORDER BY `minOrder` ASC [ RunTime:0.002785s ]
select * from pdf where partno='2200000715' and brandshort='basler' limit 1 [ RunTime:0.006354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000715' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.008593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235683 LIMIT 5 [ RunTime:0.002807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235683 ORDER BY `minOrder` ASC [ RunTime:0.015578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235683 ORDER BY `unit` DESC [ RunTime:0.000629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235683 LIMIT 2 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235683 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='2200000571' and brandshort='basler' limit 1 [ RunTime:0.000823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000571' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.010144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134452 LIMIT 5 [ RunTime:0.013803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134452 ORDER BY `minOrder` ASC [ RunTime:0.014011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134452 ORDER BY `unit` DESC [ RunTime:0.009589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134452 LIMIT 2 [ RunTime:0.003826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134452 ORDER BY `minOrder` ASC [ RunTime:0.001693s ]
select * from pdf where partno='2200000296' and brandshort='basler' limit 1 [ RunTime:0.003897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000296' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.001350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131596 LIMIT 5 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131596 ORDER BY `minOrder` ASC [ RunTime:0.001252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51131596 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51131596 LIMIT 2 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131596 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='2200001806' and brandshort='basler' limit 1 [ RunTime:0.000744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200001806' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.000856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235644 LIMIT 5 [ RunTime:0.001798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235644 ORDER BY `minOrder` ASC [ RunTime:0.000771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235644 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235644 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235644 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='2200000569' and brandshort='basler' limit 1 [ RunTime:0.000871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000569' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.004485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134441 LIMIT 5 [ RunTime:0.006724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134441 ORDER BY `minOrder` ASC [ RunTime:0.022177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134441 ORDER BY `unit` DESC [ RunTime:0.026971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134441 LIMIT 2 [ RunTime:0.002601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134441 ORDER BY `minOrder` ASC [ RunTime:0.004331s ]
select * from pdf where partno='2200000297' and brandshort='basler' limit 1 [ RunTime:0.005270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000297' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.011543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235764 LIMIT 5 [ RunTime:0.005140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235764 ORDER BY `minOrder` ASC [ RunTime:0.000565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235764 ORDER BY `unit` DESC [ RunTime:0.000645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235764 LIMIT 2 [ RunTime:0.003580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235764 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
select * from pdf where partno='2200000626' and brandshort='basler' limit 1 [ RunTime:0.001382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000626' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.004914s ]
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 '22000%' OR `brand` LIKE '22000%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63211425 LIMIT 5 [ RunTime:0.018579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63211425 ORDER BY `minOrder` ASC [ RunTime:0.006242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63211425 ORDER BY `unit` DESC [ RunTime:0.019638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63211425 LIMIT 2 [ RunTime:0.008407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63211425 ORDER BY `minOrder` ASC [ RunTime:0.008207s ]
select * from pdf where partno='2200000204' and brandshort='Basler Inc.' limit 1 [ RunTime:0.010610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000204' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.016047s ]
SELECT `id` FROM `stock` WHERE `id` <> 63211425 AND `partno` = '2200000204' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.011506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11233672 [ RunTime:0.011100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63460259 LIMIT 5 [ RunTime:0.055858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460259 ORDER BY `minOrder` ASC [ RunTime:0.035295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63460259 ORDER BY `unit` DESC [ RunTime:0.024201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63460259 LIMIT 2 [ RunTime:0.019251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460259 ORDER BY `minOrder` ASC [ RunTime:0.010033s ]
select * from pdf where partno='2200072' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200072' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.022486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212082 LIMIT 5 [ RunTime:0.016283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212082 ORDER BY `minOrder` ASC [ RunTime:0.024446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212082 ORDER BY `unit` DESC [ RunTime:0.000934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212082 LIMIT 2 [ RunTime:0.014098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212082 ORDER BY `minOrder` ASC [ RunTime:0.009799s ]
select * from pdf where partno='2200002382' and brandshort='Basler Inc.' limit 1 [ RunTime:0.008851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200002382' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.013505s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212082 AND `partno` = '2200002382' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.055339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11234624 [ RunTime:0.015789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64250579 LIMIT 5 [ RunTime:0.013880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250579 ORDER BY `minOrder` ASC [ RunTime:0.024970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64250579 ORDER BY `unit` DESC [ RunTime:0.021229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64250579 LIMIT 2 [ RunTime:0.016651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250579 ORDER BY `minOrder` ASC [ RunTime:0.006952s ]
select * from pdf where partno='2200002206' and brandshort='Basler Inc.' limit 1 [ RunTime:0.015190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200002206' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.000676s ]
SELECT `id` FROM `stock` WHERE `id` <> 64250579 AND `partno` = '2200002206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.003103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140771 [ RunTime:0.021272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64250578 LIMIT 5 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250578 ORDER BY `minOrder` ASC [ RunTime:0.003566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64250578 ORDER BY `unit` DESC [ RunTime:0.005373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64250578 LIMIT 2 [ RunTime:0.017006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250578 ORDER BY `minOrder` ASC [ RunTime:0.010851s ]
select * from pdf where partno='2200002204' and brandshort='Basler Inc.' limit 1 [ RunTime:0.004347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200002204' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.002938s ]
SELECT `id` FROM `stock` WHERE `id` <> 64250578 AND `partno` = '2200002204' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.010212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266263 [ RunTime:0.015235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64250541 LIMIT 5 [ RunTime:0.014288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250541 ORDER BY `minOrder` ASC [ RunTime:0.008704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64250541 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64250541 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250541 ORDER BY `minOrder` ASC [ RunTime:0.003245s ]
select * from pdf where partno='2200002207' and brandshort='Basler Inc.' limit 1 [ RunTime:0.012933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200002207' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.001786s ]
SELECT `id` FROM `stock` WHERE `id` <> 64250541 AND `partno` = '2200002207' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266298 [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64250580 LIMIT 5 [ RunTime:0.006809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250580 ORDER BY `minOrder` ASC [ RunTime:0.000576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64250580 ORDER BY `unit` DESC [ RunTime:0.000453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64250580 LIMIT 2 [ RunTime:0.003516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250580 ORDER BY `minOrder` ASC [ RunTime:0.010292s ]
select * from pdf where partno='2200002205' and brandshort='Basler Inc.' limit 1 [ RunTime:0.004249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200002205' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.024161s ]
SELECT `id` FROM `stock` WHERE `id` <> 64250580 AND `partno` = '2200002205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.022806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15360708 [ RunTime:0.010440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212995 LIMIT 5 [ RunTime:0.001027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212995 ORDER BY `minOrder` ASC [ RunTime:0.001618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212995 ORDER BY `unit` DESC [ RunTime:0.003462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212995 LIMIT 2 [ RunTime:0.007199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212995 ORDER BY `minOrder` ASC [ RunTime:0.013581s ]
select * from pdf where partno='2200000981' and brandshort='Basler Inc.' limit 1 [ RunTime:0.003767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000981' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.009399s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212995 AND `partno` = '2200000981' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.019843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64808462 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808462 ORDER BY `minOrder` ASC [ RunTime:0.006726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64808462 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64808462 LIMIT 2 [ RunTime:0.007487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64808462 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='2200000576' and brandshort='Basler Inc.' limit 1 [ RunTime:0.000540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000576' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.016882s ]
SELECT `id` FROM `stock` WHERE `id` <> 64808462 AND `partno` = '2200000576' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.002072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14197204 [ RunTime:0.000829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63214050 LIMIT 5 [ RunTime:0.001167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63214050 ORDER BY `minOrder` ASC [ RunTime:0.012290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63214050 ORDER BY `unit` DESC [ RunTime:0.010997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63214050 LIMIT 2 [ RunTime:0.001188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63214050 ORDER BY `minOrder` ASC [ RunTime:0.002688s ]
select * from pdf where partno='2200000622' and brandshort='Basler Inc.' limit 1 [ RunTime:0.007645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000622' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.023664s ]
SELECT `id` FROM `stock` WHERE `id` <> 63214050 AND `partno` = '2200000622' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.011002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11235108 [ RunTime:0.007624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64250722 LIMIT 5 [ RunTime:0.010010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250722 ORDER BY `minOrder` ASC [ RunTime:0.022580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64250722 ORDER BY `unit` DESC [ RunTime:0.018860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64250722 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250722 ORDER BY `minOrder` ASC [ RunTime:0.000193s ]
select * from pdf where partno='2200000720' and brandshort='Basler Inc.' limit 1 [ RunTime:0.001412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000720' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.003890s ]
SELECT `id` FROM `stock` WHERE `id` <> 64250722 AND `partno` = '2200000720' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.009002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140779 [ RunTime:0.019147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64250686 LIMIT 5 [ RunTime:0.016528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250686 ORDER BY `minOrder` ASC [ RunTime:0.008002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64250686 ORDER BY `unit` DESC [ RunTime:0.003351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64250686 LIMIT 2 [ RunTime:0.022982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250686 ORDER BY `minOrder` ASC [ RunTime:0.026831s ]
select * from pdf where partno='2200000716' and brandshort='Basler Inc.' limit 1 [ RunTime:0.022743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000716' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.018760s ]
SELECT `id` FROM `stock` WHERE `id` <> 64250686 AND `partno` = '2200000716' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.008188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19266322 [ RunTime:0.004972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63213982 LIMIT 5 [ RunTime:0.008144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213982 ORDER BY `minOrder` ASC [ RunTime:0.001228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63213982 ORDER BY `unit` DESC [ RunTime:0.005403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63213982 LIMIT 2 [ RunTime:0.002296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213982 ORDER BY `minOrder` ASC [ RunTime:0.005351s ]
select * from pdf where partno='2200000324' and brandshort='Basler Inc.' limit 1 [ RunTime:0.003821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000324' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.000875s ]
SELECT `id` FROM `stock` WHERE `id` <> 63213982 AND `partno` = '2200000324' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.000802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12239107 [ RunTime:0.003125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58557305 LIMIT 5 [ RunTime:0.007768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58557305 ORDER BY `minOrder` ASC [ RunTime:0.004055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58557305 ORDER BY `unit` DESC [ RunTime:0.001358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58557305 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58557305 ORDER BY `minOrder` ASC [ RunTime:0.003076s ]
select * from pdf where partno='22000' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.000985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22000' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.013875s ]
SELECT `id` FROM `stock` WHERE `id` <> 58557305 AND `partno` = '22000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.003155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705957 [ RunTime:0.000642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58116725 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58116725 ORDER BY `minOrder` ASC [ RunTime:0.004499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58116725 ORDER BY `unit` DESC [ RunTime:0.000758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58116725 LIMIT 2 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58116725 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='2200000320' and brandshort='Basler Inc.' limit 1 [ RunTime:0.000784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000320' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.003308s ]
SELECT `id` FROM `stock` WHERE `id` <> 58116725 AND `partno` = '2200000320' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.001484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18915265 [ RunTime:0.000978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64811586 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811586 ORDER BY `minOrder` ASC [ RunTime:0.001274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64811586 ORDER BY `unit` DESC [ RunTime:0.001480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64811586 LIMIT 2 [ RunTime:0.005457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811586 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='2200002412' and brandshort='Basler Inc.' limit 1 [ RunTime:0.000650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200002412' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.002970s ]
SELECT `id` FROM `stock` WHERE `id` <> 64811586 AND `partno` = '2200002412' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.002298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64811579 LIMIT 5 [ RunTime:0.000723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811579 ORDER BY `minOrder` ASC [ RunTime:0.003099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64811579 ORDER BY `unit` DESC [ RunTime:0.009538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64811579 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811579 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
select * from pdf where partno='2200001661' and brandshort='Basler Inc.' limit 1 [ RunTime:0.002825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200001661' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.005415s ]
SELECT `id` FROM `stock` WHERE `id` <> 64811579 AND `partno` = '2200001661' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.003838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64811228 LIMIT 5 [ RunTime:0.002119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811228 ORDER BY `minOrder` ASC [ RunTime:0.002529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64811228 ORDER BY `unit` DESC [ RunTime:0.002960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64811228 LIMIT 2 [ RunTime:0.004533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811228 ORDER BY `minOrder` ASC [ RunTime:0.004570s ]
select * from pdf where partno='2200000024' and brandshort='Basler Inc.' limit 1 [ RunTime:0.000970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200000024' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.000587s ]
SELECT `id` FROM `stock` WHERE `id` <> 64811228 AND `partno` = '2200000024' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.000568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64811104 LIMIT 5 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811104 ORDER BY `minOrder` ASC [ RunTime:0.000679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64811104 ORDER BY `unit` DESC [ RunTime:0.004775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64811104 LIMIT 2 [ RunTime:0.007451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811104 ORDER BY `minOrder` ASC [ RunTime:0.007230s ]
select * from pdf where partno='2200002379' and brandshort='Basler Inc.' limit 1 [ RunTime:0.013452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200002379' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.000931s ]
SELECT `id` FROM `stock` WHERE `id` <> 64811104 AND `partno` = '2200002379' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.013395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64811098 LIMIT 5 [ RunTime:0.016837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811098 ORDER BY `minOrder` ASC [ RunTime:0.002275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64811098 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64811098 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811098 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='2200002378' and brandshort='Basler Inc.' limit 1 [ RunTime:0.012396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2200002378' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.002119s ]
SELECT `id` FROM `stock` WHERE `id` <> 64811098 AND `partno` = '2200002378' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%basler inc.%' ) [ RunTime:0.000893s ]
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 '22000%' OR `brand` LIKE '22000%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006071s ]
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 '22000%' OR `brand` LIKE '22000%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002270s ]
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 '22000%' OR `brand` LIKE '22000%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003704s ]
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 '22000%' OR `brand` LIKE '22000%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014327s ]
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 '22000%' OR `brand` LIKE '22000%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014141s ]
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 '22000%' OR `brand` LIKE '22000%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004183s ]
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 '22000%' OR `brand` LIKE '22000%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012091s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '22000%' OR `brand` LIKE '22000%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006423s ]