SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001228s ]
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 '100000360%' OR `brand` LIKE '100000360%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014046s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828990 LIMIT 5 [ RunTime:0.011096s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828990 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828990 ORDER BY `unit` DESC [ RunTime:0.016080s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828990 LIMIT 2 [ RunTime:0.006400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828990 ORDER BY `minOrder` ASC [ RunTime:0.006243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17019842 LIMIT 5 [ RunTime:0.030956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17019842 ORDER BY `minOrder` ASC [ RunTime:0.008521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17019842 ORDER BY `unit` DESC [ RunTime:0.011711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17019842 LIMIT 2 [ RunTime:0.004207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17019842 ORDER BY `minOrder` ASC [ RunTime:0.004140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012237 LIMIT 5 [ RunTime:0.016392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012237 ORDER BY `minOrder` ASC [ RunTime:0.038707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16012237 ORDER BY `unit` DESC [ RunTime:0.042559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16012237 LIMIT 2 [ RunTime:0.037137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012237 ORDER BY `minOrder` ASC [ RunTime:0.028194s ]
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 '100000360%' OR `brand` LIKE '100000360%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037649s ]
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 '100000360%' OR `brand` LIKE '100000360%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64237260 LIMIT 5 [ RunTime:0.041534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64237260 ORDER BY `minOrder` ASC [ RunTime:0.048508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64237260 ORDER BY `unit` DESC [ RunTime:0.028648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64237260 LIMIT 2 [ RunTime:0.060888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64237260 ORDER BY `minOrder` ASC [ RunTime:0.031798s ]
select * from pdf where partno='100000360' and brandshort='Amphenol Procom' limit 1 [ RunTime:0.029985s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '100000360' OR `brand` LIKE 'Amphenol Procom%' ) ) LIMIT 1 [ RunTime:0.028116s ]
SELECT `id` FROM `stock` WHERE `id` <> 64237260 AND `partno` = '100000360' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol procom%' ) [ RunTime:0.044205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64059777 LIMIT 5 [ RunTime:0.027098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64059777 ORDER BY `minOrder` ASC [ RunTime:0.055801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64059777 ORDER BY `unit` DESC [ RunTime:0.058553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64059777 LIMIT 2 [ RunTime:0.031071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64059777 ORDER BY `minOrder` ASC [ RunTime:0.015028s ]
select * from pdf where partno='1000003603' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.032646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1000003603' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.048220s ]
SELECT `id` FROM `stock` WHERE `id` <> 64059777 AND `partno` = '1000003603' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.053179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828990 [ RunTime:0.067384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64059625 LIMIT 5 [ RunTime:0.146617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64059625 ORDER BY `minOrder` ASC [ RunTime:0.018627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64059625 ORDER BY `unit` DESC [ RunTime:0.036891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64059625 LIMIT 2 [ RunTime:0.108392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64059625 ORDER BY `minOrder` ASC [ RunTime:0.005141s ]
select * from pdf where partno='1000003607' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.051440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1000003607' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.040052s ]
SELECT `id` FROM `stock` WHERE `id` <> 64059625 AND `partno` = '1000003607' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.041377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17019842 [ RunTime:0.017928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64059460 LIMIT 5 [ RunTime:0.019929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64059460 ORDER BY `minOrder` ASC [ RunTime:0.037367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64059460 ORDER BY `unit` DESC [ RunTime:0.007723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64059460 LIMIT 2 [ RunTime:0.023598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64059460 ORDER BY `minOrder` ASC [ RunTime:0.010920s ]
select * from pdf where partno='1000003604' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.024401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1000003604' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.010100s ]
SELECT `id` FROM `stock` WHERE `id` <> 64059460 AND `partno` = '1000003604' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.004170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012237 [ RunTime:0.002095s ]
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 '100000360%' OR `brand` LIKE '100000360%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008875s ]
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 '100000360%' OR `brand` LIKE '100000360%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023114s ]
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 '100000360%' OR `brand` LIKE '100000360%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004272s ]
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 '100000360%' OR `brand` LIKE '100000360%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018030s ]
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 '100000360%' OR `brand` LIKE '100000360%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001777s ]
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 '100000360%' OR `brand` LIKE '100000360%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001256s ]
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 '100000360%' OR `brand` LIKE '100000360%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008056s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '100000360%' OR `brand` LIKE '100000360%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000783s ]