SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001352s ]
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 '105901%' OR `brand` LIKE '105901%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003942s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979878 LIMIT 5 [ RunTime:0.030493s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979878 ORDER BY `minOrder` ASC [ RunTime:0.022384s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979878 ORDER BY `unit` DESC [ RunTime:0.027003s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979878 LIMIT 2 [ RunTime:0.015525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979878 ORDER BY `minOrder` ASC [ RunTime:0.011678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772406 LIMIT 5 [ RunTime:0.029788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772406 ORDER BY `minOrder` ASC [ RunTime:0.054826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772406 ORDER BY `unit` DESC [ RunTime:0.028339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772406 LIMIT 2 [ RunTime:0.058657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772406 ORDER BY `minOrder` ASC [ RunTime:0.022539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772367 LIMIT 5 [ RunTime:0.039573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772367 ORDER BY `minOrder` ASC [ RunTime:0.045626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772367 ORDER BY `unit` DESC [ RunTime:0.085963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772367 LIMIT 2 [ RunTime:0.062214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772367 ORDER BY `minOrder` ASC [ RunTime:0.032772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16620951 LIMIT 5 [ RunTime:0.052954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16620951 ORDER BY `minOrder` ASC [ RunTime:0.045049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16620951 ORDER BY `unit` DESC [ RunTime:0.059356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16620951 LIMIT 2 [ RunTime:0.103893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16620951 ORDER BY `minOrder` ASC [ RunTime:0.018871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011227 LIMIT 5 [ RunTime:0.030328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011227 ORDER BY `minOrder` ASC [ RunTime:0.044650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16011227 ORDER BY `unit` DESC [ RunTime:0.026650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16011227 LIMIT 2 [ RunTime:0.044070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16011227 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224079 LIMIT 5 [ RunTime:0.075163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224079 ORDER BY `minOrder` ASC [ RunTime:0.025947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224079 ORDER BY `unit` DESC [ RunTime:0.026143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224079 LIMIT 2 [ RunTime:0.015305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224079 ORDER BY `minOrder` ASC [ RunTime:0.018478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223164 LIMIT 5 [ RunTime:0.022973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223164 ORDER BY `minOrder` ASC [ RunTime:0.010140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223164 ORDER BY `unit` DESC [ RunTime:0.010893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223164 LIMIT 2 [ RunTime:0.002346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223164 ORDER BY `minOrder` ASC [ RunTime:0.004750s ]
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 '105901%' OR `brand` LIKE '105901%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014037s ]
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 '105901%' OR `brand` LIKE '105901%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802991 LIMIT 5 [ RunTime:0.011320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802991 ORDER BY `minOrder` ASC [ RunTime:0.002905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802991 ORDER BY `unit` DESC [ RunTime:0.011809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802991 LIMIT 2 [ RunTime:0.016313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802991 ORDER BY `minOrder` ASC [ RunTime:0.014685s ]
select * from pdf where partno='1059013' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010497s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059013' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009646s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802991 AND `partno` = '1059013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772406 [ RunTime:0.000560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802937 LIMIT 5 [ RunTime:0.010722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802937 ORDER BY `minOrder` ASC [ RunTime:0.017594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802937 ORDER BY `unit` DESC [ RunTime:0.021149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802937 LIMIT 2 [ RunTime:0.002869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802937 ORDER BY `minOrder` ASC [ RunTime:0.011705s ]
select * from pdf where partno='1059018' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059018' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006804s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802937 AND `partno` = '1059018' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772367 [ RunTime:0.029912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802572 LIMIT 5 [ RunTime:0.014096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802572 ORDER BY `minOrder` ASC [ RunTime:0.008730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802572 ORDER BY `unit` DESC [ RunTime:0.006481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802572 LIMIT 2 [ RunTime:0.007429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802572 ORDER BY `minOrder` ASC [ RunTime:0.002120s ]
select * from pdf where partno='1059016' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059016' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001864s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802572 AND `partno` = '1059016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16011227 [ RunTime:0.012548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802173 LIMIT 5 [ RunTime:0.019731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802173 ORDER BY `minOrder` ASC [ RunTime:0.027460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802173 ORDER BY `unit` DESC [ RunTime:0.020557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802173 LIMIT 2 [ RunTime:0.024246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802173 ORDER BY `minOrder` ASC [ RunTime:0.025067s ]
select * from pdf where partno='1059017' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059017' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010428s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802173 AND `partno` = '1059017' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979878 [ RunTime:0.019423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64801448 LIMIT 5 [ RunTime:0.004648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801448 ORDER BY `minOrder` ASC [ RunTime:0.008450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64801448 ORDER BY `unit` DESC [ RunTime:0.008495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64801448 LIMIT 2 [ RunTime:0.002432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64801448 ORDER BY `minOrder` ASC [ RunTime:0.007284s ]
select * from pdf where partno='1059015' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059015' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033077s ]
SELECT `id` FROM `stock` WHERE `id` <> 64801448 AND `partno` = '1059015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223164 [ RunTime:0.007164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63377813 LIMIT 5 [ RunTime:0.019766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63377813 ORDER BY `minOrder` ASC [ RunTime:0.011815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63377813 ORDER BY `unit` DESC [ RunTime:0.007464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63377813 LIMIT 2 [ RunTime:0.015205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63377813 ORDER BY `minOrder` ASC [ RunTime:0.003336s ]
select * from pdf where partno='105901' and brandshort='Brady Corporation' limit 1 [ RunTime:0.010841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '105901' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005696s ]
SELECT `id` FROM `stock` WHERE `id` <> 63377813 AND `partno` = '105901' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16620951 [ RunTime:0.000785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38512922 LIMIT 5 [ RunTime:0.000840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38512922 ORDER BY `minOrder` ASC [ RunTime:0.005568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38512922 ORDER BY `unit` DESC [ RunTime:0.006412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38512922 LIMIT 2 [ RunTime:0.013461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38512922 ORDER BY `minOrder` ASC [ RunTime:0.008258s ]
select * from pdf where partno='1059011' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1059011' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004691s ]
SELECT `id` FROM `stock` WHERE `id` <> 38512922 AND `partno` = '1059011' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224079 [ RunTime:0.001675s ]
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 '105901%' OR `brand` LIKE '105901%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013401s ]
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 '105901%' OR `brand` LIKE '105901%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050553s ]
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 '105901%' OR `brand` LIKE '105901%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022786s ]
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 '105901%' OR `brand` LIKE '105901%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014824s ]
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 '105901%' OR `brand` LIKE '105901%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026277s ]
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 '105901%' OR `brand` LIKE '105901%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020822s ]
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 '105901%' OR `brand` LIKE '105901%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015648s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '105901%' OR `brand` LIKE '105901%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041138s ]