SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002553s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.149' , `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=BC857A&search=1' [ RunTime:0.005278s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.004512s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004148s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001921s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.149' ) [ RunTime:0.000645s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001719s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000632s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003492s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BC857A' LIMIT 1 [ RunTime:0.009142s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-09-08 02:18:38' WHERE `partno` = 'BC857A' [ RunTime:0.027353s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.007751s ]
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 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008281s ]
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 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017927s ]
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 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035215s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65421057 LIMIT 5 [ RunTime:0.008449s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65421057 ORDER BY `minOrder` ASC [ RunTime:0.010344s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65421057 ORDER BY `unit` DESC [ RunTime:0.006968s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65421057 LIMIT 2 [ RunTime:0.007545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65421057 ORDER BY `minOrder` ASC [ RunTime:0.010490s ]
select * from pdf where partno='BC857AQAZ' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.001932s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.007360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857AQAZ' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.009560s ]
SELECT `id` FROM `stock` WHERE `id` <> 65421057 AND `partno` = 'BC857AQAZ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp usa inc.%' ) [ RunTime:0.010430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51737694 LIMIT 5 [ RunTime:0.007517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51737694 ORDER BY `minOrder` ASC [ RunTime:0.010988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51737694 ORDER BY `unit` DESC [ RunTime:0.010088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51737694 LIMIT 2 [ RunTime:0.010802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51737694 ORDER BY `minOrder` ASC [ RunTime:0.007477s ]
select * from pdf where partno='BC857ALT1' and brandshort='onsemi' limit 1 [ RunTime:0.010731s ]
select foldpath,foldpath2,filename from pdf_file where id=423333 limit 1 [ RunTime:0.007329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857ALT1' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.034117s ]
SELECT `id` FROM `stock` WHERE `id` <> 51737694 AND `partno` = 'BC857ALT1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.009417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65416149 LIMIT 5 [ RunTime:0.007791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65416149 ORDER BY `minOrder` ASC [ RunTime:0.008579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65416149 ORDER BY `unit` DESC [ RunTime:0.006956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65416149 LIMIT 2 [ RunTime:0.010702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65416149 ORDER BY `minOrder` ASC [ RunTime:0.010899s ]
select * from pdf where partno='BC857A-7-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.005009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857A-7-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.010813s ]
SELECT `id` FROM `stock` WHERE `id` <> 65416149 AND `partno` = 'BC857A-7-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.007402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65418525 LIMIT 5 [ RunTime:0.007618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65418525 ORDER BY `minOrder` ASC [ RunTime:0.007105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65418525 ORDER BY `unit` DESC [ RunTime:0.014154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65418525 LIMIT 2 [ RunTime:0.004231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65418525 ORDER BY `minOrder` ASC [ RunTime:0.001054s ]
select * from pdf where partno='BC857AMTF' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.001513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857AMTF' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001957s ]
SELECT `id` FROM `stock` WHERE `id` <> 65418525 AND `partno` = 'BC857AMTF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.010510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65415910 LIMIT 5 [ RunTime:0.003707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65415910 ORDER BY `minOrder` ASC [ RunTime:0.001933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65415910 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65415910 LIMIT 2 [ RunTime:0.000466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65415910 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
select * from pdf where partno='BC857ALT1G' and brandshort='onsemi' limit 1 [ RunTime:0.004914s ]
select foldpath,foldpath2,filename from pdf_file where id=1164808 limit 1 [ RunTime:0.007702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857ALT1G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.015130s ]
SELECT `id` FROM `stock` WHERE `id` <> 65415910 AND `partno` = 'BC857ALT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.001186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65417033 LIMIT 5 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65417033 ORDER BY `minOrder` ASC [ RunTime:0.004653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65417033 ORDER BY `unit` DESC [ RunTime:0.000754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65417033 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65417033 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
select * from pdf where partno='BC857A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000726s ]
SELECT `id` FROM `stock` WHERE `id` <> 65417033 AND `partno` = 'BC857A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65418032 LIMIT 5 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65418032 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65418032 ORDER BY `unit` DESC [ RunTime:0.000519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65418032 LIMIT 2 [ RunTime:0.000459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65418032 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
select * from pdf where partno='BC857AWHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.003020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857AWHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000773s ]
SELECT `id` FROM `stock` WHERE `id` <> 65418032 AND `partno` = 'BC857AWHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65415922 LIMIT 5 [ RunTime:0.002112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65415922 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65415922 ORDER BY `unit` DESC [ RunTime:0.000604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65415922 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65415922 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
select * from pdf where partno='BC857A,215' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.000646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857A,215' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000534s ]
SELECT `id` FROM `stock` WHERE `id` <> 65415922 AND `partno` = 'BC857A,215' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.000662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65418039 LIMIT 5 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65418039 ORDER BY `minOrder` ASC [ RunTime:0.038631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65418039 ORDER BY `unit` DESC [ RunTime:0.010596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65418039 LIMIT 2 [ RunTime:0.007499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65418039 ORDER BY `minOrder` ASC [ RunTime:0.004233s ]
select * from pdf where partno='BC857AHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857AHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.000719s ]
SELECT `id` FROM `stock` WHERE `id` <> 65418039 AND `partno` = 'BC857AHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.000960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65415924 LIMIT 5 [ RunTime:0.000888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65415924 ORDER BY `minOrder` ASC [ RunTime:0.001007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65415924 ORDER BY `unit` DESC [ RunTime:0.000896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65415924 LIMIT 2 [ RunTime:0.000803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65415924 ORDER BY `minOrder` ASC [ RunTime:0.000990s ]
select * from pdf where partno='BC857A' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.007375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857A' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.010402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419500 LIMIT 5 [ RunTime:0.010635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419500 ORDER BY `minOrder` ASC [ RunTime:0.011046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419500 ORDER BY `unit` DESC [ RunTime:0.006739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419500 LIMIT 2 [ RunTime:0.002428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419500 ORDER BY `minOrder` ASC [ RunTime:0.002337s ]
select * from pdf where partno='BC857AQC-QZ' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.004470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857AQC-QZ' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.003503s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419500 AND `partno` = 'BC857AQC-QZ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.004548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65416077 LIMIT 5 [ RunTime:0.005706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65416077 ORDER BY `minOrder` ASC [ RunTime:0.007927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65416077 ORDER BY `unit` DESC [ RunTime:0.005899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65416077 LIMIT 2 [ RunTime:0.009176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65416077 ORDER BY `minOrder` ASC [ RunTime:0.010881s ]
select * from pdf where partno='BC857A RFG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.009104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857A RFG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.010508s ]
SELECT `id` FROM `stock` WHERE `id` <> 65416077 AND `partno` = 'BC857A RFG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.010545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419387 LIMIT 5 [ RunTime:0.003766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419387 ORDER BY `minOrder` ASC [ RunTime:0.009713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419387 ORDER BY `unit` DESC [ RunTime:0.010465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419387 LIMIT 2 [ RunTime:0.007381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419387 ORDER BY `minOrder` ASC [ RunTime:0.007480s ]
select * from pdf where partno='BC857A-AU_R1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.010968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857A-AU_R1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.007435s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419387 AND `partno` = 'BC857A-AU_R1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.007424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65418885 LIMIT 5 [ RunTime:0.007524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65418885 ORDER BY `minOrder` ASC [ RunTime:0.007527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65418885 ORDER BY `unit` DESC [ RunTime:0.010621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65418885 LIMIT 2 [ RunTime:0.007504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65418885 ORDER BY `minOrder` ASC [ RunTime:0.001431s ]
select * from pdf where partno='BC857AW' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.016890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857AW' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.007274s ]
SELECT `id` FROM `stock` WHERE `id` <> 65418885 AND `partno` = 'BC857AW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.007437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65419209 LIMIT 5 [ RunTime:0.007463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419209 ORDER BY `minOrder` ASC [ RunTime:0.007411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65419209 ORDER BY `unit` DESC [ RunTime:0.010571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65419209 LIMIT 2 [ RunTime:0.003850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65419209 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
select * from pdf where partno='BC857AW_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857AW_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000724s ]
SELECT `id` FROM `stock` WHERE `id` <> 65419209 AND `partno` = 'BC857AW_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65417932 LIMIT 5 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65417932 ORDER BY `minOrder` ASC [ RunTime:0.000953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65417932 ORDER BY `unit` DESC [ RunTime:0.010715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65417932 LIMIT 2 [ RunTime:0.007393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65417932 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
select * from pdf where partno='BC857A-AQ' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.000764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857A-AQ' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000785s ]
SELECT `id` FROM `stock` WHERE `id` <> 65417932 AND `partno` = 'BC857A-AQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.001122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65421733 LIMIT 5 [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65421733 ORDER BY `minOrder` ASC [ RunTime:0.001822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65421733 ORDER BY `unit` DESC [ RunTime:0.009660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65421733 LIMIT 2 [ RunTime:0.010830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65421733 ORDER BY `minOrder` ASC [ RunTime:0.010631s ]
select * from pdf where partno='BC857A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.006377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.001195s ]
SELECT `id` FROM `stock` WHERE `id` <> 65421733 AND `partno` = 'BC857A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.001257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65421489 LIMIT 5 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65421489 ORDER BY `minOrder` ASC [ RunTime:0.003717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65421489 ORDER BY `unit` DESC [ RunTime:0.010517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65421489 LIMIT 2 [ RunTime:0.007442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65421489 ORDER BY `minOrder` ASC [ RunTime:0.007391s ]
select * from pdf where partno='BC857AW-7-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.010827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857AW-7-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.007298s ]
SELECT `id` FROM `stock` WHERE `id` <> 65421489 AND `partno` = 'BC857AW-7-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.007414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65421642 LIMIT 5 [ RunTime:0.007475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65421642 ORDER BY `minOrder` ASC [ RunTime:0.007535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65421642 ORDER BY `unit` DESC [ RunTime:0.010319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65421642 LIMIT 2 [ RunTime:0.007514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65421642 ORDER BY `minOrder` ASC [ RunTime:0.007523s ]
select * from pdf where partno='BC857AM,315' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.007194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857AM,315' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000680s ]
SELECT `id` FROM `stock` WHERE `id` <> 65421642 AND `partno` = 'BC857AM,315' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.000664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65421345 LIMIT 5 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65421345 ORDER BY `minOrder` ASC [ RunTime:0.007863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65421345 ORDER BY `unit` DESC [ RunTime:0.010665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65421345 LIMIT 2 [ RunTime:0.007515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65421345 ORDER BY `minOrder` ASC [ RunTime:0.007526s ]
select * from pdf where partno='BC857AW,115' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.010898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC857AW,115' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.007366s ]
SELECT `id` FROM `stock` WHERE `id` <> 65421345 AND `partno` = 'BC857AW,115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.007462s ]
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 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011090s ]
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 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011138s ]
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 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011026s ]
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 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011168s ]
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 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009527s ]
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 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007201s ]
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 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002359s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BC857A%' OR `brand` LIKE 'BC857A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001721s ]