SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002408s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=P6SMB7.5A&search=1' [ RunTime:0.006727s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002495s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006634s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001647s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.003691s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001237s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002300s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001415s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6SMB7.5A' LIMIT 1 [ RunTime:0.022219s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-18 04:11:27' WHERE `partno` = 'P6SMB7.5A' [ RunTime:0.010290s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001441s ]
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 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010169s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663373 LIMIT 5 [ RunTime:0.009289s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663373 ORDER BY `minOrder` ASC [ RunTime:0.019846s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663373 ORDER BY `unit` DESC [ RunTime:0.020114s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663373 LIMIT 2 [ RunTime:0.009404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663373 ORDER BY `minOrder` ASC [ RunTime:0.004940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815970 LIMIT 5 [ RunTime:0.012136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815970 ORDER BY `minOrder` ASC [ RunTime:0.002089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815970 ORDER BY `unit` DESC [ RunTime:0.032754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815970 LIMIT 2 [ RunTime:0.025178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815970 ORDER BY `minOrder` ASC [ RunTime:0.016064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816379 LIMIT 5 [ RunTime:0.014900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816379 ORDER BY `minOrder` ASC [ RunTime:0.006264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816379 ORDER BY `unit` DESC [ RunTime:0.008663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816379 LIMIT 2 [ RunTime:0.003614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816379 ORDER BY `minOrder` ASC [ RunTime:0.013123s ]
select * from pdf where partno='P6SMB7.5A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.027969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800841 LIMIT 5 [ RunTime:0.036108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800841 ORDER BY `minOrder` ASC [ RunTime:0.020951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800841 ORDER BY `unit` DESC [ RunTime:0.008755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800841 LIMIT 2 [ RunTime:0.011171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800841 ORDER BY `minOrder` ASC [ RunTime:0.009526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692200 LIMIT 5 [ RunTime:0.010602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692200 ORDER BY `minOrder` ASC [ RunTime:0.005806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692200 ORDER BY `unit` DESC [ RunTime:0.013210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692200 LIMIT 2 [ RunTime:0.017043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692200 ORDER BY `minOrder` ASC [ RunTime:0.006274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692199 LIMIT 5 [ RunTime:0.011177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692199 ORDER BY `minOrder` ASC [ RunTime:0.012187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692199 ORDER BY `unit` DESC [ RunTime:0.005057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692199 LIMIT 2 [ RunTime:0.013792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692199 ORDER BY `minOrder` ASC [ RunTime:0.025547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691397 LIMIT 5 [ RunTime:0.007603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691397 ORDER BY `minOrder` ASC [ RunTime:0.002453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691397 ORDER BY `unit` DESC [ RunTime:0.003976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691397 LIMIT 2 [ RunTime:0.014794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691397 ORDER BY `minOrder` ASC [ RunTime:0.000927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671767 LIMIT 5 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671767 ORDER BY `minOrder` ASC [ RunTime:0.004223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671767 ORDER BY `unit` DESC [ RunTime:0.009454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671767 LIMIT 2 [ RunTime:0.013733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671767 ORDER BY `minOrder` ASC [ RunTime:0.006677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671696 LIMIT 5 [ RunTime:0.005351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671696 ORDER BY `minOrder` ASC [ RunTime:0.004080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671696 ORDER BY `unit` DESC [ RunTime:0.008137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671696 LIMIT 2 [ RunTime:0.013286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671696 ORDER BY `minOrder` ASC [ RunTime:0.009401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670426 LIMIT 5 [ RunTime:0.008103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670426 ORDER BY `minOrder` ASC [ RunTime:0.005803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670426 ORDER BY `unit` DESC [ RunTime:0.006501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670426 LIMIT 2 [ RunTime:0.012324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670426 ORDER BY `minOrder` ASC [ RunTime:0.011224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669574 LIMIT 5 [ RunTime:0.011379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669574 ORDER BY `minOrder` ASC [ RunTime:0.007188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669574 ORDER BY `unit` DESC [ RunTime:0.003306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669574 LIMIT 2 [ RunTime:0.002021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669574 ORDER BY `minOrder` ASC [ RunTime:0.006582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668722 LIMIT 5 [ RunTime:0.001024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668722 ORDER BY `minOrder` ASC [ RunTime:0.008705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668722 ORDER BY `unit` DESC [ RunTime:0.019191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668722 LIMIT 2 [ RunTime:0.017596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668722 ORDER BY `minOrder` ASC [ RunTime:0.005405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818479 LIMIT 5 [ RunTime:0.001917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818479 ORDER BY `minOrder` ASC [ RunTime:0.017636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818479 ORDER BY `unit` DESC [ RunTime:0.010761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818479 LIMIT 2 [ RunTime:0.006597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818479 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816940 LIMIT 5 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816940 ORDER BY `minOrder` ASC [ RunTime:0.002771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816940 ORDER BY `unit` DESC [ RunTime:0.012136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816940 LIMIT 2 [ RunTime:0.014120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816940 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814905 LIMIT 5 [ RunTime:0.001873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814905 ORDER BY `minOrder` ASC [ RunTime:0.002540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814905 ORDER BY `unit` DESC [ RunTime:0.005635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814905 LIMIT 2 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814905 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811733 LIMIT 5 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811733 ORDER BY `minOrder` ASC [ RunTime:0.008408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811733 ORDER BY `unit` DESC [ RunTime:0.001811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811733 LIMIT 2 [ RunTime:0.006479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811733 ORDER BY `minOrder` ASC [ RunTime:0.002078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811669 LIMIT 5 [ RunTime:0.017295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811669 ORDER BY `minOrder` ASC [ RunTime:0.000713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811669 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811669 LIMIT 2 [ RunTime:0.003905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811669 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810908 LIMIT 5 [ RunTime:0.005241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810908 ORDER BY `minOrder` ASC [ RunTime:0.001758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810908 ORDER BY `unit` DESC [ RunTime:0.000500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810908 LIMIT 2 [ RunTime:0.002359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810908 ORDER BY `minOrder` ASC [ RunTime:0.006370s ]
select * from pdf where partno='P6SMB7.5A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810788 LIMIT 5 [ RunTime:0.008572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810788 ORDER BY `minOrder` ASC [ RunTime:0.022297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810788 ORDER BY `unit` DESC [ RunTime:0.002352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810788 LIMIT 2 [ RunTime:0.005899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810788 ORDER BY `minOrder` ASC [ RunTime:0.008768s ]
select * from pdf where partno='P6SMB7.5A-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809644 LIMIT 5 [ RunTime:0.020109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809644 ORDER BY `minOrder` ASC [ RunTime:0.008821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809644 ORDER BY `unit` DESC [ RunTime:0.010499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809644 LIMIT 2 [ RunTime:0.006402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809644 ORDER BY `minOrder` ASC [ RunTime:0.004268s ]
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 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005226s ]
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 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159953 LIMIT 5 [ RunTime:0.033956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159953 ORDER BY `minOrder` ASC [ RunTime:0.003439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159953 ORDER BY `unit` DESC [ RunTime:0.009818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159953 LIMIT 2 [ RunTime:0.009592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159953 ORDER BY `minOrder` ASC [ RunTime:0.008228s ]
select * from pdf where partno='P6SMB7.5A' and brandshort='NextGen Components' limit 1 [ RunTime:0.000618s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5A' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.011198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42124501 LIMIT 5 [ RunTime:0.007903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124501 ORDER BY `minOrder` ASC [ RunTime:0.009652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42124501 ORDER BY `unit` DESC [ RunTime:0.002161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42124501 LIMIT 2 [ RunTime:0.012917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42124501 ORDER BY `minOrder` ASC [ RunTime:0.002148s ]
select * from pdf where partno='P6SMB7.5A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.006379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.023242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112606 LIMIT 5 [ RunTime:0.009808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112606 ORDER BY `minOrder` ASC [ RunTime:0.009355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112606 ORDER BY `unit` DESC [ RunTime:0.019817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112606 LIMIT 2 [ RunTime:0.048148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112606 ORDER BY `minOrder` ASC [ RunTime:0.016710s ]
select * from pdf where partno='P6SMB7.5A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.009094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.005692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150188 LIMIT 5 [ RunTime:0.015388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150188 ORDER BY `minOrder` ASC [ RunTime:0.011549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150188 ORDER BY `unit` DESC [ RunTime:0.010785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150188 LIMIT 2 [ RunTime:0.026887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150188 ORDER BY `minOrder` ASC [ RunTime:0.003729s ]
select * from pdf where partno='P6SMB7.5AT3G' and brandshort='onsemi' limit 1 [ RunTime:0.063864s ]
select foldpath,foldpath2,filename from pdf_file where id=1109184 limit 1 [ RunTime:0.019279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AT3G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.072242s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150188 AND `partno` = 'P6SMB7.5AT3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.041783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800841 [ RunTime:0.027673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42140714 LIMIT 5 [ RunTime:0.004353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140714 ORDER BY `minOrder` ASC [ RunTime:0.054100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42140714 ORDER BY `unit` DESC [ RunTime:0.022046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42140714 LIMIT 2 [ RunTime:0.006100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140714 ORDER BY `minOrder` ASC [ RunTime:0.011483s ]
select * from pdf where partno='P6SMB7.5A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.061777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004716s ]
SELECT `id` FROM `stock` WHERE `id` <> 42140714 AND `partno` = 'P6SMB7.5A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.026843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42259867 LIMIT 5 [ RunTime:0.083614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259867 ORDER BY `minOrder` ASC [ RunTime:0.088920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42259867 ORDER BY `unit` DESC [ RunTime:0.028682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42259867 LIMIT 2 [ RunTime:0.015285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259867 ORDER BY `minOrder` ASC [ RunTime:0.004134s ]
select * from pdf where partno='P6SMB7.5AT3' and brandshort='onsemi' limit 1 [ RunTime:0.026432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AT3' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.042711s ]
SELECT `id` FROM `stock` WHERE `id` <> 42259867 AND `partno` = 'P6SMB7.5AT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.024677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814905 [ RunTime:0.051535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42244378 LIMIT 5 [ RunTime:0.031557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42244378 ORDER BY `minOrder` ASC [ RunTime:0.014674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42244378 ORDER BY `unit` DESC [ RunTime:0.054108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42244378 LIMIT 2 [ RunTime:0.014014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42244378 ORDER BY `minOrder` ASC [ RunTime:0.014832s ]
select * from pdf where partno='P6SMB7.5AHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013735s ]
SELECT `id` FROM `stock` WHERE `id` <> 42244378 AND `partno` = 'P6SMB7.5AHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.028472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914062 [ RunTime:0.016749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42244375 LIMIT 5 [ RunTime:0.004635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42244375 ORDER BY `minOrder` ASC [ RunTime:0.010875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42244375 ORDER BY `unit` DESC [ RunTime:0.088056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42244375 LIMIT 2 [ RunTime:0.030947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42244375 ORDER BY `minOrder` ASC [ RunTime:0.049694s ]
select * from pdf where partno='P6SMB7.5AHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.018478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.052890s ]
SELECT `id` FROM `stock` WHERE `id` <> 42244375 AND `partno` = 'P6SMB7.5AHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.097550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914810 [ RunTime:0.064627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242327 LIMIT 5 [ RunTime:0.048071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242327 ORDER BY `minOrder` ASC [ RunTime:0.037908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242327 ORDER BY `unit` DESC [ RunTime:0.027564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242327 LIMIT 2 [ RunTime:0.077828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242327 ORDER BY `minOrder` ASC [ RunTime:0.053492s ]
select * from pdf where partno='P6SMB7.5AHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.032434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.058855s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242327 AND `partno` = 'P6SMB7.5AHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.027788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671696 [ RunTime:0.049480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242323 LIMIT 5 [ RunTime:0.021030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242323 ORDER BY `minOrder` ASC [ RunTime:0.022120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242323 ORDER BY `unit` DESC [ RunTime:0.026049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242323 LIMIT 2 [ RunTime:0.024126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242323 ORDER BY `minOrder` ASC [ RunTime:0.011206s ]
select * from pdf where partno='P6SMB7.5AHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.015726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.015785s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242323 AND `partno` = 'P6SMB7.5AHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.057668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811669 [ RunTime:0.035608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42234619 LIMIT 5 [ RunTime:0.037156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234619 ORDER BY `minOrder` ASC [ RunTime:0.028693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42234619 ORDER BY `unit` DESC [ RunTime:0.023549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42234619 LIMIT 2 [ RunTime:0.041069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234619 ORDER BY `minOrder` ASC [ RunTime:0.003280s ]
select * from pdf where partno='P6SMB7.5AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.024680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.054356s ]
SELECT `id` FROM `stock` WHERE `id` <> 42234619 AND `partno` = 'P6SMB7.5AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915055 [ RunTime:0.024721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42232960 LIMIT 5 [ RunTime:0.019192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232960 ORDER BY `minOrder` ASC [ RunTime:0.018254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42232960 ORDER BY `unit` DESC [ RunTime:0.011052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42232960 LIMIT 2 [ RunTime:0.015273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232960 ORDER BY `minOrder` ASC [ RunTime:0.037621s ]
select * from pdf where partno='P6SMB7.5A-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.010478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5A-M3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.046815s ]
SELECT `id` FROM `stock` WHERE `id` <> 42232960 AND `partno` = 'P6SMB7.5A-M3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810788 [ RunTime:0.014165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42232959 LIMIT 5 [ RunTime:0.050518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232959 ORDER BY `minOrder` ASC [ RunTime:0.005498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42232959 ORDER BY `unit` DESC [ RunTime:0.007364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42232959 LIMIT 2 [ RunTime:0.020238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232959 ORDER BY `minOrder` ASC [ RunTime:0.009061s ]
select * from pdf where partno='P6SMB7.5A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.021951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5A-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014100s ]
SELECT `id` FROM `stock` WHERE `id` <> 42232959 AND `partno` = 'P6SMB7.5A-M3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.030409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810908 [ RunTime:0.012694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42232878 LIMIT 5 [ RunTime:0.004883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232878 ORDER BY `minOrder` ASC [ RunTime:0.011755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42232878 ORDER BY `unit` DESC [ RunTime:0.031089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42232878 LIMIT 2 [ RunTime:0.036484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232878 ORDER BY `minOrder` ASC [ RunTime:0.016106s ]
select * from pdf where partno='P6SMB7.5AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.033138s ]
SELECT `id` FROM `stock` WHERE `id` <> 42232878 AND `partno` = 'P6SMB7.5AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.056119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671767 [ RunTime:0.031554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42230464 LIMIT 5 [ RunTime:0.024105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42230464 ORDER BY `minOrder` ASC [ RunTime:0.039609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42230464 ORDER BY `unit` DESC [ RunTime:0.028334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42230464 LIMIT 2 [ RunTime:0.028284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42230464 ORDER BY `minOrder` ASC [ RunTime:0.003261s ]
select * from pdf where partno='P6SMB7.5AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.029141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.016983s ]
SELECT `id` FROM `stock` WHERE `id` <> 42230464 AND `partno` = 'P6SMB7.5AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.008208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811733 [ RunTime:0.037011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222475 LIMIT 5 [ RunTime:0.008155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222475 ORDER BY `minOrder` ASC [ RunTime:0.011839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222475 ORDER BY `unit` DESC [ RunTime:0.020565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222475 LIMIT 2 [ RunTime:0.019278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222475 ORDER BY `minOrder` ASC [ RunTime:0.009108s ]
select * from pdf where partno='P6SMB7.5AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.024478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.030921s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222475 AND `partno` = 'P6SMB7.5AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.032500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670426 [ RunTime:0.026515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221615 LIMIT 5 [ RunTime:0.023876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221615 ORDER BY `minOrder` ASC [ RunTime:0.021835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221615 ORDER BY `unit` DESC [ RunTime:0.016500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221615 LIMIT 2 [ RunTime:0.015103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221615 ORDER BY `minOrder` ASC [ RunTime:0.023950s ]
select * from pdf where partno='P6SMB7.5A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.019200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.050860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221604 LIMIT 5 [ RunTime:0.022164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221604 ORDER BY `minOrder` ASC [ RunTime:0.015726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221604 ORDER BY `unit` DESC [ RunTime:0.021678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221604 LIMIT 2 [ RunTime:0.007481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221604 ORDER BY `minOrder` ASC [ RunTime:0.002694s ]
select * from pdf where partno='P6SMB7.5AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.017395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002013s ]
SELECT `id` FROM `stock` WHERE `id` <> 42221604 AND `partno` = 'P6SMB7.5AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.019580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809644 [ RunTime:0.012548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42212830 LIMIT 5 [ RunTime:0.055392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212830 ORDER BY `minOrder` ASC [ RunTime:0.015458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42212830 ORDER BY `unit` DESC [ RunTime:0.009265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42212830 LIMIT 2 [ RunTime:0.008711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212830 ORDER BY `minOrder` ASC [ RunTime:0.003070s ]
select * from pdf where partno='P6SMB7.5A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.029419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.003308s ]
SELECT `id` FROM `stock` WHERE `id` <> 42212830 AND `partno` = 'P6SMB7.5A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.001690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668722 [ RunTime:0.030042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42210863 LIMIT 5 [ RunTime:0.006402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42210863 ORDER BY `minOrder` ASC [ RunTime:0.014352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42210863 ORDER BY `unit` DESC [ RunTime:0.024084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42210863 LIMIT 2 [ RunTime:0.006183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42210863 ORDER BY `minOrder` ASC [ RunTime:0.005120s ]
select * from pdf where partno='P6SMB7.5A-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB7.5A-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.012090s ]
SELECT `id` FROM `stock` WHERE `id` <> 42210863 AND `partno` = 'P6SMB7.5A-E3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.008052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807302 [ RunTime:0.020944s ]
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 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012085s ]
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 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011387s ]
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 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013184s ]
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 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012884s ]
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 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060378s ]
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 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016583s ]
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 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060897s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6SMB7.5A%' OR `brand` LIKE 'P6SMB7.5A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.029262s ]