SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001421s ]
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 '106732%' OR `brand` LIKE '106732%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051433s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352414 LIMIT 5 [ RunTime:0.101978s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352414 ORDER BY `minOrder` ASC [ RunTime:0.050627s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352414 ORDER BY `unit` DESC [ RunTime:0.179313s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.180798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352414 LIMIT 2 [ RunTime:0.114233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352414 ORDER BY `minOrder` ASC [ RunTime:0.102359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13358777 LIMIT 5 [ RunTime:0.045164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13358777 ORDER BY `minOrder` ASC [ RunTime:0.191623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13358777 ORDER BY `unit` DESC [ RunTime:0.029486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13358777 LIMIT 2 [ RunTime:0.022357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13358777 ORDER BY `minOrder` ASC [ RunTime:0.109887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666663 LIMIT 5 [ RunTime:0.051067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666663 ORDER BY `minOrder` ASC [ RunTime:0.082436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19666663 ORDER BY `unit` DESC [ RunTime:0.041381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19666663 LIMIT 2 [ RunTime:0.109608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666663 ORDER BY `minOrder` ASC [ RunTime:0.043619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779733 LIMIT 5 [ RunTime:0.115855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779733 ORDER BY `minOrder` ASC [ RunTime:0.076086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779733 ORDER BY `unit` DESC [ RunTime:0.088499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779733 LIMIT 2 [ RunTime:0.249216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779733 ORDER BY `minOrder` ASC [ RunTime:0.057683s ]
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 '106732%' OR `brand` LIKE '106732%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.099972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235687 LIMIT 5 [ RunTime:0.163549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235687 ORDER BY `minOrder` ASC [ RunTime:0.104715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235687 ORDER BY `unit` DESC [ RunTime:0.027415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235687 LIMIT 2 [ RunTime:0.082212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235687 ORDER BY `minOrder` ASC [ RunTime:0.066518s ]
select * from pdf where partno='106732' and brandshort='basler' limit 1 [ RunTime:0.036027s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106732' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.014347s ]
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 '106732%' OR `brand` LIKE '106732%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64125824 LIMIT 5 [ RunTime:0.024916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64125824 ORDER BY `minOrder` ASC [ RunTime:0.070399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64125824 ORDER BY `unit` DESC [ RunTime:0.046249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64125824 LIMIT 2 [ RunTime:0.084693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64125824 ORDER BY `minOrder` ASC [ RunTime:0.009034s ]
select * from pdf where partno='1067325' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.028292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067325' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.041488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64116822 LIMIT 5 [ RunTime:0.082713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64116822 ORDER BY `minOrder` ASC [ RunTime:0.067383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64116822 ORDER BY `unit` DESC [ RunTime:0.034615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64116822 LIMIT 2 [ RunTime:0.012962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64116822 ORDER BY `minOrder` ASC [ RunTime:0.015752s ]
select * from pdf where partno='1067327' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.017350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067327' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.028173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63344672 LIMIT 5 [ RunTime:0.045184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63344672 ORDER BY `minOrder` ASC [ RunTime:0.020776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63344672 ORDER BY `unit` DESC [ RunTime:0.042661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63344672 LIMIT 2 [ RunTime:0.037250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63344672 ORDER BY `minOrder` ASC [ RunTime:0.019164s ]
select * from pdf where partno='1067329' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.051061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067329' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.050198s ]
SELECT `id` FROM `stock` WHERE `id` <> 63344672 AND `partno` = '1067329' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779733 [ RunTime:0.105301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63291752 LIMIT 5 [ RunTime:0.049245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63291752 ORDER BY `minOrder` ASC [ RunTime:0.014713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63291752 ORDER BY `unit` DESC [ RunTime:0.016917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63291752 LIMIT 2 [ RunTime:0.013645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63291752 ORDER BY `minOrder` ASC [ RunTime:0.034518s ]
select * from pdf where partno='106732' and brandshort='Basler Inc.' limit 1 [ RunTime:0.042497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106732' OR `brand` LIKE 'Basler Inc.%' ) ) LIMIT 1 [ RunTime:0.017665s ]
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 '106732%' OR `brand` LIKE '106732%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076160s ]
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 '106732%' OR `brand` LIKE '106732%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.078749s ]
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 '106732%' OR `brand` LIKE '106732%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.241831s ]
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 '106732%' OR `brand` LIKE '106732%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082658s ]
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 '106732%' OR `brand` LIKE '106732%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.125062s ]
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 '106732%' OR `brand` LIKE '106732%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.157193s ]
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 '106732%' OR `brand` LIKE '106732%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090366s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '106732%' OR `brand` LIKE '106732%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.105917s ]