SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002548s ]
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 '10482%' OR `brand` LIKE '10482%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025150s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.020238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351924 LIMIT 5 [ RunTime:0.032935s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351924 ORDER BY `minOrder` ASC [ RunTime:0.004799s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13351924 ORDER BY `unit` DESC [ RunTime:0.012375s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13351924 LIMIT 2 [ RunTime:0.025873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351924 ORDER BY `minOrder` ASC [ RunTime:0.012579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12867951 LIMIT 5 [ RunTime:0.084005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12867951 ORDER BY `minOrder` ASC [ RunTime:0.019643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12867951 ORDER BY `unit` DESC [ RunTime:0.044420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12867951 LIMIT 2 [ RunTime:0.091179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12867951 ORDER BY `minOrder` ASC [ RunTime:0.038984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632778 LIMIT 5 [ RunTime:0.022117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632778 ORDER BY `minOrder` ASC [ RunTime:0.069494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19632778 ORDER BY `unit` DESC [ RunTime:0.080542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19632778 LIMIT 2 [ RunTime:0.009330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632778 ORDER BY `minOrder` ASC [ RunTime:0.023521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632772 LIMIT 5 [ RunTime:0.068865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632772 ORDER BY `minOrder` ASC [ RunTime:0.016169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19632772 ORDER BY `unit` DESC [ RunTime:0.088198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19632772 LIMIT 2 [ RunTime:0.020572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632772 ORDER BY `minOrder` ASC [ RunTime:0.106745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18851395 LIMIT 5 [ RunTime:0.037722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18851395 ORDER BY `minOrder` ASC [ RunTime:0.058021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18851395 ORDER BY `unit` DESC [ RunTime:0.034601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18851395 LIMIT 2 [ RunTime:0.094647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18851395 ORDER BY `minOrder` ASC [ RunTime:0.015485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18783994 LIMIT 5 [ RunTime:0.034847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18783994 ORDER BY `minOrder` ASC [ RunTime:0.065214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18783994 ORDER BY `unit` DESC [ RunTime:0.046761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18783994 LIMIT 2 [ RunTime:0.029524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18783994 ORDER BY `minOrder` ASC [ RunTime:0.004018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781739 LIMIT 5 [ RunTime:0.046071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781739 ORDER BY `minOrder` ASC [ RunTime:0.018441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781739 ORDER BY `unit` DESC [ RunTime:0.025239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781739 LIMIT 2 [ RunTime:0.030574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781739 ORDER BY `minOrder` ASC [ RunTime:0.001672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225172 LIMIT 5 [ RunTime:0.027236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225172 ORDER BY `minOrder` ASC [ RunTime:0.007584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15225172 ORDER BY `unit` DESC [ RunTime:0.018541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15225172 LIMIT 2 [ RunTime:0.010282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225172 ORDER BY `minOrder` ASC [ RunTime:0.002793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14186808 LIMIT 5 [ RunTime:0.010472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14186808 ORDER BY `minOrder` ASC [ RunTime:0.004351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14186808 ORDER BY `unit` DESC [ RunTime:0.000629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14186808 LIMIT 2 [ RunTime:0.013750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14186808 ORDER BY `minOrder` ASC [ RunTime:0.002455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13298063 LIMIT 5 [ RunTime:0.010046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13298063 ORDER BY `minOrder` ASC [ RunTime:0.012378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13298063 ORDER BY `unit` DESC [ RunTime:0.002085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13298063 LIMIT 2 [ RunTime:0.007455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13298063 ORDER BY `minOrder` ASC [ RunTime:0.010289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13226675 LIMIT 5 [ RunTime:0.005509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13226675 ORDER BY `minOrder` ASC [ RunTime:0.007439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13226675 ORDER BY `unit` DESC [ RunTime:0.009131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13226675 LIMIT 2 [ RunTime:0.015602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13226675 ORDER BY `minOrder` ASC [ RunTime:0.005518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13226655 LIMIT 5 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13226655 ORDER BY `minOrder` ASC [ RunTime:0.005034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13226655 ORDER BY `unit` DESC [ RunTime:0.003627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13226655 LIMIT 2 [ RunTime:0.014685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13226655 ORDER BY `minOrder` ASC [ RunTime:0.003937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520954 LIMIT 5 [ RunTime:0.002230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520954 ORDER BY `minOrder` ASC [ RunTime:0.007337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12520954 ORDER BY `unit` DESC [ RunTime:0.001722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12520954 LIMIT 2 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520954 ORDER BY `minOrder` ASC [ RunTime:0.004196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12199401 LIMIT 5 [ RunTime:0.018332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12199401 ORDER BY `minOrder` ASC [ RunTime:0.008800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12199401 ORDER BY `unit` DESC [ RunTime:0.024969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12199401 LIMIT 2 [ RunTime:0.031628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12199401 ORDER BY `minOrder` ASC [ RunTime:0.027130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12030106 LIMIT 5 [ RunTime:0.027331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12030106 ORDER BY `minOrder` ASC [ RunTime:0.005511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12030106 ORDER BY `unit` DESC [ RunTime:0.034630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12030106 LIMIT 2 [ RunTime:0.029550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12030106 ORDER BY `minOrder` ASC [ RunTime:0.015031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857205 LIMIT 5 [ RunTime:0.002527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857205 ORDER BY `minOrder` ASC [ RunTime:0.007594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11857205 ORDER BY `unit` DESC [ RunTime:0.007197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11857205 LIMIT 2 [ RunTime:0.031989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857205 ORDER BY `minOrder` ASC [ RunTime:0.008327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857158 LIMIT 5 [ RunTime:0.031507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857158 ORDER BY `minOrder` ASC [ RunTime:0.006693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11857158 ORDER BY `unit` DESC [ RunTime:0.011920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11857158 LIMIT 2 [ RunTime:0.003926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857158 ORDER BY `minOrder` ASC [ RunTime:0.005152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857073 LIMIT 5 [ RunTime:0.018092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857073 ORDER BY `minOrder` ASC [ RunTime:0.008351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11857073 ORDER BY `unit` DESC [ RunTime:0.018047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11857073 LIMIT 2 [ RunTime:0.018566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857073 ORDER BY `minOrder` ASC [ RunTime:0.028409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11854191 LIMIT 5 [ RunTime:0.012828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11854191 ORDER BY `minOrder` ASC [ RunTime:0.012558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11854191 ORDER BY `unit` DESC [ RunTime:0.023294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11854191 LIMIT 2 [ RunTime:0.009174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11854191 ORDER BY `minOrder` ASC [ RunTime:0.032012s ]
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 '10482%' OR `brand` LIKE '10482%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019698s ]
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 '10482%' OR `brand` LIKE '10482%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57743918 LIMIT 5 [ RunTime:0.033241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57743918 ORDER BY `minOrder` ASC [ RunTime:0.045359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57743918 ORDER BY `unit` DESC [ RunTime:0.019653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57743918 LIMIT 2 [ RunTime:0.016564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57743918 ORDER BY `minOrder` ASC [ RunTime:0.042114s ]
select * from pdf where partno='10482CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.031424s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10482CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.021331s ]
SELECT `id` FROM `stock` WHERE `id` <> 57743918 AND `partno` = '10482CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.027699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351924 [ RunTime:0.086110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60470544 LIMIT 5 [ RunTime:0.044783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60470544 ORDER BY `minOrder` ASC [ RunTime:0.095941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60470544 ORDER BY `unit` DESC [ RunTime:0.040795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60470544 LIMIT 2 [ RunTime:0.053825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60470544 ORDER BY `minOrder` ASC [ RunTime:0.042234s ]
select * from pdf where partno='1048240000' and brandshort='Weidmüller' limit 1 [ RunTime:0.025035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048240000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.015994s ]
SELECT `id` FROM `stock` WHERE `id` <> 60470544 AND `partno` = '1048240000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.061460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469971 LIMIT 5 [ RunTime:0.073622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469971 ORDER BY `minOrder` ASC [ RunTime:0.020167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469971 ORDER BY `unit` DESC [ RunTime:0.017046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469971 LIMIT 2 [ RunTime:0.048871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469971 ORDER BY `minOrder` ASC [ RunTime:0.031902s ]
select * from pdf where partno='1048220000' and brandshort='Weidmüller' limit 1 [ RunTime:0.037504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048220000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.040169s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469971 AND `partno` = '1048220000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.042285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63277915 LIMIT 5 [ RunTime:0.022664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63277915 ORDER BY `minOrder` ASC [ RunTime:0.028729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63277915 ORDER BY `unit` DESC [ RunTime:0.031880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63277915 LIMIT 2 [ RunTime:0.059974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63277915 ORDER BY `minOrder` ASC [ RunTime:0.035075s ]
select * from pdf where partno='1048214' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048214' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.065575s ]
SELECT `id` FROM `stock` WHERE `id` <> 63277915 AND `partno` = '1048214' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12867951 [ RunTime:0.143786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64107306 LIMIT 5 [ RunTime:0.063501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64107306 ORDER BY `minOrder` ASC [ RunTime:0.103073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64107306 ORDER BY `unit` DESC [ RunTime:0.078952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64107306 LIMIT 2 [ RunTime:0.039736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64107306 ORDER BY `minOrder` ASC [ RunTime:0.018313s ]
select * from pdf where partno='1048208' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.031792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048208' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.058709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64107302 LIMIT 5 [ RunTime:0.047363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64107302 ORDER BY `minOrder` ASC [ RunTime:0.028927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64107302 ORDER BY `unit` DESC [ RunTime:0.029042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64107302 LIMIT 2 [ RunTime:0.036150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64107302 ORDER BY `minOrder` ASC [ RunTime:0.022486s ]
select * from pdf where partno='1048209' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.043859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048209' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.040648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63381639 LIMIT 5 [ RunTime:0.052729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381639 ORDER BY `minOrder` ASC [ RunTime:0.024205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63381639 ORDER BY `unit` DESC [ RunTime:0.001961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63381639 LIMIT 2 [ RunTime:0.029332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381639 ORDER BY `minOrder` ASC [ RunTime:0.022559s ]
select * from pdf where partno='10482F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.014855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10482F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.030322s ]
SELECT `id` FROM `stock` WHERE `id` <> 63381639 AND `partno` = '10482F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.033600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380636 LIMIT 5 [ RunTime:0.055128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380636 ORDER BY `minOrder` ASC [ RunTime:0.037897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380636 ORDER BY `unit` DESC [ RunTime:0.009017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380636 LIMIT 2 [ RunTime:0.011816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380636 ORDER BY `minOrder` ASC [ RunTime:0.023086s ]
select * from pdf where partno='10482' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.045278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10482' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.068427s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380636 AND `partno` = '10482' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.066473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63347623 LIMIT 5 [ RunTime:0.021248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347623 ORDER BY `minOrder` ASC [ RunTime:0.045078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63347623 ORDER BY `unit` DESC [ RunTime:0.031230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63347623 LIMIT 2 [ RunTime:0.036780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63347623 ORDER BY `minOrder` ASC [ RunTime:0.022407s ]
select * from pdf where partno='1048278' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.038651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048278' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.040663s ]
SELECT `id` FROM `stock` WHERE `id` <> 63347623 AND `partno` = '1048278' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781739 [ RunTime:0.037170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346719 LIMIT 5 [ RunTime:0.068032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346719 ORDER BY `minOrder` ASC [ RunTime:0.099644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346719 ORDER BY `unit` DESC [ RunTime:0.025219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346719 LIMIT 2 [ RunTime:0.046307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346719 ORDER BY `minOrder` ASC [ RunTime:0.013602s ]
select * from pdf where partno='1048208' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048208' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.036068s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346719 AND `partno` = '1048208' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.078325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225172 [ RunTime:0.060426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63314936 LIMIT 5 [ RunTime:0.039526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63314936 ORDER BY `minOrder` ASC [ RunTime:0.041134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63314936 ORDER BY `unit` DESC [ RunTime:0.036702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63314936 LIMIT 2 [ RunTime:0.037152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63314936 ORDER BY `minOrder` ASC [ RunTime:0.011471s ]
select * from pdf where partno='1048206' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048206' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.036216s ]
SELECT `id` FROM `stock` WHERE `id` <> 63314936 AND `partno` = '1048206' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.037091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13226675 [ RunTime:0.063235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63314879 LIMIT 5 [ RunTime:0.027466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63314879 ORDER BY `minOrder` ASC [ RunTime:0.048903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63314879 ORDER BY `unit` DESC [ RunTime:0.044594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63314879 LIMIT 2 [ RunTime:0.012893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63314879 ORDER BY `minOrder` ASC [ RunTime:0.041025s ]
select * from pdf where partno='1048205' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.037333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048205' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017706s ]
SELECT `id` FROM `stock` WHERE `id` <> 63314879 AND `partno` = '1048205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.048376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13226655 [ RunTime:0.022071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63299174 LIMIT 5 [ RunTime:0.024180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63299174 ORDER BY `minOrder` ASC [ RunTime:0.042726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63299174 ORDER BY `unit` DESC [ RunTime:0.046968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63299174 LIMIT 2 [ RunTime:0.047119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63299174 ORDER BY `minOrder` ASC [ RunTime:0.031338s ]
select * from pdf where partno='1048235' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048235' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.075314s ]
SELECT `id` FROM `stock` WHERE `id` <> 63299174 AND `partno` = '1048235' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.062926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63299172 LIMIT 5 [ RunTime:0.020670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63299172 ORDER BY `minOrder` ASC [ RunTime:0.010330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63299172 ORDER BY `unit` DESC [ RunTime:0.055867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63299172 LIMIT 2 [ RunTime:0.047704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63299172 ORDER BY `minOrder` ASC [ RunTime:0.018544s ]
select * from pdf where partno='1048236' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048236' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020352s ]
SELECT `id` FROM `stock` WHERE `id` <> 63299172 AND `partno` = '1048236' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520954 [ RunTime:0.013713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60585326 LIMIT 5 [ RunTime:0.043683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60585326 ORDER BY `minOrder` ASC [ RunTime:0.023805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60585326 ORDER BY `unit` DESC [ RunTime:0.029220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60585326 LIMIT 2 [ RunTime:0.027931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60585326 ORDER BY `minOrder` ASC [ RunTime:0.018258s ]
select * from pdf where partno='10482.4' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.023840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10482.4' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.018511s ]
SELECT `id` FROM `stock` WHERE `id` <> 60585326 AND `partno` = '10482.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.018084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60585325 LIMIT 5 [ RunTime:0.006706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60585325 ORDER BY `minOrder` ASC [ RunTime:0.013042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60585325 ORDER BY `unit` DESC [ RunTime:0.006957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60585325 LIMIT 2 [ RunTime:0.021155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60585325 ORDER BY `minOrder` ASC [ RunTime:0.004600s ]
select * from pdf where partno='10482.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.005054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10482.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.002490s ]
SELECT `id` FROM `stock` WHERE `id` <> 60585325 AND `partno` = '10482.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.003552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60523482 LIMIT 5 [ RunTime:0.018607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60523482 ORDER BY `minOrder` ASC [ RunTime:0.017404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60523482 ORDER BY `unit` DESC [ RunTime:0.004127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60523482 LIMIT 2 [ RunTime:0.030338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60523482 ORDER BY `minOrder` ASC [ RunTime:0.008386s ]
select * from pdf where partno='1048280000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048280000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010512s ]
SELECT `id` FROM `stock` WHERE `id` <> 60523482 AND `partno` = '1048280000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.020477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632778 [ RunTime:0.036418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60523479 LIMIT 5 [ RunTime:0.028339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60523479 ORDER BY `minOrder` ASC [ RunTime:0.021694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60523479 ORDER BY `unit` DESC [ RunTime:0.027978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60523479 LIMIT 2 [ RunTime:0.007566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60523479 ORDER BY `minOrder` ASC [ RunTime:0.013645s ]
select * from pdf where partno='1048270000' and brandshort='Weidmüller' limit 1 [ RunTime:0.033567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1048270000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.024306s ]
SELECT `id` FROM `stock` WHERE `id` <> 60523479 AND `partno` = '1048270000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.027131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632772 [ RunTime:0.011229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60408636 LIMIT 5 [ RunTime:0.031542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60408636 ORDER BY `minOrder` ASC [ RunTime:0.054784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60408636 ORDER BY `unit` DESC [ RunTime:0.007885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60408636 LIMIT 2 [ RunTime:0.021483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60408636 ORDER BY `minOrder` ASC [ RunTime:0.004784s ]
select * from pdf where partno='104821NP' and brandshort='LAPP' limit 1 [ RunTime:0.030595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '104821NP' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.074958s ]
SELECT `id` FROM `stock` WHERE `id` <> 60408636 AND `partno` = '104821NP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.044391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857205 [ RunTime:0.031761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60408237 LIMIT 5 [ RunTime:0.012200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60408237 ORDER BY `minOrder` ASC [ RunTime:0.046164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60408237 ORDER BY `unit` DESC [ RunTime:0.027875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60408237 LIMIT 2 [ RunTime:0.023678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60408237 ORDER BY `minOrder` ASC [ RunTime:0.035718s ]
select * from pdf where partno='104821' and brandshort='LAPP' limit 1 [ RunTime:0.006574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '104821' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.009818s ]
SELECT `id` FROM `stock` WHERE `id` <> 60408237 AND `partno` = '104821' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.049708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857158 [ RunTime:0.031628s ]
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 '10482%' OR `brand` LIKE '10482%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043155s ]
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 '10482%' OR `brand` LIKE '10482%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056796s ]
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 '10482%' OR `brand` LIKE '10482%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030012s ]
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 '10482%' OR `brand` LIKE '10482%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050505s ]
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 '10482%' OR `brand` LIKE '10482%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042941s ]
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 '10482%' OR `brand` LIKE '10482%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050543s ]
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 '10482%' OR `brand` LIKE '10482%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015052s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10482%' OR `brand` LIKE '10482%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.087326s ]