SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002859s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=esp32-s2&search=1' [ RunTime:0.004265s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002426s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000664s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002130s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.000383s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002352s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003057s ]
SELECT * FROM `stock_search` WHERE `partno` = 'esp32-s2' LIMIT 1 [ RunTime:0.003349s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-07-24 02:08:57' WHERE `partno` = 'esp32-s2' [ RunTime:0.002353s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002307s ]
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 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027456s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975572 LIMIT 5 [ RunTime:0.011603s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.023639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975572 ORDER BY `minOrder` ASC [ RunTime:0.024526s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11975572 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11975572 LIMIT 2 [ RunTime:0.031083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975572 ORDER BY `minOrder` ASC [ RunTime:0.008578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13245661 LIMIT 5 [ RunTime:0.015372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13245661 ORDER BY `minOrder` ASC [ RunTime:0.022351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13245661 ORDER BY `unit` DESC [ RunTime:0.018646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13245661 LIMIT 2 [ RunTime:0.023964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13245661 ORDER BY `minOrder` ASC [ RunTime:0.003865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13245664 LIMIT 5 [ RunTime:0.001403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13245664 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13245664 ORDER BY `unit` DESC [ RunTime:0.025126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13245664 LIMIT 2 [ RunTime:0.005503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13245664 ORDER BY `minOrder` ASC [ RunTime:0.006930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13244178 LIMIT 5 [ RunTime:0.012538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13244178 ORDER BY `minOrder` ASC [ RunTime:0.013832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13244178 ORDER BY `unit` DESC [ RunTime:0.014602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13244178 LIMIT 2 [ RunTime:0.033237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13244178 ORDER BY `minOrder` ASC [ RunTime:0.005286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11973504 LIMIT 5 [ RunTime:0.007606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11973504 ORDER BY `minOrder` ASC [ RunTime:0.021556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11973504 ORDER BY `unit` DESC [ RunTime:0.047680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11973504 LIMIT 2 [ RunTime:0.013434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11973504 ORDER BY `minOrder` ASC [ RunTime:0.018403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13244175 LIMIT 5 [ RunTime:0.015502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13244175 ORDER BY `minOrder` ASC [ RunTime:0.010123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13244175 ORDER BY `unit` DESC [ RunTime:0.026677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13244175 LIMIT 2 [ RunTime:0.006307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13244175 ORDER BY `minOrder` ASC [ RunTime:0.023937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975582 LIMIT 5 [ RunTime:0.024781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975582 ORDER BY `minOrder` ASC [ RunTime:0.015909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11975582 ORDER BY `unit` DESC [ RunTime:0.026372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11975582 LIMIT 2 [ RunTime:0.010530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975582 ORDER BY `minOrder` ASC [ RunTime:0.004735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11973865 LIMIT 5 [ RunTime:0.010637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11973865 ORDER BY `minOrder` ASC [ RunTime:0.022446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11973865 ORDER BY `unit` DESC [ RunTime:0.026412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11973865 LIMIT 2 [ RunTime:0.032123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11973865 ORDER BY `minOrder` ASC [ RunTime:0.005101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975583 LIMIT 5 [ RunTime:0.008970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975583 ORDER BY `minOrder` ASC [ RunTime:0.004567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11975583 ORDER BY `unit` DESC [ RunTime:0.011079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11975583 LIMIT 2 [ RunTime:0.005703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975583 ORDER BY `minOrder` ASC [ RunTime:0.006585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13244177 LIMIT 5 [ RunTime:0.018146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13244177 ORDER BY `minOrder` ASC [ RunTime:0.045142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13244177 ORDER BY `unit` DESC [ RunTime:0.007301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13244177 LIMIT 2 [ RunTime:0.030971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13244177 ORDER BY `minOrder` ASC [ RunTime:0.007261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11973652 LIMIT 5 [ RunTime:0.011259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11973652 ORDER BY `minOrder` ASC [ RunTime:0.037284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11973652 ORDER BY `unit` DESC [ RunTime:0.022182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11973652 LIMIT 2 [ RunTime:0.009860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11973652 ORDER BY `minOrder` ASC [ RunTime:0.012070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975584 LIMIT 5 [ RunTime:0.013201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975584 ORDER BY `minOrder` ASC [ RunTime:0.023297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11975584 ORDER BY `unit` DESC [ RunTime:0.030268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11975584 LIMIT 2 [ RunTime:0.013062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975584 ORDER BY `minOrder` ASC [ RunTime:0.019702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11973653 LIMIT 5 [ RunTime:0.008106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11973653 ORDER BY `minOrder` ASC [ RunTime:0.034394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11973653 ORDER BY `unit` DESC [ RunTime:0.005591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11973653 LIMIT 2 [ RunTime:0.027415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11973653 ORDER BY `minOrder` ASC [ RunTime:0.013232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975585 LIMIT 5 [ RunTime:0.010933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975585 ORDER BY `minOrder` ASC [ RunTime:0.016304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11975585 ORDER BY `unit` DESC [ RunTime:0.037714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11975585 LIMIT 2 [ RunTime:0.028955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11975585 ORDER BY `minOrder` ASC [ RunTime:0.013445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13245662 LIMIT 5 [ RunTime:0.036113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13245662 ORDER BY `minOrder` ASC [ RunTime:0.044916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13245662 ORDER BY `unit` DESC [ RunTime:0.022383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13245662 LIMIT 2 [ RunTime:0.013693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13245662 ORDER BY `minOrder` ASC [ RunTime:0.001105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12406285 LIMIT 5 [ RunTime:0.009433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406285 ORDER BY `minOrder` ASC [ RunTime:0.021013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12406285 ORDER BY `unit` DESC [ RunTime:0.015902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12406285 LIMIT 2 [ RunTime:0.007492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12406285 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11343754 LIMIT 5 [ RunTime:0.013780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343754 ORDER BY `minOrder` ASC [ RunTime:0.002094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11343754 ORDER BY `unit` DESC [ RunTime:0.012952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11343754 LIMIT 2 [ RunTime:0.023726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343754 ORDER BY `minOrder` ASC [ RunTime:0.001878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11343752 LIMIT 5 [ RunTime:0.010874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343752 ORDER BY `minOrder` ASC [ RunTime:0.017226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11343752 ORDER BY `unit` DESC [ RunTime:0.011057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11343752 LIMIT 2 [ RunTime:0.016592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343752 ORDER BY `minOrder` ASC [ RunTime:0.015815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11345658 LIMIT 5 [ RunTime:0.007712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11345658 ORDER BY `minOrder` ASC [ RunTime:0.007695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11345658 ORDER BY `unit` DESC [ RunTime:0.010978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11345658 LIMIT 2 [ RunTime:0.008187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11345658 ORDER BY `minOrder` ASC [ RunTime:0.002840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11343753 LIMIT 5 [ RunTime:0.008593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343753 ORDER BY `minOrder` ASC [ RunTime:0.021352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11343753 ORDER BY `unit` DESC [ RunTime:0.018565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11343753 LIMIT 2 [ RunTime:0.007880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11343753 ORDER BY `minOrder` ASC [ RunTime:0.005990s ]
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 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32303941 LIMIT 5 [ RunTime:0.018312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32303941 ORDER BY `minOrder` ASC [ RunTime:0.026753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32303941 ORDER BY `unit` DESC [ RunTime:0.060790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32303941 LIMIT 2 [ RunTime:0.015953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32303941 ORDER BY `minOrder` ASC [ RunTime:0.005356s ]
select * from pdf where partno='esp32-s2-mini-2u-n4' and brandshort='espressif systems' limit 1 [ RunTime:0.032837s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2-mini-2u-n4' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.017930s ]
SELECT `id` FROM `stock` WHERE `id` <> 32303941 AND `partno` = 'esp32-s2-mini-2u-n4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.011880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32297144 [ RunTime:0.019136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606517 [ RunTime:0.010653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409088 [ RunTime:0.011332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32297144 LIMIT 5 [ RunTime:0.006517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32297144 ORDER BY `minOrder` ASC [ RunTime:0.011013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32297144 ORDER BY `unit` DESC [ RunTime:0.012815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32297144 LIMIT 2 [ RunTime:0.010872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32297144 ORDER BY `minOrder` ASC [ RunTime:0.002665s ]
select * from pdf where partno='esp32-s2-mini-2u-n4' and brandshort='espressif systems' limit 1 [ RunTime:0.012740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2-mini-2u-n4' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.002164s ]
SELECT `id` FROM `stock` WHERE `id` <> 32297144 AND `partno` = 'esp32-s2-mini-2u-n4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.008038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32303941 [ RunTime:0.014969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606517 [ RunTime:0.003914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409088 [ RunTime:0.005656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51039516 LIMIT 5 [ RunTime:0.005759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51039516 ORDER BY `minOrder` ASC [ RunTime:0.008085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51039516 ORDER BY `unit` DESC [ RunTime:0.006139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51039516 LIMIT 2 [ RunTime:0.018755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51039516 ORDER BY `minOrder` ASC [ RunTime:0.001970s ]
select * from pdf where partno='esp32-s2fn4r2' and brandshort='espressif systems' limit 1 [ RunTime:0.003713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2fn4r2' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.014467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32297837 LIMIT 5 [ RunTime:0.024484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32297837 ORDER BY `minOrder` ASC [ RunTime:0.014603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32297837 ORDER BY `unit` DESC [ RunTime:0.020917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32297837 LIMIT 2 [ RunTime:0.015243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32297837 ORDER BY `minOrder` ASC [ RunTime:0.007632s ]
select * from pdf where partno='esp32-s2-mini-2-n4' and brandshort='espressif systems' limit 1 [ RunTime:0.004756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2-mini-2-n4' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.005490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51039330 LIMIT 5 [ RunTime:0.011828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51039330 ORDER BY `minOrder` ASC [ RunTime:0.007497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51039330 ORDER BY `unit` DESC [ RunTime:0.010730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51039330 LIMIT 2 [ RunTime:0.020508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51039330 ORDER BY `minOrder` ASC [ RunTime:0.005625s ]
select * from pdf where partno='esp32-s2fh2' and brandshort='espressif systems' limit 1 [ RunTime:0.003492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2fh2' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.003489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32297921 LIMIT 5 [ RunTime:0.002844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32297921 ORDER BY `minOrder` ASC [ RunTime:0.006020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32297921 ORDER BY `unit` DESC [ RunTime:0.018017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32297921 LIMIT 2 [ RunTime:0.022231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32297921 ORDER BY `minOrder` ASC [ RunTime:0.005312s ]
select * from pdf where partno='esp32-s2-mini-2-n4r2' and brandshort='espressif systems' limit 1 [ RunTime:0.015174s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2-mini-2-n4r2' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.012779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51044821 LIMIT 5 [ RunTime:0.013086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51044821 ORDER BY `minOrder` ASC [ RunTime:0.004507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51044821 ORDER BY `unit` DESC [ RunTime:0.004459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51044821 LIMIT 2 [ RunTime:0.008860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51044821 ORDER BY `minOrder` ASC [ RunTime:0.008639s ]
select * from pdf where partno='esp32-s2' and brandshort='espressif systems' limit 1 [ RunTime:0.002750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.002799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51039050 LIMIT 5 [ RunTime:0.007526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51039050 ORDER BY `minOrder` ASC [ RunTime:0.019106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51039050 ORDER BY `unit` DESC [ RunTime:0.034276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51039050 LIMIT 2 [ RunTime:0.007490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51039050 ORDER BY `minOrder` ASC [ RunTime:0.007919s ]
select * from pdf where partno='esp32-s2' and brandshort='espressif systems' limit 1 [ RunTime:0.000611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.009471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32297922 LIMIT 5 [ RunTime:0.016561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32297922 ORDER BY `minOrder` ASC [ RunTime:0.010566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32297922 ORDER BY `unit` DESC [ RunTime:0.012800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32297922 LIMIT 2 [ RunTime:0.010567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32297922 ORDER BY `minOrder` ASC [ RunTime:0.000897s ]
select * from pdf where partno='esp32-s2-solo-2-n4r2' and brandshort='espressif systems' limit 1 [ RunTime:0.013155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2-solo-2-n4r2' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.009833s ]
SELECT `id` FROM `stock` WHERE `id` <> 32297922 AND `partno` = 'esp32-s2-solo-2-n4r2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.006551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975584 [ RunTime:0.015012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32298057 LIMIT 5 [ RunTime:0.008154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32298057 ORDER BY `minOrder` ASC [ RunTime:0.002473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32298057 ORDER BY `unit` DESC [ RunTime:0.009342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32298057 LIMIT 2 [ RunTime:0.022995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32298057 ORDER BY `minOrder` ASC [ RunTime:0.009978s ]
select * from pdf where partno='esp32-s2-solo-2-n4' and brandshort='espressif systems' limit 1 [ RunTime:0.010769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2-solo-2-n4' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.014284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51039425 LIMIT 5 [ RunTime:0.002571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51039425 ORDER BY `minOrder` ASC [ RunTime:0.011402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51039425 ORDER BY `unit` DESC [ RunTime:0.004301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51039425 LIMIT 2 [ RunTime:0.003672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51039425 ORDER BY `minOrder` ASC [ RunTime:0.005968s ]
select * from pdf where partno='esp32-s2fh4' and brandshort='espressif systems' limit 1 [ RunTime:0.014279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'esp32-s2fh4' OR `brand` LIKE 'espressif systems%' ) ) LIMIT 1 [ RunTime:0.004314s ]
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 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606519 LIMIT 5 [ RunTime:0.008422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606519 ORDER BY `minOrder` ASC [ RunTime:0.016759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37606519 ORDER BY `unit` DESC [ RunTime:0.008159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37606519 LIMIT 2 [ RunTime:0.005824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606519 ORDER BY `minOrder` ASC [ RunTime:0.008113s ]
select * from pdf where partno='ESP32-S2-SOLO-2U-N4' and brandshort='Espressif Systems' limit 1 [ RunTime:0.010215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-SOLO-2U-N4' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.008992s ]
SELECT `id` FROM `stock` WHERE `id` <> 37606519 AND `partno` = 'ESP32-S2-SOLO-2U-N4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.009610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13245664 [ RunTime:0.013813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409399 LIMIT 5 [ RunTime:0.016840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409399 ORDER BY `minOrder` ASC [ RunTime:0.018763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50409399 ORDER BY `unit` DESC [ RunTime:0.023545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50409399 LIMIT 2 [ RunTime:0.023692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409399 ORDER BY `minOrder` ASC [ RunTime:0.018333s ]
select * from pdf where partno='ESP32-S2R2' and brandshort='Espressif Systems' limit 1 [ RunTime:0.014286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2R2' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.029738s ]
SELECT `id` FROM `stock` WHERE `id` <> 50409399 AND `partno` = 'ESP32-S2R2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.039688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975572 [ RunTime:0.030390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606818 LIMIT 5 [ RunTime:0.021658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606818 ORDER BY `minOrder` ASC [ RunTime:0.033842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37606818 ORDER BY `unit` DESC [ RunTime:0.025533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37606818 LIMIT 2 [ RunTime:0.047584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606818 ORDER BY `minOrder` ASC [ RunTime:0.013847s ]
select * from pdf where partno='ESP32-S2R2' and brandshort='Espressif Systems' limit 1 [ RunTime:0.016890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2R2' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.010954s ]
SELECT `id` FROM `stock` WHERE `id` <> 37606818 AND `partno` = 'ESP32-S2R2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.030298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975572 [ RunTime:0.020795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606817 LIMIT 5 [ RunTime:0.032242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606817 ORDER BY `minOrder` ASC [ RunTime:0.038523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37606817 ORDER BY `unit` DESC [ RunTime:0.094567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37606817 LIMIT 2 [ RunTime:0.041196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606817 ORDER BY `minOrder` ASC [ RunTime:0.009905s ]
select * from pdf where partno='ESP32-S2' and brandshort='Espressif Systems' limit 1 [ RunTime:0.029444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.013639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409072 LIMIT 5 [ RunTime:0.035516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409072 ORDER BY `minOrder` ASC [ RunTime:0.021235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50409072 ORDER BY `unit` DESC [ RunTime:0.051815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50409072 LIMIT 2 [ RunTime:0.044451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409072 ORDER BY `minOrder` ASC [ RunTime:0.006909s ]
select * from pdf where partno='ESP32-S2' and brandshort='Espressif Systems' limit 1 [ RunTime:0.023996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.002312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50408781 LIMIT 5 [ RunTime:0.028407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50408781 ORDER BY `minOrder` ASC [ RunTime:0.039140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50408781 ORDER BY `unit` DESC [ RunTime:0.034853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50408781 LIMIT 2 [ RunTime:0.019367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50408781 ORDER BY `minOrder` ASC [ RunTime:0.022792s ]
select * from pdf where partno='ESP32-S2-MINI-2-N4R2' and brandshort='Espressif Systems' limit 1 [ RunTime:0.009493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-MINI-2-N4R2' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.020707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606202 LIMIT 5 [ RunTime:0.007386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606202 ORDER BY `minOrder` ASC [ RunTime:0.021897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37606202 ORDER BY `unit` DESC [ RunTime:0.016667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37606202 LIMIT 2 [ RunTime:0.005251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606202 ORDER BY `minOrder` ASC [ RunTime:0.004624s ]
select * from pdf where partno='ESP32-S2-MINI-2-N4R2' and brandshort='Espressif Systems' limit 1 [ RunTime:0.008701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-MINI-2-N4R2' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606520 LIMIT 5 [ RunTime:0.010800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606520 ORDER BY `minOrder` ASC [ RunTime:0.023614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37606520 ORDER BY `unit` DESC [ RunTime:0.009194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37606520 LIMIT 2 [ RunTime:0.011033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606520 ORDER BY `minOrder` ASC [ RunTime:0.019206s ]
select * from pdf where partno='ESP32-S2-MINI-2U-N4R2' and brandshort='Espressif Systems' limit 1 [ RunTime:0.015497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-MINI-2U-N4R2' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.009766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409090 LIMIT 5 [ RunTime:0.017106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409090 ORDER BY `minOrder` ASC [ RunTime:0.021908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50409090 ORDER BY `unit` DESC [ RunTime:0.012244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50409090 LIMIT 2 [ RunTime:0.022441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409090 ORDER BY `minOrder` ASC [ RunTime:0.002099s ]
select * from pdf where partno='ESP32-S2-MINI-2U-N4R2' and brandshort='Espressif Systems' limit 1 [ RunTime:0.001769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-MINI-2U-N4R2' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.013957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37607273 LIMIT 5 [ RunTime:0.004903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37607273 ORDER BY `minOrder` ASC [ RunTime:0.010805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37607273 ORDER BY `unit` DESC [ RunTime:0.025371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37607273 LIMIT 2 [ RunTime:0.008288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37607273 ORDER BY `minOrder` ASC [ RunTime:0.007248s ]
select * from pdf where partno='ESP32-S2-MINI-1U-N4' and brandshort='Espressif Systems' limit 1 [ RunTime:0.008647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-MINI-1U-N4' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.008235s ]
SELECT `id` FROM `stock` WHERE `id` <> 37607273 AND `partno` = 'ESP32-S2-MINI-1U-N4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.013424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13244175 [ RunTime:0.012612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409846 LIMIT 5 [ RunTime:0.013768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409846 ORDER BY `minOrder` ASC [ RunTime:0.018403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50409846 ORDER BY `unit` DESC [ RunTime:0.004341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50409846 LIMIT 2 [ RunTime:0.004251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409846 ORDER BY `minOrder` ASC [ RunTime:0.007451s ]
select * from pdf where partno='ESP32-S2-MINI-1U-N4' and brandshort='Espressif Systems' limit 1 [ RunTime:0.012593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-MINI-1U-N4' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.005692s ]
SELECT `id` FROM `stock` WHERE `id` <> 50409846 AND `partno` = 'ESP32-S2-MINI-1U-N4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.005711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13244175 [ RunTime:0.003388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606515 LIMIT 5 [ RunTime:0.009271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606515 ORDER BY `minOrder` ASC [ RunTime:0.007571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37606515 ORDER BY `unit` DESC [ RunTime:0.006875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37606515 LIMIT 2 [ RunTime:0.004111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606515 ORDER BY `minOrder` ASC [ RunTime:0.002110s ]
select * from pdf where partno='ESP32-S2-MINI-2-N4' and brandshort='Espressif Systems' limit 1 [ RunTime:0.005592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-MINI-2-N4' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.006849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409847 LIMIT 5 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409847 ORDER BY `minOrder` ASC [ RunTime:0.004973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50409847 ORDER BY `unit` DESC [ RunTime:0.002969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50409847 LIMIT 2 [ RunTime:0.017233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409847 ORDER BY `minOrder` ASC [ RunTime:0.008290s ]
select * from pdf where partno='ESP32-S2-SOLO-U-N4' and brandshort='Espressif Systems' limit 1 [ RunTime:0.023087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-SOLO-U-N4' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.008253s ]
SELECT `id` FROM `stock` WHERE `id` <> 50409847 AND `partno` = 'ESP32-S2-SOLO-U-N4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.010977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11973653 [ RunTime:0.035345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37607274 LIMIT 5 [ RunTime:0.005378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37607274 ORDER BY `minOrder` ASC [ RunTime:0.013993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37607274 ORDER BY `unit` DESC [ RunTime:0.005252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37607274 LIMIT 2 [ RunTime:0.009997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37607274 ORDER BY `minOrder` ASC [ RunTime:0.002705s ]
select * from pdf where partno='ESP32-S2-SOLO-U-N4' and brandshort='Espressif Systems' limit 1 [ RunTime:0.001217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-SOLO-U-N4' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.000475s ]
SELECT `id` FROM `stock` WHERE `id` <> 37607274 AND `partno` = 'ESP32-S2-SOLO-U-N4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.008429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11973653 [ RunTime:0.006345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409085 LIMIT 5 [ RunTime:0.023439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409085 ORDER BY `minOrder` ASC [ RunTime:0.017500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50409085 ORDER BY `unit` DESC [ RunTime:0.050759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50409085 LIMIT 2 [ RunTime:0.037581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409085 ORDER BY `minOrder` ASC [ RunTime:0.067834s ]
select * from pdf where partno='ESP32-S2-MINI-2-N4' and brandshort='Espressif Systems' limit 1 [ RunTime:0.051015s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-MINI-2-N4' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.051392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606504 LIMIT 5 [ RunTime:0.051569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606504 ORDER BY `minOrder` ASC [ RunTime:0.051396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37606504 ORDER BY `unit` DESC [ RunTime:0.100579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37606504 LIMIT 2 [ RunTime:0.082308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606504 ORDER BY `minOrder` ASC [ RunTime:0.025961s ]
select * from pdf where partno='ESP32-S2FH4' and brandshort='Espressif Systems' limit 1 [ RunTime:0.034442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2FH4' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.043434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409848 LIMIT 5 [ RunTime:0.148454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409848 ORDER BY `minOrder` ASC [ RunTime:0.058278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50409848 ORDER BY `unit` DESC [ RunTime:0.032854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50409848 LIMIT 2 [ RunTime:0.049809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409848 ORDER BY `minOrder` ASC [ RunTime:0.035326s ]
select * from pdf where partno='ESP32-S2-SOLO-N4' and brandshort='Espressif Systems' limit 1 [ RunTime:0.007402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-SOLO-N4' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.013922s ]
SELECT `id` FROM `stock` WHERE `id` <> 50409848 AND `partno` = 'ESP32-S2-SOLO-N4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.006525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13244177 [ RunTime:0.015924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37607275 LIMIT 5 [ RunTime:0.000918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37607275 ORDER BY `minOrder` ASC [ RunTime:0.005435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37607275 ORDER BY `unit` DESC [ RunTime:0.012146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37607275 LIMIT 2 [ RunTime:0.020429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37607275 ORDER BY `minOrder` ASC [ RunTime:0.006142s ]
select * from pdf where partno='ESP32-S2-SOLO-N4' and brandshort='Espressif Systems' limit 1 [ RunTime:0.002679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-SOLO-N4' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.000533s ]
SELECT `id` FROM `stock` WHERE `id` <> 37607275 AND `partno` = 'ESP32-S2-SOLO-N4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.006474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13244177 [ RunTime:0.001028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37606522 LIMIT 5 [ RunTime:0.003670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606522 ORDER BY `minOrder` ASC [ RunTime:0.003183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37606522 ORDER BY `unit` DESC [ RunTime:0.000679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37606522 LIMIT 2 [ RunTime:0.010131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37606522 ORDER BY `minOrder` ASC [ RunTime:0.007085s ]
select * from pdf where partno='ESP32-S2-SOLO-2U-N4R2' and brandshort='Espressif Systems' limit 1 [ RunTime:0.012924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-SOLO-2U-N4R2' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.009324s ]
SELECT `id` FROM `stock` WHERE `id` <> 37606522 AND `partno` = 'ESP32-S2-SOLO-2U-N4R2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.014785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975585 [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50409092 LIMIT 5 [ RunTime:0.001133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409092 ORDER BY `minOrder` ASC [ RunTime:0.005232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50409092 ORDER BY `unit` DESC [ RunTime:0.009469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50409092 LIMIT 2 [ RunTime:0.009293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50409092 ORDER BY `minOrder` ASC [ RunTime:0.003031s ]
select * from pdf where partno='ESP32-S2-SOLO-2U-N4R2' and brandshort='Espressif Systems' limit 1 [ RunTime:0.000587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESP32-S2-SOLO-2U-N4R2' OR `brand` LIKE 'Espressif Systems%' ) ) LIMIT 1 [ RunTime:0.000449s ]
SELECT `id` FROM `stock` WHERE `id` <> 50409092 AND `partno` = 'ESP32-S2-SOLO-2U-N4R2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%espressif systems%' ) [ RunTime:0.000902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11975585 [ RunTime:0.000384s ]
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 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011724s ]
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 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006030s ]
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 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015918s ]
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 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010789s ]
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 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002351s ]
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 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002427s ]
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 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001114s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'esp32-s2%' OR `brand` LIKE 'esp32-s2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001439s ]