SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003268s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000659s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002670s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.93' ) [ RunTime:0.000374s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002130s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002159s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TL431' LIMIT 1 [ RunTime:0.000704s ]
UPDATE `stock_search` SET `count` = 2398 , `updatetime` = '2026-06-02 04:05:38' WHERE `partno` = 'TL431' [ RunTime:0.003750s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000284s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002533s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'TL431%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.024770s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'TL431%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 540,20 [ RunTime:0.007356s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('25047793','25047792','25047791','25047787','25047785','25047784','25047782','25047781','25047780','25047776','25047758','25047756','25047755','25047754','25047753','25047752','25047746','25047744','25047743','25047741') ORDER BY FIELD(s.id, 25047793,25047792,25047791,25047787,25047785,25047784,25047782,25047781,25047780,25047776,25047758,25047756,25047755,25047754,25047753,25047752,25047746,25047744,25047743,25047741) [ RunTime:0.006574s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047793 LIMIT 4 [ RunTime:0.008086s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047793 ORDER BY `minOrder` ASC [ RunTime:0.004870s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047793 ORDER BY `unit` DESC [ RunTime:0.006924s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047793 LIMIT 2 [ RunTime:0.007911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047793 ORDER BY `minOrder` ASC [ RunTime:0.001091s ]
select * from pdf where partno='TL431IDRE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.008492s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431IDRE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.003782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047792 LIMIT 4 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047792 ORDER BY `minOrder` ASC [ RunTime:0.002210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047792 ORDER BY `unit` DESC [ RunTime:0.004174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047792 LIMIT 2 [ RunTime:0.024593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047792 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='TL431IL5T' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.003211s ]
select foldpath,foldpath2,filename from pdf_file where id=1114464 limit 1 [ RunTime:0.005227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431IL5T' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.002160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047791 LIMIT 4 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047791 ORDER BY `minOrder` ASC [ RunTime:0.015168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047791 ORDER BY `unit` DESC [ RunTime:0.015199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047791 LIMIT 2 [ RunTime:0.004597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047791 ORDER BY `minOrder` ASC [ RunTime:0.003253s ]
select * from pdf where partno='TL431AU-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.007195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AU-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.013892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047787 LIMIT 4 [ RunTime:0.008330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047787 ORDER BY `minOrder` ASC [ RunTime:0.010798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047787 ORDER BY `unit` DESC [ RunTime:0.006382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047787 LIMIT 2 [ RunTime:0.003101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047787 ORDER BY `minOrder` ASC [ RunTime:0.007358s ]
select * from pdf where partno='TL431ILPRE' and brandshort='onsemi' limit 1 [ RunTime:0.001356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431ILPRE' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.022955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047785 LIMIT 4 [ RunTime:0.005129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047785 ORDER BY `minOrder` ASC [ RunTime:0.007233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047785 ORDER BY `unit` DESC [ RunTime:0.013470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047785 LIMIT 2 [ RunTime:0.003601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047785 ORDER BY `minOrder` ASC [ RunTime:0.003571s ]
select * from pdf where partno='TL431CPG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.002461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CPG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.006668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047784 LIMIT 4 [ RunTime:0.008484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047784 ORDER BY `minOrder` ASC [ RunTime:0.008994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047784 ORDER BY `unit` DESC [ RunTime:0.018032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047784 LIMIT 2 [ RunTime:0.034203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047784 ORDER BY `minOrder` ASC [ RunTime:0.008948s ]
select * from pdf where partno='TL431BMFDT/8R' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.026827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BMFDT/8R' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.012764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047782 LIMIT 4 [ RunTime:0.010074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047782 ORDER BY `minOrder` ASC [ RunTime:0.015622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047782 ORDER BY `unit` DESC [ RunTime:0.006314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047782 LIMIT 2 [ RunTime:0.013043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047782 ORDER BY `minOrder` ASC [ RunTime:0.015106s ]
select * from pdf where partno='TL431CD' and brandshort='onsemi' limit 1 [ RunTime:0.009701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CD' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.018102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047781 LIMIT 4 [ RunTime:0.024624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047781 ORDER BY `minOrder` ASC [ RunTime:0.015142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047781 ORDER BY `unit` DESC [ RunTime:0.016391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047781 LIMIT 2 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047781 ORDER BY `minOrder` ASC [ RunTime:0.003203s ]
select * from pdf where partno='TL431CPKE6' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CPKE6' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.011783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047780 LIMIT 4 [ RunTime:0.009834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047780 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047780 ORDER BY `unit` DESC [ RunTime:0.007520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047780 LIMIT 2 [ RunTime:0.015886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047780 ORDER BY `minOrder` ASC [ RunTime:0.015993s ]
select * from pdf where partno='TL431AS-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.014445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AS-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.006665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047776 LIMIT 4 [ RunTime:0.014627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047776 ORDER BY `minOrder` ASC [ RunTime:0.012967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047776 ORDER BY `unit` DESC [ RunTime:0.016686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047776 LIMIT 2 [ RunTime:0.011275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047776 ORDER BY `minOrder` ASC [ RunTime:0.006622s ]
select * from pdf where partno='TL431QDBVRE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.019451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431QDBVRE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.013932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047758 LIMIT 4 [ RunTime:0.014952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047758 ORDER BY `minOrder` ASC [ RunTime:0.020292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047758 ORDER BY `unit` DESC [ RunTime:0.017763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047758 LIMIT 2 [ RunTime:0.019250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047758 ORDER BY `minOrder` ASC [ RunTime:0.004927s ]
select * from pdf where partno='TL431CPWR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.008051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CPWR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.004557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047756 LIMIT 4 [ RunTime:0.011336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047756 ORDER BY `minOrder` ASC [ RunTime:0.012335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047756 ORDER BY `unit` DESC [ RunTime:0.008017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047756 LIMIT 2 [ RunTime:0.016484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047756 ORDER BY `minOrder` ASC [ RunTime:0.001943s ]
select * from pdf where partno='TL431BMFDT/8VL' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.001105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BMFDT/8VL' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.003829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047755 LIMIT 4 [ RunTime:0.016416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047755 ORDER BY `minOrder` ASC [ RunTime:0.003771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047755 ORDER BY `unit` DESC [ RunTime:0.008058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047755 LIMIT 2 [ RunTime:0.001509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047755 ORDER BY `minOrder` ASC [ RunTime:0.002413s ]
select * from pdf where partno='TL431BFDT,215' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.008505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BFDT,215' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.008771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047754 LIMIT 4 [ RunTime:0.008520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047754 ORDER BY `minOrder` ASC [ RunTime:0.004927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047754 ORDER BY `unit` DESC [ RunTime:0.004619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047754 LIMIT 2 [ RunTime:0.006666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047754 ORDER BY `minOrder` ASC [ RunTime:0.008551s ]
select * from pdf where partno='TL431CPWG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.004459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CPWG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.001392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047753 LIMIT 4 [ RunTime:0.001440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047753 ORDER BY `minOrder` ASC [ RunTime:0.004815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047753 ORDER BY `unit` DESC [ RunTime:0.008364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047753 LIMIT 2 [ RunTime:0.010466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047753 ORDER BY `minOrder` ASC [ RunTime:0.001491s ]
select * from pdf where partno='TL431CPWE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CPWE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.006312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047752 LIMIT 4 [ RunTime:0.006370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047752 ORDER BY `minOrder` ASC [ RunTime:0.003846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047752 ORDER BY `unit` DESC [ RunTime:0.005256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047752 LIMIT 2 [ RunTime:0.004969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047752 ORDER BY `minOrder` ASC [ RunTime:0.000568s ]
select * from pdf where partno='TL431CPW' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431CPW' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.008300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047746 LIMIT 4 [ RunTime:0.000754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047746 ORDER BY `minOrder` ASC [ RunTime:0.010709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047746 ORDER BY `unit` DESC [ RunTime:0.019441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047746 LIMIT 2 [ RunTime:0.018799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047746 ORDER BY `minOrder` ASC [ RunTime:0.009667s ]
select * from pdf where partno='TL431AIDRE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.009575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AIDRE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047744 LIMIT 4 [ RunTime:0.009446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047744 ORDER BY `minOrder` ASC [ RunTime:0.008716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047744 ORDER BY `unit` DESC [ RunTime:0.007754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047744 LIMIT 2 [ RunTime:0.007185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047744 ORDER BY `minOrder` ASC [ RunTime:0.001829s ]
select * from pdf where partno='TL431BIDBZR,215' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.009760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BIDBZR,215' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.006685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047743 LIMIT 4 [ RunTime:0.004852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047743 ORDER BY `minOrder` ASC [ RunTime:0.000787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047743 ORDER BY `unit` DESC [ RunTime:0.005355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047743 LIMIT 2 [ RunTime:0.005643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047743 ORDER BY `minOrder` ASC [ RunTime:0.011996s ]
select * from pdf where partno='TL431AN' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.010366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AN' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.027180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25047741 LIMIT 4 [ RunTime:0.002731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047741 ORDER BY `minOrder` ASC [ RunTime:0.004390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25047741 ORDER BY `unit` DESC [ RunTime:0.001532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25047741 LIMIT 2 [ RunTime:0.004151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25047741 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
select * from pdf where partno='TL431AQDBVRG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.002072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AQDBVRG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.004314s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'TL431%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.005355s ]