SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001325s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=1069900&search=1' [ RunTime:0.001737s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001405s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.025625s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001565s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.009262s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001513s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011739s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001843s ]
SELECT * FROM `stock_search` WHERE `partno` = '1069900' LIMIT 1 [ RunTime:0.049864s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-24 10:33:18' WHERE `partno` = '1069900' [ RunTime:0.005704s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001465s ]
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 '1069900%' OR `brand` LIKE '1069900%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068157s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13374074 LIMIT 5 [ RunTime:0.020369s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13374074 ORDER BY `minOrder` ASC [ RunTime:0.041868s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13374074 ORDER BY `unit` DESC [ RunTime:0.042948s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.024695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13374074 LIMIT 2 [ RunTime:0.041007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13374074 ORDER BY `minOrder` ASC [ RunTime:0.020115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265163 LIMIT 5 [ RunTime:0.022239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265163 ORDER BY `minOrder` ASC [ RunTime:0.040312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265163 ORDER BY `unit` DESC [ RunTime:0.015633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265163 LIMIT 2 [ RunTime:0.043453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265163 ORDER BY `minOrder` ASC [ RunTime:0.008928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19517014 LIMIT 5 [ RunTime:0.007495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19517014 ORDER BY `minOrder` ASC [ RunTime:0.019608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19517014 ORDER BY `unit` DESC [ RunTime:0.020992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19517014 LIMIT 2 [ RunTime:0.008199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19517014 ORDER BY `minOrder` ASC [ RunTime:0.021905s ]
select * from pdf where partno='106990005' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.014430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19517013 LIMIT 5 [ RunTime:0.015385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19517013 ORDER BY `minOrder` ASC [ RunTime:0.018679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19517013 ORDER BY `unit` DESC [ RunTime:0.005681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19517013 LIMIT 2 [ RunTime:0.003884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19517013 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19517012 LIMIT 5 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19517012 ORDER BY `minOrder` ASC [ RunTime:0.002944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19517012 ORDER BY `unit` DESC [ RunTime:0.005877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19517012 LIMIT 2 [ RunTime:0.006333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19517012 ORDER BY `minOrder` ASC [ RunTime:0.009618s ]
select * from pdf where partno='106990007' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.025837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858464 LIMIT 5 [ RunTime:0.005786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858464 ORDER BY `minOrder` ASC [ RunTime:0.010256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17858464 ORDER BY `unit` DESC [ RunTime:0.004686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17858464 LIMIT 2 [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17858464 ORDER BY `minOrder` ASC [ RunTime:0.010724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17857879 LIMIT 5 [ RunTime:0.023557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17857879 ORDER BY `minOrder` ASC [ RunTime:0.017754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17857879 ORDER BY `unit` DESC [ RunTime:0.002821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17857879 LIMIT 2 [ RunTime:0.013527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17857879 ORDER BY `minOrder` ASC [ RunTime:0.004658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15427895 LIMIT 5 [ RunTime:0.005059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15427895 ORDER BY `minOrder` ASC [ RunTime:0.005600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15427895 ORDER BY `unit` DESC [ RunTime:0.011904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15427895 LIMIT 2 [ RunTime:0.027117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15427895 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273697 LIMIT 5 [ RunTime:0.001058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14273697 ORDER BY `minOrder` ASC [ RunTime:0.006195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14273697 ORDER BY `unit` DESC [ RunTime:0.006661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14273697 LIMIT 2 [ RunTime:0.009165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14273697 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14257875 LIMIT 5 [ RunTime:0.017396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14257875 ORDER BY `minOrder` ASC [ RunTime:0.007989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14257875 ORDER BY `unit` DESC [ RunTime:0.001015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14257875 LIMIT 2 [ RunTime:0.003647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14257875 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12403097 LIMIT 5 [ RunTime:0.015674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12403097 ORDER BY `minOrder` ASC [ RunTime:0.006859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12403097 ORDER BY `unit` DESC [ RunTime:0.001455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12403097 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12403097 ORDER BY `minOrder` ASC [ RunTime:0.001011s ]
select * from pdf where partno='106990069' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.014352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12402631 LIMIT 5 [ RunTime:0.010639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12402631 ORDER BY `minOrder` ASC [ RunTime:0.015013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12402631 ORDER BY `unit` DESC [ RunTime:0.002892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12402631 LIMIT 2 [ RunTime:0.001388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12402631 ORDER BY `minOrder` ASC [ RunTime:0.008620s ]
select * from pdf where partno='106990008' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.029423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12402586 LIMIT 5 [ RunTime:0.027784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12402586 ORDER BY `minOrder` ASC [ RunTime:0.008344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12402586 ORDER BY `unit` DESC [ RunTime:0.008458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12402586 LIMIT 2 [ RunTime:0.002151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12402586 ORDER BY `minOrder` ASC [ RunTime:0.004638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12402571 LIMIT 5 [ RunTime:0.001330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12402571 ORDER BY `minOrder` ASC [ RunTime:0.002192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12402571 ORDER BY `unit` DESC [ RunTime:0.024695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12402571 LIMIT 2 [ RunTime:0.008134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12402571 ORDER BY `minOrder` ASC [ RunTime:0.003105s ]
select * from pdf where partno='106990018' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.023185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12394683 LIMIT 5 [ RunTime:0.002547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12394683 ORDER BY `minOrder` ASC [ RunTime:0.022931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12394683 ORDER BY `unit` DESC [ RunTime:0.010986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12394683 LIMIT 2 [ RunTime:0.018333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12394683 ORDER BY `minOrder` ASC [ RunTime:0.011869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12390181 LIMIT 5 [ RunTime:0.018102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12390181 ORDER BY `minOrder` ASC [ RunTime:0.031614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12390181 ORDER BY `unit` DESC [ RunTime:0.042833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12390181 LIMIT 2 [ RunTime:0.009486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12390181 ORDER BY `minOrder` ASC [ RunTime:0.011185s ]
select * from pdf where partno='106990006' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.003787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336647 LIMIT 5 [ RunTime:0.013466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11336647 ORDER BY `minOrder` ASC [ RunTime:0.007922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11336647 ORDER BY `unit` DESC [ RunTime:0.003425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11336647 LIMIT 2 [ RunTime:0.005544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11336647 ORDER BY `minOrder` ASC [ RunTime:0.007451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11128317 LIMIT 5 [ RunTime:0.004807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11128317 ORDER BY `minOrder` ASC [ RunTime:0.003877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11128317 ORDER BY `unit` DESC [ RunTime:0.006078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11128317 LIMIT 2 [ RunTime:0.002601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11128317 ORDER BY `minOrder` ASC [ RunTime:0.010917s ]
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 '1069900%' OR `brand` LIKE '1069900%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010625s ]
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 '1069900%' OR `brand` LIKE '1069900%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64413315 LIMIT 5 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64413315 ORDER BY `minOrder` ASC [ RunTime:0.020354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64413315 ORDER BY `unit` DESC [ RunTime:0.016765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64413315 LIMIT 2 [ RunTime:0.009431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64413315 ORDER BY `minOrder` ASC [ RunTime:0.038808s ]
select * from pdf where partno='106990017' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.009922s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990017' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.010857s ]
SELECT `id` FROM `stock` WHERE `id` <> 64413315 AND `partno` = '106990017' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.025402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13374074 [ RunTime:0.010533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64050382 LIMIT 5 [ RunTime:0.009378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050382 ORDER BY `minOrder` ASC [ RunTime:0.013973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64050382 ORDER BY `unit` DESC [ RunTime:0.011725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64050382 LIMIT 2 [ RunTime:0.002903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64050382 ORDER BY `minOrder` ASC [ RunTime:0.003127s ]
select * from pdf where partno='106990020' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.011489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990020' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000620s ]
SELECT `id` FROM `stock` WHERE `id` <> 64050382 AND `partno` = '106990020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.011446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265163 [ RunTime:0.016502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64413722 LIMIT 5 [ RunTime:0.022815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64413722 ORDER BY `minOrder` ASC [ RunTime:0.063565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64413722 ORDER BY `unit` DESC [ RunTime:0.010897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64413722 LIMIT 2 [ RunTime:0.004830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64413722 ORDER BY `minOrder` ASC [ RunTime:0.015412s ]
select * from pdf where partno='106990004' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.005087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990004' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.008249s ]
SELECT `id` FROM `stock` WHERE `id` <> 64413722 AND `partno` = '106990004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.007669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14257875 [ RunTime:0.001477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64055207 LIMIT 5 [ RunTime:0.008352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64055207 ORDER BY `minOrder` ASC [ RunTime:0.004365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64055207 ORDER BY `unit` DESC [ RunTime:0.007534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64055207 LIMIT 2 [ RunTime:0.008329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64055207 ORDER BY `minOrder` ASC [ RunTime:0.002893s ]
select * from pdf where partno='106990016' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.001141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990016' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.004247s ]
SELECT `id` FROM `stock` WHERE `id` <> 64055207 AND `partno` = '106990016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.014790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12394683 [ RunTime:0.018357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64055068 LIMIT 5 [ RunTime:0.001581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64055068 ORDER BY `minOrder` ASC [ RunTime:0.013087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64055068 ORDER BY `unit` DESC [ RunTime:0.021482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64055068 LIMIT 2 [ RunTime:0.014490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64055068 ORDER BY `minOrder` ASC [ RunTime:0.011808s ]
select * from pdf where partno='106990026' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.011426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990026' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.011474s ]
SELECT `id` FROM `stock` WHERE `id` <> 64055068 AND `partno` = '106990026' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.010774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336647 [ RunTime:0.019307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64040964 LIMIT 5 [ RunTime:0.010718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64040964 ORDER BY `minOrder` ASC [ RunTime:0.014421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64040964 ORDER BY `unit` DESC [ RunTime:0.012548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64040964 LIMIT 2 [ RunTime:0.026541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64040964 ORDER BY `minOrder` ASC [ RunTime:0.005403s ]
select * from pdf where partno='106990019' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.013599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990019' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.018495s ]
SELECT `id` FROM `stock` WHERE `id` <> 64040964 AND `partno` = '106990019' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.018621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15427895 [ RunTime:0.002621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64040926 LIMIT 5 [ RunTime:0.006847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64040926 ORDER BY `minOrder` ASC [ RunTime:0.006935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64040926 ORDER BY `unit` DESC [ RunTime:0.003402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64040926 LIMIT 2 [ RunTime:0.007067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64040926 ORDER BY `minOrder` ASC [ RunTime:0.002476s ]
select * from pdf where partno='106990005' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.023347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990005' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.003111s ]
SELECT `id` FROM `stock` WHERE `id` <> 64040926 AND `partno` = '106990005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.001387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19517014 [ RunTime:0.016294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64040925 LIMIT 5 [ RunTime:0.023901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64040925 ORDER BY `minOrder` ASC [ RunTime:0.013055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64040925 ORDER BY `unit` DESC [ RunTime:0.014023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64040925 LIMIT 2 [ RunTime:0.006100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64040925 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='106990003' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.009085s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990003' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.010198s ]
SELECT `id` FROM `stock` WHERE `id` <> 64040925 AND `partno` = '106990003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.023455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19517013 [ RunTime:0.021994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64040924 LIMIT 5 [ RunTime:0.001430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64040924 ORDER BY `minOrder` ASC [ RunTime:0.000756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64040924 ORDER BY `unit` DESC [ RunTime:0.011748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64040924 LIMIT 2 [ RunTime:0.020293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64040924 ORDER BY `minOrder` ASC [ RunTime:0.000797s ]
select * from pdf where partno='106990007' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.005437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990007' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.006644s ]
SELECT `id` FROM `stock` WHERE `id` <> 64040924 AND `partno` = '106990007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.001486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19517012 [ RunTime:0.001134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64029424 LIMIT 5 [ RunTime:0.013338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64029424 ORDER BY `minOrder` ASC [ RunTime:0.012935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64029424 ORDER BY `unit` DESC [ RunTime:0.002151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64029424 LIMIT 2 [ RunTime:0.014077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64029424 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='106990069' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990069' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000807s ]
SELECT `id` FROM `stock` WHERE `id` <> 64029424 AND `partno` = '106990069' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.000864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12403097 [ RunTime:0.009069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64028455 LIMIT 5 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64028455 ORDER BY `minOrder` ASC [ RunTime:0.019568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64028455 ORDER BY `unit` DESC [ RunTime:0.003907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64028455 LIMIT 2 [ RunTime:0.001701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64028455 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='106990008' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990008' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.000833s ]
SELECT `id` FROM `stock` WHERE `id` <> 64028455 AND `partno` = '106990008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.001776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12402631 [ RunTime:0.007000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64028386 LIMIT 5 [ RunTime:0.006424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64028386 ORDER BY `minOrder` ASC [ RunTime:0.004688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64028386 ORDER BY `unit` DESC [ RunTime:0.017427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64028386 LIMIT 2 [ RunTime:0.008068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64028386 ORDER BY `minOrder` ASC [ RunTime:0.009888s ]
select * from pdf where partno='106990022' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.001632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990022' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.001613s ]
SELECT `id` FROM `stock` WHERE `id` <> 64028386 AND `partno` = '106990022' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.003517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12402586 [ RunTime:0.001408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64028362 LIMIT 5 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64028362 ORDER BY `minOrder` ASC [ RunTime:0.002797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64028362 ORDER BY `unit` DESC [ RunTime:0.021967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64028362 LIMIT 2 [ RunTime:0.009670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64028362 ORDER BY `minOrder` ASC [ RunTime:0.011405s ]
select * from pdf where partno='106990018' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.007104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990018' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.012742s ]
SELECT `id` FROM `stock` WHERE `id` <> 64028362 AND `partno` = '106990018' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.030744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12402571 [ RunTime:0.016629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64013606 LIMIT 5 [ RunTime:0.003231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64013606 ORDER BY `minOrder` ASC [ RunTime:0.001414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64013606 ORDER BY `unit` DESC [ RunTime:0.001173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64013606 LIMIT 2 [ RunTime:0.006355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64013606 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='106990006' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.000630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990006' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.024108s ]
SELECT `id` FROM `stock` WHERE `id` <> 64013606 AND `partno` = '106990006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.002651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12390181 [ RunTime:0.006815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60630163 LIMIT 5 [ RunTime:0.018371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60630163 ORDER BY `minOrder` ASC [ RunTime:0.013042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60630163 ORDER BY `unit` DESC [ RunTime:0.003957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60630163 LIMIT 2 [ RunTime:0.001707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60630163 ORDER BY `minOrder` ASC [ RunTime:0.002835s ]
select * from pdf where partno='1069900000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1069900000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.041757s ]
SELECT `id` FROM `stock` WHERE `id` <> 60630163 AND `partno` = '1069900000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.017674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58169543 LIMIT 5 [ RunTime:0.016346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58169543 ORDER BY `minOrder` ASC [ RunTime:0.054668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58169543 ORDER BY `unit` DESC [ RunTime:0.026675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58169543 LIMIT 2 [ RunTime:0.023623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58169543 ORDER BY `minOrder` ASC [ RunTime:0.011930s ]
select * from pdf where partno='106990027' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.013713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990027' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.007486s ]
SELECT `id` FROM `stock` WHERE `id` <> 58169543 AND `partno` = '106990027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.031106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17858464 [ RunTime:0.003108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58168511 LIMIT 5 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58168511 ORDER BY `minOrder` ASC [ RunTime:0.030404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58168511 ORDER BY `unit` DESC [ RunTime:0.068561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58168511 LIMIT 2 [ RunTime:0.041114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58168511 ORDER BY `minOrder` ASC [ RunTime:0.022616s ]
select * from pdf where partno='106990048' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.039044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990048' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.016974s ]
SELECT `id` FROM `stock` WHERE `id` <> 58168511 AND `partno` = '106990048' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.024056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17857879 [ RunTime:0.018540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104021 LIMIT 5 [ RunTime:0.012496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104021 ORDER BY `minOrder` ASC [ RunTime:0.021805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104021 ORDER BY `unit` DESC [ RunTime:0.037822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104021 LIMIT 2 [ RunTime:0.029898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104021 ORDER BY `minOrder` ASC [ RunTime:0.004558s ]
select * from pdf where partno='106990000' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.031356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990000' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.019046s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104021 AND `partno` = '106990000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.037640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14273697 [ RunTime:0.008475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41614771 LIMIT 5 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41614771 ORDER BY `minOrder` ASC [ RunTime:0.018236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41614771 ORDER BY `unit` DESC [ RunTime:0.013977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41614771 LIMIT 2 [ RunTime:0.019995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41614771 ORDER BY `minOrder` ASC [ RunTime:0.003612s ]
select * from pdf where partno='106990023' and brandshort='Seeed Technology Co., Ltd' limit 1 [ RunTime:0.015830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106990023' OR `brand` LIKE 'Seeed Technology Co., Ltd%' ) ) LIMIT 1 [ RunTime:0.035680s ]
SELECT `id` FROM `stock` WHERE `id` <> 41614771 AND `partno` = '106990023' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%seeed technology co., ltd%' ) [ RunTime:0.006484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11128317 [ RunTime:0.011005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32343650 LIMIT 5 [ RunTime:0.021588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32343650 ORDER BY `minOrder` ASC [ RunTime:0.018533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32343650 ORDER BY `unit` DESC [ RunTime:0.005210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32343650 LIMIT 2 [ RunTime:0.013502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32343650 ORDER BY `minOrder` ASC [ RunTime:0.016309s ]
select * from pdf where partno='1069900' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.020690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1069900' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005169s ]
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 '1069900%' OR `brand` LIKE '1069900%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020374s ]
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 '1069900%' OR `brand` LIKE '1069900%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031582s ]
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 '1069900%' OR `brand` LIKE '1069900%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003251s ]
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 '1069900%' OR `brand` LIKE '1069900%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010116s ]
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 '1069900%' OR `brand` LIKE '1069900%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033392s ]
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 '1069900%' OR `brand` LIKE '1069900%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009519s ]
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 '1069900%' OR `brand` LIKE '1069900%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006192s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1069900%' OR `brand` LIKE '1069900%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001956s ]