SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001511s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=SMAJ120C&search=1' [ RunTime:0.007122s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001376s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002163s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001694s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.007174s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002442s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000324s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002338s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ120C' LIMIT 1 [ RunTime:0.037697s ]
UPDATE `stock_search` SET `count` = 10 , `updatetime` = '2026-08-18 03:31:23' WHERE `partno` = 'SMAJ120C' [ RunTime:0.003033s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002476s ]
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 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060613s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664813 LIMIT 5 [ RunTime:0.042654s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664813 ORDER BY `minOrder` ASC [ RunTime:0.009291s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664813 ORDER BY `unit` DESC [ RunTime:0.012984s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664813 LIMIT 2 [ RunTime:0.035361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664813 ORDER BY `minOrder` ASC [ RunTime:0.008251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665040 LIMIT 5 [ RunTime:0.037558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665040 ORDER BY `minOrder` ASC [ RunTime:0.017430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665040 ORDER BY `unit` DESC [ RunTime:0.005734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665040 LIMIT 2 [ RunTime:0.039097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665040 ORDER BY `minOrder` ASC [ RunTime:0.005430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919269 LIMIT 5 [ RunTime:0.034030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919269 ORDER BY `minOrder` ASC [ RunTime:0.020535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13919269 ORDER BY `unit` DESC [ RunTime:0.036965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13919269 LIMIT 2 [ RunTime:0.043804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919269 ORDER BY `minOrder` ASC [ RunTime:0.010144s ]
select * from pdf where partno='SMAJ120CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.052730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904744 LIMIT 5 [ RunTime:0.041667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904744 ORDER BY `minOrder` ASC [ RunTime:0.049509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904744 ORDER BY `unit` DESC [ RunTime:0.034256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904744 LIMIT 2 [ RunTime:0.047167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904744 ORDER BY `minOrder` ASC [ RunTime:0.026844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906144 LIMIT 5 [ RunTime:0.034469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906144 ORDER BY `minOrder` ASC [ RunTime:0.064741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906144 ORDER BY `unit` DESC [ RunTime:0.066203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906144 LIMIT 2 [ RunTime:0.027565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906144 ORDER BY `minOrder` ASC [ RunTime:0.005541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906149 LIMIT 5 [ RunTime:0.005294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906149 ORDER BY `minOrder` ASC [ RunTime:0.021990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906149 ORDER BY `unit` DESC [ RunTime:0.013235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906149 LIMIT 2 [ RunTime:0.015825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906149 ORDER BY `minOrder` ASC [ RunTime:0.000849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825961 LIMIT 5 [ RunTime:0.001370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825961 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14825961 ORDER BY `unit` DESC [ RunTime:0.017709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14825961 LIMIT 2 [ RunTime:0.008023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825961 ORDER BY `minOrder` ASC [ RunTime:0.002658s ]
select * from pdf where partno='SMAJ120CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908440 LIMIT 5 [ RunTime:0.024724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908440 ORDER BY `minOrder` ASC [ RunTime:0.008776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908440 ORDER BY `unit` DESC [ RunTime:0.002843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908440 LIMIT 2 [ RunTime:0.000912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908440 ORDER BY `minOrder` ASC [ RunTime:0.002150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689440 LIMIT 5 [ RunTime:0.003848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689440 ORDER BY `minOrder` ASC [ RunTime:0.012065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689440 ORDER BY `unit` DESC [ RunTime:0.010186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689440 LIMIT 2 [ RunTime:0.004527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689440 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
select * from pdf where partno='SMAJ120CAHE3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.016620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671371 LIMIT 5 [ RunTime:0.004923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671371 ORDER BY `minOrder` ASC [ RunTime:0.007739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671371 ORDER BY `unit` DESC [ RunTime:0.014393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671371 LIMIT 2 [ RunTime:0.020272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671371 ORDER BY `minOrder` ASC [ RunTime:0.001812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670623 LIMIT 5 [ RunTime:0.000723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670623 ORDER BY `minOrder` ASC [ RunTime:0.007443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670623 ORDER BY `unit` DESC [ RunTime:0.015720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670623 LIMIT 2 [ RunTime:0.003983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670623 ORDER BY `minOrder` ASC [ RunTime:0.003696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669512 LIMIT 5 [ RunTime:0.010481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669512 ORDER BY `minOrder` ASC [ RunTime:0.001278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669512 ORDER BY `unit` DESC [ RunTime:0.008039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669512 LIMIT 2 [ RunTime:0.002622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669512 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669393 LIMIT 5 [ RunTime:0.006947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669393 ORDER BY `minOrder` ASC [ RunTime:0.002813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669393 ORDER BY `unit` DESC [ RunTime:0.000575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669393 LIMIT 2 [ RunTime:0.031212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669393 ORDER BY `minOrder` ASC [ RunTime:0.009237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668344 LIMIT 5 [ RunTime:0.010103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668344 ORDER BY `minOrder` ASC [ RunTime:0.001116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668344 ORDER BY `unit` DESC [ RunTime:0.009824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668344 LIMIT 2 [ RunTime:0.018639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668344 ORDER BY `minOrder` ASC [ RunTime:0.007216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668328 LIMIT 5 [ RunTime:0.010826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668328 ORDER BY `minOrder` ASC [ RunTime:0.017713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668328 ORDER BY `unit` DESC [ RunTime:0.014017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668328 LIMIT 2 [ RunTime:0.014146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668328 ORDER BY `minOrder` ASC [ RunTime:0.033867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16668327 LIMIT 5 [ RunTime:0.007884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668327 ORDER BY `minOrder` ASC [ RunTime:0.010289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16668327 ORDER BY `unit` DESC [ RunTime:0.002555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16668327 LIMIT 2 [ RunTime:0.027652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16668327 ORDER BY `minOrder` ASC [ RunTime:0.001208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667999 LIMIT 5 [ RunTime:0.026532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667999 ORDER BY `minOrder` ASC [ RunTime:0.019174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667999 ORDER BY `unit` DESC [ RunTime:0.010285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667999 LIMIT 2 [ RunTime:0.001163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667999 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='SMAJ120CA-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667833 LIMIT 5 [ RunTime:0.004391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667833 ORDER BY `minOrder` ASC [ RunTime:0.010818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667833 ORDER BY `unit` DESC [ RunTime:0.008781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667833 LIMIT 2 [ RunTime:0.015998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667833 ORDER BY `minOrder` ASC [ RunTime:0.011316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666661 LIMIT 5 [ RunTime:0.003831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666661 ORDER BY `minOrder` ASC [ RunTime:0.003632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666661 ORDER BY `unit` DESC [ RunTime:0.035391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666661 LIMIT 2 [ RunTime:0.019051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666661 ORDER BY `minOrder` ASC [ RunTime:0.006296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666459 LIMIT 5 [ RunTime:0.028526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666459 ORDER BY `minOrder` ASC [ RunTime:0.022444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666459 ORDER BY `unit` DESC [ RunTime:0.014844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666459 LIMIT 2 [ RunTime:0.004845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666459 ORDER BY `minOrder` ASC [ RunTime:0.003311s ]
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 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014774s ]
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 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113001 LIMIT 5 [ RunTime:0.025068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113001 ORDER BY `minOrder` ASC [ RunTime:0.057430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113001 ORDER BY `unit` DESC [ RunTime:0.023973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113001 LIMIT 2 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113001 ORDER BY `minOrder` ASC [ RunTime:0.003968s ]
select * from pdf where partno='SMAJ120CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.009989s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002167s ]
SELECT `id` FROM `stock` WHERE `id` <> 42113001 AND `partno` = 'SMAJ120CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.001405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664813 [ RunTime:0.000647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42102015 LIMIT 5 [ RunTime:0.001676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102015 ORDER BY `minOrder` ASC [ RunTime:0.010610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42102015 ORDER BY `unit` DESC [ RunTime:0.021762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42102015 LIMIT 2 [ RunTime:0.021686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102015 ORDER BY `minOrder` ASC [ RunTime:0.009940s ]
select * from pdf where partno='SMAJ120CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.004459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.016113s ]
SELECT `id` FROM `stock` WHERE `id` <> 42102015 AND `partno` = 'SMAJ120CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.028189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665040 [ RunTime:0.003009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42154885 LIMIT 5 [ RunTime:0.004124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154885 ORDER BY `minOrder` ASC [ RunTime:0.010701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42154885 ORDER BY `unit` DESC [ RunTime:0.008927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42154885 LIMIT 2 [ RunTime:0.010866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154885 ORDER BY `minOrder` ASC [ RunTime:0.010207s ]
select * from pdf where partno='SMAJ120CAHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CAHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003877s ]
SELECT `id` FROM `stock` WHERE `id` <> 42154885 AND `partno` = 'SMAJ120CAHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.010794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906144 [ RunTime:0.013455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42154896 LIMIT 5 [ RunTime:0.026848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154896 ORDER BY `minOrder` ASC [ RunTime:0.032698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42154896 ORDER BY `unit` DESC [ RunTime:0.012586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42154896 LIMIT 2 [ RunTime:0.018827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42154896 ORDER BY `minOrder` ASC [ RunTime:0.008533s ]
select * from pdf where partno='SMAJ120CHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.007277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.012895s ]
SELECT `id` FROM `stock` WHERE `id` <> 42154896 AND `partno` = 'SMAJ120CHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.008843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906149 [ RunTime:0.010867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42127070 LIMIT 5 [ RunTime:0.009068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127070 ORDER BY `minOrder` ASC [ RunTime:0.014043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42127070 ORDER BY `unit` DESC [ RunTime:0.006399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42127070 LIMIT 2 [ RunTime:0.016726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127070 ORDER BY `minOrder` ASC [ RunTime:0.015966s ]
select * from pdf where partno='SMAJ120CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.030757s ]
SELECT `id` FROM `stock` WHERE `id` <> 42127070 AND `partno` = 'SMAJ120CA-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.016890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825961 [ RunTime:0.020483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112337 LIMIT 5 [ RunTime:0.014350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112337 ORDER BY `minOrder` ASC [ RunTime:0.025071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112337 ORDER BY `unit` DESC [ RunTime:0.007881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112337 LIMIT 2 [ RunTime:0.011955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112337 ORDER BY `minOrder` ASC [ RunTime:0.003545s ]
select * from pdf where partno='SMAJ120CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003598s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112337 AND `partno` = 'SMAJ120CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.037393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919269 [ RunTime:0.006117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42256218 LIMIT 5 [ RunTime:0.012996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256218 ORDER BY `minOrder` ASC [ RunTime:0.005494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42256218 ORDER BY `unit` DESC [ RunTime:0.006210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42256218 LIMIT 2 [ RunTime:0.017150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256218 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
select * from pdf where partno='SMAJ120CA-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.031736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.005091s ]
SELECT `id` FROM `stock` WHERE `id` <> 42256218 AND `partno` = 'SMAJ120CA-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.002950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814306 [ RunTime:0.013887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42238636 LIMIT 5 [ RunTime:0.021417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238636 ORDER BY `minOrder` ASC [ RunTime:0.020811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42238636 ORDER BY `unit` DESC [ RunTime:0.011813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42238636 LIMIT 2 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238636 ORDER BY `minOrder` ASC [ RunTime:0.003643s ]
select * from pdf where partno='SMAJ120CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.012633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.008802s ]
SELECT `id` FROM `stock` WHERE `id` <> 42238636 AND `partno` = 'SMAJ120CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.012261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671371 [ RunTime:0.005278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42238635 LIMIT 5 [ RunTime:0.007201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238635 ORDER BY `minOrder` ASC [ RunTime:0.011513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42238635 ORDER BY `unit` DESC [ RunTime:0.003724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42238635 LIMIT 2 [ RunTime:0.001313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238635 ORDER BY `minOrder` ASC [ RunTime:0.006754s ]
select * from pdf where partno='SMAJ120CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.005492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.005013s ]
SELECT `id` FROM `stock` WHERE `id` <> 42238635 AND `partno` = 'SMAJ120CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.005115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914526 [ RunTime:0.006468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42232923 LIMIT 5 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232923 ORDER BY `minOrder` ASC [ RunTime:0.005336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42232923 ORDER BY `unit` DESC [ RunTime:0.003714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42232923 LIMIT 2 [ RunTime:0.013668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232923 ORDER BY `minOrder` ASC [ RunTime:0.002593s ]
select * from pdf where partno='SMAJ120CAHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CAHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.020013s ]
SELECT `id` FROM `stock` WHERE `id` <> 42232923 AND `partno` = 'SMAJ120CAHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670623 [ RunTime:0.004456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42232922 LIMIT 5 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232922 ORDER BY `minOrder` ASC [ RunTime:0.014772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42232922 ORDER BY `unit` DESC [ RunTime:0.002800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42232922 LIMIT 2 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232922 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='SMAJ120CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.005833s ]
SELECT `id` FROM `stock` WHERE `id` <> 42232922 AND `partno` = 'SMAJ120CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810488 [ RunTime:0.012743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42228946 LIMIT 5 [ RunTime:0.020551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228946 ORDER BY `minOrder` ASC [ RunTime:0.017515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42228946 ORDER BY `unit` DESC [ RunTime:0.017872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42228946 LIMIT 2 [ RunTime:0.007809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228946 ORDER BY `minOrder` ASC [ RunTime:0.007865s ]
select * from pdf where partno='SMAJ120CAHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.021765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CAHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.015810s ]
SELECT `id` FROM `stock` WHERE `id` <> 42228946 AND `partno` = 'SMAJ120CAHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.028492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809840 [ RunTime:0.014156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42228945 LIMIT 5 [ RunTime:0.004800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228945 ORDER BY `minOrder` ASC [ RunTime:0.003134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42228945 ORDER BY `unit` DESC [ RunTime:0.020400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42228945 LIMIT 2 [ RunTime:0.024689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228945 ORDER BY `minOrder` ASC [ RunTime:0.007665s ]
select * from pdf where partno='SMAJ120CAHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CAHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.015166s ]
SELECT `id` FROM `stock` WHERE `id` <> 42228945 AND `partno` = 'SMAJ120CAHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.039592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669512 [ RunTime:0.019471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42214453 LIMIT 5 [ RunTime:0.013395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214453 ORDER BY `minOrder` ASC [ RunTime:0.026305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42214453 ORDER BY `unit` DESC [ RunTime:0.027699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42214453 LIMIT 2 [ RunTime:0.009446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42214453 ORDER BY `minOrder` ASC [ RunTime:0.009625s ]
select * from pdf where partno='SMAJ120CA-M3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.016774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA-M3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.011457s ]
SELECT `id` FROM `stock` WHERE `id` <> 42214453 AND `partno` = 'SMAJ120CA-M3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.024553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809087 [ RunTime:0.031251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42213208 LIMIT 5 [ RunTime:0.012039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42213208 ORDER BY `minOrder` ASC [ RunTime:0.017737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42213208 ORDER BY `unit` DESC [ RunTime:0.014398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42213208 LIMIT 2 [ RunTime:0.013044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42213208 ORDER BY `minOrder` ASC [ RunTime:0.011971s ]
select * from pdf where partno='SMAJ120CAQ-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.010099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CAQ-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.042775s ]
SELECT `id` FROM `stock` WHERE `id` <> 42213208 AND `partno` = 'SMAJ120CAQ-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.055643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912146 [ RunTime:0.032193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42212513 LIMIT 5 [ RunTime:0.023770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212513 ORDER BY `minOrder` ASC [ RunTime:0.016078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42212513 ORDER BY `unit` DESC [ RunTime:0.015943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42212513 LIMIT 2 [ RunTime:0.023033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42212513 ORDER BY `minOrder` ASC [ RunTime:0.012163s ]
select * from pdf where partno='SMAJ120CA-M3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.057847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA-M3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.026134s ]
SELECT `id` FROM `stock` WHERE `id` <> 42212513 AND `partno` = 'SMAJ120CA-M3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.034187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912860 [ RunTime:0.086948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42211580 LIMIT 5 [ RunTime:0.031076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42211580 ORDER BY `minOrder` ASC [ RunTime:0.066346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42211580 ORDER BY `unit` DESC [ RunTime:0.017028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42211580 LIMIT 2 [ RunTime:0.019747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42211580 ORDER BY `minOrder` ASC [ RunTime:0.003757s ]
select * from pdf where partno='SMAJ120CAQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.007795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CAQ-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.020166s ]
SELECT `id` FROM `stock` WHERE `id` <> 42211580 AND `partno` = 'SMAJ120CAQ-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.012919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669393 [ RunTime:0.028415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42210824 LIMIT 5 [ RunTime:0.037419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42210824 ORDER BY `minOrder` ASC [ RunTime:0.017531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42210824 ORDER BY `unit` DESC [ RunTime:0.043922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42210824 LIMIT 2 [ RunTime:0.037918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42210824 ORDER BY `minOrder` ASC [ RunTime:0.047250s ]
select * from pdf where partno='SMAJ120CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.025160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.045641s ]
SELECT `id` FROM `stock` WHERE `id` <> 42210824 AND `partno` = 'SMAJ120CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.034911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808809 [ RunTime:0.017386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42207596 LIMIT 5 [ RunTime:0.018300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207596 ORDER BY `minOrder` ASC [ RunTime:0.041860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42207596 ORDER BY `unit` DESC [ RunTime:0.035475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42207596 LIMIT 2 [ RunTime:0.045625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42207596 ORDER BY `minOrder` ASC [ RunTime:0.063800s ]
select * from pdf where partno='SMAJ120CAHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.015242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CAHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.022767s ]
SELECT `id` FROM `stock` WHERE `id` <> 42207596 AND `partno` = 'SMAJ120CAHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.039480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911187 [ RunTime:0.020288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42205467 LIMIT 5 [ RunTime:0.039828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205467 ORDER BY `minOrder` ASC [ RunTime:0.079193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42205467 ORDER BY `unit` DESC [ RunTime:0.021084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42205467 LIMIT 2 [ RunTime:0.026434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205467 ORDER BY `minOrder` ASC [ RunTime:0.009981s ]
select * from pdf where partno='SMAJ120CA-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ120CA-E3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.013958s ]
SELECT `id` FROM `stock` WHERE `id` <> 42205467 AND `partno` = 'SMAJ120CA-E3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.030349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667999 [ RunTime:0.011154s ]
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 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065389s ]
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 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024115s ]
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 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027108s ]
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 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042642s ]
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 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052658s ]
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 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032224s ]
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 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022606s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ120C%' OR `brand` LIKE 'SMAJ120C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023361s ]