SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002336s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.103' , `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=SMAJ18AH&search=1' [ RunTime:0.003877s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002422s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008450s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002361s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.103' ) [ RunTime:0.006469s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002377s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002826s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002816s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ18AH' LIMIT 1 [ RunTime:0.033657s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-13 13:09:26' WHERE `partno` = 'SMAJ18AH' [ RunTime:0.029311s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002688s ]
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 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.085730s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13927864 LIMIT 5 [ RunTime:0.069375s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13927864 ORDER BY `minOrder` ASC [ RunTime:0.043914s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13927864 ORDER BY `unit` DESC [ RunTime:0.095206s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.024924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13927864 LIMIT 2 [ RunTime:0.023313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13927864 ORDER BY `minOrder` ASC [ RunTime:0.018010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819732 LIMIT 5 [ RunTime:0.038207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819732 ORDER BY `minOrder` ASC [ RunTime:0.065966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819732 ORDER BY `unit` DESC [ RunTime:0.090103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819732 LIMIT 2 [ RunTime:0.046337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819732 ORDER BY `minOrder` ASC [ RunTime:0.018036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662847 LIMIT 5 [ RunTime:0.106234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662847 ORDER BY `minOrder` ASC [ RunTime:0.061965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662847 ORDER BY `unit` DESC [ RunTime:0.054520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662847 LIMIT 2 [ RunTime:0.030901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662847 ORDER BY `minOrder` ASC [ RunTime:0.021238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692305 LIMIT 5 [ RunTime:0.050727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692305 ORDER BY `minOrder` ASC [ RunTime:0.063485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692305 ORDER BY `unit` DESC [ RunTime:0.168222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692305 LIMIT 2 [ RunTime:0.106827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692305 ORDER BY `minOrder` ASC [ RunTime:0.062541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669384 LIMIT 5 [ RunTime:0.026489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669384 ORDER BY `minOrder` ASC [ RunTime:0.148715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669384 ORDER BY `unit` DESC [ RunTime:0.125920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669384 LIMIT 2 [ RunTime:0.042194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669384 ORDER BY `minOrder` ASC [ RunTime:0.057732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668018 LIMIT 5 [ RunTime:0.028433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668018 ORDER BY `minOrder` ASC [ RunTime:0.056764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668018 ORDER BY `unit` DESC [ RunTime:0.051990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668018 LIMIT 2 [ RunTime:0.035706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668018 ORDER BY `minOrder` ASC [ RunTime:0.041218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667572 LIMIT 5 [ RunTime:0.086967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667572 ORDER BY `minOrder` ASC [ RunTime:0.032207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667572 ORDER BY `unit` DESC [ RunTime:0.029235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667572 LIMIT 2 [ RunTime:0.162839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667572 ORDER BY `minOrder` ASC [ RunTime:0.012731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829663 LIMIT 5 [ RunTime:0.050412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829663 ORDER BY `minOrder` ASC [ RunTime:0.078017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829663 ORDER BY `unit` DESC [ RunTime:0.087788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829663 LIMIT 2 [ RunTime:0.038104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829663 ORDER BY `minOrder` ASC [ RunTime:0.022820s ]
select * from pdf where partno='SMAJ18AHE3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829153 LIMIT 5 [ RunTime:0.016428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829153 ORDER BY `minOrder` ASC [ RunTime:0.042677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829153 ORDER BY `unit` DESC [ RunTime:0.014779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829153 LIMIT 2 [ RunTime:0.010966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829153 ORDER BY `minOrder` ASC [ RunTime:0.040703s ]
select * from pdf where partno='SMAJ18AHE3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.069551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932727 LIMIT 5 [ RunTime:0.036394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932727 ORDER BY `minOrder` ASC [ RunTime:0.041053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932727 ORDER BY `unit` DESC [ RunTime:0.052402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932727 LIMIT 2 [ RunTime:0.035490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932727 ORDER BY `minOrder` ASC [ RunTime:0.029783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911484 LIMIT 5 [ RunTime:0.047270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911484 ORDER BY `minOrder` ASC [ RunTime:0.040900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13911484 ORDER BY `unit` DESC [ RunTime:0.057169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13911484 LIMIT 2 [ RunTime:0.029549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911484 ORDER BY `minOrder` ASC [ RunTime:0.016317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910476 LIMIT 5 [ RunTime:0.047867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910476 ORDER BY `minOrder` ASC [ RunTime:0.048987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910476 ORDER BY `unit` DESC [ RunTime:0.026688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910476 LIMIT 2 [ RunTime:0.026041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910476 ORDER BY `minOrder` ASC [ RunTime:0.021394s ]
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 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007862s ]
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 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123963 LIMIT 5 [ RunTime:0.080578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123963 ORDER BY `minOrder` ASC [ RunTime:0.019735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123963 ORDER BY `unit` DESC [ RunTime:0.027928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123963 LIMIT 2 [ RunTime:0.030714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123963 ORDER BY `minOrder` ASC [ RunTime:0.015529s ]
select * from pdf where partno='SMAJ18AH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.009442s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ18AH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.011188s ]
SELECT `id` FROM `stock` WHERE `id` <> 42123963 AND `partno` = 'SMAJ18AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.017450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13927864 [ RunTime:0.024253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114708 LIMIT 5 [ RunTime:0.013347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114708 ORDER BY `minOrder` ASC [ RunTime:0.021331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114708 ORDER BY `unit` DESC [ RunTime:0.017793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114708 LIMIT 2 [ RunTime:0.008772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114708 ORDER BY `minOrder` ASC [ RunTime:0.001066s ]
select * from pdf where partno='SMAJ18AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ18AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003064s ]
SELECT `id` FROM `stock` WHERE `id` <> 42114708 AND `partno` = 'SMAJ18AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.025590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819732 [ RunTime:0.005665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42153004 LIMIT 5 [ RunTime:0.048936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153004 ORDER BY `minOrder` ASC [ RunTime:0.012007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42153004 ORDER BY `unit` DESC [ RunTime:0.003205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42153004 LIMIT 2 [ RunTime:0.012493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153004 ORDER BY `minOrder` ASC [ RunTime:0.002986s ]
select * from pdf where partno='SMAJ18AHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.018586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ18AHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.021341s ]
SELECT `id` FROM `stock` WHERE `id` <> 42153004 AND `partno` = 'SMAJ18AHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.019031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662847 [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42216621 LIMIT 5 [ RunTime:0.016276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42216621 ORDER BY `minOrder` ASC [ RunTime:0.014054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42216621 ORDER BY `unit` DESC [ RunTime:0.007308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42216621 LIMIT 2 [ RunTime:0.006070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42216621 ORDER BY `minOrder` ASC [ RunTime:0.001531s ]
select * from pdf where partno='SMAJ18AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.015977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ18AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.026891s ]
SELECT `id` FROM `stock` WHERE `id` <> 42216621 AND `partno` = 'SMAJ18AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669384 [ RunTime:0.035814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42215852 LIMIT 5 [ RunTime:0.032395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215852 ORDER BY `minOrder` ASC [ RunTime:0.020535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42215852 ORDER BY `unit` DESC [ RunTime:0.009488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42215852 LIMIT 2 [ RunTime:0.007528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215852 ORDER BY `minOrder` ASC [ RunTime:0.012957s ]
select * from pdf where partno='SMAJ18AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ18AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004601s ]
SELECT `id` FROM `stock` WHERE `id` <> 42215852 AND `partno` = 'SMAJ18AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668018 [ RunTime:0.012986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42206555 LIMIT 5 [ RunTime:0.037036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42206555 ORDER BY `minOrder` ASC [ RunTime:0.048489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42206555 ORDER BY `unit` DESC [ RunTime:0.009642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42206555 LIMIT 2 [ RunTime:0.009521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42206555 ORDER BY `minOrder` ASC [ RunTime:0.005884s ]
select * from pdf where partno='SMAJ18AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ18AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.009675s ]
SELECT `id` FROM `stock` WHERE `id` <> 42206555 AND `partno` = 'SMAJ18AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.024740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911484 [ RunTime:0.013090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42205598 LIMIT 5 [ RunTime:0.017593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205598 ORDER BY `minOrder` ASC [ RunTime:0.023434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42205598 ORDER BY `unit` DESC [ RunTime:0.034863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42205598 LIMIT 2 [ RunTime:0.014840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205598 ORDER BY `minOrder` ASC [ RunTime:0.004323s ]
select * from pdf where partno='SMAJ18AHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.008736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ18AHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.010461s ]
SELECT `id` FROM `stock` WHERE `id` <> 42205598 AND `partno` = 'SMAJ18AHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.016896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667572 [ RunTime:0.011896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42193948 LIMIT 5 [ RunTime:0.010114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42193948 ORDER BY `minOrder` ASC [ RunTime:0.014124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42193948 ORDER BY `unit` DESC [ RunTime:0.020136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42193948 LIMIT 2 [ RunTime:0.023497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42193948 ORDER BY `minOrder` ASC [ RunTime:0.003595s ]
select * from pdf where partno='SMAJ18AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.006870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ18AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.007583s ]
SELECT `id` FROM `stock` WHERE `id` <> 42193948 AND `partno` = 'SMAJ18AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.002262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910476 [ RunTime:0.000466s ]
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 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014507s ]
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 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016138s ]
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 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019367s ]
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 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008753s ]
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 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031209s ]
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 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016152s ]
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 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006861s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ18AH%' OR `brand` LIKE 'SMAJ18AH%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015403s ]