SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001423s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.250' , `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=P6SMB200CA&search=1' [ RunTime:0.021491s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.004267s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005199s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002349s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.250' ) [ RunTime:0.003168s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001596s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000305s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001535s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6SMB200CA' LIMIT 1 [ RunTime:0.004404s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-11 10:28:01' WHERE `partno` = 'P6SMB200CA' [ RunTime:0.003741s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001573s ]
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 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036716s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.014678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801789 LIMIT 5 [ RunTime:0.009909s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801789 ORDER BY `minOrder` ASC [ RunTime:0.028544s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801789 ORDER BY `unit` DESC [ RunTime:0.052337s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.016094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801789 LIMIT 2 [ RunTime:0.031678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801789 ORDER BY `minOrder` ASC [ RunTime:0.021231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827504 LIMIT 5 [ RunTime:0.036223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827504 ORDER BY `minOrder` ASC [ RunTime:0.020664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827504 ORDER BY `unit` DESC [ RunTime:0.035073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827504 LIMIT 2 [ RunTime:0.023656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827504 ORDER BY `minOrder` ASC [ RunTime:0.003619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917263 LIMIT 5 [ RunTime:0.011638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917263 ORDER BY `minOrder` ASC [ RunTime:0.019983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917263 ORDER BY `unit` DESC [ RunTime:0.025257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917263 LIMIT 2 [ RunTime:0.022547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917263 ORDER BY `minOrder` ASC [ RunTime:0.012127s ]
select * from pdf where partno='P6SMB200CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.036378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687348 LIMIT 5 [ RunTime:0.008102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687348 ORDER BY `minOrder` ASC [ RunTime:0.007848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687348 ORDER BY `unit` DESC [ RunTime:0.026225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687348 LIMIT 2 [ RunTime:0.035940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687348 ORDER BY `minOrder` ASC [ RunTime:0.005905s ]
select * from pdf where partno='P6SMB200CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904802 LIMIT 5 [ RunTime:0.013690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904802 ORDER BY `minOrder` ASC [ RunTime:0.017716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904802 ORDER BY `unit` DESC [ RunTime:0.014501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904802 LIMIT 2 [ RunTime:0.027136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904802 ORDER BY `minOrder` ASC [ RunTime:0.015661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907577 LIMIT 5 [ RunTime:0.012991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907577 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907577 ORDER BY `unit` DESC [ RunTime:0.004563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907577 LIMIT 2 [ RunTime:0.026566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907577 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692141 LIMIT 5 [ RunTime:0.002765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692141 ORDER BY `minOrder` ASC [ RunTime:0.012290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692141 ORDER BY `unit` DESC [ RunTime:0.010151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692141 LIMIT 2 [ RunTime:0.014889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692141 ORDER BY `minOrder` ASC [ RunTime:0.019868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692140 LIMIT 5 [ RunTime:0.025488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692140 ORDER BY `minOrder` ASC [ RunTime:0.024563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692140 ORDER BY `unit` DESC [ RunTime:0.003866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692140 LIMIT 2 [ RunTime:0.016008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692140 ORDER BY `minOrder` ASC [ RunTime:0.014219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672707 LIMIT 5 [ RunTime:0.003407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672707 ORDER BY `minOrder` ASC [ RunTime:0.006667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672707 ORDER BY `unit` DESC [ RunTime:0.016279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672707 LIMIT 2 [ RunTime:0.013529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672707 ORDER BY `minOrder` ASC [ RunTime:0.009871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670494 LIMIT 5 [ RunTime:0.017600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670494 ORDER BY `minOrder` ASC [ RunTime:0.024595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670494 ORDER BY `unit` DESC [ RunTime:0.019493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670494 LIMIT 2 [ RunTime:0.003596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670494 ORDER BY `minOrder` ASC [ RunTime:0.014602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670493 LIMIT 5 [ RunTime:0.009176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670493 ORDER BY `minOrder` ASC [ RunTime:0.020856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670493 ORDER BY `unit` DESC [ RunTime:0.048979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670493 LIMIT 2 [ RunTime:0.080999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670493 ORDER BY `minOrder` ASC [ RunTime:0.015767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669782 LIMIT 5 [ RunTime:0.017586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669782 ORDER BY `minOrder` ASC [ RunTime:0.059623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669782 ORDER BY `unit` DESC [ RunTime:0.012019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669782 LIMIT 2 [ RunTime:0.021114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669782 ORDER BY `minOrder` ASC [ RunTime:0.034683s ]
select * from pdf where partno='P6SMB200CA-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.038017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831741 LIMIT 5 [ RunTime:0.026158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831741 ORDER BY `minOrder` ASC [ RunTime:0.007228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831741 ORDER BY `unit` DESC [ RunTime:0.030790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831741 LIMIT 2 [ RunTime:0.004948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831741 ORDER BY `minOrder` ASC [ RunTime:0.003045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831740 LIMIT 5 [ RunTime:0.054190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831740 ORDER BY `minOrder` ASC [ RunTime:0.032743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831740 ORDER BY `unit` DESC [ RunTime:0.077474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831740 LIMIT 2 [ RunTime:0.048975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831740 ORDER BY `minOrder` ASC [ RunTime:0.006495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829554 LIMIT 5 [ RunTime:0.017502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829554 ORDER BY `minOrder` ASC [ RunTime:0.011450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829554 ORDER BY `unit` DESC [ RunTime:0.054339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829554 LIMIT 2 [ RunTime:0.075668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829554 ORDER BY `minOrder` ASC [ RunTime:0.038769s ]
select * from pdf where partno='P6SMB200CAHE3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.028296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828942 LIMIT 5 [ RunTime:0.042870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828942 ORDER BY `minOrder` ASC [ RunTime:0.028113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828942 ORDER BY `unit` DESC [ RunTime:0.031283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828942 LIMIT 2 [ RunTime:0.012946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828942 ORDER BY `minOrder` ASC [ RunTime:0.022628s ]
select * from pdf where partno='P6SMB200CAHE3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.041991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818621 LIMIT 5 [ RunTime:0.025238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818621 ORDER BY `minOrder` ASC [ RunTime:0.056554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818621 ORDER BY `unit` DESC [ RunTime:0.027454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818621 LIMIT 2 [ RunTime:0.006061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818621 ORDER BY `minOrder` ASC [ RunTime:0.002907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813366 LIMIT 5 [ RunTime:0.005120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813366 ORDER BY `minOrder` ASC [ RunTime:0.009998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813366 ORDER BY `unit` DESC [ RunTime:0.066788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813366 LIMIT 2 [ RunTime:0.041656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813366 ORDER BY `minOrder` ASC [ RunTime:0.014381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812884 LIMIT 5 [ RunTime:0.046125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812884 ORDER BY `minOrder` ASC [ RunTime:0.036107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812884 ORDER BY `unit` DESC [ RunTime:0.049097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812884 LIMIT 2 [ RunTime:0.055671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812884 ORDER BY `minOrder` ASC [ RunTime:0.016325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812292 LIMIT 5 [ RunTime:0.013523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812292 ORDER BY `minOrder` ASC [ RunTime:0.024489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812292 ORDER BY `unit` DESC [ RunTime:0.030463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812292 LIMIT 2 [ RunTime:0.017151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812292 ORDER BY `minOrder` ASC [ 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 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013379s ]
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 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160755 LIMIT 5 [ RunTime:0.008354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160755 ORDER BY `minOrder` ASC [ RunTime:0.043478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160755 ORDER BY `unit` DESC [ RunTime:0.019740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160755 LIMIT 2 [ RunTime:0.006154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160755 ORDER BY `minOrder` ASC [ RunTime:0.005184s ]
select * from pdf where partno='P6SMB200CA' and brandshort='NextGen Components' limit 1 [ RunTime:0.009924s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.011327s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160755 AND `partno` = 'P6SMB200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.030918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801789 [ RunTime:0.014835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113777 LIMIT 5 [ RunTime:0.028583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113777 ORDER BY `minOrder` ASC [ RunTime:0.013595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113777 ORDER BY `unit` DESC [ RunTime:0.013094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113777 LIMIT 2 [ RunTime:0.030665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113777 ORDER BY `minOrder` ASC [ RunTime:0.009702s ]
select * from pdf where partno='P6SMB200CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.009453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.015521s ]
SELECT `id` FROM `stock` WHERE `id` <> 42113777 AND `partno` = 'P6SMB200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.008091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917263 [ RunTime:0.008938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152989 LIMIT 5 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152989 ORDER BY `minOrder` ASC [ RunTime:0.007998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152989 ORDER BY `unit` DESC [ RunTime:0.002757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152989 LIMIT 2 [ RunTime:0.006398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152989 ORDER BY `minOrder` ASC [ RunTime:0.005647s ]
select * from pdf where partno='P6SMB200CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.005749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.008862s ]
SELECT `id` FROM `stock` WHERE `id` <> 42152989 AND `partno` = 'P6SMB200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.022625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827504 [ RunTime:0.012625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128158 LIMIT 5 [ RunTime:0.005478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128158 ORDER BY `minOrder` ASC [ RunTime:0.037521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128158 ORDER BY `unit` DESC [ RunTime:0.023832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128158 LIMIT 2 [ RunTime:0.020041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128158 ORDER BY `minOrder` ASC [ RunTime:0.008000s ]
select * from pdf where partno='P6SMB200CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006099s ]
SELECT `id` FROM `stock` WHERE `id` <> 42128158 AND `partno` = 'P6SMB200CA-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.056721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687348 [ RunTime:0.075668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42122949 LIMIT 5 [ RunTime:0.063758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122949 ORDER BY `minOrder` ASC [ RunTime:0.091279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42122949 ORDER BY `unit` DESC [ RunTime:0.023014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42122949 LIMIT 2 [ RunTime:0.022075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42122949 ORDER BY `minOrder` ASC [ RunTime:0.009711s ]
select * from pdf where partno='P6SMB200CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.018220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.030988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170556 LIMIT 5 [ RunTime:0.095809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170556 ORDER BY `minOrder` ASC [ RunTime:0.065543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170556 ORDER BY `unit` DESC [ RunTime:0.027716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170556 LIMIT 2 [ RunTime:0.065378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170556 ORDER BY `minOrder` ASC [ RunTime:0.032574s ]
select * from pdf where partno='P6SMB200CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.085423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.019055s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170556 AND `partno` = 'P6SMB200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.047656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907577 [ RunTime:0.077441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42258982 LIMIT 5 [ RunTime:0.068946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258982 ORDER BY `minOrder` ASC [ RunTime:0.059441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42258982 ORDER BY `unit` DESC [ RunTime:0.032521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42258982 LIMIT 2 [ RunTime:0.066989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258982 ORDER BY `minOrder` ASC [ RunTime:0.027124s ]
select * from pdf where partno='P6SMB200CAHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.057510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CAHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.049906s ]
SELECT `id` FROM `stock` WHERE `id` <> 42258982 AND `partno` = 'P6SMB200CAHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.021843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915829 [ RunTime:0.048907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42258977 LIMIT 5 [ RunTime:0.029523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258977 ORDER BY `minOrder` ASC [ RunTime:0.068103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42258977 ORDER BY `unit` DESC [ RunTime:0.066742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42258977 LIMIT 2 [ RunTime:0.042190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258977 ORDER BY `minOrder` ASC [ RunTime:0.011346s ]
select * from pdf where partno='P6SMB200CAHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CAHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.031777s ]
SELECT `id` FROM `stock` WHERE `id` <> 42258977 AND `partno` = 'P6SMB200CAHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.061529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672707 [ RunTime:0.037143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42256796 LIMIT 5 [ RunTime:0.013203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256796 ORDER BY `minOrder` ASC [ RunTime:0.022471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42256796 ORDER BY `unit` DESC [ RunTime:0.029305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42256796 LIMIT 2 [ RunTime:0.016214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256796 ORDER BY `minOrder` ASC [ RunTime:0.001746s ]
select * from pdf where partno='P6SMB200CAHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.026222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CAHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.031706s ]
SELECT `id` FROM `stock` WHERE `id` <> 42256796 AND `partno` = 'P6SMB200CAHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.027351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812292 [ RunTime:0.012308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42256795 LIMIT 5 [ RunTime:0.008663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256795 ORDER BY `minOrder` ASC [ RunTime:0.009831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42256795 ORDER BY `unit` DESC [ RunTime:0.022384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42256795 LIMIT 2 [ RunTime:0.077044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256795 ORDER BY `minOrder` ASC [ RunTime:0.013354s ]
select * from pdf where partno='P6SMB200CAHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.038076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CAHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.038852s ]
SELECT `id` FROM `stock` WHERE `id` <> 42256795 AND `partno` = 'P6SMB200CAHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.060685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812884 [ RunTime:0.052613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242509 LIMIT 5 [ RunTime:0.021507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242509 ORDER BY `minOrder` ASC [ RunTime:0.030671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242509 ORDER BY `unit` DESC [ RunTime:0.075422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242509 LIMIT 2 [ RunTime:0.052812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242509 ORDER BY `minOrder` ASC [ RunTime:0.037078s ]
select * from pdf where partno='P6SMB200CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.032216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.037656s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242509 AND `partno` = 'P6SMB200CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916151 [ RunTime:0.031240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242301 LIMIT 5 [ RunTime:0.018276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242301 ORDER BY `minOrder` ASC [ RunTime:0.041683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242301 ORDER BY `unit` DESC [ RunTime:0.063855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242301 LIMIT 2 [ RunTime:0.010855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242301 ORDER BY `minOrder` ASC [ RunTime:0.022179s ]
select * from pdf where partno='P6SMB200CAHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.026712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CAHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.022003s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242301 AND `partno` = 'P6SMB200CAHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.023724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813366 [ RunTime:0.079418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42240471 LIMIT 5 [ RunTime:0.028111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240471 ORDER BY `minOrder` ASC [ RunTime:0.028980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42240471 ORDER BY `unit` DESC [ RunTime:0.014500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42240471 LIMIT 2 [ RunTime:0.022186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240471 ORDER BY `minOrder` ASC [ RunTime:0.006562s ]
select * from pdf where partno='P6SMB200CAHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CAHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.029354s ]
SELECT `id` FROM `stock` WHERE `id` <> 42240471 AND `partno` = 'P6SMB200CAHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.023589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915926 [ RunTime:0.042880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42239913 LIMIT 5 [ RunTime:0.019513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239913 ORDER BY `minOrder` ASC [ RunTime:0.071043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42239913 ORDER BY `unit` DESC [ RunTime:0.024655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42239913 LIMIT 2 [ RunTime:0.017991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42239913 ORDER BY `minOrder` ASC [ RunTime:0.025037s ]
select * from pdf where partno='P6SMB200CAHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CAHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.060511s ]
SELECT `id` FROM `stock` WHERE `id` <> 42239913 AND `partno` = 'P6SMB200CAHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.021607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915843 [ RunTime:0.004281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42236260 LIMIT 5 [ RunTime:0.041851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236260 ORDER BY `minOrder` ASC [ RunTime:0.071528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42236260 ORDER BY `unit` DESC [ RunTime:0.018318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42236260 LIMIT 2 [ RunTime:0.034921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236260 ORDER BY `minOrder` ASC [ RunTime:0.016449s ]
select * from pdf where partno='P6SMB200CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.039739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.022345s ]
SELECT `id` FROM `stock` WHERE `id` <> 42236260 AND `partno` = 'P6SMB200CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.023553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914767 [ RunTime:0.020737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42236063 LIMIT 5 [ RunTime:0.042371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236063 ORDER BY `minOrder` ASC [ RunTime:0.031524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42236063 ORDER BY `unit` DESC [ RunTime:0.039404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42236063 LIMIT 2 [ RunTime:0.015156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236063 ORDER BY `minOrder` ASC [ RunTime:0.016822s ]
select * from pdf where partno='P6SMB200CA-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.029083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA-M3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.018990s ]
SELECT `id` FROM `stock` WHERE `id` <> 42236063 AND `partno` = 'P6SMB200CA-M3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.023184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810867 [ RunTime:0.023031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42236062 LIMIT 5 [ RunTime:0.026943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236062 ORDER BY `minOrder` ASC [ RunTime:0.006075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42236062 ORDER BY `unit` DESC [ RunTime:0.013375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42236062 LIMIT 2 [ RunTime:0.025651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236062 ORDER BY `minOrder` ASC [ RunTime:0.009620s ]
select * from pdf where partno='P6SMB200CA-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019385s ]
SELECT `id` FROM `stock` WHERE `id` <> 42236062 AND `partno` = 'P6SMB200CA-M3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.024635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914107 [ RunTime:0.017767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222876 LIMIT 5 [ RunTime:0.041076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222876 ORDER BY `minOrder` ASC [ RunTime:0.014843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222876 ORDER BY `unit` DESC [ RunTime:0.012386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222876 LIMIT 2 [ RunTime:0.008205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222876 ORDER BY `minOrder` ASC [ RunTime:0.002576s ]
select * from pdf where partno='P6SMB200CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.026149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.028542s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222876 AND `partno` = 'P6SMB200CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.030930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670494 [ RunTime:0.006597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222875 LIMIT 5 [ RunTime:0.004070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222875 ORDER BY `minOrder` ASC [ RunTime:0.003906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222875 ORDER BY `unit` DESC [ RunTime:0.058958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222875 LIMIT 2 [ RunTime:0.036463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222875 ORDER BY `minOrder` ASC [ RunTime:0.029945s ]
select * from pdf where partno='P6SMB200CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.010494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.019103s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222875 AND `partno` = 'P6SMB200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.018282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670493 [ RunTime:0.030354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221809 LIMIT 5 [ RunTime:0.077083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221809 ORDER BY `minOrder` ASC [ RunTime:0.079783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221809 ORDER BY `unit` DESC [ RunTime:0.062629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221809 LIMIT 2 [ RunTime:0.027599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221809 ORDER BY `minOrder` ASC [ RunTime:0.067291s ]
select * from pdf where partno='P6SMB200CA-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.041460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB200CA-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.045822s ]
SELECT `id` FROM `stock` WHERE `id` <> 42221809 AND `partno` = 'P6SMB200CA-E3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.040688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669782 [ RunTime:0.090806s ]
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 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018338s ]
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 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020326s ]
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 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026582s ]
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 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025301s ]
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 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009927s ]
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 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010217s ]
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 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046322s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6SMB200CA%' OR `brand` LIKE 'P6SMB200CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.037433s ]