SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001965s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=P4SMA10C&search=1' [ RunTime:0.008027s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001613s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000905s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004333s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.010328s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002433s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002249s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001465s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P4SMA10C' LIMIT 1 [ RunTime:0.028849s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-20 21:18:11' WHERE `partno` = 'P4SMA10C' [ RunTime:0.004026s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001607s ]
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 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058599s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906598 LIMIT 5 [ RunTime:0.010095s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906598 ORDER BY `minOrder` ASC [ RunTime:0.008765s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906598 ORDER BY `unit` DESC [ RunTime:0.011188s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906598 LIMIT 2 [ RunTime:0.014544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906598 ORDER BY `minOrder` ASC [ RunTime:0.006047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672169 LIMIT 5 [ RunTime:0.029260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672169 ORDER BY `minOrder` ASC [ RunTime:0.018767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16672169 ORDER BY `unit` DESC [ RunTime:0.010707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16672169 LIMIT 2 [ RunTime:0.001054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16672169 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661456 LIMIT 5 [ RunTime:0.011635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661456 ORDER BY `minOrder` ASC [ RunTime:0.014726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661456 ORDER BY `unit` DESC [ RunTime:0.002077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661456 LIMIT 2 [ RunTime:0.006129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661456 ORDER BY `minOrder` ASC [ RunTime:0.003056s ]
select * from pdf where partno='P4SMA10CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692673 LIMIT 5 [ RunTime:0.018649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692673 ORDER BY `minOrder` ASC [ RunTime:0.016280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692673 ORDER BY `unit` DESC [ RunTime:0.007581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692673 LIMIT 2 [ RunTime:0.023862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692673 ORDER BY `minOrder` ASC [ RunTime:0.002146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691319 LIMIT 5 [ RunTime:0.007237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691319 ORDER BY `minOrder` ASC [ RunTime:0.006642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691319 ORDER BY `unit` DESC [ RunTime:0.001339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691319 LIMIT 2 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691319 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691318 LIMIT 5 [ RunTime:0.006324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691318 ORDER BY `minOrder` ASC [ RunTime:0.007988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691318 ORDER BY `unit` DESC [ RunTime:0.005853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691318 LIMIT 2 [ RunTime:0.013405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691318 ORDER BY `minOrder` ASC [ RunTime:0.007059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688667 LIMIT 5 [ RunTime:0.002524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688667 ORDER BY `minOrder` ASC [ RunTime:0.000846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688667 ORDER BY `unit` DESC [ RunTime:0.007784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688667 LIMIT 2 [ RunTime:0.010398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688667 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
select * from pdf where partno='P4SMA10CAHE3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676549 LIMIT 5 [ RunTime:0.008944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676549 ORDER BY `minOrder` ASC [ RunTime:0.016977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676549 ORDER BY `unit` DESC [ RunTime:0.006128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676549 LIMIT 2 [ RunTime:0.000958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676549 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674792 LIMIT 5 [ RunTime:0.001363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674792 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674792 ORDER BY `unit` DESC [ RunTime:0.002615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674792 LIMIT 2 [ RunTime:0.002484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674792 ORDER BY `minOrder` ASC [ RunTime:0.003012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668371 LIMIT 5 [ RunTime:0.005073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668371 ORDER BY `minOrder` ASC [ RunTime:0.002166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668371 ORDER BY `unit` DESC [ RunTime:0.006654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668371 LIMIT 2 [ RunTime:0.008715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668371 ORDER BY `minOrder` ASC [ RunTime:0.002033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668300 LIMIT 5 [ RunTime:0.008005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668300 ORDER BY `minOrder` ASC [ RunTime:0.036934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668300 ORDER BY `unit` DESC [ RunTime:0.006062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668300 LIMIT 2 [ RunTime:0.001335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668300 ORDER BY `minOrder` ASC [ RunTime:0.000960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668282 LIMIT 5 [ RunTime:0.012621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668282 ORDER BY `minOrder` ASC [ RunTime:0.002872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668282 ORDER BY `unit` DESC [ RunTime:0.003719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668282 LIMIT 2 [ RunTime:0.016442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668282 ORDER BY `minOrder` ASC [ RunTime:0.012600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667434 LIMIT 5 [ RunTime:0.027413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667434 ORDER BY `minOrder` ASC [ RunTime:0.027228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667434 ORDER BY `unit` DESC [ RunTime:0.011472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667434 LIMIT 2 [ RunTime:0.008482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667434 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667415 LIMIT 5 [ RunTime:0.005929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667415 ORDER BY `minOrder` ASC [ RunTime:0.008481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667415 ORDER BY `unit` DESC [ RunTime:0.007211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667415 LIMIT 2 [ RunTime:0.008975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667415 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
select * from pdf where partno='P4SMA10CA-M3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665967 LIMIT 5 [ RunTime:0.002212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665967 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665967 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665967 LIMIT 2 [ RunTime:0.000459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665967 ORDER BY `minOrder` ASC [ RunTime:0.001701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832485 LIMIT 5 [ RunTime:0.002419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832485 ORDER BY `minOrder` ASC [ RunTime:0.003063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832485 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832485 LIMIT 2 [ RunTime:0.001183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832485 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827462 LIMIT 5 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827462 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827462 ORDER BY `unit` DESC [ RunTime:0.000374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827462 LIMIT 2 [ RunTime:0.012004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827462 ORDER BY `minOrder` ASC [ RunTime:0.005639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817950 LIMIT 5 [ RunTime:0.006491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817950 ORDER BY `minOrder` ASC [ RunTime:0.003553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817950 ORDER BY `unit` DESC [ RunTime:0.007444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817950 LIMIT 2 [ RunTime:0.006182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817950 ORDER BY `minOrder` ASC [ RunTime:0.007003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817942 LIMIT 5 [ RunTime:0.008068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817942 ORDER BY `minOrder` ASC [ RunTime:0.021415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817942 ORDER BY `unit` DESC [ RunTime:0.003292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817942 LIMIT 2 [ RunTime:0.009246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817942 ORDER BY `minOrder` ASC [ RunTime:0.002190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815298 LIMIT 5 [ RunTime:0.001243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815298 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815298 ORDER BY `unit` DESC [ RunTime:0.010290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815298 LIMIT 2 [ RunTime:0.010888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815298 ORDER BY `minOrder` ASC [ RunTime:0.008024s ]
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 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141211 LIMIT 5 [ RunTime:0.011231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141211 ORDER BY `minOrder` ASC [ RunTime:0.002973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141211 ORDER BY `unit` DESC [ RunTime:0.004821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141211 LIMIT 2 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141211 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
select * from pdf where partno='p4sma10ca' and brandshort='bourns' limit 1 [ RunTime:0.006350s ]
select foldpath,foldpath2,filename from pdf_file where id=1698472 limit 1 [ RunTime:0.000728s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'p4sma10ca' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.006978s ]
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 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160790 LIMIT 5 [ RunTime:0.001205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160790 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160790 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160790 LIMIT 2 [ RunTime:0.002219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160790 ORDER BY `minOrder` ASC [ RunTime:0.004066s ]
select * from pdf where partno='P4SMA10CA' and brandshort='NextGen Components' limit 1 [ RunTime:0.000845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.000557s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160790 AND `partno` = 'P4SMA10CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.004492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906598 [ RunTime:0.005438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113376 LIMIT 5 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113376 ORDER BY `minOrder` ASC [ RunTime:0.009116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113376 ORDER BY `unit` DESC [ RunTime:0.002241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113376 LIMIT 2 [ RunTime:0.001497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113376 ORDER BY `minOrder` ASC [ RunTime:0.004887s ]
select * from pdf where partno='P4SMA10CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.010478s ]
SELECT `id` FROM `stock` WHERE `id` <> 42113376 AND `partno` = 'P4SMA10CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.013593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16672169 [ RunTime:0.003816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42140725 LIMIT 5 [ RunTime:0.003500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140725 ORDER BY `minOrder` ASC [ RunTime:0.001559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42140725 ORDER BY `unit` DESC [ RunTime:0.011128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42140725 LIMIT 2 [ RunTime:0.008184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42140725 ORDER BY `minOrder` ASC [ RunTime:0.003504s ]
select * from pdf where partno='P4SMA10CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001231s ]
SELECT `id` FROM `stock` WHERE `id` <> 42140725 AND `partno` = 'P4SMA10CA-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661456 [ RunTime:0.002543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42285468 LIMIT 5 [ RunTime:0.002410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42285468 ORDER BY `minOrder` ASC [ RunTime:0.004092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42285468 ORDER BY `unit` DESC [ RunTime:0.002345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42285468 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42285468 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
select * from pdf where partno='P4SMA10CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.002769s ]
SELECT `id` FROM `stock` WHERE `id` <> 42285468 AND `partno` = 'P4SMA10CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.004473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817950 [ RunTime:0.000815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242110 LIMIT 5 [ RunTime:0.001560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242110 ORDER BY `minOrder` ASC [ RunTime:0.000881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242110 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242110 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242110 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
select * from pdf where partno='P4SMA10CAHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003049s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CAHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000637s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242110 AND `partno` = 'P4SMA10CAHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815298 [ RunTime:0.005876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242109 LIMIT 5 [ RunTime:0.001876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242109 ORDER BY `minOrder` ASC [ RunTime:0.003170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242109 ORDER BY `unit` DESC [ RunTime:0.000922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242109 LIMIT 2 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242109 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='P4SMA10CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000783s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242109 AND `partno` = 'P4SMA10CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674792 [ RunTime:0.004963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42228592 LIMIT 5 [ RunTime:0.001071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228592 ORDER BY `minOrder` ASC [ RunTime:0.001372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42228592 ORDER BY `unit` DESC [ RunTime:0.010857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42228592 LIMIT 2 [ RunTime:0.009016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228592 ORDER BY `minOrder` ASC [ RunTime:0.011944s ]
select * from pdf where partno='P4SMA10CAHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.023363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CAHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000946s ]
SELECT `id` FROM `stock` WHERE `id` <> 42228592 AND `partno` = 'P4SMA10CAHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.005690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810265 [ RunTime:0.016687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42228591 LIMIT 5 [ RunTime:0.003413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228591 ORDER BY `minOrder` ASC [ RunTime:0.009289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42228591 ORDER BY `unit` DESC [ RunTime:0.009223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42228591 LIMIT 2 [ RunTime:0.003374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228591 ORDER BY `minOrder` ASC [ RunTime:0.005225s ]
select * from pdf where partno='P4SMA10CAHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CAHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.007893s ]
SELECT `id` FROM `stock` WHERE `id` <> 42228591 AND `partno` = 'P4SMA10CAHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913431 [ RunTime:0.003875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42223160 LIMIT 5 [ RunTime:0.001380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223160 ORDER BY `minOrder` ASC [ RunTime:0.001819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42223160 ORDER BY `unit` DESC [ RunTime:0.001454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42223160 LIMIT 2 [ RunTime:0.001434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223160 ORDER BY `minOrder` ASC [ RunTime:0.001338s ]
select * from pdf where partno='P4SMA10CA-M3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA-M3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.018987s ]
SELECT `id` FROM `stock` WHERE `id` <> 42223160 AND `partno` = 'P4SMA10CA-M3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807663 [ RunTime:0.009172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42220224 LIMIT 5 [ RunTime:0.015591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220224 ORDER BY `minOrder` ASC [ RunTime:0.015385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42220224 ORDER BY `unit` DESC [ RunTime:0.016742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42220224 LIMIT 2 [ RunTime:0.010231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42220224 ORDER BY `minOrder` ASC [ RunTime:0.015739s ]
select * from pdf where partno='P4SMA10CA-M3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA-M3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004227s ]
SELECT `id` FROM `stock` WHERE `id` <> 42220224 AND `partno` = 'P4SMA10CA-M3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667415 [ RunTime:0.017127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42213775 LIMIT 5 [ RunTime:0.008071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42213775 ORDER BY `minOrder` ASC [ RunTime:0.004865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42213775 ORDER BY `unit` DESC [ RunTime:0.006689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42213775 LIMIT 2 [ RunTime:0.004429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42213775 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='P4SMA10CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.006603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002381s ]
SELECT `id` FROM `stock` WHERE `id` <> 42213775 AND `partno` = 'P4SMA10CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.012625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808905 [ RunTime:0.009083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42205439 LIMIT 5 [ RunTime:0.006486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205439 ORDER BY `minOrder` ASC [ RunTime:0.004309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42205439 ORDER BY `unit` DESC [ RunTime:0.002353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42205439 LIMIT 2 [ RunTime:0.003340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205439 ORDER BY `minOrder` ASC [ RunTime:0.002659s ]
select * from pdf where partno='P4SMA10CA-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA-E3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002225s ]
SELECT `id` FROM `stock` WHERE `id` <> 42205439 AND `partno` = 'P4SMA10CA-E3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911556 [ RunTime:0.005169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42203154 LIMIT 5 [ RunTime:0.002165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203154 ORDER BY `minOrder` ASC [ RunTime:0.007962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42203154 ORDER BY `unit` DESC [ RunTime:0.011179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42203154 LIMIT 2 [ RunTime:0.006978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203154 ORDER BY `minOrder` ASC [ RunTime:0.001045s ]
select * from pdf where partno='P4SMA10CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003320s ]
SELECT `id` FROM `stock` WHERE `id` <> 42203154 AND `partno` = 'P4SMA10CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.005745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668300 [ RunTime:0.003004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42203080 LIMIT 5 [ RunTime:0.004336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203080 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42203080 ORDER BY `unit` DESC [ RunTime:0.007334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42203080 LIMIT 2 [ RunTime:0.005517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42203080 ORDER BY `minOrder` ASC [ RunTime:0.003760s ]
select * from pdf where partno='P4SMA10C' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.003607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10C' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000582s ]
SELECT `id` FROM `stock` WHERE `id` <> 42203080 AND `partno` = 'P4SMA10C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668371 [ RunTime:0.006110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42202621 LIMIT 5 [ RunTime:0.002958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202621 ORDER BY `minOrder` ASC [ RunTime:0.002792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42202621 ORDER BY `unit` DESC [ RunTime:0.004823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42202621 LIMIT 2 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202621 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='P4SMA10CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.002616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.001389s ]
SELECT `id` FROM `stock` WHERE `id` <> 42202621 AND `partno` = 'P4SMA10CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668282 [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196853 LIMIT 5 [ RunTime:0.014122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196853 ORDER BY `minOrder` ASC [ RunTime:0.022223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196853 ORDER BY `unit` DESC [ RunTime:0.005379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196853 LIMIT 2 [ RunTime:0.016596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196853 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
select * from pdf where partno='P4SMA10CA_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.005334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.008831s ]
SELECT `id` FROM `stock` WHERE `id` <> 42196853 AND `partno` = 'P4SMA10CA_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.010980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817942 [ RunTime:0.023569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42195011 LIMIT 5 [ RunTime:0.011646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42195011 ORDER BY `minOrder` ASC [ RunTime:0.007986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42195011 ORDER BY `unit` DESC [ RunTime:0.000398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42195011 LIMIT 2 [ RunTime:0.002283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42195011 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
select * from pdf where partno='P4SMA10CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.011334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.015571s ]
SELECT `id` FROM `stock` WHERE `id` <> 42195011 AND `partno` = 'P4SMA10CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.009189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667434 [ RunTime:0.010209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42192087 LIMIT 5 [ RunTime:0.010736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192087 ORDER BY `minOrder` ASC [ RunTime:0.008469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42192087 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42192087 LIMIT 2 [ RunTime:0.002486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192087 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='P4SMA10CA-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.001116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42191755 LIMIT 5 [ RunTime:0.007971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191755 ORDER BY `minOrder` ASC [ RunTime:0.001303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42191755 ORDER BY `unit` DESC [ RunTime:0.017603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42191755 LIMIT 2 [ RunTime:0.003020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191755 ORDER BY `minOrder` ASC [ RunTime:0.007590s ]
select * from pdf where partno='P4SMA10CAS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.000904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CAS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.006399s ]
SELECT `id` FROM `stock` WHERE `id` <> 42191755 AND `partno` = 'P4SMA10CAS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.007421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676549 [ RunTime:0.007171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42190860 LIMIT 5 [ RunTime:0.005866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190860 ORDER BY `minOrder` ASC [ RunTime:0.003166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42190860 ORDER BY `unit` DESC [ RunTime:0.014864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42190860 LIMIT 2 [ RunTime:0.000910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42190860 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='P4SMA10CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.005688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA10CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.006551s ]
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 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007932s ]
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 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003623s ]
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 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001374s ]
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 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001747s ]
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 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002356s ]
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 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008441s ]
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 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001629s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P4SMA10C%' OR `brand` LIKE 'P4SMA10C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014809s ]