SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001838s ]
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 '60211%' OR `brand` LIKE '60211%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049096s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14692950 LIMIT 5 [ RunTime:0.006080s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692950 ORDER BY `minOrder` ASC [ RunTime:0.029093s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14692950 ORDER BY `unit` DESC [ RunTime:0.024284s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14692950 LIMIT 2 [ RunTime:0.012039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692950 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13803876 LIMIT 5 [ RunTime:0.006309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13803876 ORDER BY `minOrder` ASC [ RunTime:0.034248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13803876 ORDER BY `unit` DESC [ RunTime:0.012504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13803876 LIMIT 2 [ RunTime:0.013674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13803876 ORDER BY `minOrder` ASC [ RunTime:0.021285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12867954 LIMIT 5 [ RunTime:0.069256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12867954 ORDER BY `minOrder` ASC [ RunTime:0.038936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12867954 ORDER BY `unit` DESC [ RunTime:0.023495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12867954 LIMIT 2 [ RunTime:0.007091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12867954 ORDER BY `minOrder` ASC [ RunTime:0.012580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10896503 LIMIT 5 [ RunTime:0.011664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10896503 ORDER BY `minOrder` ASC [ RunTime:0.061489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10896503 ORDER BY `unit` DESC [ RunTime:0.017689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10896503 LIMIT 2 [ RunTime:0.033331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10896503 ORDER BY `minOrder` ASC [ RunTime:0.009364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11673593 LIMIT 5 [ RunTime:0.030039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11673593 ORDER BY `minOrder` ASC [ RunTime:0.029800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11673593 ORDER BY `unit` DESC [ RunTime:0.013411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11673593 LIMIT 2 [ RunTime:0.020302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11673593 ORDER BY `minOrder` ASC [ RunTime:0.028387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11673592 LIMIT 5 [ RunTime:0.030244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11673592 ORDER BY `minOrder` ASC [ RunTime:0.059616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11673592 ORDER BY `unit` DESC [ RunTime:0.020568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11673592 LIMIT 2 [ RunTime:0.023975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11673592 ORDER BY `minOrder` ASC [ RunTime:0.010466s ]
select * from pdf where partno='6021124' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10896769 LIMIT 5 [ RunTime:0.026808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10896769 ORDER BY `minOrder` ASC [ RunTime:0.062413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10896769 ORDER BY `unit` DESC [ RunTime:0.007641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10896769 LIMIT 2 [ RunTime:0.004720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10896769 ORDER BY `minOrder` ASC [ RunTime:0.029101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781199 LIMIT 5 [ RunTime:0.047941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781199 ORDER BY `minOrder` ASC [ RunTime:0.087634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781199 ORDER BY `unit` DESC [ RunTime:0.045584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781199 LIMIT 2 [ RunTime:0.048283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781199 ORDER BY `minOrder` ASC [ RunTime:0.049974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14692468 LIMIT 5 [ RunTime:0.045149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692468 ORDER BY `minOrder` ASC [ RunTime:0.087680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14692468 ORDER BY `unit` DESC [ RunTime:0.090248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14692468 LIMIT 2 [ RunTime:0.039247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692468 ORDER BY `minOrder` ASC [ RunTime:0.072022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14666409 LIMIT 5 [ RunTime:0.034063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14666409 ORDER BY `minOrder` ASC [ RunTime:0.102357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14666409 ORDER BY `unit` DESC [ RunTime:0.141975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14666409 LIMIT 2 [ RunTime:0.105855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14666409 ORDER BY `minOrder` ASC [ RunTime:0.077474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14180266 LIMIT 5 [ RunTime:0.110998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14180266 ORDER BY `minOrder` ASC [ RunTime:0.097634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14180266 ORDER BY `unit` DESC [ RunTime:0.098324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14180266 LIMIT 2 [ RunTime:0.050982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14180266 ORDER BY `minOrder` ASC [ RunTime:0.056424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526148 LIMIT 5 [ RunTime:0.042232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526148 ORDER BY `minOrder` ASC [ RunTime:0.063568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13526148 ORDER BY `unit` DESC [ RunTime:0.046791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13526148 LIMIT 2 [ RunTime:0.058815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526148 ORDER BY `minOrder` ASC [ RunTime:0.017201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13033649 LIMIT 5 [ RunTime:0.055445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13033649 ORDER BY `minOrder` ASC [ RunTime:0.136141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13033649 ORDER BY `unit` DESC [ RunTime:0.135098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13033649 LIMIT 2 [ RunTime:0.076377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13033649 ORDER BY `minOrder` ASC [ RunTime:0.050816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12867409 LIMIT 5 [ RunTime:0.051606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12867409 ORDER BY `minOrder` ASC [ RunTime:0.022157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12867409 ORDER BY `unit` DESC [ RunTime:0.053082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12867409 LIMIT 2 [ RunTime:0.147264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12867409 ORDER BY `minOrder` ASC [ RunTime:0.052564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12020731 LIMIT 5 [ RunTime:0.124239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12020731 ORDER BY `minOrder` ASC [ RunTime:0.014868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12020731 ORDER BY `unit` DESC [ RunTime:0.049448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12020731 LIMIT 2 [ RunTime:0.042194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12020731 ORDER BY `minOrder` ASC [ RunTime:0.031603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12019508 LIMIT 5 [ RunTime:0.025739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12019508 ORDER BY `minOrder` ASC [ RunTime:0.032018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12019508 ORDER BY `unit` DESC [ RunTime:0.025478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12019508 LIMIT 2 [ RunTime:0.027721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12019508 ORDER BY `minOrder` ASC [ RunTime:0.017012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11193547 LIMIT 5 [ RunTime:0.030877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193547 ORDER BY `minOrder` ASC [ RunTime:0.040536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11193547 ORDER BY `unit` DESC [ RunTime:0.038069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11193547 LIMIT 2 [ RunTime:0.057405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11193547 ORDER BY `minOrder` ASC [ RunTime:0.018283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10824703 LIMIT 5 [ RunTime:0.020230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10824703 ORDER BY `minOrder` ASC [ RunTime:0.021685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10824703 ORDER BY `unit` DESC [ RunTime:0.024286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10824703 LIMIT 2 [ RunTime:0.105753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10824703 ORDER BY `minOrder` ASC [ RunTime:0.014563s ]
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 '60211%' OR `brand` LIKE '60211%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090754s ]
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 '60211%' OR `brand` LIKE '60211%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62955899 LIMIT 5 [ RunTime:0.004663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62955899 ORDER BY `minOrder` ASC [ RunTime:0.027518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62955899 ORDER BY `unit` DESC [ RunTime:0.010345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62955899 LIMIT 2 [ RunTime:0.020034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62955899 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
select * from pdf where partno='6021195' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022451s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021195' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004750s ]
SELECT `id` FROM `stock` WHERE `id` <> 62955899 AND `partno` = '6021195' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14666409 [ RunTime:0.012418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63277874 LIMIT 5 [ RunTime:0.006710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63277874 ORDER BY `minOrder` ASC [ RunTime:0.072163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63277874 ORDER BY `unit` DESC [ RunTime:0.006150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63277874 LIMIT 2 [ RunTime:0.012073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63277874 ORDER BY `minOrder` ASC [ RunTime:0.024290s ]
select * from pdf where partno='6021123' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021123' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018476s ]
SELECT `id` FROM `stock` WHERE `id` <> 63277874 AND `partno` = '6021123' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12867954 [ RunTime:0.022024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62134288 LIMIT 5 [ RunTime:0.014845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62134288 ORDER BY `minOrder` ASC [ RunTime:0.051924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62134288 ORDER BY `unit` DESC [ RunTime:0.013948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62134288 LIMIT 2 [ RunTime:0.026442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62134288 ORDER BY `minOrder` ASC [ RunTime:0.010920s ]
select * from pdf where partno='6021165' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.035459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021165' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005889s ]
SELECT `id` FROM `stock` WHERE `id` <> 62134288 AND `partno` = '6021165' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14692950 [ RunTime:0.007236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62134228 LIMIT 5 [ RunTime:0.006283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62134228 ORDER BY `minOrder` ASC [ RunTime:0.011041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62134228 ORDER BY `unit` DESC [ RunTime:0.012459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62134228 LIMIT 2 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62134228 ORDER BY `minOrder` ASC [ RunTime:0.014553s ]
select * from pdf where partno='6021164' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021164' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007290s ]
SELECT `id` FROM `stock` WHERE `id` <> 62134228 AND `partno` = '6021164' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.035524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13803876 [ RunTime:0.036912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63277926 LIMIT 5 [ RunTime:0.028041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63277926 ORDER BY `minOrder` ASC [ RunTime:0.035129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63277926 ORDER BY `unit` DESC [ RunTime:0.025887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63277926 LIMIT 2 [ RunTime:0.005355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63277926 ORDER BY `minOrder` ASC [ RunTime:0.014874s ]
select * from pdf where partno='6021124' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021124' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030991s ]
SELECT `id` FROM `stock` WHERE `id` <> 63277926 AND `partno` = '6021124' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11673592 [ RunTime:0.013566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63277954 LIMIT 5 [ RunTime:0.015900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63277954 ORDER BY `minOrder` ASC [ RunTime:0.145829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63277954 ORDER BY `unit` DESC [ RunTime:0.100189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63277954 LIMIT 2 [ RunTime:0.064675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63277954 ORDER BY `minOrder` ASC [ RunTime:0.147339s ]
select * from pdf where partno='6021126' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021126' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.068323s ]
SELECT `id` FROM `stock` WHERE `id` <> 63277954 AND `partno` = '6021126' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.078720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61150824 LIMIT 5 [ RunTime:0.077885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61150824 ORDER BY `minOrder` ASC [ RunTime:0.049305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61150824 ORDER BY `unit` DESC [ RunTime:0.038809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61150824 LIMIT 2 [ RunTime:0.062977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61150824 ORDER BY `minOrder` ASC [ RunTime:0.106341s ]
select * from pdf where partno='6021156' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.056910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021156' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.066662s ]
SELECT `id` FROM `stock` WHERE `id` <> 61150824 AND `partno` = '6021156' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.036370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10896769 [ RunTime:0.046158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63278440 LIMIT 5 [ RunTime:0.029414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63278440 ORDER BY `minOrder` ASC [ RunTime:0.072627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63278440 ORDER BY `unit` DESC [ RunTime:0.033599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63278440 LIMIT 2 [ RunTime:0.028932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63278440 ORDER BY `minOrder` ASC [ RunTime:0.019281s ]
select * from pdf where partno='6021125' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005717s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021125' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017144s ]
SELECT `id` FROM `stock` WHERE `id` <> 63278440 AND `partno` = '6021125' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11673593 [ RunTime:0.019583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61192444 LIMIT 5 [ RunTime:0.009357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61192444 ORDER BY `minOrder` ASC [ RunTime:0.017429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61192444 ORDER BY `unit` DESC [ RunTime:0.019078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61192444 LIMIT 2 [ RunTime:0.023835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61192444 ORDER BY `minOrder` ASC [ RunTime:0.007369s ]
select * from pdf where partno='6021167' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021167' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006085s ]
SELECT `id` FROM `stock` WHERE `id` <> 61192444 AND `partno` = '6021167' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10896503 [ RunTime:0.012606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346937 LIMIT 5 [ RunTime:0.008732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346937 ORDER BY `minOrder` ASC [ RunTime:0.013237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346937 ORDER BY `unit` DESC [ RunTime:0.008896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346937 LIMIT 2 [ RunTime:0.008789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346937 ORDER BY `minOrder` ASC [ RunTime:0.002413s ]
select * from pdf where partno='6021162' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021162' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008608s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346937 AND `partno` = '6021162' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14180266 [ RunTime:0.007601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346934 LIMIT 5 [ RunTime:0.004195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346934 ORDER BY `minOrder` ASC [ RunTime:0.023929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346934 ORDER BY `unit` DESC [ RunTime:0.000835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346934 LIMIT 2 [ RunTime:0.014148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346934 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
select * from pdf where partno='6021163' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021163' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002242s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346934 AND `partno` = '6021163' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781199 [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63280346 LIMIT 5 [ RunTime:0.002226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63280346 ORDER BY `minOrder` ASC [ RunTime:0.001230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63280346 ORDER BY `unit` DESC [ RunTime:0.004152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63280346 LIMIT 2 [ RunTime:0.008001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63280346 ORDER BY `minOrder` ASC [ RunTime:0.002078s ]
select * from pdf where partno='6021128' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021128' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001924s ]
SELECT `id` FROM `stock` WHERE `id` <> 63280346 AND `partno` = '6021128' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63280344 LIMIT 5 [ RunTime:0.000801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63280344 ORDER BY `minOrder` ASC [ RunTime:0.006251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63280344 ORDER BY `unit` DESC [ RunTime:0.000708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63280344 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63280344 ORDER BY `minOrder` ASC [ RunTime:0.010700s ]
select * from pdf where partno='6021129' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021129' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001420s ]
SELECT `id` FROM `stock` WHERE `id` <> 63280344 AND `partno` = '6021129' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12867409 [ RunTime:0.006544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63279777 LIMIT 5 [ RunTime:0.002939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63279777 ORDER BY `minOrder` ASC [ RunTime:0.003458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63279777 ORDER BY `unit` DESC [ RunTime:0.002269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63279777 LIMIT 2 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63279777 ORDER BY `minOrder` ASC [ RunTime:0.004178s ]
select * from pdf where partno='6021127' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021127' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008805s ]
SELECT `id` FROM `stock` WHERE `id` <> 63279777 AND `partno` = '6021127' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62197958 LIMIT 5 [ RunTime:0.003410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62197958 ORDER BY `minOrder` ASC [ RunTime:0.003478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62197958 ORDER BY `unit` DESC [ RunTime:0.003748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62197958 LIMIT 2 [ RunTime:0.008450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62197958 ORDER BY `minOrder` ASC [ RunTime:0.003122s ]
select * from pdf where partno='6021175' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021175' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016571s ]
SELECT `id` FROM `stock` WHERE `id` <> 62197958 AND `partno` = '6021175' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14692468 [ RunTime:0.010952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61359883 LIMIT 5 [ RunTime:0.001040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61359883 ORDER BY `minOrder` ASC [ RunTime:0.011296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61359883 ORDER BY `unit` DESC [ RunTime:0.000908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61359883 LIMIT 2 [ RunTime:0.000848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61359883 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='6021192' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021192' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005374s ]
SELECT `id` FROM `stock` WHERE `id` <> 61359883 AND `partno` = '6021192' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13033649 [ RunTime:0.007611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61346319 LIMIT 5 [ RunTime:0.003759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61346319 ORDER BY `minOrder` ASC [ RunTime:0.001459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61346319 ORDER BY `unit` DESC [ RunTime:0.000770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61346319 LIMIT 2 [ RunTime:0.003680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61346319 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='6021191' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021191' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001848s ]
SELECT `id` FROM `stock` WHERE `id` <> 61346319 AND `partno` = '6021191' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10824703 [ RunTime:0.001579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57700947 LIMIT 5 [ RunTime:0.003295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700947 ORDER BY `minOrder` ASC [ RunTime:0.010924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57700947 ORDER BY `unit` DESC [ RunTime:0.002599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57700947 LIMIT 2 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57700947 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='60211' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60211' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000876s ]
SELECT `id` FROM `stock` WHERE `id` <> 57700947 AND `partno` = '60211' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526148 [ RunTime:0.003334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32544628 LIMIT 5 [ RunTime:0.002221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32544628 ORDER BY `minOrder` ASC [ RunTime:0.008559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32544628 ORDER BY `unit` DESC [ RunTime:0.004903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32544628 LIMIT 2 [ RunTime:0.003968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32544628 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='6021168' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021168' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009389s ]
SELECT `id` FROM `stock` WHERE `id` <> 32544628 AND `partno` = '6021168' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12020731 [ RunTime:0.000740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32503653 LIMIT 5 [ RunTime:0.012356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32503653 ORDER BY `minOrder` ASC [ RunTime:0.003472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32503653 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32503653 LIMIT 2 [ RunTime:0.003821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32503653 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
select * from pdf where partno='6021166' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6021166' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011148s ]
SELECT `id` FROM `stock` WHERE `id` <> 32503653 AND `partno` = '6021166' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12019508 [ RunTime:0.001051s ]
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 '60211%' OR `brand` LIKE '60211%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006640s ]
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 '60211%' OR `brand` LIKE '60211%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005077s ]
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 '60211%' OR `brand` LIKE '60211%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003656s ]
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 '60211%' OR `brand` LIKE '60211%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004956s ]
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 '60211%' OR `brand` LIKE '60211%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003462s ]
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 '60211%' OR `brand` LIKE '60211%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004044s ]
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 '60211%' OR `brand` LIKE '60211%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005222s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60211%' OR `brand` LIKE '60211%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001947s ]