SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001839s ]
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 '2D25%' OR `brand` LIKE '2D25%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009383s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724546 LIMIT 5 [ RunTime:0.006089s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724546 ORDER BY `minOrder` ASC [ RunTime:0.001269s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14724546 ORDER BY `unit` DESC [ RunTime:0.012006s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14724546 LIMIT 2 [ RunTime:0.011798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724546 ORDER BY `minOrder` ASC [ RunTime:0.002329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14728737 LIMIT 5 [ RunTime:0.012445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14728737 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14728737 ORDER BY `unit` DESC [ RunTime:0.007521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14728737 LIMIT 2 [ RunTime:0.011215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14728737 ORDER BY `minOrder` ASC [ RunTime:0.008569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724857 LIMIT 5 [ RunTime:0.017994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724857 ORDER BY `minOrder` ASC [ RunTime:0.025899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14724857 ORDER BY `unit` DESC [ RunTime:0.052668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14724857 LIMIT 2 [ RunTime:0.023766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14724857 ORDER BY `minOrder` ASC [ RunTime:0.015044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13841579 LIMIT 5 [ RunTime:0.013355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13841579 ORDER BY `minOrder` ASC [ RunTime:0.025253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13841579 ORDER BY `unit` DESC [ RunTime:0.011289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13841579 LIMIT 2 [ RunTime:0.020514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13841579 ORDER BY `minOrder` ASC [ RunTime:0.005647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13831074 LIMIT 5 [ RunTime:0.020129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13831074 ORDER BY `minOrder` ASC [ RunTime:0.018884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13831074 ORDER BY `unit` DESC [ RunTime:0.008936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13831074 LIMIT 2 [ RunTime:0.010873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13831074 ORDER BY `minOrder` ASC [ RunTime:0.010870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12438841 LIMIT 5 [ RunTime:0.039430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12438841 ORDER BY `minOrder` ASC [ RunTime:0.028713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12438841 ORDER BY `unit` DESC [ RunTime:0.015574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12438841 LIMIT 2 [ RunTime:0.026728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12438841 ORDER BY `minOrder` ASC [ RunTime:0.006912s ]
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 '2D25%' OR `brand` LIKE '2D25%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008497s ]
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 '2D25%' OR `brand` LIKE '2D25%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58397325 LIMIT 5 [ RunTime:0.002189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58397325 ORDER BY `minOrder` ASC [ RunTime:0.010115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58397325 ORDER BY `unit` DESC [ RunTime:0.017443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58397325 LIMIT 2 [ RunTime:0.048417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58397325 ORDER BY `minOrder` ASC [ RunTime:0.022529s ]
select * from pdf where partno='2D25' and brandshort='WEC' limit 1 [ RunTime:0.020263s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2D25' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.015435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43884016 LIMIT 5 [ RunTime:0.016404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884016 ORDER BY `minOrder` ASC [ RunTime:0.016418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43884016 ORDER BY `unit` DESC [ RunTime:0.025245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43884016 LIMIT 2 [ RunTime:0.016699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884016 ORDER BY `minOrder` ASC [ RunTime:0.010670s ]
select * from pdf where partno='2D25' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.035307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2D25' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.030032s ]
SELECT `id` FROM `stock` WHERE `id` <> 43884016 AND `partno` = '2D25' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.023898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12438841 [ RunTime:0.040694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42008417 LIMIT 5 [ RunTime:0.053812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42008417 ORDER BY `minOrder` ASC [ RunTime:0.065713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42008417 ORDER BY `unit` DESC [ RunTime:0.021731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42008417 LIMIT 2 [ RunTime:0.016218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42008417 ORDER BY `minOrder` ASC [ RunTime:0.012069s ]
select * from pdf where partno='2D25GL' and brandshort='Altech Corporation' limit 1 [ RunTime:0.022416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2D25GL' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.009386s ]
SELECT `id` FROM `stock` WHERE `id` <> 42008417 AND `partno` = '2D25GL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.024085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13841579 [ RunTime:0.046326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41968221 LIMIT 5 [ RunTime:0.048037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41968221 ORDER BY `minOrder` ASC [ RunTime:0.071898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41968221 ORDER BY `unit` DESC [ RunTime:0.041279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41968221 LIMIT 2 [ RunTime:0.038812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41968221 ORDER BY `minOrder` ASC [ RunTime:0.001460s ]
select * from pdf where partno='2D25DL' and brandshort='Altech Corporation' limit 1 [ RunTime:0.015248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2D25DL' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.022256s ]
SELECT `id` FROM `stock` WHERE `id` <> 41968221 AND `partno` = '2D25DL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.040831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14728737 [ RunTime:0.067304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41937092 LIMIT 5 [ RunTime:0.025786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41937092 ORDER BY `minOrder` ASC [ RunTime:0.044589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41937092 ORDER BY `unit` DESC [ RunTime:0.075083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41937092 LIMIT 2 [ RunTime:0.051599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41937092 ORDER BY `minOrder` ASC [ RunTime:0.025979s ]
select * from pdf where partno='2D25UM' and brandshort='Altech Corporation' limit 1 [ RunTime:0.044316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2D25UM' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.062836s ]
SELECT `id` FROM `stock` WHERE `id` <> 41937092 AND `partno` = '2D25UM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.090220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724857 [ RunTime:0.037423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41911136 LIMIT 5 [ RunTime:0.028193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41911136 ORDER BY `minOrder` ASC [ RunTime:0.036519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41911136 ORDER BY `unit` DESC [ RunTime:0.054957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41911136 LIMIT 2 [ RunTime:0.045423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41911136 ORDER BY `minOrder` ASC [ RunTime:0.016771s ]
select * from pdf where partno='2D25UR' and brandshort='Altech Corporation' limit 1 [ RunTime:0.046211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2D25UR' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.032042s ]
SELECT `id` FROM `stock` WHERE `id` <> 41911136 AND `partno` = '2D25UR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.022711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13831074 [ RunTime:0.010158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41872213 LIMIT 5 [ RunTime:0.050863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41872213 ORDER BY `minOrder` ASC [ RunTime:0.033097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41872213 ORDER BY `unit` DESC [ RunTime:0.039425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41872213 LIMIT 2 [ RunTime:0.013655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41872213 ORDER BY `minOrder` ASC [ RunTime:0.002699s ]
select * from pdf where partno='2D25UL' and brandshort='Altech Corporation' limit 1 [ RunTime:0.034108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2D25UL' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.014349s ]
SELECT `id` FROM `stock` WHERE `id` <> 41872213 AND `partno` = '2D25UL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.048716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14724546 [ RunTime:0.045242s ]
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 '2D25%' OR `brand` LIKE '2D25%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016572s ]
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 '2D25%' OR `brand` LIKE '2D25%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003703s ]
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 '2D25%' OR `brand` LIKE '2D25%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024392s ]
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 '2D25%' OR `brand` LIKE '2D25%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035808s ]
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 '2D25%' OR `brand` LIKE '2D25%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038711s ]
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 '2D25%' OR `brand` LIKE '2D25%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014753s ]
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 '2D25%' OR `brand` LIKE '2D25%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052510s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2D25%' OR `brand` LIKE '2D25%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041486s ]