SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002185s ]
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 '30530%' OR `brand` LIKE '30530%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021861s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11183855 LIMIT 5 [ RunTime:0.067290s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.023736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11183855 ORDER BY `minOrder` ASC [ RunTime:0.042572s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.033018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11183855 ORDER BY `unit` DESC [ RunTime:0.040236s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11183855 LIMIT 2 [ RunTime:0.041011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11183855 ORDER BY `minOrder` ASC [ RunTime:0.029116s ]
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 '30530%' OR `brand` LIKE '30530%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047159s ]
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 '30530%' OR `brand` LIKE '30530%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43761541 LIMIT 5 [ RunTime:0.030804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43761541 ORDER BY `minOrder` ASC [ RunTime:0.065413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43761541 ORDER BY `unit` DESC [ RunTime:0.107138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43761541 LIMIT 2 [ RunTime:0.088060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43761541 ORDER BY `minOrder` ASC [ RunTime:0.030709s ]
select * from pdf where partno='3053010000' and brandshort='Weidmüller' limit 1 [ RunTime:0.053651s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053010000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.037131s ]
SELECT `id` FROM `stock` WHERE `id` <> 43761541 AND `partno` = '3053010000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.026203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63404595 LIMIT 5 [ RunTime:0.096421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63404595 ORDER BY `minOrder` ASC [ RunTime:0.035944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63404595 ORDER BY `unit` DESC [ RunTime:0.034061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63404595 LIMIT 2 [ RunTime:0.084306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63404595 ORDER BY `minOrder` ASC [ RunTime:0.014769s ]
select * from pdf where partno='305308059902' and brandshort='Essentra Components' limit 1 [ RunTime:0.034439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '305308059902' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.115441s ]
SELECT `id` FROM `stock` WHERE `id` <> 63404595 AND `partno` = '305308059902' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.107298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58525458 LIMIT 5 [ RunTime:0.031744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525458 ORDER BY `minOrder` ASC [ RunTime:0.021242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58525458 ORDER BY `unit` DESC [ RunTime:0.041151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58525458 LIMIT 2 [ RunTime:0.029633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525458 ORDER BY `minOrder` ASC [ RunTime:0.015656s ]
select * from pdf where partno='30530' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.015520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30530' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.049868s ]
SELECT `id` FROM `stock` WHERE `id` <> 58525458 AND `partno` = '30530' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.040825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43771968 LIMIT 5 [ RunTime:0.025460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771968 ORDER BY `minOrder` ASC [ RunTime:0.067075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43771968 ORDER BY `unit` DESC [ RunTime:0.052202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43771968 LIMIT 2 [ RunTime:0.006097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771968 ORDER BY `minOrder` ASC [ RunTime:0.022513s ]
select * from pdf where partno='3053060000' and brandshort='Weidmüller' limit 1 [ RunTime:0.031083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053060000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.027967s ]
SELECT `id` FROM `stock` WHERE `id` <> 43771968 AND `partno` = '3053060000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.016690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43771877 LIMIT 5 [ RunTime:0.023240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771877 ORDER BY `minOrder` ASC [ RunTime:0.058684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43771877 ORDER BY `unit` DESC [ RunTime:0.010248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43771877 LIMIT 2 [ RunTime:0.009933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771877 ORDER BY `minOrder` ASC [ RunTime:0.002566s ]
select * from pdf where partno='3053030000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053030000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011601s ]
SELECT `id` FROM `stock` WHERE `id` <> 43771877 AND `partno` = '3053030000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43771785 LIMIT 5 [ RunTime:0.013226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771785 ORDER BY `minOrder` ASC [ RunTime:0.019472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43771785 ORDER BY `unit` DESC [ RunTime:0.011006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43771785 LIMIT 2 [ RunTime:0.000779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771785 ORDER BY `minOrder` ASC [ RunTime:0.004603s ]
select * from pdf where partno='3053090000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053090000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.025763s ]
SELECT `id` FROM `stock` WHERE `id` <> 43771785 AND `partno` = '3053090000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.014563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43771556 LIMIT 5 [ RunTime:0.007697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771556 ORDER BY `minOrder` ASC [ RunTime:0.013459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43771556 ORDER BY `unit` DESC [ RunTime:0.007083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43771556 LIMIT 2 [ RunTime:0.014180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771556 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
select * from pdf where partno='3053020000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053020000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001772s ]
SELECT `id` FROM `stock` WHERE `id` <> 43771556 AND `partno` = '3053020000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43771555 LIMIT 5 [ RunTime:0.015496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771555 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43771555 ORDER BY `unit` DESC [ RunTime:0.003213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43771555 LIMIT 2 [ RunTime:0.005267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771555 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='3053050000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053050000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009787s ]
SELECT `id` FROM `stock` WHERE `id` <> 43771555 AND `partno` = '3053050000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43771454 LIMIT 5 [ RunTime:0.006301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771454 ORDER BY `minOrder` ASC [ RunTime:0.019918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43771454 ORDER BY `unit` DESC [ RunTime:0.002481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43771454 LIMIT 2 [ RunTime:0.000879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771454 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='3053040000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053040000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.022642s ]
SELECT `id` FROM `stock` WHERE `id` <> 43771454 AND `partno` = '3053040000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.020953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43771341 LIMIT 5 [ RunTime:0.006529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771341 ORDER BY `minOrder` ASC [ RunTime:0.008786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43771341 ORDER BY `unit` DESC [ RunTime:0.011340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43771341 LIMIT 2 [ RunTime:0.003518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771341 ORDER BY `minOrder` ASC [ RunTime:0.010745s ]
select * from pdf where partno='3053080000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053080000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.027256s ]
SELECT `id` FROM `stock` WHERE `id` <> 43771341 AND `partno` = '3053080000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.014251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43771337 LIMIT 5 [ RunTime:0.017715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771337 ORDER BY `minOrder` ASC [ RunTime:0.047348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43771337 ORDER BY `unit` DESC [ RunTime:0.035854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43771337 LIMIT 2 [ RunTime:0.018571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771337 ORDER BY `minOrder` ASC [ RunTime:0.010393s ]
select * from pdf where partno='3053070000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053070000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.021600s ]
SELECT `id` FROM `stock` WHERE `id` <> 43771337 AND `partno` = '3053070000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.029571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43771132 LIMIT 5 [ RunTime:0.015438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771132 ORDER BY `minOrder` ASC [ RunTime:0.011289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43771132 ORDER BY `unit` DESC [ RunTime:0.031124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43771132 LIMIT 2 [ RunTime:0.041253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43771132 ORDER BY `minOrder` ASC [ RunTime:0.018243s ]
select * from pdf where partno='3053000000' and brandshort='Weidmüller' limit 1 [ RunTime:0.029006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3053000000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.075062s ]
SELECT `id` FROM `stock` WHERE `id` <> 43771132 AND `partno` = '3053000000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.032583s ]
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 '30530%' OR `brand` LIKE '30530%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.084504s ]
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 '30530%' OR `brand` LIKE '30530%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058707s ]
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 '30530%' OR `brand` LIKE '30530%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.102730s ]
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 '30530%' OR `brand` LIKE '30530%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015816s ]
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 '30530%' OR `brand` LIKE '30530%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061258s ]
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 '30530%' OR `brand` LIKE '30530%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074991s ]
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 '30530%' OR `brand` LIKE '30530%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079775s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '30530%' OR `brand` LIKE '30530%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.126687s ]