SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002642s ]
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=1.5SMC30A&search=1' [ RunTime:0.003158s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002464s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000709s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002395s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000374s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002119s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007070s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002086s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5SMC30A' LIMIT 1 [ RunTime:0.013381s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-18 04:49:04' WHERE `partno` = '1.5SMC30A' [ RunTime:0.005713s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002547s ]
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 '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044082s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678853 LIMIT 5 [ RunTime:0.016850s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678853 ORDER BY `minOrder` ASC [ RunTime:0.013646s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678853 ORDER BY `unit` DESC [ RunTime:0.014882s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678853 LIMIT 2 [ RunTime:0.029384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678853 ORDER BY `minOrder` ASC [ RunTime:0.008404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13933043 LIMIT 5 [ RunTime:0.081374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13933043 ORDER BY `minOrder` ASC [ RunTime:0.024633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13933043 ORDER BY `unit` DESC [ RunTime:0.030043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13933043 LIMIT 2 [ RunTime:0.035013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13933043 ORDER BY `minOrder` ASC [ RunTime:0.037298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910641 LIMIT 5 [ RunTime:0.021985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910641 ORDER BY `minOrder` ASC [ RunTime:0.007860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910641 ORDER BY `unit` DESC [ RunTime:0.006571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910641 LIMIT 2 [ RunTime:0.036506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910641 ORDER BY `minOrder` ASC [ RunTime:0.013244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910344 LIMIT 5 [ RunTime:0.019992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910344 ORDER BY `minOrder` ASC [ RunTime:0.047648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910344 ORDER BY `unit` DESC [ RunTime:0.056205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910344 LIMIT 2 [ RunTime:0.042809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910344 ORDER BY `minOrder` ASC [ RunTime:0.033362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661776 LIMIT 5 [ RunTime:0.041329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661776 ORDER BY `minOrder` ASC [ RunTime:0.016431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661776 ORDER BY `unit` DESC [ RunTime:0.021754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661776 LIMIT 2 [ RunTime:0.021526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661776 ORDER BY `minOrder` ASC [ RunTime:0.010330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908249 LIMIT 5 [ RunTime:0.038588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908249 ORDER BY `minOrder` ASC [ RunTime:0.038044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908249 ORDER BY `unit` DESC [ RunTime:0.021581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908249 LIMIT 2 [ RunTime:0.009992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908249 ORDER BY `minOrder` ASC [ RunTime:0.006400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908152 LIMIT 5 [ RunTime:0.014950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908152 ORDER BY `minOrder` ASC [ RunTime:0.004685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908152 ORDER BY `unit` DESC [ RunTime:0.036968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908152 LIMIT 2 [ RunTime:0.005911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908152 ORDER BY `minOrder` ASC [ RunTime:0.007748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907861 LIMIT 5 [ RunTime:0.012765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907861 ORDER BY `minOrder` ASC [ RunTime:0.055358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907861 ORDER BY `unit` DESC [ RunTime:0.014032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907861 LIMIT 2 [ RunTime:0.010016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907861 ORDER BY `minOrder` ASC [ RunTime:0.003458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691690 LIMIT 5 [ RunTime:0.001277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691690 ORDER BY `minOrder` ASC [ RunTime:0.003634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691690 ORDER BY `unit` DESC [ RunTime:0.002023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691690 LIMIT 2 [ RunTime:0.008747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691690 ORDER BY `minOrder` ASC [ RunTime:0.012675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691506 LIMIT 5 [ RunTime:0.002646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691506 ORDER BY `minOrder` ASC [ RunTime:0.002877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691506 ORDER BY `unit` DESC [ RunTime:0.000909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691506 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691506 ORDER BY `minOrder` ASC [ RunTime:0.001859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688547 LIMIT 5 [ RunTime:0.006311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688547 ORDER BY `minOrder` ASC [ RunTime:0.013844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688547 ORDER BY `unit` DESC [ RunTime:0.001139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688547 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688547 ORDER BY `minOrder` ASC [ RunTime:0.015541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679033 LIMIT 5 [ RunTime:0.002009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679033 ORDER BY `minOrder` ASC [ RunTime:0.008734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679033 ORDER BY `unit` DESC [ RunTime:0.029580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679033 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679033 ORDER BY `minOrder` ASC [ RunTime:0.002396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16677892 LIMIT 5 [ RunTime:0.007858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677892 ORDER BY `minOrder` ASC [ RunTime:0.003530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16677892 ORDER BY `unit` DESC [ RunTime:0.009580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16677892 LIMIT 2 [ RunTime:0.021113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16677892 ORDER BY `minOrder` ASC [ RunTime:0.013589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674972 LIMIT 5 [ RunTime:0.011937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674972 ORDER BY `minOrder` ASC [ RunTime:0.022063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674972 ORDER BY `unit` DESC [ RunTime:0.015959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674972 LIMIT 2 [ RunTime:0.010021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674972 ORDER BY `minOrder` ASC [ RunTime:0.013976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674616 LIMIT 5 [ RunTime:0.009136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674616 ORDER BY `minOrder` ASC [ RunTime:0.001559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674616 ORDER BY `unit` DESC [ RunTime:0.002803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674616 LIMIT 2 [ RunTime:0.018607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674616 ORDER BY `minOrder` ASC [ RunTime:0.007832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673690 LIMIT 5 [ RunTime:0.012383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673690 ORDER BY `minOrder` ASC [ RunTime:0.002908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673690 ORDER BY `unit` DESC [ RunTime:0.017735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673690 LIMIT 2 [ RunTime:0.024538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673690 ORDER BY `minOrder` ASC [ RunTime:0.010527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670249 LIMIT 5 [ RunTime:0.014412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670249 ORDER BY `minOrder` ASC [ RunTime:0.014770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670249 ORDER BY `unit` DESC [ RunTime:0.007618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670249 LIMIT 2 [ RunTime:0.005588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670249 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829505 LIMIT 5 [ RunTime:0.007467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829505 ORDER BY `minOrder` ASC [ RunTime:0.000718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829505 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829505 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829505 ORDER BY `minOrder` ASC [ RunTime:0.002444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827332 LIMIT 5 [ RunTime:0.001263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827332 ORDER BY `minOrder` ASC [ RunTime:0.007467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827332 ORDER BY `unit` DESC [ RunTime:0.001627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827332 LIMIT 2 [ RunTime:0.001202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827332 ORDER BY `minOrder` ASC [ RunTime:0.006178s ]
select * from pdf where partno='1.5SMC30AT3' and brandshort='onsemi' limit 1 [ RunTime:0.002612s ]
select foldpath,foldpath2,filename from pdf_file where id=310499 limit 1 [ RunTime:0.005283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815771 LIMIT 5 [ RunTime:0.003861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815771 ORDER BY `minOrder` ASC [ RunTime:0.007011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815771 ORDER BY `unit` DESC [ RunTime:0.002089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815771 LIMIT 2 [ RunTime:0.003592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815771 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
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 '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140915 LIMIT 5 [ RunTime:0.008001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140915 ORDER BY `minOrder` ASC [ RunTime:0.003322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140915 ORDER BY `unit` DESC [ RunTime:0.000551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140915 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140915 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='1.5smc30ahm3_a/i' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.001198s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5smc30ahm3_a/i' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.002717s ]
SELECT `id` FROM `stock` WHERE `id` <> 51140915 AND `partno` = '1.5smc30ahm3_a/i' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.001553s ]
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 '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117021 LIMIT 5 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117021 ORDER BY `minOrder` ASC [ RunTime:0.011268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117021 ORDER BY `unit` DESC [ RunTime:0.013015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117021 LIMIT 2 [ RunTime:0.025844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117021 ORDER BY `minOrder` ASC [ RunTime:0.002433s ]
select * from pdf where partno='1.5SMC30A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000851s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117021 AND `partno` = '1.5SMC30A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.018148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678853 [ RunTime:0.008484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42132707 LIMIT 5 [ RunTime:0.004923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132707 ORDER BY `minOrder` ASC [ RunTime:0.002821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42132707 ORDER BY `unit` DESC [ RunTime:0.003100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42132707 LIMIT 2 [ RunTime:0.002471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42132707 ORDER BY `minOrder` ASC [ RunTime:0.003520s ]
select * from pdf where partno='1.5SMC30A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002632s ]
SELECT `id` FROM `stock` WHERE `id` <> 42132707 AND `partno` = '1.5SMC30A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13933043 [ RunTime:0.000577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143519 LIMIT 5 [ RunTime:0.001984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143519 ORDER BY `minOrder` ASC [ RunTime:0.004189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143519 ORDER BY `unit` DESC [ RunTime:0.005897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143519 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143519 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='1.5SMC30AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002481s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143519 AND `partno` = '1.5SMC30AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.009610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661776 [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142929 LIMIT 5 [ RunTime:0.012500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142929 ORDER BY `minOrder` ASC [ RunTime:0.006554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142929 ORDER BY `unit` DESC [ RunTime:0.005650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142929 LIMIT 2 [ RunTime:0.003749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142929 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
select * from pdf where partno='1.5SMC30A-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.009723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.011267s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142929 AND `partno` = '1.5SMC30A-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.011006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909121 [ RunTime:0.012304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105225 LIMIT 5 [ RunTime:0.004284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105225 ORDER BY `minOrder` ASC [ RunTime:0.002544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105225 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105225 LIMIT 2 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105225 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='1.5SMC30A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.006039s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105225 AND `partno` = '1.5SMC30A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.003746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910641 [ RunTime:0.015235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42117907 LIMIT 5 [ RunTime:0.002185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117907 ORDER BY `minOrder` ASC [ RunTime:0.003002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42117907 ORDER BY `unit` DESC [ RunTime:0.003714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42117907 LIMIT 2 [ RunTime:0.005552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42117907 ORDER BY `minOrder` ASC [ RunTime:0.003541s ]
select * from pdf where partno='1.5SMC30A-E3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-E3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003612s ]
SELECT `id` FROM `stock` WHERE `id` <> 42117907 AND `partno` = '1.5SMC30A-E3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910344 [ RunTime:0.000642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174648 LIMIT 5 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174648 ORDER BY `minOrder` ASC [ RunTime:0.001008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174648 ORDER BY `unit` DESC [ RunTime:0.001733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174648 LIMIT 2 [ RunTime:0.006832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174648 ORDER BY `minOrder` ASC [ RunTime:0.003611s ]
select * from pdf where partno='1.5SMC30A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.003274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.005234s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174648 AND `partno` = '1.5SMC30A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908249 [ RunTime:0.000531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42173714 LIMIT 5 [ RunTime:0.002485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173714 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42173714 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42173714 LIMIT 2 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173714 ORDER BY `minOrder` ASC [ RunTime:0.003374s ]
select * from pdf where partno='1.5SMC30AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.015903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000902s ]
SELECT `id` FROM `stock` WHERE `id` <> 42173714 AND `partno` = '1.5SMC30AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.001875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908152 [ RunTime:0.005516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42172109 LIMIT 5 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42172109 ORDER BY `minOrder` ASC [ RunTime:0.005255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42172109 ORDER BY `unit` DESC [ RunTime:0.001880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42172109 LIMIT 2 [ RunTime:0.003049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42172109 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='1.5SMC30A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.003159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42272403 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272403 ORDER BY `minOrder` ASC [ RunTime:0.001000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42272403 ORDER BY `unit` DESC [ RunTime:0.000550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42272403 LIMIT 2 [ RunTime:0.006684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272403 ORDER BY `minOrder` ASC [ RunTime:0.003001s ]
select * from pdf where partno='1.5SMC30AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003804s ]
SELECT `id` FROM `stock` WHERE `id` <> 42272403 AND `partno` = '1.5SMC30AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.004231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815410 [ RunTime:0.001730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267053 LIMIT 5 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267053 ORDER BY `minOrder` ASC [ RunTime:0.001414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267053 ORDER BY `unit` DESC [ RunTime:0.004593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267053 LIMIT 2 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267053 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='1.5SMC30AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003907s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267053 AND `partno` = '1.5SMC30AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674972 [ RunTime:0.004362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42263633 LIMIT 5 [ RunTime:0.001540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263633 ORDER BY `minOrder` ASC [ RunTime:0.004049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42263633 ORDER BY `unit` DESC [ RunTime:0.003408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42263633 LIMIT 2 [ RunTime:0.005600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42263633 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
select * from pdf where partno='1.5SMC30AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003591s ]
SELECT `id` FROM `stock` WHERE `id` <> 42263633 AND `partno` = '1.5SMC30AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815771 [ RunTime:0.003991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262205 LIMIT 5 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262205 ORDER BY `minOrder` ASC [ RunTime:0.004697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262205 ORDER BY `unit` DESC [ RunTime:0.006340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262205 LIMIT 2 [ RunTime:0.002719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262205 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='1.5SMC30A TR13 PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.002018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A TR13 PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.000811s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262205 AND `partno` = '1.5SMC30A TR13 PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.000746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917517 [ RunTime:0.003307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257540 LIMIT 5 [ RunTime:0.002275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257540 ORDER BY `minOrder` ASC [ RunTime:0.012679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257540 ORDER BY `unit` DESC [ RunTime:0.002222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257540 LIMIT 2 [ RunTime:0.008504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257540 ORDER BY `minOrder` ASC [ RunTime:0.003252s ]
select * from pdf where partno='1.5SMC30A-M3/57T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.010846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-M3/57T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.005637s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257540 AND `partno` = '1.5SMC30A-M3/57T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917704 [ RunTime:0.004489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257513 LIMIT 5 [ RunTime:0.001031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257513 ORDER BY `minOrder` ASC [ RunTime:0.000915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257513 ORDER BY `unit` DESC [ RunTime:0.003658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257513 LIMIT 2 [ RunTime:0.007766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257513 ORDER BY `minOrder` ASC [ RunTime:0.002851s ]
select * from pdf where partno='1.5SMC30A-M3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-M3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003054s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257513 AND `partno` = '1.5SMC30A-M3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674616 [ RunTime:0.004293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42257495 LIMIT 5 [ RunTime:0.000932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257495 ORDER BY `minOrder` ASC [ RunTime:0.002678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42257495 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42257495 LIMIT 2 [ RunTime:0.002907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42257495 ORDER BY `minOrder` ASC [ RunTime:0.004205s ]
select * from pdf where partno='1.5SMC30A-AU_R1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.012549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-AU_R1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.003103s ]
SELECT `id` FROM `stock` WHERE `id` <> 42257495 AND `partno` = '1.5SMC30A-AU_R1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.006013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679033 [ RunTime:0.008386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246608 LIMIT 5 [ RunTime:0.003674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246608 ORDER BY `minOrder` ASC [ RunTime:0.001192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246608 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246608 LIMIT 2 [ RunTime:0.001126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246608 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='1.5SMC30A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000412s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246608 AND `partno` = '1.5SMC30A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916637 [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42246139 LIMIT 5 [ RunTime:0.007882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246139 ORDER BY `minOrder` ASC [ RunTime:0.013675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42246139 ORDER BY `unit` DESC [ RunTime:0.006495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42246139 LIMIT 2 [ RunTime:0.001328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42246139 ORDER BY `minOrder` ASC [ RunTime:0.008050s ]
select * from pdf where partno='1.5SMC30AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002896s ]
SELECT `id` FROM `stock` WHERE `id` <> 42246139 AND `partno` = '1.5SMC30AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.005088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673690 [ RunTime:0.002966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245933 LIMIT 5 [ RunTime:0.003394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245933 ORDER BY `minOrder` ASC [ RunTime:0.001981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245933 ORDER BY `unit` DESC [ RunTime:0.013368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245933 LIMIT 2 [ RunTime:0.005455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245933 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='1.5SMC30A-E3/9AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-E3/9AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.006456s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245933 AND `partno` = '1.5SMC30A-E3/9AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.016608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813583 [ RunTime:0.001345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227754 LIMIT 5 [ RunTime:0.007433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227754 ORDER BY `minOrder` ASC [ RunTime:0.001290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227754 ORDER BY `unit` DESC [ RunTime:0.010392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227754 LIMIT 2 [ RunTime:0.004744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227754 ORDER BY `minOrder` ASC [ RunTime:0.000619s ]
select * from pdf where partno='1.5SMC30A-AT/7' and brandshort='YAGEO' limit 1 [ RunTime:0.002279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5SMC30A-AT/7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.005851s ]
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 '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004546s ]
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 '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001234s ]
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 '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002484s ]
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 '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001341s ]
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 '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002935s ]
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 '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004662s ]
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 '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003672s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5SMC30A%' OR `brand` LIKE '1.5SMC30A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003189s ]