SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001542s ]
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=716&search=1' [ RunTime:0.002639s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001216s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009194s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004142s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.006062s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002082s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003777s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002060s ]
SELECT * FROM `stock_search` WHERE `partno` = '716' LIMIT 1 [ RunTime:0.001023s ]
UPDATE `stock_search` SET `count` = 96 , `updatetime` = '2026-08-20 09:10:51' WHERE `partno` = '716' [ RunTime:0.005168s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002423s ]
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 '716%' OR `brand` LIKE '716%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053582s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068527 LIMIT 5 [ RunTime:0.000595s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068527 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068527 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068527 LIMIT 2 [ RunTime:0.002461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068527 ORDER BY `minOrder` ASC [ RunTime:0.001914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350911 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350911 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350911 ORDER BY `unit` DESC [ RunTime:0.000304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350911 LIMIT 2 [ RunTime:0.001233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350911 ORDER BY `minOrder` ASC [ RunTime:0.000931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067706 LIMIT 5 [ RunTime:0.001175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067706 ORDER BY `minOrder` ASC [ RunTime:0.014050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067706 ORDER BY `unit` DESC [ RunTime:0.001505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067706 LIMIT 2 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067706 ORDER BY `minOrder` ASC [ RunTime:0.004598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350063 LIMIT 5 [ RunTime:0.007473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350063 ORDER BY `minOrder` ASC [ RunTime:0.003924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350063 ORDER BY `unit` DESC [ RunTime:0.002297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350063 LIMIT 2 [ RunTime:0.001807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350063 ORDER BY `minOrder` ASC [ RunTime:0.009116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13112095 LIMIT 5 [ RunTime:0.002375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13112095 ORDER BY `minOrder` ASC [ RunTime:0.004742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13112095 ORDER BY `unit` DESC [ RunTime:0.000561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13112095 LIMIT 2 [ RunTime:0.006854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13112095 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611884 LIMIT 5 [ RunTime:0.001656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611884 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11611884 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11611884 LIMIT 2 [ RunTime:0.001514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11611884 ORDER BY `minOrder` ASC [ RunTime:0.003066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617753 LIMIT 5 [ RunTime:0.001974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617753 ORDER BY `minOrder` ASC [ RunTime:0.008205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11617753 ORDER BY `unit` DESC [ RunTime:0.005270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11617753 LIMIT 2 [ RunTime:0.003579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617753 ORDER BY `minOrder` ASC [ RunTime:0.001574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352084 LIMIT 5 [ RunTime:0.000876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352084 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352084 ORDER BY `unit` DESC [ RunTime:0.000675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352084 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352084 ORDER BY `minOrder` ASC [ RunTime:0.000814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 559 LIMIT 5 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 559 ORDER BY `minOrder` ASC [ RunTime:0.004692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 559 ORDER BY `unit` DESC [ RunTime:0.001238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 559 LIMIT 2 [ RunTime:0.013089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 559 ORDER BY `minOrder` ASC [ RunTime:0.005473s ]
select * from pdf where partno='71600-020LF' and brandshort='AMPHENOL COMMUNICATIONS SOLUTIONS' limit 1 [ RunTime:0.003844s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71600-020LF' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.001671s ]
SELECT `id` FROM `stock` WHERE `id` <> 559 AND `partno` = '71600-020LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol communications solutions%' ) [ RunTime:0.003251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801607 LIMIT 5 [ RunTime:0.006174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801607 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12801607 ORDER BY `unit` DESC [ RunTime:0.002070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12801607 LIMIT 2 [ RunTime:0.013683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801607 ORDER BY `minOrder` ASC [ RunTime:0.002028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12796380 LIMIT 5 [ RunTime:0.001387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796380 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12796380 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12796380 LIMIT 2 [ RunTime:0.002239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796380 ORDER BY `minOrder` ASC [ RunTime:0.004463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11859493 LIMIT 5 [ RunTime:0.000990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11859493 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11859493 ORDER BY `unit` DESC [ RunTime:0.002172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11859493 LIMIT 2 [ RunTime:0.001232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11859493 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801594 LIMIT 5 [ RunTime:0.001193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801594 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12801594 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12801594 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801594 ORDER BY `minOrder` ASC [ RunTime:0.003329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350268 LIMIT 5 [ RunTime:0.001625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350268 ORDER BY `minOrder` ASC [ RunTime:0.008080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13350268 ORDER BY `unit` DESC [ RunTime:0.000694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13350268 LIMIT 2 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13350268 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11613334 LIMIT 5 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11613334 ORDER BY `minOrder` ASC [ RunTime:0.002250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11613334 ORDER BY `unit` DESC [ RunTime:0.006584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11613334 LIMIT 2 [ RunTime:0.008315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11613334 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351672 LIMIT 5 [ RunTime:0.002909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351672 ORDER BY `minOrder` ASC [ RunTime:0.001166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13351672 ORDER BY `unit` DESC [ RunTime:0.001962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13351672 LIMIT 2 [ RunTime:0.001413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13351672 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680530 LIMIT 5 [ RunTime:0.001053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680530 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12680530 ORDER BY `unit` DESC [ RunTime:0.001756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12680530 LIMIT 2 [ RunTime:0.006907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680530 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617354 LIMIT 5 [ RunTime:0.000901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617354 ORDER BY `minOrder` ASC [ RunTime:0.005451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11617354 ORDER BY `unit` DESC [ RunTime:0.001700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11617354 LIMIT 2 [ RunTime:0.002846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617354 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12796853 LIMIT 5 [ RunTime:0.000846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796853 ORDER BY `minOrder` ASC [ RunTime:0.001055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12796853 ORDER BY `unit` DESC [ RunTime:0.002065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12796853 LIMIT 2 [ RunTime:0.000918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796853 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12794719 LIMIT 5 [ RunTime:0.001428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794719 ORDER BY `minOrder` ASC [ RunTime:0.001598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12794719 ORDER BY `unit` DESC [ RunTime:0.000544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12794719 LIMIT 2 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12794719 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
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 '716%' OR `brand` LIKE '716%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268956 LIMIT 5 [ RunTime:0.000368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268956 ORDER BY `minOrder` ASC [ RunTime:0.000824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268956 ORDER BY `unit` DESC [ RunTime:0.005533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268956 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268956 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
select * from pdf where partno='71609-302lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.001788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71609-302lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.006859s ]
SELECT `id` FROM `stock` WHERE `id` <> 32268956 AND `partno` = '71609-302lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.003123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269407 LIMIT 5 [ RunTime:0.003349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269407 ORDER BY `minOrder` ASC [ RunTime:0.015384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269407 ORDER BY `unit` DESC [ RunTime:0.002569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269407 LIMIT 2 [ RunTime:0.006377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269407 ORDER BY `minOrder` ASC [ RunTime:0.002180s ]
select * from pdf where partno='71609-310alf' and brandshort='amphenol fci' limit 1 [ RunTime:0.000924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71609-310alf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.002863s ]
SELECT `id` FROM `stock` WHERE `id` <> 32269407 AND `partno` = '71609-310alf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.004557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269182 LIMIT 5 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269182 ORDER BY `minOrder` ASC [ RunTime:0.001113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269182 ORDER BY `unit` DESC [ RunTime:0.001938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269182 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269182 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='71609-303lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.001037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71609-303lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.007006s ]
SELECT `id` FROM `stock` WHERE `id` <> 32269182 AND `partno` = '71609-303lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.000789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269310 LIMIT 5 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269310 ORDER BY `minOrder` ASC [ RunTime:0.002337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269310 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269310 LIMIT 2 [ RunTime:0.001498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269310 ORDER BY `minOrder` ASC [ RunTime:0.001210s ]
select * from pdf where partno='71661-2540' and brandshort='molex' limit 1 [ RunTime:0.001675s ]
select foldpath,foldpath2,filename from pdf_file where id=855395 limit 1 [ RunTime:0.002675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71661-2540' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.010074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268957 LIMIT 5 [ RunTime:0.001828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268957 ORDER BY `minOrder` ASC [ RunTime:0.006072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268957 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268957 LIMIT 2 [ RunTime:0.008711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268957 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='71609-308lf' and brandshort='amphenol fci' limit 1 [ RunTime:0.000559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71609-308lf' OR `brand` LIKE 'amphenol fci%' ) ) LIMIT 1 [ RunTime:0.003308s ]
SELECT `id` FROM `stock` WHERE `id` <> 32268957 AND `partno` = '71609-308lf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol fci%' ) [ RunTime:0.001282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32219440 LIMIT 5 [ RunTime:0.001344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32219440 ORDER BY `minOrder` ASC [ RunTime:0.001869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32219440 ORDER BY `unit` DESC [ RunTime:0.006047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32219440 LIMIT 2 [ RunTime:0.002441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32219440 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
select * from pdf where partno='7164' and brandshort='keystone electronics' limit 1 [ RunTime:0.001294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7164' OR `brand` LIKE 'keystone electronics%' ) ) LIMIT 1 [ RunTime:0.004436s ]
SELECT `id` FROM `stock` WHERE `id` <> 32219440 AND `partno` = '7164' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18993711 [ RunTime:0.002715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32219752 LIMIT 5 [ RunTime:0.002155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32219752 ORDER BY `minOrder` ASC [ RunTime:0.001378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32219752 ORDER BY `unit` DESC [ RunTime:0.003224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32219752 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32219752 ORDER BY `minOrder` ASC [ RunTime:0.000208s ]
select * from pdf where partno='7162' and brandshort='keystone electronics' limit 1 [ RunTime:0.001314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7162' OR `brand` LIKE 'keystone electronics%' ) ) LIMIT 1 [ RunTime:0.000419s ]
SELECT `id` FROM `stock` WHERE `id` <> 32219752 AND `partno` = '7162' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18991331 [ RunTime:0.001129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32219439 LIMIT 5 [ RunTime:0.005455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32219439 ORDER BY `minOrder` ASC [ RunTime:0.001169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32219439 ORDER BY `unit` DESC [ RunTime:0.002973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32219439 LIMIT 2 [ RunTime:0.001388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32219439 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
select * from pdf where partno='7163' and brandshort='keystone electronics' limit 1 [ RunTime:0.000886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7163' OR `brand` LIKE 'keystone electronics%' ) ) LIMIT 1 [ RunTime:0.009453s ]
SELECT `id` FROM `stock` WHERE `id` <> 32219439 AND `partno` = '7163' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.002265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15268375 [ RunTime:0.003838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51102521 LIMIT 5 [ RunTime:0.001359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51102521 ORDER BY `minOrder` ASC [ RunTime:0.001163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51102521 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51102521 LIMIT 2 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51102521 ORDER BY `minOrder` ASC [ RunTime:0.000194s ]
select * from pdf where partno='716' and brandshort='adafruit' limit 1 [ RunTime:0.001325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.005655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090049 LIMIT 5 [ RunTime:0.003593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090049 ORDER BY `minOrder` ASC [ RunTime:0.001408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090049 ORDER BY `unit` DESC [ RunTime:0.002112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090049 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090049 ORDER BY `minOrder` ASC [ RunTime:0.002929s ]
select * from pdf where partno='716425' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.000510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716425' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.002446s ]
SELECT `id` FROM `stock` WHERE `id` <> 51090049 AND `partno` = '716425' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.001687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51089945 LIMIT 5 [ RunTime:0.003797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089945 ORDER BY `minOrder` ASC [ RunTime:0.005120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51089945 ORDER BY `unit` DESC [ RunTime:0.002220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51089945 LIMIT 2 [ RunTime:0.007143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089945 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
select * from pdf where partno='716428' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.003904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716428' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.005059s ]
SELECT `id` FROM `stock` WHERE `id` <> 51089945 AND `partno` = '716428' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51089817 LIMIT 5 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089817 ORDER BY `minOrder` ASC [ RunTime:0.003141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51089817 ORDER BY `unit` DESC [ RunTime:0.008301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51089817 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089817 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
select * from pdf where partno='716430' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.007508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716430' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.002647s ]
SELECT `id` FROM `stock` WHERE `id` <> 51089817 AND `partno` = '716430' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.005007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090050 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090050 ORDER BY `minOrder` ASC [ RunTime:0.002511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090050 ORDER BY `unit` DESC [ RunTime:0.000643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090050 LIMIT 2 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090050 ORDER BY `minOrder` ASC [ RunTime:0.000757s ]
select * from pdf where partno='716429' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.002566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716429' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.001812s ]
SELECT `id` FROM `stock` WHERE `id` <> 51090050 AND `partno` = '716429' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32213719 LIMIT 5 [ RunTime:0.002387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32213719 ORDER BY `minOrder` ASC [ RunTime:0.009776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32213719 ORDER BY `unit` DESC [ RunTime:0.006520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32213719 LIMIT 2 [ RunTime:0.014656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32213719 ORDER BY `minOrder` ASC [ RunTime:0.002691s ]
select * from pdf where partno='716401' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.000803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716401' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.002492s ]
SELECT `id` FROM `stock` WHERE `id` <> 32213719 AND `partno` = '716401' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.003256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51089894 LIMIT 5 [ RunTime:0.022454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089894 ORDER BY `minOrder` ASC [ RunTime:0.016622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51089894 ORDER BY `unit` DESC [ RunTime:0.010802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51089894 LIMIT 2 [ RunTime:0.007355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089894 ORDER BY `minOrder` ASC [ RunTime:0.001210s ]
select * from pdf where partno='716420' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.024870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716420' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.021605s ]
SELECT `id` FROM `stock` WHERE `id` <> 51089894 AND `partno` = '716420' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.006865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32213720 LIMIT 5 [ RunTime:0.005179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32213720 ORDER BY `minOrder` ASC [ RunTime:0.000902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32213720 ORDER BY `unit` DESC [ RunTime:0.000630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32213720 LIMIT 2 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32213720 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='716413' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.007296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716413' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.006666s ]
SELECT `id` FROM `stock` WHERE `id` <> 32213720 AND `partno` = '716413' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.005404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090013 LIMIT 5 [ RunTime:0.000821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090013 ORDER BY `minOrder` ASC [ RunTime:0.000754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090013 ORDER BY `unit` DESC [ RunTime:0.012438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090013 LIMIT 2 [ RunTime:0.026662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090013 ORDER BY `minOrder` ASC [ RunTime:0.009540s ]
select * from pdf where partno='716421' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.002896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716421' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.005985s ]
SELECT `id` FROM `stock` WHERE `id` <> 51090013 AND `partno` = '716421' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.015462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090124 LIMIT 5 [ RunTime:0.004087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090124 ORDER BY `minOrder` ASC [ RunTime:0.003304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090124 ORDER BY `unit` DESC [ RunTime:0.002436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090124 LIMIT 2 [ RunTime:0.006840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090124 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='716410' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.001023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716410' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.002057s ]
SELECT `id` FROM `stock` WHERE `id` <> 51090124 AND `partno` = '716410' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.005075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32213177 [ RunTime:0.005292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32213177 LIMIT 5 [ RunTime:0.008358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32213177 ORDER BY `minOrder` ASC [ RunTime:0.017494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32213177 ORDER BY `unit` DESC [ RunTime:0.009624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32213177 LIMIT 2 [ RunTime:0.025838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32213177 ORDER BY `minOrder` ASC [ RunTime:0.004125s ]
select * from pdf where partno='716410' and brandshort='lutze / amphenol' limit 1 [ RunTime:0.010418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716410' OR `brand` LIKE 'lutze / amphenol%' ) ) LIMIT 1 [ RunTime:0.002852s ]
SELECT `id` FROM `stock` WHERE `id` <> 32213177 AND `partno` = '716410' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lutze / amphenol%' ) [ RunTime:0.004819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090124 [ RunTime:0.008009s ]
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 '716%' OR `brand` LIKE '716%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64563858 LIMIT 5 [ RunTime:0.021171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563858 ORDER BY `minOrder` ASC [ RunTime:0.005135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64563858 ORDER BY `unit` DESC [ RunTime:0.012520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64563858 LIMIT 2 [ RunTime:0.029550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563858 ORDER BY `minOrder` ASC [ RunTime:0.001203s ]
select * from pdf where partno='71607SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71607SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.010461s ]
SELECT `id` FROM `stock` WHERE `id` <> 64563858 AND `partno` = '71607SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352084 [ RunTime:0.004750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50740610 LIMIT 5 [ RunTime:0.004654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50740610 ORDER BY `minOrder` ASC [ RunTime:0.024778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50740610 ORDER BY `unit` DESC [ RunTime:0.011109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50740610 LIMIT 2 [ RunTime:0.005847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50740610 ORDER BY `minOrder` ASC [ RunTime:0.001118s ]
select * from pdf where partno='71651SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71651SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000932s ]
SELECT `id` FROM `stock` WHERE `id` <> 50740610 AND `partno` = '71651SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350672 [ RunTime:0.012981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38142811 LIMIT 5 [ RunTime:0.001877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38142811 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38142811 ORDER BY `unit` DESC [ RunTime:0.008622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38142811 LIMIT 2 [ RunTime:0.003679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38142811 ORDER BY `minOrder` ASC [ RunTime:0.001025s ]
select * from pdf where partno='71651SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71651SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000320s ]
SELECT `id` FROM `stock` WHERE `id` <> 38142811 AND `partno` = '71651SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350672 [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562958 LIMIT 5 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562958 ORDER BY `minOrder` ASC [ RunTime:0.003711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562958 ORDER BY `unit` DESC [ RunTime:0.002039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562958 LIMIT 2 [ RunTime:0.001291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562958 ORDER BY `minOrder` ASC [ RunTime:0.000912s ]
select * from pdf where partno='71606CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71606CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.005317s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562958 AND `partno` = '71606CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351476 [ RunTime:0.002343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561435 LIMIT 5 [ RunTime:0.004803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561435 ORDER BY `minOrder` ASC [ RunTime:0.004011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561435 ORDER BY `unit` DESC [ RunTime:0.000679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561435 LIMIT 2 [ RunTime:0.003310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561435 ORDER BY `minOrder` ASC [ RunTime:0.001063s ]
select * from pdf where partno='71694CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71694CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003694s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561435 AND `partno` = '71694CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.005838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350463 [ RunTime:0.013067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561047 LIMIT 5 [ RunTime:0.006594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561047 ORDER BY `minOrder` ASC [ RunTime:0.007906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561047 ORDER BY `unit` DESC [ RunTime:0.002366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561047 LIMIT 2 [ RunTime:0.007984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561047 ORDER BY `minOrder` ASC [ RunTime:0.009068s ]
select * from pdf where partno='71661CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.012150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71661CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013111s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561047 AND `partno` = '71661CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.019724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067550 [ RunTime:0.008714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50739913 LIMIT 5 [ RunTime:0.000723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50739913 ORDER BY `minOrder` ASC [ RunTime:0.004266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50739913 ORDER BY `unit` DESC [ RunTime:0.007335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50739913 LIMIT 2 [ RunTime:0.006397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50739913 ORDER BY `minOrder` ASC [ RunTime:0.003365s ]
select * from pdf where partno='71686CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71686CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004620s ]
SELECT `id` FROM `stock` WHERE `id` <> 50739913 AND `partno` = '71686CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350239 [ RunTime:0.003122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38141717 LIMIT 5 [ RunTime:0.003745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38141717 ORDER BY `minOrder` ASC [ RunTime:0.006540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38141717 ORDER BY `unit` DESC [ RunTime:0.012958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38141717 LIMIT 2 [ RunTime:0.013398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38141717 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
select * from pdf where partno='71686CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71686CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000508s ]
SELECT `id` FROM `stock` WHERE `id` <> 38141717 AND `partno` = '71686CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350239 [ RunTime:0.001850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59904389 LIMIT 5 [ RunTime:0.003504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59904389 ORDER BY `minOrder` ASC [ RunTime:0.001260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59904389 ORDER BY `unit` DESC [ RunTime:0.000629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59904389 LIMIT 2 [ RunTime:0.010173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59904389 ORDER BY `minOrder` ASC [ RunTime:0.001344s ]
select * from pdf where partno='71600-104LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71600-104LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001840s ]
SELECT `id` FROM `stock` WHERE `id` <> 59904389 AND `partno` = '71600-104LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11611884 [ RunTime:0.004725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64561191 LIMIT 5 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561191 ORDER BY `minOrder` ASC [ RunTime:0.007829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64561191 ORDER BY `unit` DESC [ RunTime:0.013718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64561191 LIMIT 2 [ RunTime:0.003789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64561191 ORDER BY `minOrder` ASC [ RunTime:0.004461s ]
select * from pdf where partno='71679CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.009449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71679CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000913s ]
SELECT `id` FROM `stock` WHERE `id` <> 64561191 AND `partno` = '71679CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067607 [ RunTime:0.001108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64563290 LIMIT 5 [ RunTime:0.002411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563290 ORDER BY `minOrder` ASC [ RunTime:0.011419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64563290 ORDER BY `unit` DESC [ RunTime:0.003802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64563290 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563290 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='71601CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71601CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003968s ]
SELECT `id` FROM `stock` WHERE `id` <> 64563290 AND `partno` = '71601CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065552 [ RunTime:0.003144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64563291 LIMIT 5 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563291 ORDER BY `minOrder` ASC [ RunTime:0.010378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64563291 ORDER BY `unit` DESC [ RunTime:0.000760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64563291 LIMIT 2 [ RunTime:0.012455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563291 ORDER BY `minOrder` ASC [ RunTime:0.009652s ]
select * from pdf where partno='71607CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71607CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001021s ]
SELECT `id` FROM `stock` WHERE `id` <> 64563291 AND `partno` = '71607CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.003686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351682 [ RunTime:0.015964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50740313 LIMIT 5 [ RunTime:0.011688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50740313 ORDER BY `minOrder` ASC [ RunTime:0.002015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50740313 ORDER BY `unit` DESC [ RunTime:0.002288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50740313 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50740313 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='71638SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71638SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.012608s ]
SELECT `id` FROM `stock` WHERE `id` <> 50740313 AND `partno` = '71638SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.003137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38142315 [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38142315 LIMIT 5 [ RunTime:0.001582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38142315 ORDER BY `minOrder` ASC [ RunTime:0.007793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38142315 ORDER BY `unit` DESC [ RunTime:0.003540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38142315 LIMIT 2 [ RunTime:0.011392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38142315 ORDER BY `minOrder` ASC [ RunTime:0.007296s ]
select * from pdf where partno='71638SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.001843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71638SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000334s ]
SELECT `id` FROM `stock` WHERE `id` <> 38142315 AND `partno` = '71638SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50740313 [ RunTime:0.005971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562119 LIMIT 5 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562119 ORDER BY `minOrder` ASC [ RunTime:0.001033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562119 ORDER BY `unit` DESC [ RunTime:0.002422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562119 LIMIT 2 [ RunTime:0.003481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562119 ORDER BY `minOrder` ASC [ RunTime:0.002346s ]
select * from pdf where partno='71691SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71691SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002750s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562119 AND `partno` = '71691SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350938 [ RunTime:0.015605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64563162 LIMIT 5 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563162 ORDER BY `minOrder` ASC [ RunTime:0.007615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64563162 ORDER BY `unit` DESC [ RunTime:0.008726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64563162 LIMIT 2 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64563162 ORDER BY `minOrder` ASC [ RunTime:0.004566s ]
select * from pdf where partno='71626CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.011939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71626CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000762s ]
SELECT `id` FROM `stock` WHERE `id` <> 64563162 AND `partno` = '71626CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13351593 [ RunTime:0.001282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64560107 LIMIT 5 [ RunTime:0.008048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560107 ORDER BY `minOrder` ASC [ RunTime:0.001104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64560107 ORDER BY `unit` DESC [ RunTime:0.005556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64560107 LIMIT 2 [ RunTime:0.004687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64560107 ORDER BY `minOrder` ASC [ RunTime:0.003641s ]
select * from pdf where partno='71651CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71651CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.014792s ]
SELECT `id` FROM `stock` WHERE `id` <> 64560107 AND `partno` = '71651CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.020666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349614 [ RunTime:0.003101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562207 LIMIT 5 [ RunTime:0.005504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562207 ORDER BY `minOrder` ASC [ RunTime:0.001091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562207 ORDER BY `unit` DESC [ RunTime:0.006453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562207 LIMIT 2 [ RunTime:0.001049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562207 ORDER BY `minOrder` ASC [ RunTime:0.005621s ]
select * from pdf where partno='71669SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.005588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71669SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001219s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562207 AND `partno` = '71669SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13350986 [ RunTime:0.003847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58726241 LIMIT 5 [ RunTime:0.002861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726241 ORDER BY `minOrder` ASC [ RunTime:0.003361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58726241 ORDER BY `unit` DESC [ RunTime:0.002244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58726241 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726241 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='716W-X2/03' and brandshort='Qualtek' limit 1 [ RunTime:0.011159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '716W-X2/03' OR `brand` LIKE 'Qualtek%' ) ) LIMIT 1 [ RunTime:0.001353s ]
SELECT `id` FROM `stock` WHERE `id` <> 58726241 AND `partno` = '716W-X2/03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%qualtek%' ) [ RunTime:0.002387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13112095 [ RunTime:0.016611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59904896 LIMIT 5 [ RunTime:0.016148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59904896 ORDER BY `minOrder` ASC [ RunTime:0.003234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59904896 ORDER BY `unit` DESC [ RunTime:0.002648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59904896 LIMIT 2 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59904896 ORDER BY `minOrder` ASC [ RunTime:0.001042s ]
select * from pdf where partno='71600-604LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.008934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '71600-604LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000816s ]
SELECT `id` FROM `stock` WHERE `id` <> 59904896 AND `partno` = '71600-604LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801584 [ RunTime:0.000591s ]
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 '716%' OR `brand` LIKE '716%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006970s ]
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 '716%' OR `brand` LIKE '716%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001402s ]
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 '716%' OR `brand` LIKE '716%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001277s ]
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 '716%' OR `brand` LIKE '716%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002746s ]
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 '716%' OR `brand` LIKE '716%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001069s ]
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 '716%' OR `brand` LIKE '716%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009559s ]
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 '716%' OR `brand` LIKE '716%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007166s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '716%' OR `brand` LIKE '716%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016516s ]