SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001449s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=ULN2004A&search=1' [ RunTime:0.001625s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001354s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003557s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002319s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.013055s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001336s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014929s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001333s ]
SELECT * FROM `stock_search` WHERE `partno` = 'ULN2004A' LIMIT 1 [ RunTime:0.008775s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-07-21 00:02:22' WHERE `partno` = 'ULN2004A' [ RunTime:0.003047s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002673s ]
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 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016956s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24521 LIMIT 5 [ RunTime:0.007704s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24521 ORDER BY `minOrder` ASC [ RunTime:0.007634s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24521 ORDER BY `unit` DESC [ RunTime:0.005336s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24521 LIMIT 2 [ RunTime:0.006411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24521 ORDER BY `minOrder` ASC [ RunTime:0.006645s ]
select * from pdf where partno='uln2004a' and brandshort='TI' limit 1 [ RunTime:0.011974s ]
select foldpath,foldpath2,filename from pdf_file where id=588447 limit 1 [ RunTime:0.020699s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'uln2004a' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.054448s ]
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 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014112s ]
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 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51750579 LIMIT 5 [ RunTime:0.013928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750579 ORDER BY `minOrder` ASC [ RunTime:0.002394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51750579 ORDER BY `unit` DESC [ RunTime:0.011323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51750579 LIMIT 2 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750579 ORDER BY `minOrder` ASC [ RunTime:0.006619s ]
select * from pdf where partno='ULN2004ADR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.009268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004ADR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.004261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51750709 LIMIT 5 [ RunTime:0.036709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750709 ORDER BY `minOrder` ASC [ RunTime:0.016333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51750709 ORDER BY `unit` DESC [ RunTime:0.002623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51750709 LIMIT 2 [ RunTime:0.001763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750709 ORDER BY `minOrder` ASC [ RunTime:0.003824s ]
select * from pdf where partno='ULN2004A' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.002528s ]
select foldpath,foldpath2,filename from pdf_file where id=332279 limit 1 [ RunTime:0.003965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004A' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751113 LIMIT 5 [ RunTime:0.013944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751113 ORDER BY `minOrder` ASC [ RunTime:0.035559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751113 ORDER BY `unit` DESC [ RunTime:0.035662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751113 LIMIT 2 [ RunTime:0.018539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751113 ORDER BY `minOrder` ASC [ RunTime:0.020124s ]
select * from pdf where partno='ULN2004ANS' and brandshort='Texas Instruments' limit 1 [ RunTime:0.018629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004ANS' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.023447s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751113 AND `partno` = 'ULN2004ANS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.034368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51750849 LIMIT 5 [ RunTime:0.024041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750849 ORDER BY `minOrder` ASC [ RunTime:0.001783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51750849 ORDER BY `unit` DESC [ RunTime:0.000624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51750849 LIMIT 2 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750849 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
select * from pdf where partno='ULN2004AS16-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.006398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AS16-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51750969 LIMIT 5 [ RunTime:0.002946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750969 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51750969 ORDER BY `unit` DESC [ RunTime:0.008881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51750969 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750969 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='ULN2004ADYYR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004ADYYR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.004106s ]
SELECT `id` FROM `stock` WHERE `id` <> 51750969 AND `partno` = 'ULN2004ADYYR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.004090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751073 LIMIT 5 [ RunTime:0.005015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751073 ORDER BY `minOrder` ASC [ RunTime:0.001317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751073 ORDER BY `unit` DESC [ RunTime:0.011266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751073 LIMIT 2 [ RunTime:0.024738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751073 ORDER BY `minOrder` ASC [ RunTime:0.011534s ]
select * from pdf where partno='ULN2004AN' and brandshort='TAEJIN' limit 1 [ RunTime:0.001155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AN' OR `brand` LIKE 'TAEJIN%' ) ) LIMIT 1 [ RunTime:0.002050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751228 LIMIT 5 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751228 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751228 ORDER BY `unit` DESC [ RunTime:0.000320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751228 LIMIT 2 [ RunTime:0.006204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751228 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
select * from pdf where partno='ULN2004AD' and brandshort='TAEJIN' limit 1 [ RunTime:0.000563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AD' OR `brand` LIKE 'TAEJIN%' ) ) LIMIT 1 [ RunTime:0.003063s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751228 AND `partno` = 'ULN2004AD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taejin%' ) [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751177 LIMIT 5 [ RunTime:0.000743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751177 ORDER BY `minOrder` ASC [ RunTime:0.000892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751177 ORDER BY `unit` DESC [ RunTime:0.002440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751177 LIMIT 2 [ RunTime:0.007780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751177 ORDER BY `minOrder` ASC [ RunTime:0.001618s ]
select * from pdf where partno='ULN2004AID' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AID' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.002740s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751177 AND `partno` = 'ULN2004AID' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51750712 LIMIT 5 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750712 ORDER BY `minOrder` ASC [ RunTime:0.003355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51750712 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51750712 LIMIT 2 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750712 ORDER BY `minOrder` ASC [ RunTime:0.008702s ]
select * from pdf where partno='ULN2004AN' and brandshort='Texas Instruments' limit 1 [ RunTime:0.002670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AN' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.001744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51750713 LIMIT 5 [ RunTime:0.003154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750713 ORDER BY `minOrder` ASC [ RunTime:0.028607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51750713 ORDER BY `unit` DESC [ RunTime:0.020907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51750713 LIMIT 2 [ RunTime:0.012163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750713 ORDER BY `minOrder` ASC [ RunTime:0.003661s ]
select * from pdf where partno='ULN2004AIN' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AIN' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.013632s ]
SELECT `id` FROM `stock` WHERE `id` <> 51750713 AND `partno` = 'ULN2004AIN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.007934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51750967 LIMIT 5 [ RunTime:0.002742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750967 ORDER BY `minOrder` ASC [ RunTime:0.016737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51750967 ORDER BY `unit` DESC [ RunTime:0.006468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51750967 LIMIT 2 [ RunTime:0.004536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51750967 ORDER BY `minOrder` ASC [ RunTime:0.005989s ]
select * from pdf where partno='ULN2004ANSR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.012148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004ANSR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.004345s ]
SELECT `id` FROM `stock` WHERE `id` <> 51750967 AND `partno` = 'ULN2004ANSR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.022388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751179 LIMIT 5 [ RunTime:0.019491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751179 ORDER BY `minOrder` ASC [ RunTime:0.010252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751179 ORDER BY `unit` DESC [ RunTime:0.027509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751179 LIMIT 2 [ RunTime:0.005137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751179 ORDER BY `minOrder` ASC [ RunTime:0.017913s ]
select * from pdf where partno='ULN2004AINSR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.018567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AINSR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.004736s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751179 AND `partno` = 'ULN2004AINSR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.003089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751322 LIMIT 5 [ RunTime:0.006089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751322 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751322 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751322 LIMIT 2 [ RunTime:0.002760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751322 ORDER BY `minOrder` ASC [ RunTime:0.013066s ]
select * from pdf where partno='ULN2004AD' and brandshort='Texas Instruments' limit 1 [ RunTime:0.011548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AD' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000858s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751322 AND `partno` = 'ULN2004AD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.007877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751995 LIMIT 5 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751995 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751995 ORDER BY `unit` DESC [ RunTime:0.002793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751995 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751995 ORDER BY `minOrder` ASC [ RunTime:0.002645s ]
select * from pdf where partno='ULN2004AIDR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AIDR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.006109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751940 LIMIT 5 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751940 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751940 ORDER BY `unit` DESC [ RunTime:0.000310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751940 LIMIT 2 [ RunTime:0.002253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751940 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='ULN2004ADRG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004ADRG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.001173s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751940 AND `partno` = 'ULN2004ADRG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751927 LIMIT 5 [ RunTime:0.001397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751927 ORDER BY `minOrder` ASC [ RunTime:0.005434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751927 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751927 LIMIT 2 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751927 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='ULN2004ADG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004ADG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000481s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751927 AND `partno` = 'ULN2004ADG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751926 LIMIT 5 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751926 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751926 ORDER BY `unit` DESC [ RunTime:0.000478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751926 LIMIT 2 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751926 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='ULN2004ADE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.000633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004ADE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.000457s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751926 AND `partno` = 'ULN2004ADE4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751862 LIMIT 5 [ RunTime:0.005399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751862 ORDER BY `minOrder` ASC [ RunTime:0.004807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751862 ORDER BY `unit` DESC [ RunTime:0.020969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751862 LIMIT 2 [ RunTime:0.038233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751862 ORDER BY `minOrder` ASC [ RunTime:0.004430s ]
select * from pdf where partno='ULN2004ANG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.019852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004ANG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.012419s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751862 AND `partno` = 'ULN2004ANG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.016906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751846 LIMIT 5 [ RunTime:0.004050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751846 ORDER BY `minOrder` ASC [ RunTime:0.020281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751846 ORDER BY `unit` DESC [ RunTime:0.005928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751846 LIMIT 2 [ RunTime:0.007918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751846 ORDER BY `minOrder` ASC [ RunTime:0.005384s ]
select * from pdf where partno='ULN2004AINSG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.006858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AINSG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.003557s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751846 AND `partno` = 'ULN2004AINSG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51751845 LIMIT 5 [ RunTime:0.013554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751845 ORDER BY `minOrder` ASC [ RunTime:0.010659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51751845 ORDER BY `unit` DESC [ RunTime:0.005688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51751845 LIMIT 2 [ RunTime:0.017815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51751845 ORDER BY `minOrder` ASC [ RunTime:0.010333s ]
select * from pdf where partno='ULN2004AINSE4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.016399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ULN2004AINSE4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.031004s ]
SELECT `id` FROM `stock` WHERE `id` <> 51751845 AND `partno` = 'ULN2004AINSE4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.035413s ]
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 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042474s ]
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 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017432s ]
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 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017847s ]
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 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017532s ]
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 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014503s ]
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 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001686s ]
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 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013173s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ULN2004A%' OR `brand` LIKE 'ULN2004A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.040781s ]