SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001241s ]
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 '105893%' OR `brand` LIKE '105893%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045524s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772368 LIMIT 5 [ RunTime:0.060204s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772368 ORDER BY `minOrder` ASC [ RunTime:0.069249s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.020974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772368 ORDER BY `unit` DESC [ RunTime:0.035727s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.034224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772368 LIMIT 2 [ RunTime:0.067727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772368 ORDER BY `minOrder` ASC [ RunTime:0.049727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771975 LIMIT 5 [ RunTime:0.038326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771975 ORDER BY `minOrder` ASC [ RunTime:0.047804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18771975 ORDER BY `unit` DESC [ RunTime:0.055242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18771975 LIMIT 2 [ RunTime:0.071333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771975 ORDER BY `minOrder` ASC [ RunTime:0.030915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17508798 LIMIT 5 [ RunTime:0.046413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508798 ORDER BY `minOrder` ASC [ RunTime:0.074668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17508798 ORDER BY `unit` DESC [ RunTime:0.065061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17508798 LIMIT 2 [ RunTime:0.076747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508798 ORDER BY `minOrder` ASC [ RunTime:0.001661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010920 LIMIT 5 [ RunTime:0.058364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010920 ORDER BY `minOrder` ASC [ RunTime:0.055768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17010920 ORDER BY `unit` DESC [ RunTime:0.021197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17010920 LIMIT 2 [ RunTime:0.092018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010920 ORDER BY `minOrder` ASC [ RunTime:0.054013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010582 LIMIT 5 [ RunTime:0.058683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010582 ORDER BY `minOrder` ASC [ RunTime:0.072419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17010582 ORDER BY `unit` DESC [ RunTime:0.048864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17010582 LIMIT 2 [ RunTime:0.043534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17010582 ORDER BY `minOrder` ASC [ RunTime:0.014565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266023 LIMIT 5 [ RunTime:0.048954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266023 ORDER BY `minOrder` ASC [ RunTime:0.039898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15266023 ORDER BY `unit` DESC [ RunTime:0.032915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15266023 LIMIT 2 [ RunTime:0.030149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266023 ORDER BY `minOrder` ASC [ RunTime:0.031507s ]
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 '105893%' OR `brand` LIKE '105893%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009517s ]
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 '105893%' OR `brand` LIKE '105893%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64804393 LIMIT 5 [ RunTime:0.009421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804393 ORDER BY `minOrder` ASC [ RunTime:0.007815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64804393 ORDER BY `unit` DESC [ RunTime:0.013907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64804393 LIMIT 2 [ RunTime:0.033187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804393 ORDER BY `minOrder` ASC [ RunTime:0.019533s ]
select * from pdf where partno='1058934' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008785s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1058934' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020297s ]
SELECT `id` FROM `stock` WHERE `id` <> 64804393 AND `partno` = '1058934' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010582 [ RunTime:0.008539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802940 LIMIT 5 [ RunTime:0.002729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802940 ORDER BY `minOrder` ASC [ RunTime:0.002755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802940 ORDER BY `unit` DESC [ RunTime:0.005211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802940 LIMIT 2 [ RunTime:0.047288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802940 ORDER BY `minOrder` ASC [ RunTime:0.016134s ]
select * from pdf where partno='1058936' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.031011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1058936' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018288s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802940 AND `partno` = '1058936' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772368 [ RunTime:0.003958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802701 LIMIT 5 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802701 ORDER BY `minOrder` ASC [ RunTime:0.013571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802701 ORDER BY `unit` DESC [ RunTime:0.014793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802701 LIMIT 2 [ RunTime:0.005846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802701 ORDER BY `minOrder` ASC [ RunTime:0.003702s ]
select * from pdf where partno='1058933' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1058933' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003025s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802701 AND `partno` = '1058933' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266023 [ RunTime:0.000721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802186 LIMIT 5 [ RunTime:0.009543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802186 ORDER BY `minOrder` ASC [ RunTime:0.005829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802186 ORDER BY `unit` DESC [ RunTime:0.000892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802186 LIMIT 2 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802186 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
select * from pdf where partno='1058939' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1058939' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000767s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802186 AND `partno` = '1058939' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771975 [ RunTime:0.000802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38513295 LIMIT 5 [ RunTime:0.002236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38513295 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38513295 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38513295 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38513295 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='1058937' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1058937' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000430s ]
SELECT `id` FROM `stock` WHERE `id` <> 38513295 AND `partno` = '1058937' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010920 [ RunTime:0.000404s ]
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 '105893%' OR `brand` LIKE '105893%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001316s ]
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 '105893%' OR `brand` LIKE '105893%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006358s ]
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 '105893%' OR `brand` LIKE '105893%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002321s ]
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 '105893%' OR `brand` LIKE '105893%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002946s ]
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 '105893%' OR `brand` LIKE '105893%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002337s ]
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 '105893%' OR `brand` LIKE '105893%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001564s ]
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 '105893%' OR `brand` LIKE '105893%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007036s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '105893%' OR `brand` LIKE '105893%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001611s ]