SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003434s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.115' , `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=P4SMA170&search=1' [ RunTime:0.002989s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002210s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001663s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001502s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.115' ) [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000966s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000236s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000967s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P4SMA170' LIMIT 1 [ RunTime:0.013008s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-15 01:40:30' WHERE `partno` = 'P4SMA170' [ RunTime:0.001772s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001924s ]
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 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014098s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801806 LIMIT 5 [ RunTime:0.000938s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801806 ORDER BY `minOrder` ASC [ RunTime:0.005116s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801806 ORDER BY `unit` DESC [ RunTime:0.002220s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801806 LIMIT 2 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801806 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906578 LIMIT 5 [ RunTime:0.001093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906578 ORDER BY `minOrder` ASC [ RunTime:0.002459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906578 ORDER BY `unit` DESC [ RunTime:0.004121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906578 LIMIT 2 [ RunTime:0.007072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906578 ORDER BY `minOrder` ASC [ RunTime:0.005112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926160 LIMIT 5 [ RunTime:0.012584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926160 ORDER BY `minOrder` ASC [ RunTime:0.001079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13926160 ORDER BY `unit` DESC [ RunTime:0.000557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13926160 LIMIT 2 [ RunTime:0.005374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926160 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
select * from pdf where partno='P4SMA170CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799909 LIMIT 5 [ RunTime:0.000930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799909 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799909 ORDER BY `unit` DESC [ RunTime:0.010543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799909 LIMIT 2 [ RunTime:0.002731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799909 ORDER BY `minOrder` ASC [ RunTime:0.004569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800920 LIMIT 5 [ RunTime:0.004359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800920 ORDER BY `minOrder` ASC [ RunTime:0.006141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800920 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800920 LIMIT 2 [ RunTime:0.000935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800920 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662514 LIMIT 5 [ RunTime:0.008773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662514 ORDER BY `minOrder` ASC [ RunTime:0.005345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662514 ORDER BY `unit` DESC [ RunTime:0.002562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662514 LIMIT 2 [ RunTime:0.002619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662514 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691768 LIMIT 5 [ RunTime:0.003908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691768 ORDER BY `minOrder` ASC [ RunTime:0.001838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691768 ORDER BY `unit` DESC [ RunTime:0.001646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691768 LIMIT 2 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691768 ORDER BY `minOrder` ASC [ RunTime:0.007982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687321 LIMIT 5 [ RunTime:0.014019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687321 ORDER BY `minOrder` ASC [ RunTime:0.007812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687321 ORDER BY `unit` DESC [ RunTime:0.015394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687321 LIMIT 2 [ RunTime:0.019598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687321 ORDER BY `minOrder` ASC [ RunTime:0.004074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677274 LIMIT 5 [ RunTime:0.000971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677274 ORDER BY `minOrder` ASC [ RunTime:0.004113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16677274 ORDER BY `unit` DESC [ RunTime:0.000849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16677274 LIMIT 2 [ RunTime:0.009715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677274 ORDER BY `minOrder` ASC [ RunTime:0.004886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677273 LIMIT 5 [ RunTime:0.000841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677273 ORDER BY `minOrder` ASC [ RunTime:0.006166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16677273 ORDER BY `unit` DESC [ RunTime:0.009992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16677273 LIMIT 2 [ RunTime:0.003688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677273 ORDER BY `minOrder` ASC [ RunTime:0.015406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677248 LIMIT 5 [ RunTime:0.003974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677248 ORDER BY `minOrder` ASC [ RunTime:0.007603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16677248 ORDER BY `unit` DESC [ RunTime:0.002625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16677248 LIMIT 2 [ RunTime:0.007400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677248 ORDER BY `minOrder` ASC [ RunTime:0.008980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668628 LIMIT 5 [ RunTime:0.010594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668628 ORDER BY `minOrder` ASC [ RunTime:0.010281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668628 ORDER BY `unit` DESC [ RunTime:0.001695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668628 LIMIT 2 [ RunTime:0.012136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668628 ORDER BY `minOrder` ASC [ RunTime:0.001165s ]
select * from pdf where partno='P4SMA170CA-M3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668373 LIMIT 5 [ RunTime:0.009888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668373 ORDER BY `minOrder` ASC [ RunTime:0.007811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668373 ORDER BY `unit` DESC [ RunTime:0.010369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668373 LIMIT 2 [ RunTime:0.018445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668373 ORDER BY `minOrder` ASC [ RunTime:0.003552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668353 LIMIT 5 [ RunTime:0.009631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668353 ORDER BY `minOrder` ASC [ RunTime:0.020409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668353 ORDER BY `unit` DESC [ RunTime:0.004070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668353 LIMIT 2 [ RunTime:0.013385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668353 ORDER BY `minOrder` ASC [ RunTime:0.008017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666580 LIMIT 5 [ RunTime:0.003102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666580 ORDER BY `minOrder` ASC [ RunTime:0.004489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666580 ORDER BY `unit` DESC [ RunTime:0.008280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666580 LIMIT 2 [ RunTime:0.012275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666580 ORDER BY `minOrder` ASC [ RunTime:0.006844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666573 LIMIT 5 [ RunTime:0.010738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666573 ORDER BY `minOrder` ASC [ RunTime:0.008817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666573 ORDER BY `unit` DESC [ RunTime:0.007801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666573 LIMIT 2 [ RunTime:0.003539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666573 ORDER BY `minOrder` ASC [ RunTime:0.005381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665966 LIMIT 5 [ RunTime:0.004913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665966 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665966 ORDER BY `unit` DESC [ RunTime:0.004191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665966 LIMIT 2 [ RunTime:0.007205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665966 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665963 LIMIT 5 [ RunTime:0.003216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665963 ORDER BY `minOrder` ASC [ RunTime:0.003694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665963 ORDER BY `unit` DESC [ RunTime:0.006057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665963 LIMIT 2 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665963 ORDER BY `minOrder` ASC [ RunTime:0.001446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833266 LIMIT 5 [ RunTime:0.015379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833266 ORDER BY `minOrder` ASC [ RunTime:0.003242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833266 ORDER BY `unit` DESC [ RunTime:0.007993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833266 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833266 ORDER BY `minOrder` ASC [ RunTime:0.005582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832502 LIMIT 5 [ RunTime:0.002664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832502 ORDER BY `minOrder` ASC [ RunTime:0.009181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832502 ORDER BY `unit` DESC [ RunTime:0.006703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832502 LIMIT 2 [ RunTime:0.005032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832502 ORDER BY `minOrder` ASC [ RunTime:0.000640s ]
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 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004998s ]
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 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160912 LIMIT 5 [ RunTime:0.011142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160912 ORDER BY `minOrder` ASC [ RunTime:0.009412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160912 ORDER BY `unit` DESC [ RunTime:0.004707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160912 LIMIT 2 [ RunTime:0.009594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160912 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
select * from pdf where partno='P4SMA170CA' and brandshort='NextGen Components' limit 1 [ RunTime:0.005721s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.007663s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160912 AND `partno` = 'P4SMA170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.009424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801806 [ RunTime:0.002986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160725 LIMIT 5 [ RunTime:0.001435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160725 ORDER BY `minOrder` ASC [ RunTime:0.005261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160725 ORDER BY `unit` DESC [ RunTime:0.003675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160725 LIMIT 2 [ RunTime:0.001963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160725 ORDER BY `minOrder` ASC [ RunTime:0.007578s ]
select * from pdf where partno='P4SMA170A' and brandshort='NextGen Components' limit 1 [ RunTime:0.007957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170A' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.002214s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160725 AND `partno` = 'P4SMA170A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906578 [ RunTime:0.009010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42127041 LIMIT 5 [ RunTime:0.001861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127041 ORDER BY `minOrder` ASC [ RunTime:0.012443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42127041 ORDER BY `unit` DESC [ RunTime:0.001442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42127041 LIMIT 2 [ RunTime:0.003816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127041 ORDER BY `minOrder` ASC [ RunTime:0.004254s ]
select * from pdf where partno='P4SMA170CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000782s ]
SELECT `id` FROM `stock` WHERE `id` <> 42127041 AND `partno` = 'P4SMA170CA-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.009489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926160 [ RunTime:0.013265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42126743 LIMIT 5 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126743 ORDER BY `minOrder` ASC [ RunTime:0.008261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42126743 ORDER BY `unit` DESC [ RunTime:0.005853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42126743 LIMIT 2 [ RunTime:0.005603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126743 ORDER BY `minOrder` ASC [ RunTime:0.012124s ]
select * from pdf where partno='P4SMA170A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.014476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.009550s ]
SELECT `id` FROM `stock` WHERE `id` <> 42126743 AND `partno` = 'P4SMA170A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.006877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799909 [ RunTime:0.013109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150180 LIMIT 5 [ RunTime:0.003842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150180 ORDER BY `minOrder` ASC [ RunTime:0.003274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150180 ORDER BY `unit` DESC [ RunTime:0.004389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150180 LIMIT 2 [ RunTime:0.003467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150180 ORDER BY `minOrder` ASC [ RunTime:0.001059s ]
select * from pdf where partno='P4SMA170A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.012707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.001623s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150180 AND `partno` = 'P4SMA170A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.002625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800920 [ RunTime:0.007343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159173 LIMIT 5 [ RunTime:0.006103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159173 ORDER BY `minOrder` ASC [ RunTime:0.003289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159173 ORDER BY `unit` DESC [ RunTime:0.010661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159173 LIMIT 2 [ RunTime:0.025531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159173 ORDER BY `minOrder` ASC [ RunTime:0.013291s ]
select * from pdf where partno='P4SMA170CA' and brandshort='Eaton - Bussmann Electrical Division' limit 1 [ RunTime:0.009430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA' OR `brand` LIKE 'Eaton - Bussmann Electrical Division%' ) ) LIMIT 1 [ RunTime:0.001346s ]
SELECT `id` FROM `stock` WHERE `id` <> 42159173 AND `partno` = 'P4SMA170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - bussmann electrical division%' ) [ RunTime:0.006482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42149169 LIMIT 5 [ RunTime:0.010306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149169 ORDER BY `minOrder` ASC [ RunTime:0.004608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42149169 ORDER BY `unit` DESC [ RunTime:0.000917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42149169 LIMIT 2 [ RunTime:0.005556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42149169 ORDER BY `minOrder` ASC [ RunTime:0.010460s ]
select * from pdf where partno='P4SMA170AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.016626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.013796s ]
SELECT `id` FROM `stock` WHERE `id` <> 42149169 AND `partno` = 'P4SMA170AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.007795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662514 [ RunTime:0.004438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42234658 LIMIT 5 [ RunTime:0.016293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234658 ORDER BY `minOrder` ASC [ RunTime:0.007892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42234658 ORDER BY `unit` DESC [ RunTime:0.010398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42234658 LIMIT 2 [ RunTime:0.019209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234658 ORDER BY `minOrder` ASC [ RunTime:0.005883s ]
select * from pdf where partno='P4SMA170CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.005197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.005028s ]
SELECT `id` FROM `stock` WHERE `id` <> 42234658 AND `partno` = 'P4SMA170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.004130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913877 [ RunTime:0.017833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42234046 LIMIT 5 [ RunTime:0.007063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234046 ORDER BY `minOrder` ASC [ RunTime:0.003721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42234046 ORDER BY `unit` DESC [ RunTime:0.023898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42234046 LIMIT 2 [ RunTime:0.006175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234046 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
select * from pdf where partno='P4SMA170CA R3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.006144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA R3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.004130s ]
SELECT `id` FROM `stock` WHERE `id` <> 42234046 AND `partno` = 'P4SMA170CA R3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.015855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914975 [ RunTime:0.039613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42226549 LIMIT 5 [ RunTime:0.023136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42226549 ORDER BY `minOrder` ASC [ RunTime:0.028499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42226549 ORDER BY `unit` DESC [ RunTime:0.000814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42226549 LIMIT 2 [ RunTime:0.003690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42226549 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='P4SMA170AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.005002s ]
SELECT `id` FROM `stock` WHERE `id` <> 42226549 AND `partno` = 'P4SMA170AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677274 [ RunTime:0.008402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42226548 LIMIT 5 [ RunTime:0.001431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42226548 ORDER BY `minOrder` ASC [ RunTime:0.013543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42226548 ORDER BY `unit` DESC [ RunTime:0.003175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42226548 LIMIT 2 [ RunTime:0.007594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42226548 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
select * from pdf where partno='P4SMA170AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003160s ]
SELECT `id` FROM `stock` WHERE `id` <> 42226548 AND `partno` = 'P4SMA170AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.002808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677273 [ RunTime:0.004560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42225800 LIMIT 5 [ RunTime:0.014555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225800 ORDER BY `minOrder` ASC [ RunTime:0.010560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42225800 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42225800 LIMIT 2 [ RunTime:0.003610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225800 ORDER BY `minOrder` ASC [ RunTime:0.001179s ]
select * from pdf where partno='P4SMA170CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.013201s ]
SELECT `id` FROM `stock` WHERE `id` <> 42225800 AND `partno` = 'P4SMA170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.005421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810318 [ RunTime:0.004379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42223129 LIMIT 5 [ RunTime:0.009054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223129 ORDER BY `minOrder` ASC [ RunTime:0.007824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42223129 ORDER BY `unit` DESC [ RunTime:0.003133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42223129 LIMIT 2 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223129 ORDER BY `minOrder` ASC [ RunTime:0.000998s ]
select * from pdf where partno='P4SMA170CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.010269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.020467s ]
SELECT `id` FROM `stock` WHERE `id` <> 42223129 AND `partno` = 'P4SMA170CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.006108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810216 [ RunTime:0.004173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222618 LIMIT 5 [ RunTime:0.006807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222618 ORDER BY `minOrder` ASC [ RunTime:0.002086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222618 ORDER BY `unit` DESC [ RunTime:0.013476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222618 LIMIT 2 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222618 ORDER BY `minOrder` ASC [ RunTime:0.001061s ]
select * from pdf where partno='P4SMA170AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.025683s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222618 AND `partno` = 'P4SMA170AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.016354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818627 [ RunTime:0.015993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42216592 LIMIT 5 [ RunTime:0.002263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42216592 ORDER BY `minOrder` ASC [ RunTime:0.006808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42216592 ORDER BY `unit` DESC [ RunTime:0.001173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42216592 LIMIT 2 [ RunTime:0.001693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42216592 ORDER BY `minOrder` ASC [ RunTime:0.000797s ]
select * from pdf where partno='P4SMA170AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006279s ]
SELECT `id` FROM `stock` WHERE `id` <> 42216592 AND `partno` = 'P4SMA170AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913794 [ RunTime:0.001131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42214575 LIMIT 5 [ RunTime:0.004727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214575 ORDER BY `minOrder` ASC [ RunTime:0.032666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42214575 ORDER BY `unit` DESC [ RunTime:0.011674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42214575 LIMIT 2 [ RunTime:0.000767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214575 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
select * from pdf where partno='P4SMA170CA-M3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-M3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004915s ]
SELECT `id` FROM `stock` WHERE `id` <> 42214575 AND `partno` = 'P4SMA170CA-M3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808952 [ RunTime:0.010162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42214444 LIMIT 5 [ RunTime:0.013568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214444 ORDER BY `minOrder` ASC [ RunTime:0.008597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42214444 ORDER BY `unit` DESC [ RunTime:0.000991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42214444 LIMIT 2 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214444 ORDER BY `minOrder` ASC [ RunTime:0.005662s ]
select * from pdf where partno='P4SMA170CA-M3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-M3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011247s ]
SELECT `id` FROM `stock` WHERE `id` <> 42214444 AND `partno` = 'P4SMA170CA-M3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668628 [ RunTime:0.022803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42205899 LIMIT 5 [ RunTime:0.010180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205899 ORDER BY `minOrder` ASC [ RunTime:0.008464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42205899 ORDER BY `unit` DESC [ RunTime:0.008657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42205899 LIMIT 2 [ RunTime:0.022098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205899 ORDER BY `minOrder` ASC [ RunTime:0.005589s ]
select * from pdf where partno='P4SMA170A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.008102s ]
SELECT `id` FROM `stock` WHERE `id` <> 42205899 AND `partno` = 'P4SMA170A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.005832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911548 [ RunTime:0.009716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42205444 LIMIT 5 [ RunTime:0.001963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205444 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42205444 ORDER BY `unit` DESC [ RunTime:0.001443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42205444 LIMIT 2 [ RunTime:0.006651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205444 ORDER BY `minOrder` ASC [ RunTime:0.001172s ]
select * from pdf where partno='P4SMA170CA-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-E3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.012941s ]
SELECT `id` FROM `stock` WHERE `id` <> 42205444 AND `partno` = 'P4SMA170CA-E3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.005172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911558 [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42203375 LIMIT 5 [ RunTime:0.003796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203375 ORDER BY `minOrder` ASC [ RunTime:0.001443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42203375 ORDER BY `unit` DESC [ RunTime:0.000459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42203375 LIMIT 2 [ RunTime:0.007376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203375 ORDER BY `minOrder` ASC [ RunTime:0.004465s ]
select * from pdf where partno='P4SMA170CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000906s ]
SELECT `id` FROM `stock` WHERE `id` <> 42203375 AND `partno` = 'P4SMA170CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.004856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808183 [ RunTime:0.007049s ]
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 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002443s ]
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 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000875s ]
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 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007313s ]
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 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003068s ]
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 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005033s ]
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 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003095s ]
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 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002326s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P4SMA170%' OR `brand` LIKE 'P4SMA170%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008437s ]