SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002826s ]
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 '40763%' OR `brand` LIKE '40763%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003913s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441226 LIMIT 5 [ RunTime:0.019774s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441226 ORDER BY `minOrder` ASC [ RunTime:0.017463s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15441226 ORDER BY `unit` DESC [ RunTime:0.003580s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15441226 LIMIT 2 [ RunTime:0.002294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441226 ORDER BY `minOrder` ASC [ RunTime:0.002923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424450 LIMIT 5 [ RunTime:0.032817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424450 ORDER BY `minOrder` ASC [ RunTime:0.010093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14424450 ORDER BY `unit` DESC [ RunTime:0.013279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14424450 LIMIT 2 [ RunTime:0.020463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14424450 ORDER BY `minOrder` ASC [ RunTime:0.006522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290373 LIMIT 5 [ RunTime:0.016709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290373 ORDER BY `minOrder` ASC [ RunTime:0.015015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290373 ORDER BY `unit` DESC [ RunTime:0.023062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290373 LIMIT 2 [ RunTime:0.010470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290373 ORDER BY `minOrder` ASC [ RunTime:0.014003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13287664 LIMIT 5 [ RunTime:0.039025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13287664 ORDER BY `minOrder` ASC [ RunTime:0.031684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13287664 ORDER BY `unit` DESC [ RunTime:0.035596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13287664 LIMIT 2 [ RunTime:0.007195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13287664 ORDER BY `minOrder` ASC [ RunTime:0.009931s ]
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 '40763%' OR `brand` LIKE '40763%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011995s ]
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 '40763%' OR `brand` LIKE '40763%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53815258 LIMIT 5 [ RunTime:0.012976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53815258 ORDER BY `minOrder` ASC [ RunTime:0.011699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53815258 ORDER BY `unit` DESC [ RunTime:0.006430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53815258 LIMIT 2 [ RunTime:0.013202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53815258 ORDER BY `minOrder` ASC [ RunTime:0.006883s ]
select * from pdf where partno='40763' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004511s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40763' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.019478s ]
SELECT `id` FROM `stock` WHERE `id` <> 53815258 AND `partno` = '40763' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441226 [ RunTime:0.030795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50710714 LIMIT 5 [ RunTime:0.006717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710714 ORDER BY `minOrder` ASC [ RunTime:0.011860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50710714 ORDER BY `unit` DESC [ RunTime:0.019404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50710714 LIMIT 2 [ RunTime:0.011452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710714 ORDER BY `minOrder` ASC [ RunTime:0.005226s ]
select * from pdf where partno='40763' and brandshort='Brady Corporation' limit 1 [ RunTime:0.027522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40763' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.028573s ]
SELECT `id` FROM `stock` WHERE `id` <> 50710714 AND `partno` = '40763' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424450 [ RunTime:0.026150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38098572 LIMIT 5 [ RunTime:0.010019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38098572 ORDER BY `minOrder` ASC [ RunTime:0.022455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38098572 ORDER BY `unit` DESC [ RunTime:0.003534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38098572 LIMIT 2 [ RunTime:0.002405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38098572 ORDER BY `minOrder` ASC [ RunTime:0.002894s ]
select * from pdf where partno='40763' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40763' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002357s ]
SELECT `id` FROM `stock` WHERE `id` <> 38098572 AND `partno` = '40763' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.011508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14424450 [ RunTime:0.001396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32592331 LIMIT 5 [ RunTime:0.014506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32592331 ORDER BY `minOrder` ASC [ RunTime:0.006061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32592331 ORDER BY `unit` DESC [ RunTime:0.016075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32592331 LIMIT 2 [ RunTime:0.015118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32592331 ORDER BY `minOrder` ASC [ RunTime:0.015318s ]
select * from pdf where partno='4076391' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4076391' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006159s ]
SELECT `id` FROM `stock` WHERE `id` <> 32592331 AND `partno` = '4076391' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290373 [ RunTime:0.008420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32507487 LIMIT 5 [ RunTime:0.005487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32507487 ORDER BY `minOrder` ASC [ RunTime:0.005478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32507487 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32507487 LIMIT 2 [ RunTime:0.001835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32507487 ORDER BY `minOrder` ASC [ RunTime:0.003580s ]
select * from pdf where partno='4076323-51' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4076323-51' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.002469s ]
SELECT `id` FROM `stock` WHERE `id` <> 32507487 AND `partno` = '4076323-51' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.002190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13287664 [ RunTime:0.002440s ]
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 '40763%' OR `brand` LIKE '40763%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002217s ]
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 '40763%' OR `brand` LIKE '40763%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006684s ]
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 '40763%' OR `brand` LIKE '40763%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002941s ]
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 '40763%' OR `brand` LIKE '40763%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007440s ]
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 '40763%' OR `brand` LIKE '40763%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011622s ]
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 '40763%' OR `brand` LIKE '40763%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003446s ]
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 '40763%' OR `brand` LIKE '40763%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022759s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40763%' OR `brand` LIKE '40763%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006916s ]