SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001807s ]
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 '27651%' OR `brand` LIKE '27651%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.098088s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17148264 LIMIT 5 [ RunTime:0.062204s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.038028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17148264 ORDER BY `minOrder` ASC [ RunTime:0.074023s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.023953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17148264 ORDER BY `unit` DESC [ RunTime:0.031231s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17148264 LIMIT 2 [ RunTime:0.098100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17148264 ORDER BY `minOrder` ASC [ RunTime:0.010822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19274210 LIMIT 5 [ RunTime:0.096704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274210 ORDER BY `minOrder` ASC [ RunTime:0.031669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19274210 ORDER BY `unit` DESC [ RunTime:0.049622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19274210 LIMIT 2 [ RunTime:0.029559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19274210 ORDER BY `minOrder` ASC [ RunTime:0.056204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19273910 LIMIT 5 [ RunTime:0.020654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19273910 ORDER BY `minOrder` ASC [ RunTime:0.076981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19273910 ORDER BY `unit` DESC [ RunTime:0.037244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19273910 LIMIT 2 [ RunTime:0.056814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19273910 ORDER BY `minOrder` ASC [ RunTime:0.017299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19273807 LIMIT 5 [ RunTime:0.105176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19273807 ORDER BY `minOrder` ASC [ RunTime:0.037117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19273807 ORDER BY `unit` DESC [ RunTime:0.089111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19273807 LIMIT 2 [ RunTime:0.042082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19273807 ORDER BY `minOrder` ASC [ RunTime:0.057911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19273790 LIMIT 5 [ RunTime:0.025317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19273790 ORDER BY `minOrder` ASC [ RunTime:0.012091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19273790 ORDER BY `unit` DESC [ RunTime:0.018153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19273790 LIMIT 2 [ RunTime:0.050312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19273790 ORDER BY `minOrder` ASC [ RunTime:0.007227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143919 LIMIT 5 [ RunTime:0.026304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143919 ORDER BY `minOrder` ASC [ RunTime:0.040271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17143919 ORDER BY `unit` DESC [ RunTime:0.037284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17143919 LIMIT 2 [ RunTime:0.027977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143919 ORDER BY `minOrder` ASC [ RunTime:0.024293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143812 LIMIT 5 [ RunTime:0.029614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143812 ORDER BY `minOrder` ASC [ RunTime:0.024086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17143812 ORDER BY `unit` DESC [ RunTime:0.048384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17143812 LIMIT 2 [ RunTime:0.016282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143812 ORDER BY `minOrder` ASC [ RunTime:0.032470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15363912 LIMIT 5 [ RunTime:0.063929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15363912 ORDER BY `minOrder` ASC [ RunTime:0.022459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15363912 ORDER BY `unit` DESC [ RunTime:0.045586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15363912 LIMIT 2 [ RunTime:0.059142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15363912 ORDER BY `minOrder` ASC [ RunTime:0.021868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15363680 LIMIT 5 [ RunTime:0.057756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15363680 ORDER BY `minOrder` ASC [ RunTime:0.000706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15363680 ORDER BY `unit` DESC [ RunTime:0.066388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15363680 LIMIT 2 [ RunTime:0.045110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15363680 ORDER BY `minOrder` ASC [ RunTime:0.015550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15363677 LIMIT 5 [ RunTime:0.052650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15363677 ORDER BY `minOrder` ASC [ RunTime:0.235203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15363677 ORDER BY `unit` DESC [ RunTime:0.035010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15363677 LIMIT 2 [ RunTime:0.035092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15363677 ORDER BY `minOrder` ASC [ RunTime:0.065581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186363 LIMIT 5 [ RunTime:0.063861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186363 ORDER BY `minOrder` ASC [ RunTime:0.062788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12186363 ORDER BY `unit` DESC [ RunTime:0.035712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12186363 LIMIT 2 [ RunTime:0.058516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186363 ORDER BY `minOrder` ASC [ RunTime:0.026569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11197460 LIMIT 5 [ RunTime:0.037684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11197460 ORDER BY `minOrder` ASC [ RunTime:0.192106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11197460 ORDER BY `unit` DESC [ RunTime:0.042645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11197460 LIMIT 2 [ RunTime:0.046972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11197460 ORDER BY `minOrder` ASC [ RunTime:0.024819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11197376 LIMIT 5 [ RunTime:0.011974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11197376 ORDER BY `minOrder` ASC [ RunTime:0.006266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11197376 ORDER BY `unit` DESC [ RunTime:0.007265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11197376 LIMIT 2 [ RunTime:0.004407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11197376 ORDER BY `minOrder` ASC [ RunTime:0.024171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11197353 LIMIT 5 [ RunTime:0.065082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11197353 ORDER BY `minOrder` ASC [ RunTime:0.036342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11197353 ORDER BY `unit` DESC [ RunTime:0.011857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11197353 LIMIT 2 [ RunTime:0.029530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11197353 ORDER BY `minOrder` ASC [ RunTime:0.021841s ]
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 '27651%' OR `brand` LIKE '27651%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025488s ]
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 '27651%' OR `brand` LIKE '27651%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43762513 LIMIT 5 [ RunTime:0.064005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43762513 ORDER BY `minOrder` ASC [ RunTime:0.046751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43762513 ORDER BY `unit` DESC [ RunTime:0.010035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43762513 LIMIT 2 [ RunTime:0.034291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43762513 ORDER BY `minOrder` ASC [ RunTime:0.023875s ]
select * from pdf where partno='2765190000' and brandshort='WEC' limit 1 [ RunTime:0.026733s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765190000' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.020079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43760877 LIMIT 5 [ RunTime:0.025539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43760877 ORDER BY `minOrder` ASC [ RunTime:0.048955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43760877 ORDER BY `unit` DESC [ RunTime:0.053003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43760877 LIMIT 2 [ RunTime:0.023556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43760877 ORDER BY `minOrder` ASC [ RunTime:0.035487s ]
select * from pdf where partno='2765160000' and brandshort='Weidmüller' limit 1 [ RunTime:0.023199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765160000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009703s ]
SELECT `id` FROM `stock` WHERE `id` <> 43760877 AND `partno` = '2765160000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.117827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17148264 [ RunTime:0.022006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58554754 LIMIT 5 [ RunTime:0.021489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554754 ORDER BY `minOrder` ASC [ RunTime:0.065168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58554754 ORDER BY `unit` DESC [ RunTime:0.039694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58554754 LIMIT 2 [ RunTime:0.026304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554754 ORDER BY `minOrder` ASC [ RunTime:0.003966s ]
select * from pdf where partno='276516' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.037083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '276516' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.013049s ]
SELECT `id` FROM `stock` WHERE `id` <> 58554754 AND `partno` = '276516' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.019799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186363 [ RunTime:0.022671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58554585 LIMIT 5 [ RunTime:0.019123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554585 ORDER BY `minOrder` ASC [ RunTime:0.036368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58554585 ORDER BY `unit` DESC [ RunTime:0.027872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58554585 LIMIT 2 [ RunTime:0.052280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554585 ORDER BY `minOrder` ASC [ RunTime:0.037430s ]
select * from pdf where partno='276518' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.013893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '276518' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.014371s ]
SELECT `id` FROM `stock` WHERE `id` <> 58554585 AND `partno` = '276518' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.056900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58554391 LIMIT 5 [ RunTime:0.042519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554391 ORDER BY `minOrder` ASC [ RunTime:0.087222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58554391 ORDER BY `unit` DESC [ RunTime:0.033950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58554391 LIMIT 2 [ RunTime:0.017068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554391 ORDER BY `minOrder` ASC [ RunTime:0.019440s ]
select * from pdf where partno='276515' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.047531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '276515' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.026778s ]
SELECT `id` FROM `stock` WHERE `id` <> 58554391 AND `partno` = '276515' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.118511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11197460 [ RunTime:0.021755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58554390 LIMIT 5 [ RunTime:0.036761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554390 ORDER BY `minOrder` ASC [ RunTime:0.126263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58554390 ORDER BY `unit` DESC [ RunTime:0.050555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58554390 LIMIT 2 [ RunTime:0.070771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554390 ORDER BY `minOrder` ASC [ RunTime:0.025153s ]
select * from pdf where partno='276514' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.095968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '276514' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.096497s ]
SELECT `id` FROM `stock` WHERE `id` <> 58554390 AND `partno` = '276514' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.098578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58554168 LIMIT 5 [ RunTime:0.018071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554168 ORDER BY `minOrder` ASC [ RunTime:0.041381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58554168 ORDER BY `unit` DESC [ RunTime:0.021364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58554168 LIMIT 2 [ RunTime:0.025336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554168 ORDER BY `minOrder` ASC [ RunTime:0.009282s ]
select * from pdf where partno='276512' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.006061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '276512' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.005331s ]
SELECT `id` FROM `stock` WHERE `id` <> 58554168 AND `partno` = '276512' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.012661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11197376 [ RunTime:0.010645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58554095 LIMIT 5 [ RunTime:0.028243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554095 ORDER BY `minOrder` ASC [ RunTime:0.024267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58554095 ORDER BY `unit` DESC [ RunTime:0.023284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58554095 LIMIT 2 [ RunTime:0.007848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58554095 ORDER BY `minOrder` ASC [ RunTime:0.012463s ]
select * from pdf where partno='276510' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.008063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '276510' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.005993s ]
SELECT `id` FROM `stock` WHERE `id` <> 58554095 AND `partno` = '276510' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.013851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11197353 [ RunTime:0.002084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43774198 LIMIT 5 [ RunTime:0.015936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43774198 ORDER BY `minOrder` ASC [ RunTime:0.010585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43774198 ORDER BY `unit` DESC [ RunTime:0.007841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43774198 LIMIT 2 [ RunTime:0.019440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43774198 ORDER BY `minOrder` ASC [ RunTime:0.026607s ]
select * from pdf where partno='2765190000' and brandshort='Weidmüller' limit 1 [ RunTime:0.032332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765190000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009996s ]
SELECT `id` FROM `stock` WHERE `id` <> 43774198 AND `partno` = '2765190000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.035320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19274210 [ RunTime:0.033002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43773666 LIMIT 5 [ RunTime:0.047502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773666 ORDER BY `minOrder` ASC [ RunTime:0.054729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43773666 ORDER BY `unit` DESC [ RunTime:0.047878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43773666 LIMIT 2 [ RunTime:0.054745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773666 ORDER BY `minOrder` ASC [ RunTime:0.013081s ]
select * from pdf where partno='2765180000' and brandshort='Weidmüller' limit 1 [ RunTime:0.040923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765180000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.058568s ]
SELECT `id` FROM `stock` WHERE `id` <> 43773666 AND `partno` = '2765180000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.046629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143919 [ RunTime:0.030147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43773653 LIMIT 5 [ RunTime:0.044906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773653 ORDER BY `minOrder` ASC [ RunTime:0.034352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43773653 ORDER BY `unit` DESC [ RunTime:0.032532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43773653 LIMIT 2 [ RunTime:0.015436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773653 ORDER BY `minOrder` ASC [ RunTime:0.019009s ]
select * from pdf where partno='2765170000' and brandshort='Weidmüller' limit 1 [ RunTime:0.039415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765170000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.022805s ]
SELECT `id` FROM `stock` WHERE `id` <> 43773653 AND `partno` = '2765170000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.024833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15363912 [ RunTime:0.013798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43773430 LIMIT 5 [ RunTime:0.018980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773430 ORDER BY `minOrder` ASC [ RunTime:0.061740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43773430 ORDER BY `unit` DESC [ RunTime:0.025168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43773430 LIMIT 2 [ RunTime:0.010618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773430 ORDER BY `minOrder` ASC [ RunTime:0.023990s ]
select * from pdf where partno='2765140000' and brandshort='Weidmüller' limit 1 [ RunTime:0.016776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765140000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.050649s ]
SELECT `id` FROM `stock` WHERE `id` <> 43773430 AND `partno` = '2765140000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.016150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19273910 [ RunTime:0.038726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43773281 LIMIT 5 [ RunTime:0.015378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773281 ORDER BY `minOrder` ASC [ RunTime:0.023003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43773281 ORDER BY `unit` DESC [ RunTime:0.019572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43773281 LIMIT 2 [ RunTime:0.020014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773281 ORDER BY `minOrder` ASC [ RunTime:0.007346s ]
select * from pdf where partno='2765150000' and brandshort='Weidmüller' limit 1 [ RunTime:0.021741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765150000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008001s ]
SELECT `id` FROM `stock` WHERE `id` <> 43773281 AND `partno` = '2765150000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.032552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143812 [ RunTime:0.006576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43773249 LIMIT 5 [ RunTime:0.011590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773249 ORDER BY `minOrder` ASC [ RunTime:0.050463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43773249 ORDER BY `unit` DESC [ RunTime:0.022671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43773249 LIMIT 2 [ RunTime:0.013289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773249 ORDER BY `minOrder` ASC [ RunTime:0.008527s ]
select * from pdf where partno='2765110000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765110000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.012628s ]
SELECT `id` FROM `stock` WHERE `id` <> 43773249 AND `partno` = '2765110000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.043230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15363680 [ RunTime:0.001820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43773158 LIMIT 5 [ RunTime:0.015551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773158 ORDER BY `minOrder` ASC [ RunTime:0.039517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43773158 ORDER BY `unit` DESC [ RunTime:0.021655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43773158 LIMIT 2 [ RunTime:0.031051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773158 ORDER BY `minOrder` ASC [ RunTime:0.021514s ]
select * from pdf where partno='2765130000' and brandshort='Weidmüller' limit 1 [ RunTime:0.018822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765130000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.035478s ]
SELECT `id` FROM `stock` WHERE `id` <> 43773158 AND `partno` = '2765130000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.029543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19273807 [ RunTime:0.047762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43773035 LIMIT 5 [ RunTime:0.003872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773035 ORDER BY `minOrder` ASC [ RunTime:0.004526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43773035 ORDER BY `unit` DESC [ RunTime:0.019837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43773035 LIMIT 2 [ RunTime:0.002547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43773035 ORDER BY `minOrder` ASC [ RunTime:0.001471s ]
select * from pdf where partno='2765120000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765120000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005465s ]
SELECT `id` FROM `stock` WHERE `id` <> 43773035 AND `partno` = '2765120000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19273790 [ RunTime:0.012531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43772605 LIMIT 5 [ RunTime:0.017580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43772605 ORDER BY `minOrder` ASC [ RunTime:0.024988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43772605 ORDER BY `unit` DESC [ RunTime:0.012942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43772605 LIMIT 2 [ RunTime:0.006954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43772605 ORDER BY `minOrder` ASC [ RunTime:0.019717s ]
select * from pdf where partno='2765100000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2765100000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008930s ]
SELECT `id` FROM `stock` WHERE `id` <> 43772605 AND `partno` = '2765100000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15363677 [ RunTime:0.023838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32650121 LIMIT 5 [ RunTime:0.012686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32650121 ORDER BY `minOrder` ASC [ RunTime:0.025442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32650121 ORDER BY `unit` DESC [ RunTime:0.027085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32650121 LIMIT 2 [ RunTime:0.037154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32650121 ORDER BY `minOrder` ASC [ RunTime:0.008460s ]
select * from pdf where partno='276514' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.032067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '276514' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.026011s ]
SELECT `id` FROM `stock` WHERE `id` <> 32650121 AND `partno` = '276514' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.013203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32381886 LIMIT 5 [ RunTime:0.033093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32381886 ORDER BY `minOrder` ASC [ RunTime:0.026735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32381886 ORDER BY `unit` DESC [ RunTime:0.008231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32381886 LIMIT 2 [ RunTime:0.013966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32381886 ORDER BY `minOrder` ASC [ RunTime:0.027628s ]
select * from pdf where partno='27651' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.019427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27651' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.025415s ]
SELECT `id` FROM `stock` WHERE `id` <> 32381886 AND `partno` = '27651' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.029474s ]
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 '27651%' OR `brand` LIKE '27651%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036360s ]
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 '27651%' OR `brand` LIKE '27651%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040514s ]
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 '27651%' OR `brand` LIKE '27651%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027368s ]
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 '27651%' OR `brand` LIKE '27651%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031408s ]
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 '27651%' OR `brand` LIKE '27651%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032680s ]
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 '27651%' OR `brand` LIKE '27651%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021497s ]
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 '27651%' OR `brand` LIKE '27651%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043941s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '27651%' OR `brand` LIKE '27651%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008235s ]