SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003098s ]
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 '25618%' OR `brand` LIKE '25618%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.148099s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.071621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17008562 LIMIT 5 [ RunTime:0.017599s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17008562 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17008562 ORDER BY `unit` DESC [ RunTime:0.051060s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.062924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17008562 LIMIT 2 [ RunTime:0.046686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17008562 ORDER BY `minOrder` ASC [ RunTime:0.089954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433423 LIMIT 5 [ RunTime:0.092145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433423 ORDER BY `minOrder` ASC [ RunTime:0.064526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16433423 ORDER BY `unit` DESC [ RunTime:0.139334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16433423 LIMIT 2 [ RunTime:0.114894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16433423 ORDER BY `minOrder` ASC [ RunTime:0.044077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552445 LIMIT 5 [ RunTime:0.051586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552445 ORDER BY `minOrder` ASC [ RunTime:0.125923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13552445 ORDER BY `unit` DESC [ RunTime:0.201431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13552445 LIMIT 2 [ RunTime:0.100161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13552445 ORDER BY `minOrder` ASC [ RunTime:0.094551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12185220 LIMIT 5 [ RunTime:0.081749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12185220 ORDER BY `minOrder` ASC [ RunTime:0.130293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12185220 ORDER BY `unit` DESC [ RunTime:0.118953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12185220 LIMIT 2 [ RunTime:0.095302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12185220 ORDER BY `minOrder` ASC [ RunTime:0.060579s ]
select * from pdf where partno='25618B' and brandshort='Dremel' limit 1 [ RunTime:0.091589s ]
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 '25618%' OR `brand` LIKE '25618%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074223s ]
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 '25618%' OR `brand` LIKE '25618%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57707561 LIMIT 5 [ RunTime:0.080922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57707561 ORDER BY `minOrder` ASC [ RunTime:0.121017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57707561 ORDER BY `unit` DESC [ RunTime:0.098963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57707561 LIMIT 2 [ RunTime:0.140322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57707561 ORDER BY `minOrder` ASC [ RunTime:0.087340s ]
select * from pdf where partno='25618' and brandshort='Brady Corporation' limit 1 [ RunTime:0.070105s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25618' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.104239s ]
SELECT `id` FROM `stock` WHERE `id` <> 57707561 AND `partno` = '25618' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.043188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13552445 [ RunTime:0.127345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56263707 LIMIT 5 [ RunTime:0.159610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56263707 ORDER BY `minOrder` ASC [ RunTime:0.126549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56263707 ORDER BY `unit` DESC [ RunTime:0.154566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56263707 LIMIT 2 [ RunTime:0.090431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56263707 ORDER BY `minOrder` ASC [ RunTime:0.047642s ]
select * from pdf where partno='25618.9' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.031232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25618.9' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.071377s ]
SELECT `id` FROM `stock` WHERE `id` <> 56263707 AND `partno` = '25618.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.217617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16433423 [ RunTime:0.141299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51689057 LIMIT 5 [ RunTime:0.129017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51689057 ORDER BY `minOrder` ASC [ RunTime:0.077319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51689057 ORDER BY `unit` DESC [ RunTime:0.171450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51689057 LIMIT 2 [ RunTime:0.044845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51689057 ORDER BY `minOrder` ASC [ RunTime:0.032458s ]
select * from pdf where partno='25618B' and brandshort='Dremel' limit 1 [ RunTime:0.027782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25618B' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.114754s ]
SELECT `id` FROM `stock` WHERE `id` <> 51689057 AND `partno` = '25618B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.017075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12185220 [ RunTime:0.037535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44014354 LIMIT 5 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44014354 ORDER BY `minOrder` ASC [ RunTime:0.036411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44014354 ORDER BY `unit` DESC [ RunTime:0.066192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44014354 LIMIT 2 [ RunTime:0.042867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44014354 ORDER BY `minOrder` ASC [ RunTime:0.012791s ]
select * from pdf where partno='2561810000' and brandshort='Weidmüller' limit 1 [ RunTime:0.058733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2561810000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.022927s ]
SELECT `id` FROM `stock` WHERE `id` <> 44014354 AND `partno` = '2561810000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.030317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17008562 [ RunTime:0.007536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32585218 LIMIT 5 [ RunTime:0.035108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32585218 ORDER BY `minOrder` ASC [ RunTime:0.098667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32585218 ORDER BY `unit` DESC [ RunTime:0.049695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32585218 LIMIT 2 [ RunTime:0.043688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32585218 ORDER BY `minOrder` ASC [ RunTime:0.003835s ]
select * from pdf where partno='256183' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.027181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '256183' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.051158s ]
SELECT `id` FROM `stock` WHERE `id` <> 32585218 AND `partno` = '256183' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.016598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32534710 LIMIT 5 [ RunTime:0.019919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32534710 ORDER BY `minOrder` ASC [ RunTime:0.029103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32534710 ORDER BY `unit` DESC [ RunTime:0.023946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32534710 LIMIT 2 [ RunTime:0.085152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32534710 ORDER BY `minOrder` ASC [ RunTime:0.019245s ]
select * from pdf where partno='256182' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.038772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '256182' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.064004s ]
SELECT `id` FROM `stock` WHERE `id` <> 32534710 AND `partno` = '256182' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.042323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32512828 LIMIT 5 [ RunTime:0.019102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32512828 ORDER BY `minOrder` ASC [ RunTime:0.095991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32512828 ORDER BY `unit` DESC [ RunTime:0.072809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32512828 LIMIT 2 [ RunTime:0.093821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32512828 ORDER BY `minOrder` ASC [ RunTime:0.042875s ]
select * from pdf where partno='256181' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.039728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '256181' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.091397s ]
SELECT `id` FROM `stock` WHERE `id` <> 32512828 AND `partno` = '256181' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.044156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32506041 LIMIT 5 [ RunTime:0.035442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32506041 ORDER BY `minOrder` ASC [ RunTime:0.048562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32506041 ORDER BY `unit` DESC [ RunTime:0.125817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32506041 LIMIT 2 [ RunTime:0.043292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32506041 ORDER BY `minOrder` ASC [ RunTime:0.056726s ]
select * from pdf where partno='256180' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.002970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '256180' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.049049s ]
SELECT `id` FROM `stock` WHERE `id` <> 32506041 AND `partno` = '256180' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.077643s ]
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 '25618%' OR `brand` LIKE '25618%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068407s ]
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 '25618%' OR `brand` LIKE '25618%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.102229s ]
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 '25618%' OR `brand` LIKE '25618%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019413s ]
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 '25618%' OR `brand` LIKE '25618%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024231s ]
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 '25618%' OR `brand` LIKE '25618%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035760s ]
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 '25618%' OR `brand` LIKE '25618%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021715s ]
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 '25618%' OR `brand` LIKE '25618%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042517s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25618%' OR `brand` LIKE '25618%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030730s ]