SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001555s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=SA24A&search=1' [ RunTime:0.003491s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001265s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004874s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001956s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.001169s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002436s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001832s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002540s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SA24A' LIMIT 1 [ RunTime:0.003210s ]
UPDATE `stock_search` SET `count` = 20353 , `updatetime` = '2026-07-30 04:23:18' WHERE `partno` = 'SA24A' [ RunTime:0.004112s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002910s ]
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 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018508s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.008497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662192 LIMIT 5 [ RunTime:0.019531s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662192 ORDER BY `minOrder` ASC [ RunTime:0.010022s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662192 ORDER BY `unit` DESC [ RunTime:0.016065s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662192 LIMIT 2 [ RunTime:0.016485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662192 ORDER BY `minOrder` ASC [ RunTime:0.006274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905446 LIMIT 5 [ RunTime:0.070058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905446 ORDER BY `minOrder` ASC [ RunTime:0.014655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905446 ORDER BY `unit` DESC [ RunTime:0.039674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905446 LIMIT 2 [ RunTime:0.027136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905446 ORDER BY `minOrder` ASC [ RunTime:0.051982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908498 LIMIT 5 [ RunTime:0.047185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908498 ORDER BY `minOrder` ASC [ RunTime:0.033755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908498 ORDER BY `unit` DESC [ RunTime:0.020393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908498 LIMIT 2 [ RunTime:0.011695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908498 ORDER BY `minOrder` ASC [ RunTime:0.024907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909383 LIMIT 5 [ RunTime:0.040505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909383 ORDER BY `minOrder` ASC [ RunTime:0.033182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13909383 ORDER BY `unit` DESC [ RunTime:0.026143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13909383 LIMIT 2 [ RunTime:0.038693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909383 ORDER BY `minOrder` ASC [ RunTime:0.008934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8674 LIMIT 5 [ RunTime:0.008193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8674 ORDER BY `minOrder` ASC [ RunTime:0.039935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8674 ORDER BY `unit` DESC [ RunTime:0.008877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8674 LIMIT 2 [ RunTime:0.018990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8674 ORDER BY `minOrder` ASC [ RunTime:0.005905s ]
select * from pdf where partno='SA24A' and brandshort='TAIWAN SEMICONDUCTOR' limit 1 [ RunTime:0.026730s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24A' OR `brand` LIKE 'TAIWAN SEMICONDUCTOR%' ) ) LIMIT 1 [ RunTime:0.027769s ]
SELECT `id` FROM `stock` WHERE `id` <> 8674 AND `partno` = 'SA24A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor%' ) [ RunTime:0.024746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668904 [ RunTime:0.067680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16693067 LIMIT 5 [ RunTime:0.012969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16693067 ORDER BY `minOrder` ASC [ RunTime:0.009326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16693067 ORDER BY `unit` DESC [ RunTime:0.016749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16693067 LIMIT 2 [ RunTime:0.021156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16693067 ORDER BY `minOrder` ASC [ RunTime:0.008637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687183 LIMIT 5 [ RunTime:0.022098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687183 ORDER BY `minOrder` ASC [ RunTime:0.061458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687183 ORDER BY `unit` DESC [ RunTime:0.032836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687183 LIMIT 2 [ RunTime:0.009443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687183 ORDER BY `minOrder` ASC [ RunTime:0.003675s ]
select * from pdf where partno='SA24A' and brandshort='onsemi' limit 1 [ RunTime:0.017471s ]
select foldpath,foldpath2,filename from pdf_file where id=346669 limit 1 [ RunTime:0.023251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668904 LIMIT 5 [ RunTime:0.010300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668904 ORDER BY `minOrder` ASC [ RunTime:0.025311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668904 ORDER BY `unit` DESC [ RunTime:0.003002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668904 LIMIT 2 [ RunTime:0.054594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668904 ORDER BY `minOrder` ASC [ RunTime:0.015101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666936 LIMIT 5 [ RunTime:0.042495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666936 ORDER BY `minOrder` ASC [ RunTime:0.012817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666936 ORDER BY `unit` DESC [ RunTime:0.028266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666936 LIMIT 2 [ RunTime:0.051918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666936 ORDER BY `minOrder` ASC [ RunTime:0.020544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833817 LIMIT 5 [ RunTime:0.021654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833817 ORDER BY `minOrder` ASC [ RunTime:0.015611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833817 ORDER BY `unit` DESC [ RunTime:0.040345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833817 LIMIT 2 [ RunTime:0.010487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833817 ORDER BY `minOrder` ASC [ RunTime:0.001072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827948 LIMIT 5 [ RunTime:0.024807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827948 ORDER BY `minOrder` ASC [ RunTime:0.009663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827948 ORDER BY `unit` DESC [ RunTime:0.008569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827948 LIMIT 2 [ RunTime:0.013222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827948 ORDER BY `minOrder` ASC [ RunTime:0.005661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932928 LIMIT 5 [ RunTime:0.004952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932928 ORDER BY `minOrder` ASC [ RunTime:0.015032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932928 ORDER BY `unit` DESC [ RunTime:0.011666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932928 LIMIT 2 [ RunTime:0.010211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932928 ORDER BY `minOrder` ASC [ RunTime:0.002020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932043 LIMIT 5 [ RunTime:0.019566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932043 ORDER BY `minOrder` ASC [ RunTime:0.024716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932043 ORDER BY `unit` DESC [ RunTime:0.012038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932043 LIMIT 2 [ RunTime:0.030651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932043 ORDER BY `minOrder` ASC [ RunTime:0.008519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928573 LIMIT 5 [ RunTime:0.004099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928573 ORDER BY `minOrder` ASC [ RunTime:0.015497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928573 ORDER BY `unit` DESC [ RunTime:0.018243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928573 LIMIT 2 [ RunTime:0.010750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928573 ORDER BY `minOrder` ASC [ RunTime:0.000631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928333 LIMIT 5 [ RunTime:0.001128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928333 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928333 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928333 LIMIT 2 [ RunTime:0.011851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928333 ORDER BY `minOrder` ASC [ RunTime:0.011281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916531 LIMIT 5 [ RunTime:0.007373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916531 ORDER BY `minOrder` ASC [ RunTime:0.005336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916531 ORDER BY `unit` DESC [ RunTime:0.004033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916531 LIMIT 2 [ RunTime:0.003499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916531 ORDER BY `minOrder` ASC [ RunTime:0.010905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912336 LIMIT 5 [ RunTime:0.004361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912336 ORDER BY `minOrder` ASC [ RunTime:0.005481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912336 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912336 LIMIT 2 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912336 ORDER BY `minOrder` ASC [ RunTime:0.003963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910242 LIMIT 5 [ RunTime:0.003377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910242 ORDER BY `minOrder` ASC [ RunTime:0.008864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910242 ORDER BY `unit` DESC [ RunTime:0.014006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910242 LIMIT 2 [ RunTime:0.006348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910242 ORDER BY `minOrder` ASC [ RunTime:0.006204s ]
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 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019053s ]
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 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42104307 LIMIT 5 [ RunTime:0.004726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104307 ORDER BY `minOrder` ASC [ RunTime:0.007661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42104307 ORDER BY `unit` DESC [ RunTime:0.014603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42104307 LIMIT 2 [ RunTime:0.005696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42104307 ORDER BY `minOrder` ASC [ RunTime:0.002242s ]
select * from pdf where partno='SA24A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.013676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.033808s ]
SELECT `id` FROM `stock` WHERE `id` <> 42104307 AND `partno` = 'SA24A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.014007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909383 [ RunTime:0.008649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147186 LIMIT 5 [ RunTime:0.010637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147186 ORDER BY `minOrder` ASC [ RunTime:0.029255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147186 ORDER BY `unit` DESC [ RunTime:0.007705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147186 LIMIT 2 [ RunTime:0.020084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147186 ORDER BY `minOrder` ASC [ RunTime:0.009830s ]
select * from pdf where partno='SA24ARLG' and brandshort='onsemi' limit 1 [ RunTime:0.009853s ]
select foldpath,foldpath2,filename from pdf_file where id=346669 limit 1 [ RunTime:0.022707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24ARLG' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.030459s ]
SELECT `id` FROM `stock` WHERE `id` <> 42147186 AND `partno` = 'SA24ARLG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.018339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662192 [ RunTime:0.026459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42145733 LIMIT 5 [ RunTime:0.012576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145733 ORDER BY `minOrder` ASC [ RunTime:0.023765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42145733 ORDER BY `unit` DESC [ RunTime:0.021737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42145733 LIMIT 2 [ RunTime:0.027609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145733 ORDER BY `minOrder` ASC [ RunTime:0.017522s ]
select * from pdf where partno='SA24A' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.026567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24A' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.033366s ]
SELECT `id` FROM `stock` WHERE `id` <> 42145733 AND `partno` = 'SA24A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.032507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905446 [ RunTime:0.047298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105132 LIMIT 5 [ RunTime:0.104334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105132 ORDER BY `minOrder` ASC [ RunTime:0.032933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105132 ORDER BY `unit` DESC [ RunTime:0.041768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105132 LIMIT 2 [ RunTime:0.040006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105132 ORDER BY `minOrder` ASC [ RunTime:0.012210s ]
select * from pdf where partno='SA24A-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.058188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24A-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.091811s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105132 AND `partno` = 'SA24A-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.046914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908498 [ RunTime:0.054717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42276762 LIMIT 5 [ RunTime:0.023829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42276762 ORDER BY `minOrder` ASC [ RunTime:0.034017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42276762 ORDER BY `unit` DESC [ RunTime:0.027543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42276762 LIMIT 2 [ RunTime:0.037572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42276762 ORDER BY `minOrder` ASC [ RunTime:0.008872s ]
select * from pdf where partno='SA24AHE3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.052905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24AHE3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.026914s ]
SELECT `id` FROM `stock` WHERE `id` <> 42276762 AND `partno` = 'SA24AHE3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.034875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42273889 LIMIT 5 [ RunTime:0.033169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273889 ORDER BY `minOrder` ASC [ RunTime:0.033950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42273889 ORDER BY `unit` DESC [ RunTime:0.030615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42273889 LIMIT 2 [ RunTime:0.023801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273889 ORDER BY `minOrder` ASC [ RunTime:0.014429s ]
select * from pdf where partno='SA24A-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.029407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24A-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009106s ]
SELECT `id` FROM `stock` WHERE `id` <> 42273889 AND `partno` = 'SA24A-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.017822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42272367 LIMIT 5 [ RunTime:0.031524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272367 ORDER BY `minOrder` ASC [ RunTime:0.031648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42272367 ORDER BY `unit` DESC [ RunTime:0.048300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42272367 LIMIT 2 [ RunTime:0.046354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272367 ORDER BY `minOrder` ASC [ RunTime:0.012811s ]
select * from pdf where partno='SA24AHE3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.034054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24AHE3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019389s ]
SELECT `id` FROM `stock` WHERE `id` <> 42272367 AND `partno` = 'SA24AHE3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916531 [ RunTime:0.000734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42212226 LIMIT 5 [ RunTime:0.009623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212226 ORDER BY `minOrder` ASC [ RunTime:0.022951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42212226 ORDER BY `unit` DESC [ RunTime:0.013570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42212226 LIMIT 2 [ RunTime:0.028001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212226 ORDER BY `minOrder` ASC [ RunTime:0.010519s ]
select * from pdf where partno='SA24AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.029814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.011690s ]
SELECT `id` FROM `stock` WHERE `id` <> 42212226 AND `partno` = 'SA24AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.022688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912336 [ RunTime:0.029567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42212225 LIMIT 5 [ RunTime:0.018427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212225 ORDER BY `minOrder` ASC [ RunTime:0.026164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42212225 ORDER BY `unit` DESC [ RunTime:0.010293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42212225 LIMIT 2 [ RunTime:0.016330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212225 ORDER BY `minOrder` ASC [ RunTime:0.018881s ]
select * from pdf where partno='SA24A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.022230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.007452s ]
SELECT `id` FROM `stock` WHERE `id` <> 42212225 AND `partno` = 'SA24A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.024894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668904 [ RunTime:0.026287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42190284 LIMIT 5 [ RunTime:0.011318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190284 ORDER BY `minOrder` ASC [ RunTime:0.029353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42190284 ORDER BY `unit` DESC [ RunTime:0.024140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42190284 LIMIT 2 [ RunTime:0.021470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190284 ORDER BY `minOrder` ASC [ RunTime:0.010510s ]
select * from pdf where partno='SA24A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.055562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.016842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42190031 LIMIT 5 [ RunTime:0.011805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190031 ORDER BY `minOrder` ASC [ RunTime:0.015135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42190031 ORDER BY `unit` DESC [ RunTime:0.027116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42190031 LIMIT 2 [ RunTime:0.030941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190031 ORDER BY `minOrder` ASC [ RunTime:0.004888s ]
select * from pdf where partno='SA24A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.002829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA24A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.032387s ]
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 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027888s ]
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 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007368s ]
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 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026278s ]
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 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006136s ]
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 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030529s ]
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 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030124s ]
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 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011952s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SA24A%' OR `brand` LIKE 'SA24A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007339s ]