SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002735s ]
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 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002681s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15289543 LIMIT 5 [ RunTime:0.003667s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15289543 ORDER BY `minOrder` ASC [ RunTime:0.003197s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15289543 ORDER BY `unit` DESC [ RunTime:0.002086s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15289543 LIMIT 2 [ RunTime:0.008470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15289543 ORDER BY `minOrder` ASC [ RunTime:0.004288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15289542 LIMIT 5 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15289542 ORDER BY `minOrder` ASC [ RunTime:0.005669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15289542 ORDER BY `unit` DESC [ RunTime:0.027882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15289542 LIMIT 2 [ RunTime:0.016239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15289542 ORDER BY `minOrder` ASC [ RunTime:0.020553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12404821 LIMIT 5 [ RunTime:0.018976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12404821 ORDER BY `minOrder` ASC [ RunTime:0.029029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12404821 ORDER BY `unit` DESC [ RunTime:0.037899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12404821 LIMIT 2 [ RunTime:0.028000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12404821 ORDER BY `minOrder` ASC [ RunTime:0.003074s ]
select * from pdf where partno='TPA6204A1EVM' and brandshort='Texas Instruments' limit 1 [ RunTime:0.033605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17268340 LIMIT 5 [ RunTime:0.030868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17268340 ORDER BY `minOrder` ASC [ RunTime:0.022886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17268340 ORDER BY `unit` DESC [ RunTime:0.026797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17268340 LIMIT 2 [ RunTime:0.039997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17268340 ORDER BY `minOrder` ASC [ RunTime:0.013697s ]
select * from pdf where partno='TPA6205A1EVM' and brandshort='Texas Instruments' limit 1 [ RunTime:0.017279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12404822 LIMIT 5 [ RunTime:0.028236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12404822 ORDER BY `minOrder` ASC [ RunTime:0.024104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12404822 ORDER BY `unit` DESC [ RunTime:0.018155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12404822 LIMIT 2 [ RunTime:0.025935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12404822 ORDER BY `minOrder` ASC [ RunTime:0.019349s ]
select * from pdf where partno='TPA6211A1EVM' and brandshort='Texas Instruments' limit 1 [ RunTime:0.019970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11342993 LIMIT 5 [ RunTime:0.012673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11342993 ORDER BY `minOrder` ASC [ RunTime:0.030331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11342993 ORDER BY `unit` DESC [ RunTime:0.023814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11342993 LIMIT 2 [ RunTime:0.008763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11342993 ORDER BY `minOrder` ASC [ RunTime:0.011363s ]
select * from pdf where partno='TPA6203A1EVM' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16657779 LIMIT 5 [ RunTime:0.031079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657779 ORDER BY `minOrder` ASC [ RunTime:0.043218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16657779 ORDER BY `unit` DESC [ RunTime:0.021288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16657779 LIMIT 2 [ RunTime:0.008542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657779 ORDER BY `minOrder` ASC [ RunTime:0.021882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16027949 LIMIT 5 [ RunTime:0.041475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16027949 ORDER BY `minOrder` ASC [ RunTime:0.027204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16027949 ORDER BY `unit` DESC [ RunTime:0.047226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16027949 LIMIT 2 [ RunTime:0.012459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16027949 ORDER BY `minOrder` ASC [ RunTime:0.014849s ]
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 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056642 LIMIT 5 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056642 ORDER BY `minOrder` ASC [ RunTime:0.007087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056642 ORDER BY `unit` DESC [ RunTime:0.007229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056642 LIMIT 2 [ RunTime:0.026585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056642 ORDER BY `minOrder` ASC [ RunTime:0.003291s ]
select * from pdf where partno='tpa6205a1dgn' and brandshort='texas instruments' limit 1 [ RunTime:0.001915s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6205a1dgn' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.007754s ]
SELECT `id` FROM `stock` WHERE `id` <> 51056642 AND `partno` = 'tpa6205a1dgn' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.012365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903369 [ RunTime:0.028506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057257 LIMIT 5 [ RunTime:0.027544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057257 ORDER BY `minOrder` ASC [ RunTime:0.018056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51057257 ORDER BY `unit` DESC [ RunTime:0.000972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51057257 LIMIT 2 [ RunTime:0.006758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057257 ORDER BY `minOrder` ASC [ RunTime:0.007924s ]
select * from pdf where partno='tpa6205a1dgnr' and brandshort='texas instruments' limit 1 [ RunTime:0.011356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6205a1dgnr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.017217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056675 LIMIT 5 [ RunTime:0.006384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056675 ORDER BY `minOrder` ASC [ RunTime:0.003416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056675 ORDER BY `unit` DESC [ RunTime:0.001984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056675 LIMIT 2 [ RunTime:0.014708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056675 ORDER BY `minOrder` ASC [ RunTime:0.010131s ]
select * from pdf where partno='tpa6203a1dgn' and brandshort='texas instruments' limit 1 [ RunTime:0.023961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6203a1dgn' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.013549s ]
SELECT `id` FROM `stock` WHERE `id` <> 51056675 AND `partno` = 'tpa6203a1dgn' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.004456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903553 [ RunTime:0.001754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056641 LIMIT 5 [ RunTime:0.001386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056641 ORDER BY `minOrder` ASC [ RunTime:0.006763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056641 ORDER BY `unit` DESC [ RunTime:0.007775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056641 LIMIT 2 [ RunTime:0.004251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056641 ORDER BY `minOrder` ASC [ RunTime:0.007023s ]
select * from pdf where partno='tpa6204a1drbr' and brandshort='texas instruments' limit 1 [ RunTime:0.001210s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6204a1drbr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.001685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056659 LIMIT 5 [ RunTime:0.010029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056659 ORDER BY `minOrder` ASC [ RunTime:0.001030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056659 ORDER BY `unit` DESC [ RunTime:0.007404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056659 LIMIT 2 [ RunTime:0.009942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056659 ORDER BY `minOrder` ASC [ RunTime:0.001832s ]
select * from pdf where partno='tpa6211a1drbrg4' and brandshort='texas instruments' limit 1 [ RunTime:0.007387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6211a1drbrg4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.001502s ]
SELECT `id` FROM `stock` WHERE `id` <> 51056659 AND `partno` = 'tpa6211a1drbrg4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.006013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63905098 [ RunTime:0.016695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056658 LIMIT 5 [ RunTime:0.009747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056658 ORDER BY `minOrder` ASC [ RunTime:0.003478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056658 ORDER BY `unit` DESC [ RunTime:0.006977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056658 LIMIT 2 [ RunTime:0.002357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056658 ORDER BY `minOrder` ASC [ RunTime:0.007958s ]
select * from pdf where partno='tpa6205a1drbr' and brandshort='texas instruments' limit 1 [ RunTime:0.009793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6205a1drbr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.016370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057550 LIMIT 5 [ RunTime:0.007698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057550 ORDER BY `minOrder` ASC [ RunTime:0.013728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51057550 ORDER BY `unit` DESC [ RunTime:0.001404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51057550 LIMIT 2 [ RunTime:0.019433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057550 ORDER BY `minOrder` ASC [ RunTime:0.004762s ]
select * from pdf where partno='tpa6203a1drbr' and brandshort='texas instruments' limit 1 [ RunTime:0.013575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6203a1drbr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.007710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056888 LIMIT 5 [ RunTime:0.012374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056888 ORDER BY `minOrder` ASC [ RunTime:0.021826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056888 ORDER BY `unit` DESC [ RunTime:0.022315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056888 LIMIT 2 [ RunTime:0.010304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056888 ORDER BY `minOrder` ASC [ RunTime:0.017061s ]
select * from pdf where partno='tpa6203a1dgnr' and brandshort='texas instruments' limit 1 [ RunTime:0.023716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6203a1dgnr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.014097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056860 LIMIT 5 [ RunTime:0.015295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056860 ORDER BY `minOrder` ASC [ RunTime:0.001274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056860 ORDER BY `unit` DESC [ RunTime:0.006803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056860 LIMIT 2 [ RunTime:0.007341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056860 ORDER BY `minOrder` ASC [ RunTime:0.003276s ]
select * from pdf where partno='tpa6203a1nmbr' and brandshort='texas instruments' limit 1 [ RunTime:0.007052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6203a1nmbr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.009989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056944 LIMIT 5 [ RunTime:0.002477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056944 ORDER BY `minOrder` ASC [ RunTime:0.003395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056944 ORDER BY `unit` DESC [ RunTime:0.014382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056944 LIMIT 2 [ RunTime:0.011279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056944 ORDER BY `minOrder` ASC [ RunTime:0.003724s ]
select * from pdf where partno='tpa6205a1nmbr' and brandshort='texas instruments' limit 1 [ RunTime:0.005459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6205a1nmbr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.012688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056890 LIMIT 5 [ RunTime:0.002814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056890 ORDER BY `minOrder` ASC [ RunTime:0.004041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056890 ORDER BY `unit` DESC [ RunTime:0.004105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056890 LIMIT 2 [ RunTime:0.016463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056890 ORDER BY `minOrder` ASC [ RunTime:0.007632s ]
select * from pdf where partno='tpa6205a1dgnrg4' and brandshort='texas instruments' limit 1 [ RunTime:0.016439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6205a1dgnrg4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.035787s ]
SELECT `id` FROM `stock` WHERE `id` <> 51056890 AND `partno` = 'tpa6205a1dgnrg4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.015263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63905130 [ RunTime:0.023079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056846 LIMIT 5 [ RunTime:0.019719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056846 ORDER BY `minOrder` ASC [ RunTime:0.022873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056846 ORDER BY `unit` DESC [ RunTime:0.001785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056846 LIMIT 2 [ RunTime:0.004596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056846 ORDER BY `minOrder` ASC [ RunTime:0.013102s ]
select * from pdf where partno='tpa6211a1drb' and brandshort='texas instruments' limit 1 [ RunTime:0.003899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6211a1drb' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.032631s ]
SELECT `id` FROM `stock` WHERE `id` <> 51056846 AND `partno` = 'tpa6211a1drb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.023846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903562 [ RunTime:0.036630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057557 LIMIT 5 [ RunTime:0.013648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057557 ORDER BY `minOrder` ASC [ RunTime:0.006322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51057557 ORDER BY `unit` DESC [ RunTime:0.003870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51057557 LIMIT 2 [ RunTime:0.014267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057557 ORDER BY `minOrder` ASC [ RunTime:0.009303s ]
select * from pdf where partno='tpa6211tdgnrq1' and brandshort='texas instruments' limit 1 [ RunTime:0.026260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6211tdgnrq1' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.025957s ]
SELECT `id` FROM `stock` WHERE `id` <> 51057557 AND `partno` = 'tpa6211tdgnrq1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.025557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903550 [ RunTime:0.033220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056889 LIMIT 5 [ RunTime:0.012626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056889 ORDER BY `minOrder` ASC [ RunTime:0.036224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51056889 ORDER BY `unit` DESC [ RunTime:0.032843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51056889 LIMIT 2 [ RunTime:0.004324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51056889 ORDER BY `minOrder` ASC [ RunTime:0.015403s ]
select * from pdf where partno='tpa6204a1drbg4' and brandshort='texas instruments' limit 1 [ RunTime:0.024360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6204a1drbg4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.014305s ]
SELECT `id` FROM `stock` WHERE `id` <> 51056889 AND `partno` = 'tpa6204a1drbg4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.029741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63905302 [ RunTime:0.022238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057549 LIMIT 5 [ RunTime:0.013687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057549 ORDER BY `minOrder` ASC [ RunTime:0.030725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51057549 ORDER BY `unit` DESC [ RunTime:0.042994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51057549 LIMIT 2 [ RunTime:0.008532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057549 ORDER BY `minOrder` ASC [ RunTime:0.011155s ]
select * from pdf where partno='tpa6203a1drb' and brandshort='texas instruments' limit 1 [ RunTime:0.017519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6203a1drb' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.030256s ]
SELECT `id` FROM `stock` WHERE `id` <> 51057549 AND `partno` = 'tpa6203a1drb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.032054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63904124 [ RunTime:0.046986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057551 LIMIT 5 [ RunTime:0.060147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057551 ORDER BY `minOrder` ASC [ RunTime:0.078707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51057551 ORDER BY `unit` DESC [ RunTime:0.031399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51057551 LIMIT 2 [ RunTime:0.017277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057551 ORDER BY `minOrder` ASC [ RunTime:0.010088s ]
select * from pdf where partno='tpa6205a1dgng4' and brandshort='texas instruments' limit 1 [ RunTime:0.013224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6205a1dgng4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.008725s ]
SELECT `id` FROM `stock` WHERE `id` <> 51057551 AND `partno` = 'tpa6205a1dgng4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.023083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057554 LIMIT 5 [ RunTime:0.040031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057554 ORDER BY `minOrder` ASC [ RunTime:0.028898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51057554 ORDER BY `unit` DESC [ RunTime:0.042821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51057554 LIMIT 2 [ RunTime:0.024374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057554 ORDER BY `minOrder` ASC [ RunTime:0.015437s ]
select * from pdf where partno='tpa6211a1dgng4' and brandshort='texas instruments' limit 1 [ RunTime:0.039360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6211a1dgng4' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.041662s ]
SELECT `id` FROM `stock` WHERE `id` <> 51057554 AND `partno` = 'tpa6211a1dgng4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.026523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63905187 [ RunTime:0.050099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057555 LIMIT 5 [ RunTime:0.017193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057555 ORDER BY `minOrder` ASC [ RunTime:0.049195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51057555 ORDER BY `unit` DESC [ RunTime:0.005799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51057555 LIMIT 2 [ RunTime:0.015880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057555 ORDER BY `minOrder` ASC [ RunTime:0.011231s ]
select * from pdf where partno='tpa6211a1drbr' and brandshort='texas instruments' limit 1 [ RunTime:0.015083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6211a1drbr' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.022591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057556 LIMIT 5 [ RunTime:0.017475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057556 ORDER BY `minOrder` ASC [ RunTime:0.071607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51057556 ORDER BY `unit` DESC [ RunTime:0.025221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51057556 LIMIT 2 [ RunTime:0.010976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057556 ORDER BY `minOrder` ASC [ RunTime:0.006159s ]
select * from pdf where partno='tpa6211a1tdgnrq1' and brandshort='texas instruments' limit 1 [ RunTime:0.013703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6211a1tdgnrq1' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.030993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057553 LIMIT 5 [ RunTime:0.017806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057553 ORDER BY `minOrder` ASC [ RunTime:0.015157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51057553 ORDER BY `unit` DESC [ RunTime:0.037950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51057553 LIMIT 2 [ RunTime:0.008003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51057553 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
select * from pdf where partno='tpa6211a1dgn' and brandshort='texas instruments' limit 1 [ RunTime:0.005176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tpa6211a1dgn' OR `brand` LIKE 'texas instruments%' ) ) LIMIT 1 [ RunTime:0.004137s ]
SELECT `id` FROM `stock` WHERE `id` <> 51057553 AND `partno` = 'tpa6211a1dgn' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.002449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63904963 [ RunTime:0.000691s ]
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 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903756 LIMIT 5 [ RunTime:0.002412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903756 ORDER BY `minOrder` ASC [ RunTime:0.008250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903756 ORDER BY `unit` DESC [ RunTime:0.000534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903756 LIMIT 2 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903756 ORDER BY `minOrder` ASC [ RunTime:0.006903s ]
select * from pdf where partno='TPA6203A1DRBR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.014990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6203A1DRBR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.008715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63904089 LIMIT 5 [ RunTime:0.004030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904089 ORDER BY `minOrder` ASC [ RunTime:0.002189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63904089 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63904089 LIMIT 2 [ RunTime:0.004790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904089 ORDER BY `minOrder` ASC [ RunTime:0.003070s ]
select * from pdf where partno='TPA6203A1NMBR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.008372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6203A1NMBR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.004372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903536 LIMIT 5 [ RunTime:0.000750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903536 ORDER BY `minOrder` ASC [ RunTime:0.003524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903536 ORDER BY `unit` DESC [ RunTime:0.007696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903536 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903536 ORDER BY `minOrder` ASC [ RunTime:0.007136s ]
select * from pdf where partno='TPA6203A1DGNR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.009100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6203A1DGNR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.008289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903550 LIMIT 5 [ RunTime:0.003193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903550 ORDER BY `minOrder` ASC [ RunTime:0.004228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903550 ORDER BY `unit` DESC [ RunTime:0.010849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903550 LIMIT 2 [ RunTime:0.003650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903550 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
select * from pdf where partno='TPA6211TDGNRQ1' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6211TDGNRQ1' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.007022s ]
SELECT `id` FROM `stock` WHERE `id` <> 63903550 AND `partno` = 'TPA6211TDGNRQ1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.003547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057557 [ RunTime:0.004266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903553 LIMIT 5 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903553 ORDER BY `minOrder` ASC [ RunTime:0.001213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903553 ORDER BY `unit` DESC [ RunTime:0.002844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903553 LIMIT 2 [ RunTime:0.014192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903553 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
select * from pdf where partno='TPA6203A1DGN' and brandshort='Texas Instruments' limit 1 [ RunTime:0.009004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6203A1DGN' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.001205s ]
SELECT `id` FROM `stock` WHERE `id` <> 63903553 AND `partno` = 'TPA6203A1DGN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056675 [ RunTime:0.000709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903546 LIMIT 5 [ RunTime:0.000715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903546 ORDER BY `minOrder` ASC [ RunTime:0.001350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903546 ORDER BY `unit` DESC [ RunTime:0.000677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903546 LIMIT 2 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903546 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
select * from pdf where partno='TPA6204A1DRBR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.008202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6204A1DRBR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903354 LIMIT 5 [ RunTime:0.000544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903354 ORDER BY `minOrder` ASC [ RunTime:0.002503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903354 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903354 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903354 ORDER BY `minOrder` ASC [ RunTime:0.001636s ]
select * from pdf where partno='TPA6211A1TDGNRQ1' and brandshort='Texas Instruments' limit 1 [ RunTime:0.006095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6211A1TDGNRQ1' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.003636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63867560 LIMIT 5 [ RunTime:0.006850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63867560 ORDER BY `minOrder` ASC [ RunTime:0.001049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63867560 ORDER BY `unit` DESC [ RunTime:0.004942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63867560 LIMIT 2 [ RunTime:0.016496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63867560 ORDER BY `minOrder` ASC [ RunTime:0.006304s ]
select * from pdf where partno='TPA620-VR-S' and brandshort='3PEAK' limit 1 [ RunTime:0.002137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA620-VR-S' OR `brand` LIKE '3PEAK%' ) ) LIMIT 1 [ RunTime:0.001154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63867556 LIMIT 5 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63867556 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63867556 ORDER BY `unit` DESC [ RunTime:0.008308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63867556 LIMIT 2 [ RunTime:0.001797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63867556 ORDER BY `minOrder` ASC [ RunTime:0.007542s ]
select * from pdf where partno='TPA626-VR-S' and brandshort='3PEAK' limit 1 [ RunTime:0.011914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA626-VR-S' OR `brand` LIKE '3PEAK%' ) ) LIMIT 1 [ RunTime:0.023205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903355 LIMIT 5 [ RunTime:0.012781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903355 ORDER BY `minOrder` ASC [ RunTime:0.001505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903355 ORDER BY `unit` DESC [ RunTime:0.003765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903355 LIMIT 2 [ RunTime:0.011064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903355 ORDER BY `minOrder` ASC [ RunTime:0.003162s ]
select * from pdf where partno='TPA6205A1DGNR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.002546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6205A1DGNR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.005037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63904139 LIMIT 5 [ RunTime:0.001049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904139 ORDER BY `minOrder` ASC [ RunTime:0.000798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63904139 ORDER BY `unit` DESC [ RunTime:0.006364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63904139 LIMIT 2 [ RunTime:0.003624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904139 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='TPA6202A1ZQVR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6202A1ZQVR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.003007s ]
SELECT `id` FROM `stock` WHERE `id` <> 63904139 AND `partno` = 'TPA6202A1ZQVR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.009172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903562 LIMIT 5 [ RunTime:0.002570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903562 ORDER BY `minOrder` ASC [ RunTime:0.005956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903562 ORDER BY `unit` DESC [ RunTime:0.003986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903562 LIMIT 2 [ RunTime:0.003451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903562 ORDER BY `minOrder` ASC [ RunTime:0.004495s ]
select * from pdf where partno='TPA6211A1DRB' and brandshort='Texas Instruments' limit 1 [ RunTime:0.007474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6211A1DRB' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.017666s ]
SELECT `id` FROM `stock` WHERE `id` <> 63903562 AND `partno` = 'TPA6211A1DRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.011931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056846 [ RunTime:0.005243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903351 LIMIT 5 [ RunTime:0.003944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903351 ORDER BY `minOrder` ASC [ RunTime:0.005685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903351 ORDER BY `unit` DESC [ RunTime:0.003733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903351 LIMIT 2 [ RunTime:0.006122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903351 ORDER BY `minOrder` ASC [ RunTime:0.007346s ]
select * from pdf where partno='TPA6211A1DRBR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6211A1DRBR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.009821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903369 LIMIT 5 [ RunTime:0.009892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903369 ORDER BY `minOrder` ASC [ RunTime:0.002028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903369 ORDER BY `unit` DESC [ RunTime:0.016925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903369 LIMIT 2 [ RunTime:0.009449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903369 ORDER BY `minOrder` ASC [ RunTime:0.010135s ]
select * from pdf where partno='TPA6205A1DGN' and brandshort='Texas Instruments' limit 1 [ RunTime:0.013783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6205A1DGN' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.001418s ]
SELECT `id` FROM `stock` WHERE `id` <> 63903369 AND `partno` = 'TPA6205A1DGN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.013925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51056642 [ RunTime:0.027222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63904167 LIMIT 5 [ RunTime:0.004441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904167 ORDER BY `minOrder` ASC [ RunTime:0.006371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63904167 ORDER BY `unit` DESC [ RunTime:0.012286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63904167 LIMIT 2 [ RunTime:0.000829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904167 ORDER BY `minOrder` ASC [ RunTime:0.005992s ]
select * from pdf where partno='TPA6205A1DRBT' and brandshort='Texas Instruments' limit 1 [ RunTime:0.007475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6205A1DRBT' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.005814s ]
SELECT `id` FROM `stock` WHERE `id` <> 63904167 AND `partno` = 'TPA6205A1DRBT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.022185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057552 [ RunTime:0.015369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63904124 LIMIT 5 [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904124 ORDER BY `minOrder` ASC [ RunTime:0.012744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63904124 ORDER BY `unit` DESC [ RunTime:0.017860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63904124 LIMIT 2 [ RunTime:0.009184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904124 ORDER BY `minOrder` ASC [ RunTime:0.007073s ]
select * from pdf where partno='TPA6203A1DRB' and brandshort='Texas Instruments' limit 1 [ RunTime:0.009437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6203A1DRB' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.012869s ]
SELECT `id` FROM `stock` WHERE `id` <> 63904124 AND `partno` = 'TPA6203A1DRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.024646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51057549 [ RunTime:0.000957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63904919 LIMIT 5 [ RunTime:0.015117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904919 ORDER BY `minOrder` ASC [ RunTime:0.030768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63904919 ORDER BY `unit` DESC [ RunTime:0.021918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63904919 LIMIT 2 [ RunTime:0.011231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904919 ORDER BY `minOrder` ASC [ RunTime:0.014070s ]
select * from pdf where partno='TPA6205A1NMBR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.007767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6205A1NMBR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.020039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63904924 LIMIT 5 [ RunTime:0.029316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904924 ORDER BY `minOrder` ASC [ RunTime:0.011207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63904924 ORDER BY `unit` DESC [ RunTime:0.023706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63904924 LIMIT 2 [ RunTime:0.015603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63904924 ORDER BY `minOrder` ASC [ RunTime:0.005895s ]
select * from pdf where partno='TPA6204A1DRB' and brandshort='Texas Instruments' limit 1 [ RunTime:0.017721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6204A1DRB' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.005561s ]
SELECT `id` FROM `stock` WHERE `id` <> 63904924 AND `partno` = 'TPA6204A1DRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.010219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63903280 LIMIT 5 [ RunTime:0.036332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903280 ORDER BY `minOrder` ASC [ RunTime:0.031607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63903280 ORDER BY `unit` DESC [ RunTime:0.022253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63903280 LIMIT 2 [ RunTime:0.037263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63903280 ORDER BY `minOrder` ASC [ RunTime:0.005306s ]
select * from pdf where partno='TPA6205A1DRBR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.017726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6205A1DRBR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.014496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64034058 LIMIT 5 [ RunTime:0.010965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64034058 ORDER BY `minOrder` ASC [ RunTime:0.022014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64034058 ORDER BY `unit` DESC [ RunTime:0.023055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64034058 LIMIT 2 [ RunTime:0.013173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64034058 ORDER BY `minOrder` ASC [ RunTime:0.020419s ]
select * from pdf where partno='TPA6204A1EVM' and brandshort='Texas Instruments' limit 1 [ RunTime:0.006240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TPA6204A1EVM' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.001505s ]
SELECT `id` FROM `stock` WHERE `id` <> 64034058 AND `partno` = 'TPA6204A1EVM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.013787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12404821 [ RunTime:0.047135s ]
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 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013923s ]
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 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018748s ]
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 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003162s ]
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 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006777s ]
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 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011128s ]
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 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008046s ]
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 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016698s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TPA62%' OR `brand` LIKE 'TPA62%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002155s ]