SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001213s ]
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=SMAJ120AH&search=1' [ RunTime:0.027109s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001845s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007589s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001366s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.002569s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.006232s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.015018s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001499s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ120AH' LIMIT 1 [ RunTime:0.029479s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-18 05:12:47' WHERE `partno` = 'SMAJ120AH' [ RunTime:0.008973s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001465s ]
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 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058927s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662846 LIMIT 5 [ RunTime:0.066880s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.031796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662846 ORDER BY `minOrder` ASC [ RunTime:0.052700s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662846 ORDER BY `unit` DESC [ RunTime:0.097460s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662846 LIMIT 2 [ RunTime:0.044447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662846 ORDER BY `minOrder` ASC [ RunTime:0.025353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689439 LIMIT 5 [ RunTime:0.021713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689439 ORDER BY `minOrder` ASC [ RunTime:0.072803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689439 ORDER BY `unit` DESC [ RunTime:0.083558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689439 LIMIT 2 [ RunTime:0.067493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689439 ORDER BY `minOrder` ASC [ RunTime:0.031084s ]
select * from pdf where partno='SMAJ120AHE3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.027601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809839 LIMIT 5 [ RunTime:0.034163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809839 ORDER BY `minOrder` ASC [ RunTime:0.133152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809839 ORDER BY `unit` DESC [ RunTime:0.019615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809839 LIMIT 2 [ RunTime:0.081329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809839 ORDER BY `minOrder` ASC [ RunTime:0.016116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806910 LIMIT 5 [ RunTime:0.020683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806910 ORDER BY `minOrder` ASC [ RunTime:0.072869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806910 ORDER BY `unit` DESC [ RunTime:0.126990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806910 LIMIT 2 [ RunTime:0.054984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806910 ORDER BY `minOrder` ASC [ RunTime:0.058723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806325 LIMIT 5 [ RunTime:0.091707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806325 ORDER BY `minOrder` ASC [ RunTime:0.029230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806325 ORDER BY `unit` DESC [ RunTime:0.057310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806325 LIMIT 2 [ RunTime:0.039166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806325 ORDER BY `minOrder` ASC [ RunTime:0.012831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932709 LIMIT 5 [ RunTime:0.097431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932709 ORDER BY `minOrder` ASC [ RunTime:0.071405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932709 ORDER BY `unit` DESC [ RunTime:0.035165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932709 LIMIT 2 [ RunTime:0.033398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932709 ORDER BY `minOrder` ASC [ RunTime:0.020911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932708 LIMIT 5 [ RunTime:0.048990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932708 ORDER BY `minOrder` ASC [ RunTime:0.087847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932708 ORDER BY `unit` DESC [ RunTime:0.046692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932708 LIMIT 2 [ RunTime:0.003468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932708 ORDER BY `minOrder` ASC [ RunTime:0.049671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13929610 LIMIT 5 [ RunTime:0.050864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929610 ORDER BY `minOrder` ASC [ RunTime:0.011400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13929610 ORDER BY `unit` DESC [ RunTime:0.065203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13929610 LIMIT 2 [ RunTime:0.030750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13929610 ORDER BY `minOrder` ASC [ RunTime:0.014796s ]
select * from pdf where partno='SMAJ120AHE3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.057420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913976 LIMIT 5 [ RunTime:0.056840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913976 ORDER BY `minOrder` ASC [ RunTime:0.028009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13913976 ORDER BY `unit` DESC [ RunTime:0.048088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13913976 LIMIT 2 [ RunTime:0.056367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913976 ORDER BY `minOrder` ASC [ RunTime:0.026752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910172 LIMIT 5 [ RunTime:0.028318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910172 ORDER BY `minOrder` ASC [ RunTime:0.021618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910172 ORDER BY `unit` DESC [ RunTime:0.014156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910172 LIMIT 2 [ RunTime:0.001765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910172 ORDER BY `minOrder` ASC [ RunTime:0.007245s ]
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 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033321s ]
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 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42153845 LIMIT 5 [ RunTime:0.038086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153845 ORDER BY `minOrder` ASC [ RunTime:0.085784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42153845 ORDER BY `unit` DESC [ RunTime:0.040190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42153845 LIMIT 2 [ RunTime:0.018009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153845 ORDER BY `minOrder` ASC [ RunTime:0.058905s ]
select * from pdf where partno='SMAJ120AHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.044256s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120AHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.023553s ]
SELECT `id` FROM `stock` WHERE `id` <> 42153845 AND `partno` = 'SMAJ120AHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.054176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662846 [ RunTime:0.071357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42225221 LIMIT 5 [ RunTime:0.043919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225221 ORDER BY `minOrder` ASC [ RunTime:0.042719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42225221 ORDER BY `unit` DESC [ RunTime:0.086703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42225221 LIMIT 2 [ RunTime:0.022667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225221 ORDER BY `minOrder` ASC [ RunTime:0.012925s ]
select * from pdf where partno='SMAJ120AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.052793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.030930s ]
SELECT `id` FROM `stock` WHERE `id` <> 42225221 AND `partno` = 'SMAJ120AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.051989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913976 [ RunTime:0.029556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42220426 LIMIT 5 [ RunTime:0.049542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220426 ORDER BY `minOrder` ASC [ RunTime:0.084406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42220426 ORDER BY `unit` DESC [ RunTime:0.102236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42220426 LIMIT 2 [ RunTime:0.029209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220426 ORDER BY `minOrder` ASC [ RunTime:0.020699s ]
select * from pdf where partno='SMAJ120AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.081074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.024540s ]
SELECT `id` FROM `stock` WHERE `id` <> 42220426 AND `partno` = 'SMAJ120AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.079470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42220425 LIMIT 5 [ RunTime:0.051649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220425 ORDER BY `minOrder` ASC [ RunTime:0.034684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42220425 ORDER BY `unit` DESC [ RunTime:0.075906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42220425 LIMIT 2 [ RunTime:0.079747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220425 ORDER BY `minOrder` ASC [ RunTime:0.026774s ]
select * from pdf where partno='SMAJ120AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.037311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.026586s ]
SELECT `id` FROM `stock` WHERE `id` <> 42220425 AND `partno` = 'SMAJ120AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42215841 LIMIT 5 [ RunTime:0.028946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215841 ORDER BY `minOrder` ASC [ RunTime:0.043073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42215841 ORDER BY `unit` DESC [ RunTime:0.040849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42215841 LIMIT 2 [ RunTime:0.017461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42215841 ORDER BY `minOrder` ASC [ RunTime:0.021005s ]
select * from pdf where partno='SMAJ120AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.055142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007832s ]
SELECT `id` FROM `stock` WHERE `id` <> 42215841 AND `partno` = 'SMAJ120AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.038280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809839 [ RunTime:0.032470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42205424 LIMIT 5 [ RunTime:0.011986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205424 ORDER BY `minOrder` ASC [ RunTime:0.020712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42205424 ORDER BY `unit` DESC [ RunTime:0.048207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42205424 LIMIT 2 [ RunTime:0.032707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205424 ORDER BY `minOrder` ASC [ RunTime:0.016906s ]
select * from pdf where partno='SMAJ120AHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.033015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120AHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.030160s ]
SELECT `id` FROM `stock` WHERE `id` <> 42205424 AND `partno` = 'SMAJ120AHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.034000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806910 [ RunTime:0.003568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42197413 LIMIT 5 [ RunTime:0.027610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42197413 ORDER BY `minOrder` ASC [ RunTime:0.017794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42197413 ORDER BY `unit` DESC [ RunTime:0.031703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42197413 LIMIT 2 [ RunTime:0.025867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42197413 ORDER BY `minOrder` ASC [ RunTime:0.031849s ]
select * from pdf where partno='SMAJ120AH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.030670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120AH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.025288s ]
SELECT `id` FROM `stock` WHERE `id` <> 42197413 AND `partno` = 'SMAJ120AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.022055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910172 [ RunTime:0.030456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42193935 LIMIT 5 [ RunTime:0.034242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42193935 ORDER BY `minOrder` ASC [ RunTime:0.020692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42193935 ORDER BY `unit` DESC [ RunTime:0.026661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42193935 LIMIT 2 [ RunTime:0.000790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42193935 ORDER BY `minOrder` ASC [ RunTime:0.027892s ]
select * from pdf where partno='SMAJ120AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.043211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.065495s ]
SELECT `id` FROM `stock` WHERE `id` <> 42193935 AND `partno` = 'SMAJ120AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.167531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806325 [ RunTime:0.072018s ]
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 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054449s ]
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 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061917s ]
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 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037438s ]
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 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051475s ]
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 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077700s ]
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 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.133726s ]
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 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.163164s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ120AH%' OR `brand` LIKE 'SMAJ120AH%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.090823s ]