SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001579s ]
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 '4649%' OR `brand` LIKE '4649%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077613s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10898917 LIMIT 5 [ RunTime:0.036168s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10898917 ORDER BY `minOrder` ASC [ RunTime:0.010939s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10898917 ORDER BY `unit` DESC [ RunTime:0.031943s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10898917 LIMIT 2 [ RunTime:0.021583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10898917 ORDER BY `minOrder` ASC [ RunTime:0.011835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18839073 LIMIT 5 [ RunTime:0.019407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18839073 ORDER BY `minOrder` ASC [ RunTime:0.037213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18839073 ORDER BY `unit` DESC [ RunTime:0.027468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18839073 LIMIT 2 [ RunTime:0.008117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18839073 ORDER BY `minOrder` ASC [ RunTime:0.018236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18756637 LIMIT 5 [ RunTime:0.031277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18756637 ORDER BY `minOrder` ASC [ RunTime:0.045582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18756637 ORDER BY `unit` DESC [ RunTime:0.013641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18756637 LIMIT 2 [ RunTime:0.035947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18756637 ORDER BY `minOrder` ASC [ RunTime:0.013183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18742662 LIMIT 5 [ RunTime:0.036719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18742662 ORDER BY `minOrder` ASC [ RunTime:0.005695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18742662 ORDER BY `unit` DESC [ RunTime:0.015904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18742662 LIMIT 2 [ RunTime:0.024209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18742662 ORDER BY `minOrder` ASC [ RunTime:0.014449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17264486 LIMIT 5 [ RunTime:0.041542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17264486 ORDER BY `minOrder` ASC [ RunTime:0.025343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17264486 ORDER BY `unit` DESC [ RunTime:0.015139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17264486 LIMIT 2 [ RunTime:0.026220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17264486 ORDER BY `minOrder` ASC [ RunTime:0.015286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17005886 LIMIT 5 [ RunTime:0.028836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005886 ORDER BY `minOrder` ASC [ RunTime:0.025303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17005886 ORDER BY `unit` DESC [ RunTime:0.028567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17005886 LIMIT 2 [ RunTime:0.017316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005886 ORDER BY `minOrder` ASC [ RunTime:0.005375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216286 LIMIT 5 [ RunTime:0.015593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216286 ORDER BY `minOrder` ASC [ RunTime:0.029370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15216286 ORDER BY `unit` DESC [ RunTime:0.042695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15216286 LIMIT 2 [ RunTime:0.010821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216286 ORDER BY `minOrder` ASC [ RunTime:0.009168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216280 LIMIT 5 [ RunTime:0.008884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216280 ORDER BY `minOrder` ASC [ RunTime:0.011309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15216280 ORDER BY `unit` DESC [ RunTime:0.008463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15216280 LIMIT 2 [ RunTime:0.010223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216280 ORDER BY `minOrder` ASC [ RunTime:0.004147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216235 LIMIT 5 [ RunTime:0.006885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216235 ORDER BY `minOrder` ASC [ RunTime:0.018740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15216235 ORDER BY `unit` DESC [ RunTime:0.012777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15216235 LIMIT 2 [ RunTime:0.008878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15216235 ORDER BY `minOrder` ASC [ RunTime:0.007256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14303008 LIMIT 5 [ RunTime:0.025180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14303008 ORDER BY `minOrder` ASC [ RunTime:0.010591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14303008 ORDER BY `unit` DESC [ RunTime:0.001728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14303008 LIMIT 2 [ RunTime:0.010063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14303008 ORDER BY `minOrder` ASC [ RunTime:0.001789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14299645 LIMIT 5 [ RunTime:0.004554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14299645 ORDER BY `minOrder` ASC [ RunTime:0.003115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14299645 ORDER BY `unit` DESC [ RunTime:0.015339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14299645 LIMIT 2 [ RunTime:0.006578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14299645 ORDER BY `minOrder` ASC [ RunTime:0.003265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14185546 LIMIT 5 [ RunTime:0.002863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14185546 ORDER BY `minOrder` ASC [ RunTime:0.004955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14185546 ORDER BY `unit` DESC [ RunTime:0.003281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14185546 LIMIT 2 [ RunTime:0.005271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14185546 ORDER BY `minOrder` ASC [ RunTime:0.003757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14172370 LIMIT 5 [ RunTime:0.001280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14172370 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14172370 ORDER BY `unit` DESC [ RunTime:0.004222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14172370 LIMIT 2 [ RunTime:0.015838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14172370 ORDER BY `minOrder` ASC [ RunTime:0.007882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555701 LIMIT 5 [ RunTime:0.009432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555701 ORDER BY `minOrder` ASC [ RunTime:0.041336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13555701 ORDER BY `unit` DESC [ RunTime:0.015313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13555701 LIMIT 2 [ RunTime:0.005462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555701 ORDER BY `minOrder` ASC [ RunTime:0.003163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13314538 LIMIT 5 [ RunTime:0.004270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314538 ORDER BY `minOrder` ASC [ RunTime:0.007823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13314538 ORDER BY `unit` DESC [ RunTime:0.003070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13314538 LIMIT 2 [ RunTime:0.003146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314538 ORDER BY `minOrder` ASC [ RunTime:0.010580s ]
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 '4649%' OR `brand` LIKE '4649%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011592s ]
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 '4649%' OR `brand` LIKE '4649%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51460545 LIMIT 5 [ RunTime:0.006705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51460545 ORDER BY `minOrder` ASC [ RunTime:0.015369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51460545 ORDER BY `unit` DESC [ RunTime:0.004069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51460545 LIMIT 2 [ RunTime:0.017833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51460545 ORDER BY `minOrder` ASC [ RunTime:0.003170s ]
select * from pdf where partno='464900201' and brandshort='C&K' limit 1 [ RunTime:0.009696s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '464900201' OR `brand` LIKE 'C&K%' ) ) LIMIT 1 [ RunTime:0.010305s ]
SELECT `id` FROM `stock` WHERE `id` <> 51460545 AND `partno` = '464900201' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%c&k%' ) [ RunTime:0.005751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54343235 LIMIT 5 [ RunTime:0.010051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54343235 ORDER BY `minOrder` ASC [ RunTime:0.012586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54343235 ORDER BY `unit` DESC [ RunTime:0.008118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54343235 LIMIT 2 [ RunTime:0.020098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54343235 ORDER BY `minOrder` ASC [ RunTime:0.023201s ]
select * from pdf where partno='464912-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.009636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '464912-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.007418s ]
SELECT `id` FROM `stock` WHERE `id` <> 54343235 AND `partno` = '464912-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.011330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10898917 [ RunTime:0.005562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53801687 LIMIT 5 [ RunTime:0.004247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53801687 ORDER BY `minOrder` ASC [ RunTime:0.014810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53801687 ORDER BY `unit` DESC [ RunTime:0.015566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53801687 LIMIT 2 [ RunTime:0.017238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53801687 ORDER BY `minOrder` ASC [ RunTime:0.002287s ]
select * from pdf where partno='4649.7' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.008570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4649.7' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.020493s ]
SELECT `id` FROM `stock` WHERE `id` <> 53801687 AND `partno` = '4649.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.014912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50711118 LIMIT 5 [ RunTime:0.009573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50711118 ORDER BY `minOrder` ASC [ RunTime:0.002870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50711118 ORDER BY `unit` DESC [ RunTime:0.004234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50711118 LIMIT 2 [ RunTime:0.029460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50711118 ORDER BY `minOrder` ASC [ RunTime:0.002778s ]
select * from pdf where partno='46491' and brandshort='Brady Corporation' limit 1 [ RunTime:0.017984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46491' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008195s ]
SELECT `id` FROM `stock` WHERE `id` <> 50711118 AND `partno` = '46491' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.023017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555701 [ RunTime:0.012615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50235510 LIMIT 5 [ RunTime:0.007992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50235510 ORDER BY `minOrder` ASC [ RunTime:0.030254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50235510 ORDER BY `unit` DESC [ RunTime:0.010955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50235510 LIMIT 2 [ RunTime:0.012379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50235510 ORDER BY `minOrder` ASC [ RunTime:0.009394s ]
select * from pdf where partno='4649' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.007768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4649' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.025972s ]
SELECT `id` FROM `stock` WHERE `id` <> 50235510 AND `partno` = '4649' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.021943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17264486 [ RunTime:0.026355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44033809 LIMIT 5 [ RunTime:0.006371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44033809 ORDER BY `minOrder` ASC [ RunTime:0.008713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44033809 ORDER BY `unit` DESC [ RunTime:0.009207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44033809 LIMIT 2 [ RunTime:0.009992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44033809 ORDER BY `minOrder` ASC [ RunTime:0.003261s ]
select * from pdf where partno='464962-3' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.015271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '464962-3' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.013890s ]
SELECT `id` FROM `stock` WHERE `id` <> 44033809 AND `partno` = '464962-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.010308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216286 [ RunTime:0.004717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44032794 LIMIT 5 [ RunTime:0.002476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44032794 ORDER BY `minOrder` ASC [ RunTime:0.009144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44032794 ORDER BY `unit` DESC [ RunTime:0.007147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44032794 LIMIT 2 [ RunTime:0.024625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44032794 ORDER BY `minOrder` ASC [ RunTime:0.010249s ]
select * from pdf where partno='464962-4' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.014641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '464962-4' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.008166s ]
SELECT `id` FROM `stock` WHERE `id` <> 44032794 AND `partno` = '464962-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.009766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216280 [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44032559 LIMIT 5 [ RunTime:0.010106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44032559 ORDER BY `minOrder` ASC [ RunTime:0.007729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44032559 ORDER BY `unit` DESC [ RunTime:0.002196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44032559 LIMIT 2 [ RunTime:0.008088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44032559 ORDER BY `minOrder` ASC [ RunTime:0.002476s ]
select * from pdf where partno='464927-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.018963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '464927-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.005340s ]
SELECT `id` FROM `stock` WHERE `id` <> 44032559 AND `partno` = '464927-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.010928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15216235 [ RunTime:0.020726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44029851 LIMIT 5 [ RunTime:0.003063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44029851 ORDER BY `minOrder` ASC [ RunTime:0.003118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44029851 ORDER BY `unit` DESC [ RunTime:0.008427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44029851 LIMIT 2 [ RunTime:0.037414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44029851 ORDER BY `minOrder` ASC [ RunTime:0.008191s ]
select * from pdf where partno='464930-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.020180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '464930-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.014019s ]
SELECT `id` FROM `stock` WHERE `id` <> 44029851 AND `partno` = '464930-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.001174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18742662 [ RunTime:0.001668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44015999 LIMIT 5 [ RunTime:0.036194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44015999 ORDER BY `minOrder` ASC [ RunTime:0.023594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44015999 ORDER BY `unit` DESC [ RunTime:0.014222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44015999 LIMIT 2 [ RunTime:0.006051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44015999 ORDER BY `minOrder` ASC [ RunTime:0.005684s ]
select * from pdf where partno='464923-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.020259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '464923-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.056309s ]
SELECT `id` FROM `stock` WHERE `id` <> 44015999 AND `partno` = '464923-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.004967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14172370 [ RunTime:0.015418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38099176 LIMIT 5 [ RunTime:0.020177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38099176 ORDER BY `minOrder` ASC [ RunTime:0.034690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38099176 ORDER BY `unit` DESC [ RunTime:0.014167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38099176 LIMIT 2 [ RunTime:0.007640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38099176 ORDER BY `minOrder` ASC [ RunTime:0.018999s ]
select * from pdf where partno='46491' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '46491' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.011431s ]
SELECT `id` FROM `stock` WHERE `id` <> 38099176 AND `partno` = '46491' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.024381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555701 [ RunTime:0.034853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37432477 LIMIT 5 [ RunTime:0.019295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37432477 ORDER BY `minOrder` ASC [ RunTime:0.041276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37432477 ORDER BY `unit` DESC [ RunTime:0.022744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37432477 LIMIT 2 [ RunTime:0.026790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37432477 ORDER BY `minOrder` ASC [ RunTime:0.006408s ]
select * from pdf where partno='4649' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.015072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4649' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.012278s ]
SELECT `id` FROM `stock` WHERE `id` <> 37432477 AND `partno` = '4649' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.014056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17264486 [ RunTime:0.028789s ]
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 '4649%' OR `brand` LIKE '4649%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039978s ]
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 '4649%' OR `brand` LIKE '4649%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048087s ]
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 '4649%' OR `brand` LIKE '4649%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022261s ]
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 '4649%' OR `brand` LIKE '4649%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036606s ]
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 '4649%' OR `brand` LIKE '4649%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024822s ]
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 '4649%' OR `brand` LIKE '4649%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048733s ]
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 '4649%' OR `brand` LIKE '4649%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031299s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4649%' OR `brand` LIKE '4649%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025012s ]