SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001929s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.151' , `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=P4SMA170C&search=1' [ RunTime:0.015455s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001264s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005240s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001273s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.151' ) [ RunTime:0.005488s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001105s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.013375s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001450s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P4SMA170C' LIMIT 1 [ RunTime:0.027184s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-14 09:19:18' WHERE `partno` = 'P4SMA170C' [ RunTime:0.017365s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001431s ]
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 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013556s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.021363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801806 LIMIT 5 [ RunTime:0.047006s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801806 ORDER BY `minOrder` ASC [ RunTime:0.005908s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801806 ORDER BY `unit` DESC [ RunTime:0.064225s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801806 LIMIT 2 [ RunTime:0.083476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801806 ORDER BY `minOrder` ASC [ RunTime:0.021495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926160 LIMIT 5 [ RunTime:0.050563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926160 ORDER BY `minOrder` ASC [ RunTime:0.024114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13926160 ORDER BY `unit` DESC [ RunTime:0.019208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13926160 LIMIT 2 [ RunTime:0.077154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926160 ORDER BY `minOrder` ASC [ RunTime:0.030965s ]
select * from pdf where partno='P4SMA170CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.024984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691768 LIMIT 5 [ RunTime:0.015839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691768 ORDER BY `minOrder` ASC [ RunTime:0.055293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691768 ORDER BY `unit` DESC [ RunTime:0.051029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691768 LIMIT 2 [ RunTime:0.047830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691768 ORDER BY `minOrder` ASC [ RunTime:0.007548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687321 LIMIT 5 [ RunTime:0.069889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687321 ORDER BY `minOrder` ASC [ RunTime:0.039634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687321 ORDER BY `unit` DESC [ RunTime:0.049838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687321 LIMIT 2 [ RunTime:0.054129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687321 ORDER BY `minOrder` ASC [ RunTime:0.017138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677248 LIMIT 5 [ RunTime:0.022780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677248 ORDER BY `minOrder` ASC [ RunTime:0.019107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16677248 ORDER BY `unit` DESC [ RunTime:0.030531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16677248 LIMIT 2 [ RunTime:0.010123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677248 ORDER BY `minOrder` ASC [ RunTime:0.002685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668628 LIMIT 5 [ RunTime:0.007514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668628 ORDER BY `minOrder` ASC [ RunTime:0.013822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668628 ORDER BY `unit` DESC [ RunTime:0.017866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668628 LIMIT 2 [ RunTime:0.022292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668628 ORDER BY `minOrder` ASC [ RunTime:0.001229s ]
select * from pdf where partno='P4SMA170CA-M3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668373 LIMIT 5 [ RunTime:0.010283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668373 ORDER BY `minOrder` ASC [ RunTime:0.008549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668373 ORDER BY `unit` DESC [ RunTime:0.008476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668373 LIMIT 2 [ RunTime:0.021956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668373 ORDER BY `minOrder` ASC [ RunTime:0.007060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668353 LIMIT 5 [ RunTime:0.004728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668353 ORDER BY `minOrder` ASC [ RunTime:0.004114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668353 ORDER BY `unit` DESC [ RunTime:0.005566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668353 LIMIT 2 [ RunTime:0.003031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668353 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666580 LIMIT 5 [ RunTime:0.002367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666580 ORDER BY `minOrder` ASC [ RunTime:0.004366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666580 ORDER BY `unit` DESC [ RunTime:0.001693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666580 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666580 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665966 LIMIT 5 [ RunTime:0.009367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665966 ORDER BY `minOrder` ASC [ RunTime:0.027871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665966 ORDER BY `unit` DESC [ RunTime:0.002783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665966 LIMIT 2 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665966 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833266 LIMIT 5 [ RunTime:0.000689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833266 ORDER BY `minOrder` ASC [ RunTime:0.005970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833266 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833266 LIMIT 2 [ RunTime:0.006405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833266 ORDER BY `minOrder` ASC [ RunTime:0.014670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832502 LIMIT 5 [ RunTime:0.008168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832502 ORDER BY `minOrder` ASC [ RunTime:0.008037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832502 ORDER BY `unit` DESC [ RunTime:0.002910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832502 LIMIT 2 [ RunTime:0.011788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832502 ORDER BY `minOrder` ASC [ RunTime:0.010704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832501 LIMIT 5 [ RunTime:0.003753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832501 ORDER BY `minOrder` ASC [ RunTime:0.007249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832501 ORDER BY `unit` DESC [ RunTime:0.010954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832501 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832501 ORDER BY `minOrder` ASC [ RunTime:0.006778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832185 LIMIT 5 [ RunTime:0.001784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832185 ORDER BY `minOrder` ASC [ RunTime:0.010773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832185 ORDER BY `unit` DESC [ RunTime:0.008444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832185 LIMIT 2 [ RunTime:0.010952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832185 ORDER BY `minOrder` ASC [ RunTime:0.008315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831689 LIMIT 5 [ RunTime:0.003599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831689 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831689 ORDER BY `unit` DESC [ RunTime:0.013166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831689 LIMIT 2 [ RunTime:0.017410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831689 ORDER BY `minOrder` ASC [ RunTime:0.009060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829520 LIMIT 5 [ RunTime:0.006715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829520 ORDER BY `minOrder` ASC [ RunTime:0.004471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829520 ORDER BY `unit` DESC [ RunTime:0.000668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829520 LIMIT 2 [ RunTime:0.003707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829520 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='P4SMA170CAHE3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828850 LIMIT 5 [ RunTime:0.015465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828850 ORDER BY `minOrder` ASC [ RunTime:0.020722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828850 ORDER BY `unit` DESC [ RunTime:0.018963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828850 LIMIT 2 [ RunTime:0.007459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828850 ORDER BY `minOrder` ASC [ RunTime:0.018317s ]
select * from pdf where partno='P4SMA170CAHE3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.016332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817092 LIMIT 5 [ RunTime:0.052195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817092 ORDER BY `minOrder` ASC [ RunTime:0.053417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817092 ORDER BY `unit` DESC [ RunTime:0.034643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817092 LIMIT 2 [ RunTime:0.036093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817092 ORDER BY `minOrder` ASC [ RunTime:0.027444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810318 LIMIT 5 [ RunTime:0.023814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810318 ORDER BY `minOrder` ASC [ RunTime:0.009135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810318 ORDER BY `unit` DESC [ RunTime:0.010150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810318 LIMIT 2 [ RunTime:0.034934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810318 ORDER BY `minOrder` ASC [ RunTime:0.012751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810216 LIMIT 5 [ RunTime:0.007387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810216 ORDER BY `minOrder` ASC [ RunTime:0.020482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810216 ORDER BY `unit` DESC [ RunTime:0.012516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810216 LIMIT 2 [ RunTime:0.008417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810216 ORDER BY `minOrder` ASC [ RunTime:0.011889s ]
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 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012366s ]
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 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160912 LIMIT 5 [ RunTime:0.006891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160912 ORDER BY `minOrder` ASC [ RunTime:0.000774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160912 ORDER BY `unit` DESC [ RunTime:0.013902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160912 LIMIT 2 [ RunTime:0.012233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160912 ORDER BY `minOrder` ASC [ RunTime:0.011694s ]
select * from pdf where partno='P4SMA170CA' and brandshort='NextGen Components' limit 1 [ RunTime:0.036860s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.021711s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160912 AND `partno` = 'P4SMA170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.052158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801806 [ RunTime:0.043017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42127041 LIMIT 5 [ RunTime:0.023460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127041 ORDER BY `minOrder` ASC [ RunTime:0.025320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42127041 ORDER BY `unit` DESC [ RunTime:0.013532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42127041 LIMIT 2 [ RunTime:0.001110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127041 ORDER BY `minOrder` ASC [ RunTime:0.008859s ]
select * from pdf where partno='P4SMA170CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003101s ]
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.006717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926160 [ RunTime:0.003101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159173 LIMIT 5 [ RunTime:0.005675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159173 ORDER BY `minOrder` ASC [ RunTime:0.014670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159173 ORDER BY `unit` DESC [ RunTime:0.008037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159173 LIMIT 2 [ RunTime:0.018978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159173 ORDER BY `minOrder` ASC [ RunTime:0.006591s ]
select * from pdf where partno='P4SMA170CA' and brandshort='Eaton - Bussmann Electrical Division' limit 1 [ RunTime:0.020222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA' OR `brand` LIKE 'Eaton - Bussmann Electrical Division%' ) ) LIMIT 1 [ RunTime:0.007924s ]
SELECT `id` FROM `stock` WHERE `id` <> 42159173 AND `partno` = 'P4SMA170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - bussmann electrical division%' ) [ RunTime:0.016194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42234658 LIMIT 5 [ RunTime:0.070449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234658 ORDER BY `minOrder` ASC [ RunTime:0.016472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42234658 ORDER BY `unit` DESC [ RunTime:0.019760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42234658 LIMIT 2 [ RunTime:0.008882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234658 ORDER BY `minOrder` ASC [ RunTime:0.007118s ]
select * from pdf where partno='P4SMA170CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.018738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.006366s ]
SELECT `id` FROM `stock` WHERE `id` <> 42234658 AND `partno` = 'P4SMA170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.012312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913877 [ RunTime:0.011621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42234046 LIMIT 5 [ RunTime:0.013550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234046 ORDER BY `minOrder` ASC [ RunTime:0.011521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42234046 ORDER BY `unit` DESC [ RunTime:0.004510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42234046 LIMIT 2 [ RunTime:0.011385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42234046 ORDER BY `minOrder` ASC [ RunTime:0.006751s ]
select * from pdf where partno='P4SMA170CA R3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.010828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA R3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.004094s ]
SELECT `id` FROM `stock` WHERE `id` <> 42234046 AND `partno` = 'P4SMA170CA R3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.003145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914975 [ RunTime:0.008311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42225800 LIMIT 5 [ RunTime:0.011755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225800 ORDER BY `minOrder` ASC [ RunTime:0.011047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42225800 ORDER BY `unit` DESC [ RunTime:0.005181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42225800 LIMIT 2 [ RunTime:0.003856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225800 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='P4SMA170CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003117s ]
SELECT `id` FROM `stock` WHERE `id` <> 42225800 AND `partno` = 'P4SMA170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.016051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810318 [ RunTime:0.000876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42223129 LIMIT 5 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223129 ORDER BY `minOrder` ASC [ RunTime:0.003215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42223129 ORDER BY `unit` DESC [ RunTime:0.006626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42223129 LIMIT 2 [ RunTime:0.012890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223129 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
select * from pdf where partno='P4SMA170CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.013032s ]
SELECT `id` FROM `stock` WHERE `id` <> 42223129 AND `partno` = 'P4SMA170CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.009582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810216 [ RunTime:0.003812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42214575 LIMIT 5 [ RunTime:0.002217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214575 ORDER BY `minOrder` ASC [ RunTime:0.014846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42214575 ORDER BY `unit` DESC [ RunTime:0.026440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42214575 LIMIT 2 [ RunTime:0.010072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214575 ORDER BY `minOrder` ASC [ RunTime:0.002089s ]
select * from pdf where partno='P4SMA170CA-M3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-M3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013894s ]
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.011844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808952 [ RunTime:0.010708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42214444 LIMIT 5 [ RunTime:0.003641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214444 ORDER BY `minOrder` ASC [ RunTime:0.007242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42214444 ORDER BY `unit` DESC [ RunTime:0.019072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42214444 LIMIT 2 [ RunTime:0.027198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214444 ORDER BY `minOrder` ASC [ RunTime:0.004996s ]
select * from pdf where partno='P4SMA170CA-M3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-M3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000970s ]
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.001511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668628 [ RunTime:0.002351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42205444 LIMIT 5 [ RunTime:0.006688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205444 ORDER BY `minOrder` ASC [ RunTime:0.007288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42205444 ORDER BY `unit` DESC [ RunTime:0.007955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42205444 LIMIT 2 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205444 ORDER BY `minOrder` ASC [ RunTime:0.003974s ]
select * from pdf where partno='P4SMA170CA-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-E3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.005095s ]
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.005110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911558 [ RunTime:0.004040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42203375 LIMIT 5 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203375 ORDER BY `minOrder` ASC [ RunTime:0.006259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42203375 ORDER BY `unit` DESC [ RunTime:0.001695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42203375 LIMIT 2 [ RunTime:0.009985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203375 ORDER BY `minOrder` ASC [ RunTime:0.007308s ]
select * from pdf where partno='P4SMA170CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.003907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.007035s ]
SELECT `id` FROM `stock` WHERE `id` <> 42203375 AND `partno` = 'P4SMA170CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808183 [ RunTime:0.006636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42203374 LIMIT 5 [ RunTime:0.006701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203374 ORDER BY `minOrder` ASC [ RunTime:0.002005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42203374 ORDER BY `unit` DESC [ RunTime:0.012949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42203374 LIMIT 2 [ RunTime:0.009330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203374 ORDER BY `minOrder` ASC [ RunTime:0.003144s ]
select * from pdf where partno='P4SMA170CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.001416s ]
SELECT `id` FROM `stock` WHERE `id` <> 42203374 AND `partno` = 'P4SMA170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.003142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808182 [ RunTime:0.004841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42203082 LIMIT 5 [ RunTime:0.005443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203082 ORDER BY `minOrder` ASC [ RunTime:0.001961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42203082 ORDER BY `unit` DESC [ RunTime:0.003321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42203082 LIMIT 2 [ RunTime:0.011622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203082 ORDER BY `minOrder` ASC [ RunTime:0.005143s ]
select * from pdf where partno='P4SMA170C' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170C' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.011091s ]
SELECT `id` FROM `stock` WHERE `id` <> 42203082 AND `partno` = 'P4SMA170C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668373 [ RunTime:0.004363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42202817 LIMIT 5 [ RunTime:0.008461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202817 ORDER BY `minOrder` ASC [ RunTime:0.003927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42202817 ORDER BY `unit` DESC [ RunTime:0.002200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42202817 LIMIT 2 [ RunTime:0.001168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202817 ORDER BY `minOrder` ASC [ RunTime:0.005055s ]
select * from pdf where partno='P4SMA170CH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.005246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.011641s ]
SELECT `id` FROM `stock` WHERE `id` <> 42202817 AND `partno` = 'P4SMA170CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.007236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668353 [ RunTime:0.000684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42202427 LIMIT 5 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202427 ORDER BY `minOrder` ASC [ RunTime:0.001420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42202427 ORDER BY `unit` DESC [ RunTime:0.002811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42202427 LIMIT 2 [ RunTime:0.004024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202427 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='P4SMA170CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.004252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.001211s ]
SELECT `id` FROM `stock` WHERE `id` <> 42202427 AND `partno` = 'P4SMA170CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.000764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807121 [ RunTime:0.000858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42199733 LIMIT 5 [ RunTime:0.004888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199733 ORDER BY `minOrder` ASC [ RunTime:0.002965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42199733 ORDER BY `unit` DESC [ RunTime:0.003988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42199733 LIMIT 2 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199733 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='P4SMA170CA_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.002505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.002044s ]
SELECT `id` FROM `stock` WHERE `id` <> 42199733 AND `partno` = 'P4SMA170CA_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.007910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677248 [ RunTime:0.011594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42192127 LIMIT 5 [ RunTime:0.013521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192127 ORDER BY `minOrder` ASC [ RunTime:0.007015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42192127 ORDER BY `unit` DESC [ RunTime:0.000730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42192127 LIMIT 2 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192127 ORDER BY `minOrder` ASC [ RunTime:0.002374s ]
select * from pdf where partno='P4SMA170CA-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.001275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42191736 LIMIT 5 [ RunTime:0.002105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191736 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42191736 ORDER BY `unit` DESC [ RunTime:0.000430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42191736 LIMIT 2 [ RunTime:0.001704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191736 ORDER BY `minOrder` ASC [ RunTime:0.010853s ]
select * from pdf where partno='P4SMA170CAS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.009251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CAS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000937s ]
SELECT `id` FROM `stock` WHERE `id` <> 42191736 AND `partno` = 'P4SMA170CAS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817092 [ RunTime:0.003595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42190999 LIMIT 5 [ RunTime:0.005646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190999 ORDER BY `minOrder` ASC [ RunTime:0.009757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42190999 ORDER BY `unit` DESC [ RunTime:0.006632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42190999 LIMIT 2 [ RunTime:0.000563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190999 ORDER BY `minOrder` ASC [ RunTime:0.001926s ]
select * from pdf where partno='P4SMA170CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.002432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42187829 LIMIT 5 [ RunTime:0.001723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187829 ORDER BY `minOrder` ASC [ RunTime:0.007765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42187829 ORDER BY `unit` DESC [ RunTime:0.000481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42187829 LIMIT 2 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187829 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='P4SMA170CA/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.005032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA170CA/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009300s ]
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 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002042s ]
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 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000906s ]
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 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002911s ]
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 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010615s ]
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 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001038s ]
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 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003086s ]
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 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012612s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P4SMA170C%' OR `brand` LIKE 'P4SMA170C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001209s ]