SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002648s ]
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 '20108%' OR `brand` LIKE '20108%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042550s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17297086 LIMIT 5 [ RunTime:0.026711s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297086 ORDER BY `minOrder` ASC [ RunTime:0.015967s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17297086 ORDER BY `unit` DESC [ RunTime:0.016590s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17297086 LIMIT 2 [ RunTime:0.007760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297086 ORDER BY `minOrder` ASC [ RunTime:0.014621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13528578 LIMIT 5 [ RunTime:0.011662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13528578 ORDER BY `minOrder` ASC [ RunTime:0.028686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13528578 ORDER BY `unit` DESC [ RunTime:0.010425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13528578 LIMIT 2 [ RunTime:0.021717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13528578 ORDER BY `minOrder` ASC [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439478 LIMIT 5 [ RunTime:0.027838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439478 ORDER BY `minOrder` ASC [ RunTime:0.033794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15439478 ORDER BY `unit` DESC [ RunTime:0.015158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15439478 LIMIT 2 [ RunTime:0.013798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439478 ORDER BY `minOrder` ASC [ RunTime:0.002425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14886961 LIMIT 5 [ RunTime:0.009498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14886961 ORDER BY `minOrder` ASC [ RunTime:0.008404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14886961 ORDER BY `unit` DESC [ RunTime:0.013978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14886961 LIMIT 2 [ RunTime:0.002771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14886961 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16723836 LIMIT 5 [ RunTime:0.015205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16723836 ORDER BY `minOrder` ASC [ RunTime:0.039485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16723836 ORDER BY `unit` DESC [ RunTime:0.041608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16723836 LIMIT 2 [ RunTime:0.051875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16723836 ORDER BY `minOrder` ASC [ RunTime:0.011600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19573982 LIMIT 5 [ RunTime:0.005487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573982 ORDER BY `minOrder` ASC [ RunTime:0.018576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19573982 ORDER BY `unit` DESC [ RunTime:0.005776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19573982 LIMIT 2 [ RunTime:0.014154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573982 ORDER BY `minOrder` ASC [ RunTime:0.018052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652131 LIMIT 5 [ RunTime:0.017268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652131 ORDER BY `minOrder` ASC [ RunTime:0.013869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19652131 ORDER BY `unit` DESC [ RunTime:0.024508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19652131 LIMIT 2 [ RunTime:0.014868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652131 ORDER BY `minOrder` ASC [ RunTime:0.003696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19572939 LIMIT 5 [ RunTime:0.003743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19572939 ORDER BY `minOrder` ASC [ RunTime:0.005128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19572939 ORDER BY `unit` DESC [ RunTime:0.019728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19572939 LIMIT 2 [ RunTime:0.001172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19572939 ORDER BY `minOrder` ASC [ RunTime:0.004777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14886984 LIMIT 5 [ RunTime:0.009599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14886984 ORDER BY `minOrder` ASC [ RunTime:0.005202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14886984 ORDER BY `unit` DESC [ RunTime:0.011089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14886984 LIMIT 2 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14886984 ORDER BY `minOrder` ASC [ RunTime:0.006062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14886983 LIMIT 5 [ RunTime:0.002022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14886983 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14886983 ORDER BY `unit` DESC [ RunTime:0.000526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14886983 LIMIT 2 [ RunTime:0.001875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14886983 ORDER BY `minOrder` ASC [ RunTime:0.004878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421387 LIMIT 5 [ RunTime:0.003896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14421387 ORDER BY `minOrder` ASC [ RunTime:0.001121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14421387 ORDER BY `unit` DESC [ RunTime:0.000422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14421387 LIMIT 2 [ RunTime:0.002600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14421387 ORDER BY `minOrder` ASC [ RunTime:0.003955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414486 LIMIT 5 [ RunTime:0.008769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414486 ORDER BY `minOrder` ASC [ RunTime:0.022232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14414486 ORDER BY `unit` DESC [ RunTime:0.098400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14414486 LIMIT 2 [ RunTime:0.041839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414486 ORDER BY `minOrder` ASC [ RunTime:0.015912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12178306 LIMIT 5 [ RunTime:0.033666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12178306 ORDER BY `minOrder` ASC [ RunTime:0.018153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12178306 ORDER BY `unit` DESC [ RunTime:0.025074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12178306 LIMIT 2 [ RunTime:0.023419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12178306 ORDER BY `minOrder` ASC [ RunTime:0.010451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013868 LIMIT 5 [ RunTime:0.016883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013868 ORDER BY `minOrder` ASC [ RunTime:0.017540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12013868 ORDER BY `unit` DESC [ RunTime:0.013858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12013868 LIMIT 2 [ RunTime:0.011038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12013868 ORDER BY `minOrder` ASC [ RunTime:0.012492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11237263 LIMIT 5 [ RunTime:0.024577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11237263 ORDER BY `minOrder` ASC [ RunTime:0.025792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11237263 ORDER BY `unit` DESC [ RunTime:0.041629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11237263 LIMIT 2 [ RunTime:0.045521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11237263 ORDER BY `minOrder` ASC [ RunTime:0.039572s ]
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 '20108%' OR `brand` LIKE '20108%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040930s ]
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 '20108%' OR `brand` LIKE '20108%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56341529 LIMIT 5 [ RunTime:0.041657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56341529 ORDER BY `minOrder` ASC [ RunTime:0.067390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56341529 ORDER BY `unit` DESC [ RunTime:0.013330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56341529 LIMIT 2 [ RunTime:0.006977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56341529 ORDER BY `minOrder` ASC [ RunTime:0.013058s ]
select * from pdf where partno='201082-000' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.045414s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '201082-000' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.029910s ]
SELECT `id` FROM `stock` WHERE `id` <> 56341529 AND `partno` = '201082-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.017319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13528578 [ RunTime:0.005695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33477027 LIMIT 5 [ RunTime:0.012761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33477027 ORDER BY `minOrder` ASC [ RunTime:0.021762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33477027 ORDER BY `unit` DESC [ RunTime:0.027469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33477027 LIMIT 2 [ RunTime:0.029550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33477027 ORDER BY `minOrder` ASC [ RunTime:0.015360s ]
select * from pdf where partno='201089-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.017312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '201089-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010390s ]
SELECT `id` FROM `stock` WHERE `id` <> 33477027 AND `partno` = '201089-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.062812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17297086 [ RunTime:0.038897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372348 LIMIT 5 [ RunTime:0.036925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372348 ORDER BY `minOrder` ASC [ RunTime:0.048583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372348 ORDER BY `unit` DESC [ RunTime:0.034745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372348 LIMIT 2 [ RunTime:0.043625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372348 ORDER BY `minOrder` ASC [ RunTime:0.011013s ]
select * from pdf where partno='201088-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '201088-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.021092s ]
SELECT `id` FROM `stock` WHERE `id` <> 60372348 AND `partno` = '201088-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.043675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439478 [ RunTime:0.028188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58028651 LIMIT 5 [ RunTime:0.072754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58028651 ORDER BY `minOrder` ASC [ RunTime:0.054525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58028651 ORDER BY `unit` DESC [ RunTime:0.068166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58028651 LIMIT 2 [ RunTime:0.039660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58028651 ORDER BY `minOrder` ASC [ RunTime:0.077110s ]
select * from pdf where partno='20108D1X103K5P' and brandshort='Vishay Dale' limit 1 [ RunTime:0.017191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20108D1X103K5P' OR `brand` LIKE 'Vishay Dale%' ) ) LIMIT 1 [ RunTime:0.029685s ]
SELECT `id` FROM `stock` WHERE `id` <> 58028651 AND `partno` = '20108D1X103K5P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay dale%' ) [ RunTime:0.030702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14886984 [ RunTime:0.016925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58028652 LIMIT 5 [ RunTime:0.086573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58028652 ORDER BY `minOrder` ASC [ RunTime:0.038917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58028652 ORDER BY `unit` DESC [ RunTime:0.047734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58028652 LIMIT 2 [ RunTime:0.040839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58028652 ORDER BY `minOrder` ASC [ RunTime:0.028216s ]
select * from pdf where partno='20108D1X102K5P' and brandshort='Vishay Dale' limit 1 [ RunTime:0.018110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20108D1X102K5P' OR `brand` LIKE 'Vishay Dale%' ) ) LIMIT 1 [ RunTime:0.029689s ]
SELECT `id` FROM `stock` WHERE `id` <> 58028652 AND `partno` = '20108D1X102K5P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay dale%' ) [ RunTime:0.049313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14886983 [ RunTime:0.041562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58028545 LIMIT 5 [ RunTime:0.020973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58028545 ORDER BY `minOrder` ASC [ RunTime:0.024454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58028545 ORDER BY `unit` DESC [ RunTime:0.043257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58028545 LIMIT 2 [ RunTime:0.018277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58028545 ORDER BY `minOrder` ASC [ RunTime:0.012113s ]
select * from pdf where partno='20108D1X104K5P' and brandshort='Vishay Dale' limit 1 [ RunTime:0.016196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20108D1X104K5P' OR `brand` LIKE 'Vishay Dale%' ) ) LIMIT 1 [ RunTime:0.036716s ]
SELECT `id` FROM `stock` WHERE `id` <> 58028545 AND `partno` = '20108D1X104K5P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay dale%' ) [ RunTime:0.032485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14886961 [ RunTime:0.033354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58028708 LIMIT 5 [ RunTime:0.005735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58028708 ORDER BY `minOrder` ASC [ RunTime:0.017508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58028708 ORDER BY `unit` DESC [ RunTime:0.051221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58028708 LIMIT 2 [ RunTime:0.051912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58028708 ORDER BY `minOrder` ASC [ RunTime:0.018980s ]
select * from pdf where partno='20108D1C221K5E' and brandshort='Vishay Dale' limit 1 [ RunTime:0.012871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20108D1C221K5E' OR `brand` LIKE 'Vishay Dale%' ) ) LIMIT 1 [ RunTime:0.015162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372652 LIMIT 5 [ RunTime:0.027970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372652 ORDER BY `minOrder` ASC [ RunTime:0.033742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372652 ORDER BY `unit` DESC [ RunTime:0.033317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372652 LIMIT 2 [ RunTime:0.018282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372652 ORDER BY `minOrder` ASC [ RunTime:0.016532s ]
select * from pdf where partno='201087-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.019371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '201087-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.027389s ]
SELECT `id` FROM `stock` WHERE `id` <> 60372652 AND `partno` = '201087-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.033646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12013868 [ RunTime:0.030879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60373078 LIMIT 5 [ RunTime:0.024972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60373078 ORDER BY `minOrder` ASC [ RunTime:0.057990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60373078 ORDER BY `unit` DESC [ RunTime:0.023504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60373078 LIMIT 2 [ RunTime:0.024012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60373078 ORDER BY `minOrder` ASC [ RunTime:0.005653s ]
select * from pdf where partno='201089-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '201089-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.048495s ]
SELECT `id` FROM `stock` WHERE `id` <> 60373078 AND `partno` = '201089-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.079225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19572939 [ RunTime:0.035467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58580817 LIMIT 5 [ RunTime:0.032081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58580817 ORDER BY `minOrder` ASC [ RunTime:0.040769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58580817 ORDER BY `unit` DESC [ RunTime:0.061105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58580817 LIMIT 2 [ RunTime:0.015413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58580817 ORDER BY `minOrder` ASC [ RunTime:0.018499s ]
select * from pdf where partno='20108' and brandshort='Master Appliance Co' limit 1 [ RunTime:0.081296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20108' OR `brand` LIKE 'Master Appliance Co%' ) ) LIMIT 1 [ RunTime:0.051587s ]
SELECT `id` FROM `stock` WHERE `id` <> 58580817 AND `partno` = '20108' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%master appliance co%' ) [ RunTime:0.038425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12178306 [ RunTime:0.038890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57717525 LIMIT 5 [ RunTime:0.061395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57717525 ORDER BY `minOrder` ASC [ RunTime:0.029519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57717525 ORDER BY `unit` DESC [ RunTime:0.119551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57717525 LIMIT 2 [ RunTime:0.041407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57717525 ORDER BY `minOrder` ASC [ RunTime:0.021878s ]
select * from pdf where partno='20108KLS' and brandshort='Brady Corporation' limit 1 [ RunTime:0.021347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20108KLS' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.037667s ]
SELECT `id` FROM `stock` WHERE `id` <> 57717525 AND `partno` = '20108KLS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.031607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421387 [ RunTime:0.052226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56409816 LIMIT 5 [ RunTime:0.049875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56409816 ORDER BY `minOrder` ASC [ RunTime:0.030710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56409816 ORDER BY `unit` DESC [ RunTime:0.026513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56409816 LIMIT 2 [ RunTime:0.052924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56409816 ORDER BY `minOrder` ASC [ RunTime:0.042055s ]
select * from pdf where partno='2010822' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2010822' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020554s ]
SELECT `id` FROM `stock` WHERE `id` <> 56409816 AND `partno` = '2010822' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.027459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11237263 [ RunTime:0.057341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56337590 LIMIT 5 [ RunTime:0.013509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56337590 ORDER BY `minOrder` ASC [ RunTime:0.024837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56337590 ORDER BY `unit` DESC [ RunTime:0.015285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56337590 LIMIT 2 [ RunTime:0.035389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56337590 ORDER BY `minOrder` ASC [ RunTime:0.008237s ]
select * from pdf where partno='20108.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.016282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20108.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.014378s ]
SELECT `id` FROM `stock` WHERE `id` <> 56337590 AND `partno` = '20108.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.022195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414486 [ RunTime:0.021968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32571721 LIMIT 5 [ RunTime:0.019500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32571721 ORDER BY `minOrder` ASC [ RunTime:0.040460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32571721 ORDER BY `unit` DESC [ RunTime:0.059046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32571721 LIMIT 2 [ RunTime:0.065399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32571721 ORDER BY `minOrder` ASC [ RunTime:0.006308s ]
select * from pdf where partno='2010814' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.032268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2010814' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018599s ]
SELECT `id` FROM `stock` WHERE `id` <> 32571721 AND `partno` = '2010814' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.054278s ]
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 '20108%' OR `brand` LIKE '20108%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030290s ]
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 '20108%' OR `brand` LIKE '20108%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014585s ]
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 '20108%' OR `brand` LIKE '20108%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045951s ]
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 '20108%' OR `brand` LIKE '20108%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010359s ]
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 '20108%' OR `brand` LIKE '20108%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043605s ]
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 '20108%' OR `brand` LIKE '20108%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025615s ]
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 '20108%' OR `brand` LIKE '20108%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041837s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20108%' OR `brand` LIKE '20108%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041087s ]