SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003076s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=10303&search=1' [ RunTime:0.002041s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001533s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000657s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001285s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.000221s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002299s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001339s ]
SELECT * FROM `stock_search` WHERE `partno` = '10303' LIMIT 1 [ RunTime:0.001022s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 13:50:26' WHERE `partno` = '10303' [ RunTime:0.001731s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001027s ]
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 '10303%' OR `brand` LIKE '10303%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008832s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12225071 LIMIT 5 [ RunTime:0.005049s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12225071 ORDER BY `minOrder` ASC [ RunTime:0.001228s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12225071 ORDER BY `unit` DESC [ RunTime:0.003617s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12225071 LIMIT 2 [ RunTime:0.003847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12225071 ORDER BY `minOrder` ASC [ RunTime:0.001275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335556 LIMIT 5 [ RunTime:0.001262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335556 ORDER BY `minOrder` ASC [ RunTime:0.002594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11335556 ORDER BY `unit` DESC [ RunTime:0.003614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11335556 LIMIT 2 [ RunTime:0.001352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335556 ORDER BY `minOrder` ASC [ RunTime:0.002025s ]
select * from pdf where partno='103030000' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.004571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066958 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066958 ORDER BY `minOrder` ASC [ RunTime:0.006669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066958 ORDER BY `unit` DESC [ RunTime:0.003419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066958 LIMIT 2 [ RunTime:0.009452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066958 ORDER BY `minOrder` ASC [ RunTime:0.002448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335825 LIMIT 5 [ RunTime:0.006260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335825 ORDER BY `minOrder` ASC [ RunTime:0.003324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11335825 ORDER BY `unit` DESC [ RunTime:0.003254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11335825 LIMIT 2 [ RunTime:0.003292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335825 ORDER BY `minOrder` ASC [ RunTime:0.003466s ]
select * from pdf where partno='103030035' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.004505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12393934 LIMIT 5 [ RunTime:0.013388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12393934 ORDER BY `minOrder` ASC [ RunTime:0.000946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12393934 ORDER BY `unit` DESC [ RunTime:0.008264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12393934 LIMIT 2 [ RunTime:0.005509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12393934 ORDER BY `minOrder` ASC [ RunTime:0.005475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391621 LIMIT 5 [ RunTime:0.001960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391621 ORDER BY `minOrder` ASC [ RunTime:0.001179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391621 ORDER BY `unit` DESC [ RunTime:0.002326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391621 LIMIT 2 [ RunTime:0.012253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391621 ORDER BY `minOrder` ASC [ RunTime:0.004898s ]
select * from pdf where partno='103030215' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.019988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265532 LIMIT 5 [ RunTime:0.008472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265532 ORDER BY `minOrder` ASC [ RunTime:0.007509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265532 ORDER BY `unit` DESC [ RunTime:0.015254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265532 LIMIT 2 [ RunTime:0.006939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265532 ORDER BY `minOrder` ASC [ RunTime:0.008803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335823 LIMIT 5 [ RunTime:0.006311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335823 ORDER BY `minOrder` ASC [ RunTime:0.009197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11335823 ORDER BY `unit` DESC [ RunTime:0.020794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11335823 LIMIT 2 [ RunTime:0.017023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335823 ORDER BY `minOrder` ASC [ RunTime:0.008620s ]
select * from pdf where partno='103030276' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.005051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562483 LIMIT 5 [ RunTime:0.020186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562483 ORDER BY `minOrder` ASC [ RunTime:0.024994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562483 ORDER BY `unit` DESC [ RunTime:0.024419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562483 LIMIT 2 [ RunTime:0.018988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562483 ORDER BY `minOrder` ASC [ RunTime:0.003234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12395154 LIMIT 5 [ RunTime:0.030160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12395154 ORDER BY `minOrder` ASC [ RunTime:0.004557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12395154 ORDER BY `unit` DESC [ RunTime:0.003167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12395154 LIMIT 2 [ RunTime:0.021522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12395154 ORDER BY `minOrder` ASC [ RunTime:0.003651s ]
select * from pdf where partno='103030401' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.014266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391708 LIMIT 5 [ RunTime:0.020865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391708 ORDER BY `minOrder` ASC [ RunTime:0.006386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391708 ORDER BY `unit` DESC [ RunTime:0.008746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391708 LIMIT 2 [ RunTime:0.002077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391708 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12395315 LIMIT 5 [ RunTime:0.006096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12395315 ORDER BY `minOrder` ASC [ RunTime:0.021750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12395315 ORDER BY `unit` DESC [ RunTime:0.015004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12395315 LIMIT 2 [ RunTime:0.003079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12395315 ORDER BY `minOrder` ASC [ RunTime:0.012425s ]
select * from pdf where partno='103030275' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.021800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336937 LIMIT 5 [ RunTime:0.013236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11336937 ORDER BY `minOrder` ASC [ RunTime:0.012159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11336937 ORDER BY `unit` DESC [ RunTime:0.007009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11336937 LIMIT 2 [ RunTime:0.013142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11336937 ORDER BY `minOrder` ASC [ RunTime:0.008118s ]
select * from pdf where partno='103030400' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.009869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14257683 LIMIT 5 [ RunTime:0.016761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14257683 ORDER BY `minOrder` ASC [ RunTime:0.006684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14257683 ORDER BY `unit` DESC [ RunTime:0.001732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14257683 LIMIT 2 [ RunTime:0.007424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14257683 ORDER BY `minOrder` ASC [ RunTime:0.003529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190613 LIMIT 5 [ RunTime:0.012584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190613 ORDER BY `minOrder` ASC [ RunTime:0.010129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11190613 ORDER BY `unit` DESC [ RunTime:0.012241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11190613 LIMIT 2 [ RunTime:0.006589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190613 ORDER BY `minOrder` ASC [ RunTime:0.007793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391888 LIMIT 5 [ RunTime:0.017216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391888 ORDER BY `minOrder` ASC [ RunTime:0.004340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391888 ORDER BY `unit` DESC [ RunTime:0.030688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391888 LIMIT 2 [ RunTime:0.004957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391888 ORDER BY `minOrder` ASC [ RunTime:0.010503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265619 LIMIT 5 [ RunTime:0.002239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265619 ORDER BY `minOrder` ASC [ RunTime:0.010347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265619 ORDER BY `unit` DESC [ RunTime:0.012639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265619 LIMIT 2 [ RunTime:0.001185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265619 ORDER BY `minOrder` ASC [ RunTime:0.008011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392194 LIMIT 5 [ RunTime:0.015901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392194 ORDER BY `minOrder` ASC [ RunTime:0.019974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12392194 ORDER BY `unit` DESC [ RunTime:0.010628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12392194 LIMIT 2 [ RunTime:0.008706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12392194 ORDER BY `minOrder` ASC [ RunTime:0.003577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335956 LIMIT 5 [ RunTime:0.005339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335956 ORDER BY `minOrder` ASC [ RunTime:0.011257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11335956 ORDER BY `unit` DESC [ RunTime:0.005176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11335956 LIMIT 2 [ RunTime:0.012767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335956 ORDER BY `minOrder` ASC [ RunTime:0.003617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650106 LIMIT 5 [ RunTime:0.008798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650106 ORDER BY `minOrder` ASC [ RunTime:0.007278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650106 ORDER BY `unit` DESC [ RunTime:0.011248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650106 LIMIT 2 [ RunTime:0.009625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650106 ORDER BY `minOrder` ASC [ RunTime:0.004408s ]
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 '10303%' OR `brand` LIKE '10303%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51109789 LIMIT 5 [ RunTime:0.009338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51109789 ORDER BY `minOrder` ASC [ RunTime:0.017946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51109789 ORDER BY `unit` DESC [ RunTime:0.005810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51109789 LIMIT 2 [ RunTime:0.006386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51109789 ORDER BY `minOrder` ASC [ RunTime:0.006585s ]
select * from pdf where partno='103030000' and brandshort='seeed studio' limit 1 [ RunTime:0.005735s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030000' OR `brand` LIKE 'seeed studio%' ) ) LIMIT 1 [ RunTime:0.013238s ]
SELECT `id` FROM `stock` WHERE `id` <> 51109789 AND `partno` = '103030000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed studio%' ) [ RunTime:0.014761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32306668 LIMIT 5 [ RunTime:0.002803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32306668 ORDER BY `minOrder` ASC [ RunTime:0.006128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32306668 ORDER BY `unit` DESC [ RunTime:0.004076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32306668 LIMIT 2 [ RunTime:0.012673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32306668 ORDER BY `minOrder` ASC [ RunTime:0.008019s ]
select * from pdf where partno='103030276' and brandshort='seeed studio' limit 1 [ RunTime:0.005634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030276' OR `brand` LIKE 'seeed studio%' ) ) LIMIT 1 [ RunTime:0.004734s ]
SELECT `id` FROM `stock` WHERE `id` <> 32306668 AND `partno` = '103030276' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed studio%' ) [ RunTime:0.000948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51111519 LIMIT 5 [ RunTime:0.003553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111519 ORDER BY `minOrder` ASC [ RunTime:0.013824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51111519 ORDER BY `unit` DESC [ RunTime:0.017872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51111519 LIMIT 2 [ RunTime:0.009593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51111519 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
select * from pdf where partno='103030356' and brandshort='seeed studio' limit 1 [ RunTime:0.003252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030356' OR `brand` LIKE 'seeed studio%' ) ) LIMIT 1 [ RunTime:0.004561s ]
SELECT `id` FROM `stock` WHERE `id` <> 51111519 AND `partno` = '103030356' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed studio%' ) [ RunTime:0.007107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32187846 LIMIT 5 [ RunTime:0.002059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32187846 ORDER BY `minOrder` ASC [ RunTime:0.013052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32187846 ORDER BY `unit` DESC [ RunTime:0.005508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32187846 LIMIT 2 [ RunTime:0.017077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32187846 ORDER BY `minOrder` ASC [ RunTime:0.006251s ]
select * from pdf where partno='103030009' and brandshort='seeed studio' limit 1 [ RunTime:0.001310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030009' OR `brand` LIKE 'seeed studio%' ) ) LIMIT 1 [ RunTime:0.001472s ]
SELECT `id` FROM `stock` WHERE `id` <> 32187846 AND `partno` = '103030009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed studio%' ) [ RunTime:0.012300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32307532 LIMIT 5 [ RunTime:0.004997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32307532 ORDER BY `minOrder` ASC [ RunTime:0.018147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32307532 ORDER BY `unit` DESC [ RunTime:0.015502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32307532 LIMIT 2 [ RunTime:0.010534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32307532 ORDER BY `minOrder` ASC [ RunTime:0.010520s ]
select * from pdf where partno='103030275' and brandshort='seeed studio' limit 1 [ RunTime:0.006291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030275' OR `brand` LIKE 'seeed studio%' ) ) LIMIT 1 [ RunTime:0.014372s ]
SELECT `id` FROM `stock` WHERE `id` <> 32307532 AND `partno` = '103030275' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed studio%' ) [ RunTime:0.015896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32307534 LIMIT 5 [ RunTime:0.008176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32307534 ORDER BY `minOrder` ASC [ RunTime:0.010641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32307534 ORDER BY `unit` DESC [ RunTime:0.011249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32307534 LIMIT 2 [ RunTime:0.011476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32307534 ORDER BY `minOrder` ASC [ RunTime:0.003909s ]
select * from pdf where partno='103030401' and brandshort='seeed studio' limit 1 [ RunTime:0.004017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030401' OR `brand` LIKE 'seeed studio%' ) ) LIMIT 1 [ RunTime:0.009468s ]
SELECT `id` FROM `stock` WHERE `id` <> 32307534 AND `partno` = '103030401' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed studio%' ) [ RunTime:0.009764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32307533 LIMIT 5 [ RunTime:0.017901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32307533 ORDER BY `minOrder` ASC [ RunTime:0.012850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32307533 ORDER BY `unit` DESC [ RunTime:0.015327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32307533 LIMIT 2 [ RunTime:0.007968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32307533 ORDER BY `minOrder` ASC [ RunTime:0.005875s ]
select * from pdf where partno='103030400' and brandshort='seeed studio' limit 1 [ RunTime:0.015304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030400' OR `brand` LIKE 'seeed studio%' ) ) LIMIT 1 [ RunTime:0.012117s ]
SELECT `id` FROM `stock` WHERE `id` <> 32307533 AND `partno` = '103030400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed studio%' ) [ RunTime:0.013156s ]
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 '10303%' OR `brand` LIKE '10303%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58146979 LIMIT 5 [ RunTime:0.008967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58146979 ORDER BY `minOrder` ASC [ RunTime:0.009576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58146979 ORDER BY `unit` DESC [ RunTime:0.003658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58146979 LIMIT 2 [ RunTime:0.015933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58146979 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='10303-C' and brandshort='ATGBICS' limit 1 [ RunTime:0.012427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10303-C' OR `brand` LIKE 'ATGBICS%' ) ) LIMIT 1 [ RunTime:0.018575s ]
SELECT `id` FROM `stock` WHERE `id` <> 58146979 AND `partno` = '10303-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%atgbics%' ) [ RunTime:0.004391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12225071 [ RunTime:0.012358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57739818 LIMIT 5 [ RunTime:0.002825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739818 ORDER BY `minOrder` ASC [ RunTime:0.018476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57739818 ORDER BY `unit` DESC [ RunTime:0.003977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57739818 LIMIT 2 [ RunTime:0.011753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739818 ORDER BY `minOrder` ASC [ RunTime:0.003607s ]
select * from pdf where partno='10303CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.006383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10303CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010557s ]
SELECT `id` FROM `stock` WHERE `id` <> 57739818 AND `partno` = '10303CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.011890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066958 [ RunTime:0.014117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241111 LIMIT 5 [ RunTime:0.003029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241111 ORDER BY `minOrder` ASC [ RunTime:0.001244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241111 ORDER BY `unit` DESC [ RunTime:0.002563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241111 LIMIT 2 [ RunTime:0.008306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241111 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
select * from pdf where partno='103030000' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030000' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000875s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241111 AND `partno` = '103030000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.000919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335556 [ RunTime:0.012201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241141 LIMIT 5 [ RunTime:0.001393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241141 ORDER BY `minOrder` ASC [ RunTime:0.000824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241141 ORDER BY `unit` DESC [ RunTime:0.002855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241141 LIMIT 2 [ RunTime:0.007041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241141 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='103030277' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.003578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030277' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000994s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241141 AND `partno` = '103030277' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.004366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12392194 [ RunTime:0.005637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57240974 LIMIT 5 [ RunTime:0.005791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57240974 ORDER BY `minOrder` ASC [ RunTime:0.008485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57240974 ORDER BY `unit` DESC [ RunTime:0.000832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57240974 LIMIT 2 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57240974 ORDER BY `minOrder` ASC [ RunTime:0.003567s ]
select * from pdf where partno='103030215' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.006123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030215' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.001639s ]
SELECT `id` FROM `stock` WHERE `id` <> 57240974 AND `partno` = '103030215' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.000882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391621 [ RunTime:0.001294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57607864 LIMIT 5 [ RunTime:0.004131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57607864 ORDER BY `minOrder` ASC [ RunTime:0.002286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57607864 ORDER BY `unit` DESC [ RunTime:0.000867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57607864 LIMIT 2 [ RunTime:0.004164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57607864 ORDER BY `minOrder` ASC [ RunTime:0.003565s ]
select * from pdf where partno='103030375' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.001311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030375' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.006533s ]
SELECT `id` FROM `stock` WHERE `id` <> 57607864 AND `partno` = '103030375' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.005345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14257683 [ RunTime:0.000893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57240948 LIMIT 5 [ RunTime:0.021276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57240948 ORDER BY `minOrder` ASC [ RunTime:0.001324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57240948 ORDER BY `unit` DESC [ RunTime:0.025062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57240948 LIMIT 2 [ RunTime:0.013761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57240948 ORDER BY `minOrder` ASC [ RunTime:0.016810s ]
select * from pdf where partno='103030356' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.013559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030356' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.033468s ]
SELECT `id` FROM `stock` WHERE `id` <> 57240948 AND `partno` = '103030356' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.024157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12393934 [ RunTime:0.020395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241352 LIMIT 5 [ RunTime:0.005571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241352 ORDER BY `minOrder` ASC [ RunTime:0.018976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241352 ORDER BY `unit` DESC [ RunTime:0.031271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241352 LIMIT 2 [ RunTime:0.034246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241352 ORDER BY `minOrder` ASC [ RunTime:0.007173s ]
select * from pdf where partno='103030009' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.016706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030009' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.007798s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241352 AND `partno` = '103030009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.042677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391708 [ RunTime:0.005924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241421 LIMIT 5 [ RunTime:0.021800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241421 ORDER BY `minOrder` ASC [ RunTime:0.055944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241421 ORDER BY `unit` DESC [ RunTime:0.083748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241421 LIMIT 2 [ RunTime:0.030574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241421 ORDER BY `minOrder` ASC [ RunTime:0.008769s ]
select * from pdf where partno='103030034' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.010397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030034' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.015954s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241421 AND `partno` = '103030034' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.039045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265532 [ RunTime:0.010338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241285 LIMIT 5 [ RunTime:0.012765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241285 ORDER BY `minOrder` ASC [ RunTime:0.020285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241285 ORDER BY `unit` DESC [ RunTime:0.014099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241285 LIMIT 2 [ RunTime:0.018545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241285 ORDER BY `minOrder` ASC [ RunTime:0.004966s ]
select * from pdf where partno='103030275' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.005055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030275' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.017122s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241285 AND `partno` = '103030275' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.022003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12395315 [ RunTime:0.012290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241420 LIMIT 5 [ RunTime:0.007944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241420 ORDER BY `minOrder` ASC [ RunTime:0.009105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241420 ORDER BY `unit` DESC [ RunTime:0.019455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241420 LIMIT 2 [ RunTime:0.017014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241420 ORDER BY `minOrder` ASC [ RunTime:0.003694s ]
select * from pdf where partno='103030276' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030276' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.013568s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241420 AND `partno` = '103030276' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.005626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335823 [ RunTime:0.011286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53648822 LIMIT 5 [ RunTime:0.004114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53648822 ORDER BY `minOrder` ASC [ RunTime:0.014927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53648822 ORDER BY `unit` DESC [ RunTime:0.001603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53648822 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53648822 ORDER BY `minOrder` ASC [ RunTime:0.002401s ]
select * from pdf where partno='1030300000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1030300000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005517s ]
SELECT `id` FROM `stock` WHERE `id` <> 53648822 AND `partno` = '1030300000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562483 [ RunTime:0.001161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241803 LIMIT 5 [ RunTime:0.001773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241803 ORDER BY `minOrder` ASC [ RunTime:0.004482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241803 ORDER BY `unit` DESC [ RunTime:0.004784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241803 LIMIT 2 [ RunTime:0.008780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241803 ORDER BY `minOrder` ASC [ RunTime:0.000958s ]
select * from pdf where partno='103030401' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030401' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000986s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241803 AND `partno` = '103030401' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.013523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12395154 [ RunTime:0.003603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241560 LIMIT 5 [ RunTime:0.004472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241560 ORDER BY `minOrder` ASC [ RunTime:0.011557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241560 ORDER BY `unit` DESC [ RunTime:0.030318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241560 LIMIT 2 [ RunTime:0.014629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241560 ORDER BY `minOrder` ASC [ RunTime:0.003153s ]
select * from pdf where partno='103030021' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.014481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030021' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.001244s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241560 AND `partno` = '103030021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.014716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265567 [ RunTime:0.026345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241777 LIMIT 5 [ RunTime:0.034112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241777 ORDER BY `minOrder` ASC [ RunTime:0.009839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241777 ORDER BY `unit` DESC [ RunTime:0.002278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241777 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241777 ORDER BY `minOrder` ASC [ RunTime:0.004913s ]
select * from pdf where partno='103030400' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.011943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030400' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.003961s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241777 AND `partno` = '103030400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336937 [ RunTime:0.003208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51705358 LIMIT 5 [ RunTime:0.021775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51705358 ORDER BY `minOrder` ASC [ RunTime:0.002496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51705358 ORDER BY `unit` DESC [ RunTime:0.020064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51705358 LIMIT 2 [ RunTime:0.018326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51705358 ORDER BY `minOrder` ASC [ RunTime:0.017793s ]
select * from pdf where partno='10303' and brandshort='Aven Tools' limit 1 [ RunTime:0.005925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10303' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.013752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57243604 LIMIT 5 [ RunTime:0.022329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57243604 ORDER BY `minOrder` ASC [ RunTime:0.020491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57243604 ORDER BY `unit` DESC [ RunTime:0.006183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57243604 LIMIT 2 [ RunTime:0.018556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57243604 ORDER BY `minOrder` ASC [ RunTime:0.006566s ]
select * from pdf where partno='103030035' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.001088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030035' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.013107s ]
SELECT `id` FROM `stock` WHERE `id` <> 57243604 AND `partno` = '103030035' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.039314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335825 [ RunTime:0.033381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57245424 LIMIT 5 [ RunTime:0.029970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57245424 ORDER BY `minOrder` ASC [ RunTime:0.054045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57245424 ORDER BY `unit` DESC [ RunTime:0.027926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57245424 LIMIT 2 [ RunTime:0.032202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57245424 ORDER BY `minOrder` ASC [ RunTime:0.029942s ]
select * from pdf where partno='103030397' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.020355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030397' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.046510s ]
SELECT `id` FROM `stock` WHERE `id` <> 57245424 AND `partno` = '103030397' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.039459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265619 [ RunTime:0.025765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57242491 LIMIT 5 [ RunTime:0.031880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57242491 ORDER BY `minOrder` ASC [ RunTime:0.022716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57242491 ORDER BY `unit` DESC [ RunTime:0.097003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57242491 LIMIT 2 [ RunTime:0.068176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57242491 ORDER BY `minOrder` ASC [ RunTime:0.022894s ]
select * from pdf where partno='103030398' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.050099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103030398' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.019948s ]
SELECT `id` FROM `stock` WHERE `id` <> 57242491 AND `partno` = '103030398' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.045405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335950 [ RunTime:0.058647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58157129 LIMIT 5 [ RunTime:0.036982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58157129 ORDER BY `minOrder` ASC [ RunTime:0.020682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58157129 ORDER BY `unit` DESC [ RunTime:0.030954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58157129 LIMIT 2 [ RunTime:0.033805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58157129 ORDER BY `minOrder` ASC [ RunTime:0.012022s ]
select * from pdf where partno='10303-ST' and brandshort='StarTech.com' limit 1 [ RunTime:0.022670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10303-ST' OR `brand` LIKE 'StarTech.com%' ) ) LIMIT 1 [ RunTime:0.034314s ]
SELECT `id` FROM `stock` WHERE `id` <> 58157129 AND `partno` = '10303-ST' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%startech.com%' ) [ RunTime:0.015546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12222864 [ RunTime:0.022276s ]
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 '10303%' OR `brand` LIKE '10303%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042767s ]
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 '10303%' OR `brand` LIKE '10303%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043555s ]
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 '10303%' OR `brand` LIKE '10303%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034777s ]
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 '10303%' OR `brand` LIKE '10303%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028083s ]
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 '10303%' OR `brand` LIKE '10303%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035054s ]
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 '10303%' OR `brand` LIKE '10303%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043622s ]
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 '10303%' OR `brand` LIKE '10303%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036791s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10303%' OR `brand` LIKE '10303%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.033545s ]