SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002120s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=14011&search=1' [ RunTime:0.005545s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002013s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.014663s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002151s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.013325s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001886s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010057s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002602s ]
SELECT * FROM `stock_search` WHERE `partno` = '14011' LIMIT 1 [ RunTime:0.056354s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 16:50:43' WHERE `partno` = '14011' [ RunTime:0.017751s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.007463s ]
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 '14011%' OR `brand` LIKE '14011%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077934s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.017188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12558919 LIMIT 5 [ RunTime:0.031000s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.035705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12558919 ORDER BY `minOrder` ASC [ RunTime:0.051858s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12558919 ORDER BY `unit` DESC [ RunTime:0.017294s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.038951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12558919 LIMIT 2 [ RunTime:0.026873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12558919 ORDER BY `minOrder` ASC [ RunTime:0.019707s ]
select * from pdf where partno='14011013101000' and brandshort='HARTING' limit 1 [ RunTime:0.024761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544379 LIMIT 5 [ RunTime:0.020124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544379 ORDER BY `minOrder` ASC [ RunTime:0.062640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12544379 ORDER BY `unit` DESC [ RunTime:0.050877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12544379 LIMIT 2 [ RunTime:0.030416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544379 ORDER BY `minOrder` ASC [ RunTime:0.018329s ]
select * from pdf where partno='14011213101000' and brandshort='HARTING' limit 1 [ RunTime:0.018481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11435308 LIMIT 5 [ RunTime:0.019030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435308 ORDER BY `minOrder` ASC [ RunTime:0.013319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11435308 ORDER BY `unit` DESC [ RunTime:0.015251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11435308 LIMIT 2 [ RunTime:0.023060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435308 ORDER BY `minOrder` ASC [ RunTime:0.030830s ]
select * from pdf where partno='14011113101000' and brandshort='HARTING' limit 1 [ RunTime:0.015415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12555896 LIMIT 5 [ RunTime:0.008943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12555896 ORDER BY `minOrder` ASC [ RunTime:0.003877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12555896 ORDER BY `unit` DESC [ RunTime:0.000869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12555896 LIMIT 2 [ RunTime:0.001856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12555896 ORDER BY `minOrder` ASC [ RunTime:0.009621s ]
select * from pdf where partno='14011013102000' and brandshort='HARTING' limit 1 [ RunTime:0.010500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369699 LIMIT 5 [ RunTime:0.016170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17369699 ORDER BY `minOrder` ASC [ RunTime:0.012199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17369699 ORDER BY `unit` DESC [ RunTime:0.003231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17369699 LIMIT 2 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17369699 ORDER BY `minOrder` ASC [ RunTime:0.008437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022860 LIMIT 5 [ RunTime:0.005379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022860 ORDER BY `minOrder` ASC [ RunTime:0.000880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19022860 ORDER BY `unit` DESC [ RunTime:0.000767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19022860 LIMIT 2 [ RunTime:0.002873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022860 ORDER BY `minOrder` ASC [ RunTime:0.001465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071975 LIMIT 5 [ RunTime:0.001839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071975 ORDER BY `minOrder` ASC [ RunTime:0.000713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071975 ORDER BY `unit` DESC [ RunTime:0.016195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071975 LIMIT 2 [ RunTime:0.003574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071975 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071774 LIMIT 5 [ RunTime:0.001151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071774 ORDER BY `minOrder` ASC [ RunTime:0.007799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20071774 ORDER BY `unit` DESC [ RunTime:0.000875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20071774 LIMIT 2 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20071774 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354060 LIMIT 5 [ RunTime:0.001063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354060 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16354060 ORDER BY `unit` DESC [ RunTime:0.011818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16354060 LIMIT 2 [ RunTime:0.011143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354060 ORDER BY `minOrder` ASC [ RunTime:0.004979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13786817 LIMIT 5 [ RunTime:0.004634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13786817 ORDER BY `minOrder` ASC [ RunTime:0.009006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13786817 ORDER BY `unit` DESC [ RunTime:0.003331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13786817 LIMIT 2 [ RunTime:0.001956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13786817 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442984 LIMIT 5 [ RunTime:0.000765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442984 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11442984 ORDER BY `unit` DESC [ RunTime:0.009440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11442984 LIMIT 2 [ RunTime:0.007177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442984 ORDER BY `minOrder` ASC [ RunTime:0.007200s ]
select * from pdf where partno='14011213102000' and brandshort='HARTING' limit 1 [ RunTime:0.006305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19141173 LIMIT 5 [ RunTime:0.011208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19141173 ORDER BY `minOrder` ASC [ RunTime:0.018458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19141173 ORDER BY `unit` DESC [ RunTime:0.014069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19141173 LIMIT 2 [ RunTime:0.006382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19141173 ORDER BY `minOrder` ASC [ RunTime:0.010492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258125 LIMIT 5 [ RunTime:0.005860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258125 ORDER BY `minOrder` ASC [ RunTime:0.004809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14258125 ORDER BY `unit` DESC [ RunTime:0.003759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14258125 LIMIT 2 [ RunTime:0.000689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258125 ORDER BY `minOrder` ASC [ RunTime:0.001983s ]
select * from pdf where partno='14011' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.001467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651200 LIMIT 5 [ RunTime:0.005162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651200 ORDER BY `minOrder` ASC [ RunTime:0.010148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19651200 ORDER BY `unit` DESC [ RunTime:0.028660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19651200 LIMIT 2 [ RunTime:0.011495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651200 ORDER BY `minOrder` ASC [ RunTime:0.005611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022932 LIMIT 5 [ RunTime:0.003966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022932 ORDER BY `minOrder` ASC [ RunTime:0.009333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19022932 ORDER BY `unit` DESC [ RunTime:0.004226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19022932 LIMIT 2 [ RunTime:0.001794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022932 ORDER BY `minOrder` ASC [ RunTime:0.006477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18993123 LIMIT 5 [ RunTime:0.017418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18993123 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18993123 ORDER BY `unit` DESC [ RunTime:0.000492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18993123 LIMIT 2 [ RunTime:0.011952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18993123 ORDER BY `minOrder` ASC [ RunTime:0.009398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17501902 LIMIT 5 [ RunTime:0.003613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17501902 ORDER BY `minOrder` ASC [ RunTime:0.008567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17501902 ORDER BY `unit` DESC [ RunTime:0.008600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17501902 LIMIT 2 [ RunTime:0.006997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17501902 ORDER BY `minOrder` ASC [ RunTime:0.004928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16355738 LIMIT 5 [ RunTime:0.024636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16355738 ORDER BY `minOrder` ASC [ RunTime:0.008315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16355738 ORDER BY `unit` DESC [ RunTime:0.010968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16355738 LIMIT 2 [ RunTime:0.009121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16355738 ORDER BY `minOrder` ASC [ RunTime:0.001979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695543 LIMIT 5 [ RunTime:0.004173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695543 ORDER BY `minOrder` ASC [ RunTime:0.007375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14695543 ORDER BY `unit` DESC [ RunTime:0.002327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14695543 LIMIT 2 [ RunTime:0.007695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14695543 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203028 LIMIT 5 [ RunTime:0.003167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203028 ORDER BY `minOrder` ASC [ RunTime:0.001730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14203028 ORDER BY `unit` DESC [ RunTime:0.002392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14203028 LIMIT 2 [ RunTime:0.007857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203028 ORDER BY `minOrder` ASC [ RunTime:0.006273s ]
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 '14011%' OR `brand` LIKE '14011%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003229s ]
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 '14011%' OR `brand` LIKE '14011%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560933 LIMIT 5 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560933 ORDER BY `minOrder` ASC [ RunTime:0.002171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560933 ORDER BY `unit` DESC [ RunTime:0.002158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560933 LIMIT 2 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560933 ORDER BY `minOrder` ASC [ RunTime:0.000723s ]
select * from pdf where partno='14011113102000' and brandshort='HARTING' limit 1 [ RunTime:0.000440s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14011113102000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005066s ]
SELECT `id` FROM `stock` WHERE `id` <> 60560933 AND `partno` = '14011113102000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.005779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560897 LIMIT 5 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560897 ORDER BY `minOrder` ASC [ RunTime:0.000190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560897 ORDER BY `unit` DESC [ RunTime:0.000170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560897 LIMIT 2 [ RunTime:0.000267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560897 ORDER BY `minOrder` ASC [ RunTime:0.001564s ]
select * from pdf where partno='14011013102000' and brandshort='HARTING' limit 1 [ RunTime:0.000463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14011013102000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.000214s ]
SELECT `id` FROM `stock` WHERE `id` <> 60560897 AND `partno` = '14011013102000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12555896 [ RunTime:0.000199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560969 LIMIT 5 [ RunTime:0.001381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560969 ORDER BY `minOrder` ASC [ RunTime:0.013468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560969 ORDER BY `unit` DESC [ RunTime:0.003507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560969 LIMIT 2 [ RunTime:0.001391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560969 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='14011213101000' and brandshort='HARTING' limit 1 [ RunTime:0.000728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14011213101000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.009848s ]
SELECT `id` FROM `stock` WHERE `id` <> 60560969 AND `partno` = '14011213101000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.022252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544379 [ RunTime:0.003096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560904 LIMIT 5 [ RunTime:0.008396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560904 ORDER BY `minOrder` ASC [ RunTime:0.010532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560904 ORDER BY `unit` DESC [ RunTime:0.000739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560904 LIMIT 2 [ RunTime:0.004120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560904 ORDER BY `minOrder` ASC [ RunTime:0.006811s ]
select * from pdf where partno='14011013101000' and brandshort='HARTING' limit 1 [ RunTime:0.004923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14011013101000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.017867s ]
SELECT `id` FROM `stock` WHERE `id` <> 60560904 AND `partno` = '14011013101000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12558919 [ RunTime:0.000710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60629585 LIMIT 5 [ RunTime:0.008561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629585 ORDER BY `minOrder` ASC [ RunTime:0.041846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60629585 ORDER BY `unit` DESC [ RunTime:0.022529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60629585 LIMIT 2 [ RunTime:0.026337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629585 ORDER BY `minOrder` ASC [ RunTime:0.024683s ]
select * from pdf where partno='1401145' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401145' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560945 LIMIT 5 [ RunTime:0.022195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560945 ORDER BY `minOrder` ASC [ RunTime:0.028151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560945 ORDER BY `unit` DESC [ RunTime:0.029728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560945 LIMIT 2 [ RunTime:0.034691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560945 ORDER BY `minOrder` ASC [ RunTime:0.006849s ]
select * from pdf where partno='14011113101000' and brandshort='HARTING' limit 1 [ RunTime:0.003662s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14011113101000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.017500s ]
SELECT `id` FROM `stock` WHERE `id` <> 60560945 AND `partno` = '14011113101000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.017768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11435308 [ RunTime:0.016710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60629761 LIMIT 5 [ RunTime:0.033765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629761 ORDER BY `minOrder` ASC [ RunTime:0.008847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60629761 ORDER BY `unit` DESC [ RunTime:0.030843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60629761 LIMIT 2 [ RunTime:0.001781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629761 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='1401158' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.027176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401158' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60629991 LIMIT 5 [ RunTime:0.013415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629991 ORDER BY `minOrder` ASC [ RunTime:0.006247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60629991 ORDER BY `unit` DESC [ RunTime:0.001579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60629991 LIMIT 2 [ RunTime:0.005703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629991 ORDER BY `minOrder` ASC [ RunTime:0.006234s ]
select * from pdf where partno='1401161' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401161' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64414353 LIMIT 5 [ RunTime:0.003912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64414353 ORDER BY `minOrder` ASC [ RunTime:0.005093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64414353 ORDER BY `unit` DESC [ RunTime:0.013120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64414353 LIMIT 2 [ RunTime:0.000867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64414353 ORDER BY `minOrder` ASC [ RunTime:0.002156s ]
select * from pdf where partno='14011' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.008703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14011' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.014325s ]
SELECT `id` FROM `stock` WHERE `id` <> 64414353 AND `partno` = '14011' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.001789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258125 [ RunTime:0.000506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418798 LIMIT 5 [ RunTime:0.002565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418798 ORDER BY `minOrder` ASC [ RunTime:0.028393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418798 ORDER BY `unit` DESC [ RunTime:0.004756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418798 LIMIT 2 [ RunTime:0.009711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418798 ORDER BY `minOrder` ASC [ RunTime:0.008015s ]
select * from pdf where partno='1401110012KE' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.031930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401110012KE' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.014335s ]
SELECT `id` FROM `stock` WHERE `id` <> 60418798 AND `partno` = '1401110012KE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.016971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17369699 [ RunTime:0.007545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64483998 LIMIT 5 [ RunTime:0.030271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64483998 ORDER BY `minOrder` ASC [ RunTime:0.027746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64483998 ORDER BY `unit` DESC [ RunTime:0.024400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64483998 LIMIT 2 [ RunTime:0.004933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64483998 ORDER BY `minOrder` ASC [ RunTime:0.022952s ]
select * from pdf where partno='140116400' and brandshort='Essentra Access Solutions' limit 1 [ RunTime:0.060245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '140116400' OR `brand` LIKE 'Essentra Access Solutions%' ) ) LIMIT 1 [ RunTime:0.046016s ]
SELECT `id` FROM `stock` WHERE `id` <> 64483998 AND `partno` = '140116400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra access solutions%' ) [ RunTime:0.061365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022860 [ RunTime:0.026227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60419366 LIMIT 5 [ RunTime:0.111686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419366 ORDER BY `minOrder` ASC [ RunTime:0.038495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60419366 ORDER BY `unit` DESC [ RunTime:0.024922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60419366 LIMIT 2 [ RunTime:0.103877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60419366 ORDER BY `minOrder` ASC [ RunTime:0.021545s ]
select * from pdf where partno='1401106113KE' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.028834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401106113KE' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.043280s ]
SELECT `id` FROM `stock` WHERE `id` <> 60419366 AND `partno` = '1401106113KE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.032390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071975 [ RunTime:0.050023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418942 LIMIT 5 [ RunTime:0.058261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418942 ORDER BY `minOrder` ASC [ RunTime:0.050177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418942 ORDER BY `unit` DESC [ RunTime:0.167231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418942 LIMIT 2 [ RunTime:0.186963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418942 ORDER BY `minOrder` ASC [ RunTime:0.104533s ]
select * from pdf where partno='1401115512KE' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.058348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401115512KE' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.116940s ]
SELECT `id` FROM `stock` WHERE `id` <> 60418942 AND `partno` = '1401115512KE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.053860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354060 [ RunTime:0.084249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60418937 LIMIT 5 [ RunTime:0.038676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418937 ORDER BY `minOrder` ASC [ RunTime:0.101335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60418937 ORDER BY `unit` DESC [ RunTime:0.042397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60418937 LIMIT 2 [ RunTime:0.029933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60418937 ORDER BY `minOrder` ASC [ RunTime:0.088664s ]
select * from pdf where partno='1401140012KE' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.031295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401140012KE' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.032485s ]
SELECT `id` FROM `stock` WHERE `id` <> 60418937 AND `partno` = '1401140012KE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.035624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20071774 [ RunTime:0.037311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64437710 LIMIT 5 [ RunTime:0.010044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64437710 ORDER BY `minOrder` ASC [ RunTime:0.023952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64437710 ORDER BY `unit` DESC [ RunTime:0.044291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64437710 LIMIT 2 [ RunTime:0.055132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64437710 ORDER BY `minOrder` ASC [ RunTime:0.024845s ]
select * from pdf where partno='1401199' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401199' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64484101 LIMIT 5 [ RunTime:0.031972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484101 ORDER BY `minOrder` ASC [ RunTime:0.046628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64484101 ORDER BY `unit` DESC [ RunTime:0.017162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64484101 LIMIT 2 [ RunTime:0.000991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484101 ORDER BY `minOrder` ASC [ RunTime:0.004147s ]
select * from pdf where partno='140119400' and brandshort='Essentra Access Solutions' limit 1 [ RunTime:0.016935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '140119400' OR `brand` LIKE 'Essentra Access Solutions%' ) ) LIMIT 1 [ RunTime:0.009537s ]
SELECT `id` FROM `stock` WHERE `id` <> 64484101 AND `partno` = '140119400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra access solutions%' ) [ RunTime:0.039286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203028 [ RunTime:0.018648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64484096 LIMIT 5 [ RunTime:0.019457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484096 ORDER BY `minOrder` ASC [ RunTime:0.012997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64484096 ORDER BY `unit` DESC [ RunTime:0.007803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64484096 LIMIT 2 [ RunTime:0.006078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484096 ORDER BY `minOrder` ASC [ RunTime:0.008574s ]
select * from pdf where partno='140119300' and brandshort='Essentra Access Solutions' limit 1 [ RunTime:0.015299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '140119300' OR `brand` LIKE 'Essentra Access Solutions%' ) ) LIMIT 1 [ RunTime:0.024013s ]
SELECT `id` FROM `stock` WHERE `id` <> 64484096 AND `partno` = '140119300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra access solutions%' ) [ RunTime:0.054435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022932 [ RunTime:0.033017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63455084 LIMIT 5 [ RunTime:0.034387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63455084 ORDER BY `minOrder` ASC [ RunTime:0.041327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63455084 ORDER BY `unit` DESC [ RunTime:0.002604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63455084 LIMIT 2 [ RunTime:0.040048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63455084 ORDER BY `minOrder` ASC [ RunTime:0.009848s ]
select * from pdf where partno='1401145512KE' and brandshort='METZ CONNECT USA Inc.' limit 1 [ RunTime:0.034753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1401145512KE' OR `brand` LIKE 'METZ CONNECT USA Inc.%' ) ) LIMIT 1 [ RunTime:0.022436s ]
SELECT `id` FROM `stock` WHERE `id` <> 63455084 AND `partno` = '1401145512KE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%metz connect usa inc.%' ) [ RunTime:0.015067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18993123 [ RunTime:0.013460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63413937 LIMIT 5 [ RunTime:0.031803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63413937 ORDER BY `minOrder` ASC [ RunTime:0.010825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63413937 ORDER BY `unit` DESC [ RunTime:0.009309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63413937 LIMIT 2 [ RunTime:0.030654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63413937 ORDER BY `minOrder` ASC [ RunTime:0.014268s ]
select * from pdf where partno='14011' and brandshort='80/20, LLC' limit 1 [ RunTime:0.011487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14011' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.006358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63091132 LIMIT 5 [ RunTime:0.017170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63091132 ORDER BY `minOrder` ASC [ RunTime:0.031512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63091132 ORDER BY `unit` DESC [ RunTime:0.021472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63091132 LIMIT 2 [ RunTime:0.041937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63091132 ORDER BY `minOrder` ASC [ RunTime:0.001233s ]
select * from pdf where partno='14011B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.032307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '14011B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.033087s ]
SELECT `id` FROM `stock` WHERE `id` <> 63091132 AND `partno` = '14011B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.054656s ]
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 '14011%' OR `brand` LIKE '14011%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050394s ]
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 '14011%' OR `brand` LIKE '14011%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009552s ]
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 '14011%' OR `brand` LIKE '14011%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047850s ]
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 '14011%' OR `brand` LIKE '14011%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033303s ]
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 '14011%' OR `brand` LIKE '14011%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013865s ]
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 '14011%' OR `brand` LIKE '14011%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007611s ]
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 '14011%' OR `brand` LIKE '14011%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029683s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '14011%' OR `brand` LIKE '14011%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008012s ]