SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001479s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.103' , `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=1945&search=1' [ RunTime:0.008517s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001395s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010777s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001847s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.103' ) [ RunTime:0.004923s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003581s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007608s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001874s ]
SELECT * FROM `stock_search` WHERE `partno` = '1945' LIMIT 1 [ RunTime:0.028530s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 13:09:26' WHERE `partno` = '1945' [ RunTime:0.039861s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002629s ]
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 '1945%' OR `brand` LIKE '1945%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083949s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606443 LIMIT 5 [ RunTime:0.021360s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606443 ORDER BY `minOrder` ASC [ RunTime:0.022778s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606443 ORDER BY `unit` DESC [ RunTime:0.032511s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606443 LIMIT 2 [ RunTime:0.011458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606443 ORDER BY `minOrder` ASC [ RunTime:0.025344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605122 LIMIT 5 [ RunTime:0.068661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605122 ORDER BY `minOrder` ASC [ RunTime:0.016967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605122 ORDER BY `unit` DESC [ RunTime:0.028482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605122 LIMIT 2 [ RunTime:0.067368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605122 ORDER BY `minOrder` ASC [ RunTime:0.003191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17312008 LIMIT 5 [ RunTime:0.135709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17312008 ORDER BY `minOrder` ASC [ RunTime:0.043888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17312008 ORDER BY `unit` DESC [ RunTime:0.088267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17312008 LIMIT 2 [ RunTime:0.120845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17312008 ORDER BY `minOrder` ASC [ RunTime:0.021859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591597 LIMIT 5 [ RunTime:0.060333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591597 ORDER BY `minOrder` ASC [ RunTime:0.102202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591597 ORDER BY `unit` DESC [ RunTime:0.092646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591597 LIMIT 2 [ RunTime:0.112493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591597 ORDER BY `minOrder` ASC [ RunTime:0.041757s ]
select * from pdf where partno='1945-0-00-15-00-00-03-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.029433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308882 LIMIT 5 [ RunTime:0.116600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308882 ORDER BY `minOrder` ASC [ RunTime:0.116649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13308882 ORDER BY `unit` DESC [ RunTime:0.081716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13308882 LIMIT 2 [ RunTime:0.130882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308882 ORDER BY `minOrder` ASC [ RunTime:0.046919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605156 LIMIT 5 [ RunTime:0.036329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605156 ORDER BY `minOrder` ASC [ RunTime:0.104170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605156 ORDER BY `unit` DESC [ RunTime:0.036425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605156 LIMIT 2 [ RunTime:0.040034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605156 ORDER BY `minOrder` ASC [ RunTime:0.043883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661996 LIMIT 5 [ RunTime:0.055630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661996 ORDER BY `minOrder` ASC [ RunTime:0.023734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19661996 ORDER BY `unit` DESC [ RunTime:0.011008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19661996 LIMIT 2 [ RunTime:0.066094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661996 ORDER BY `minOrder` ASC [ RunTime:0.045310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605143 LIMIT 5 [ RunTime:0.057961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605143 ORDER BY `minOrder` ASC [ RunTime:0.075563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605143 ORDER BY `unit` DESC [ RunTime:0.073219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605143 LIMIT 2 [ RunTime:0.042058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605143 ORDER BY `minOrder` ASC [ RunTime:0.050164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606506 LIMIT 5 [ RunTime:0.039948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606506 ORDER BY `minOrder` ASC [ RunTime:0.054390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606506 ORDER BY `unit` DESC [ RunTime:0.033405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606506 LIMIT 2 [ RunTime:0.049197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606506 ORDER BY `minOrder` ASC [ RunTime:0.069147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14310544 LIMIT 5 [ RunTime:0.036245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14310544 ORDER BY `minOrder` ASC [ RunTime:0.040948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14310544 ORDER BY `unit` DESC [ RunTime:0.033319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14310544 LIMIT 2 [ RunTime:0.111424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14310544 ORDER BY `minOrder` ASC [ RunTime:0.018495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348924 LIMIT 5 [ RunTime:0.002737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348924 ORDER BY `minOrder` ASC [ RunTime:0.039616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348924 ORDER BY `unit` DESC [ RunTime:0.031649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348924 LIMIT 2 [ RunTime:0.038166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348924 ORDER BY `minOrder` ASC [ RunTime:0.053842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13416311 LIMIT 5 [ RunTime:0.030886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13416311 ORDER BY `minOrder` ASC [ RunTime:0.035728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13416311 ORDER BY `unit` DESC [ RunTime:0.030041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13416311 LIMIT 2 [ RunTime:0.026937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13416311 ORDER BY `minOrder` ASC [ RunTime:0.023559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13416266 LIMIT 5 [ RunTime:0.034561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13416266 ORDER BY `minOrder` ASC [ RunTime:0.014739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13416266 ORDER BY `unit` DESC [ RunTime:0.034158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13416266 LIMIT 2 [ RunTime:0.027396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13416266 ORDER BY `minOrder` ASC [ RunTime:0.020374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605239 LIMIT 5 [ RunTime:0.006330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605239 ORDER BY `minOrder` ASC [ RunTime:0.015045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605239 ORDER BY `unit` DESC [ RunTime:0.026464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605239 LIMIT 2 [ RunTime:0.029128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605239 ORDER BY `minOrder` ASC [ RunTime:0.005076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15453417 LIMIT 5 [ RunTime:0.016207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15453417 ORDER BY `minOrder` ASC [ RunTime:0.003565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15453417 ORDER BY `unit` DESC [ RunTime:0.016008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15453417 LIMIT 2 [ RunTime:0.022123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15453417 ORDER BY `minOrder` ASC [ RunTime:0.011102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15444309 LIMIT 5 [ RunTime:0.017160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15444309 ORDER BY `minOrder` ASC [ RunTime:0.024380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15444309 ORDER BY `unit` DESC [ RunTime:0.020976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15444309 LIMIT 2 [ RunTime:0.005831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15444309 ORDER BY `minOrder` ASC [ RunTime:0.003475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13416343 LIMIT 5 [ RunTime:0.003418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13416343 ORDER BY `minOrder` ASC [ RunTime:0.004011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13416343 ORDER BY `unit` DESC [ RunTime:0.010346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13416343 LIMIT 2 [ RunTime:0.020028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13416343 ORDER BY `minOrder` ASC [ RunTime:0.010785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605741 LIMIT 5 [ RunTime:0.025210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605741 ORDER BY `minOrder` ASC [ RunTime:0.018420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605741 ORDER BY `unit` DESC [ RunTime:0.009499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605741 LIMIT 2 [ RunTime:0.005757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605741 ORDER BY `minOrder` ASC [ RunTime:0.008038s ]
select * from pdf where partno='1945216' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16148593 LIMIT 5 [ RunTime:0.025957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148593 ORDER BY `minOrder` ASC [ RunTime:0.011608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16148593 ORDER BY `unit` DESC [ RunTime:0.010854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16148593 LIMIT 2 [ RunTime:0.008135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148593 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16148409 LIMIT 5 [ RunTime:0.000869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148409 ORDER BY `minOrder` ASC [ RunTime:0.019337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16148409 ORDER BY `unit` DESC [ RunTime:0.010545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16148409 LIMIT 2 [ RunTime:0.005605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148409 ORDER BY `minOrder` ASC [ RunTime:0.007958s ]
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 '1945%' OR `brand` LIKE '1945%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090569 LIMIT 5 [ RunTime:0.010019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090569 ORDER BY `minOrder` ASC [ RunTime:0.031983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090569 ORDER BY `unit` DESC [ RunTime:0.009754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090569 LIMIT 2 [ RunTime:0.027580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090569 ORDER BY `minOrder` ASC [ RunTime:0.008958s ]
select * from pdf where partno='19450-01m' and brandshort='bussmann / eaton' limit 1 [ RunTime:0.043969s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.006054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19450-01m' OR `brand` LIKE 'bussmann / eaton%' ) ) LIMIT 1 [ RunTime:0.009606s ]
SELECT `id` FROM `stock` WHERE `id` <> 51090569 AND `partno` = '19450-01m' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bussmann / eaton%' ) [ RunTime:0.012545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275295 LIMIT 5 [ RunTime:0.008660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275295 ORDER BY `minOrder` ASC [ RunTime:0.007017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275295 ORDER BY `unit` DESC [ RunTime:0.003176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275295 LIMIT 2 [ RunTime:0.045306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275295 ORDER BY `minOrder` ASC [ RunTime:0.008515s ]
select * from pdf where partno='1945041' and brandshort='phoenix contact' limit 1 [ RunTime:0.036002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945041' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.015571s ]
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 '1945%' OR `brand` LIKE '1945%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60477795 LIMIT 5 [ RunTime:0.008034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477795 ORDER BY `minOrder` ASC [ RunTime:0.021919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60477795 ORDER BY `unit` DESC [ RunTime:0.016470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60477795 LIMIT 2 [ RunTime:0.015944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477795 ORDER BY `minOrder` ASC [ RunTime:0.005031s ]
select * from pdf where partno='1945119' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945119' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.024408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60310600 LIMIT 5 [ RunTime:0.029764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60310600 ORDER BY `minOrder` ASC [ RunTime:0.010052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60310600 ORDER BY `unit` DESC [ RunTime:0.001060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60310600 LIMIT 2 [ RunTime:0.012322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60310600 ORDER BY `minOrder` ASC [ RunTime:0.011281s ]
select * from pdf where partno='1945-0-00-15-00-00-03-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.006571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945-0-00-15-00-00-03-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.009630s ]
SELECT `id` FROM `stock` WHERE `id` <> 60310600 AND `partno` = '1945-0-00-15-00-00-03-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.006420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591597 [ RunTime:0.011967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63390602 LIMIT 5 [ RunTime:0.016218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390602 ORDER BY `minOrder` ASC [ RunTime:0.033985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63390602 ORDER BY `unit` DESC [ RunTime:0.003243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63390602 LIMIT 2 [ RunTime:0.005767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390602 ORDER BY `minOrder` ASC [ RunTime:0.003123s ]
select * from pdf where partno='1945' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.008017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.002766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60477790 LIMIT 5 [ RunTime:0.012714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477790 ORDER BY `minOrder` ASC [ RunTime:0.019240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60477790 ORDER BY `unit` DESC [ RunTime:0.015834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60477790 LIMIT 2 [ RunTime:0.011073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477790 ORDER BY `minOrder` ASC [ RunTime:0.000891s ]
select * from pdf where partno='1945106' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945106' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.028698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478362 LIMIT 5 [ RunTime:0.001236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478362 ORDER BY `minOrder` ASC [ RunTime:0.018529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478362 ORDER BY `unit` DESC [ RunTime:0.008290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478362 LIMIT 2 [ RunTime:0.011359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478362 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='1945122' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945122' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.014992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60477825 LIMIT 5 [ RunTime:0.003830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477825 ORDER BY `minOrder` ASC [ RunTime:0.006491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60477825 ORDER BY `unit` DESC [ RunTime:0.019352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60477825 LIMIT 2 [ RunTime:0.002185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60477825 ORDER BY `minOrder` ASC [ RunTime:0.007323s ]
select * from pdf where partno='1945151' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945151' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60479803 LIMIT 5 [ RunTime:0.002433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479803 ORDER BY `minOrder` ASC [ RunTime:0.006685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60479803 ORDER BY `unit` DESC [ RunTime:0.005089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60479803 LIMIT 2 [ RunTime:0.005320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479803 ORDER BY `minOrder` ASC [ RunTime:0.000956s ]
select * from pdf where partno='1945148' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945148' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559175 LIMIT 5 [ RunTime:0.007743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559175 ORDER BY `minOrder` ASC [ RunTime:0.002995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559175 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559175 LIMIT 2 [ RunTime:0.010760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559175 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
select * from pdf where partno='1945CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.015400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002776s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559175 AND `partno` = '1945CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.004940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348924 [ RunTime:0.004611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40475585 LIMIT 5 [ RunTime:0.004373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475585 ORDER BY `minOrder` ASC [ RunTime:0.001698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40475585 ORDER BY `unit` DESC [ RunTime:0.001004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40475585 LIMIT 2 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475585 ORDER BY `minOrder` ASC [ RunTime:0.005900s ]
select * from pdf where partno='1945-20J' and brandshort='Delevan' limit 1 [ RunTime:0.008742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945-20J' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.001004s ]
SELECT `id` FROM `stock` WHERE `id` <> 40475585 AND `partno` = '1945-20J' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.005461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14310544 [ RunTime:0.010123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40475586 LIMIT 5 [ RunTime:0.005179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475586 ORDER BY `minOrder` ASC [ RunTime:0.004362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40475586 ORDER BY `unit` DESC [ RunTime:0.010731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40475586 LIMIT 2 [ RunTime:0.008673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475586 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='1945-31J' and brandshort='Delevan' limit 1 [ RunTime:0.003694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945-31J' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.002684s ]
SELECT `id` FROM `stock` WHERE `id` <> 40475586 AND `partno` = '1945-31J' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.012115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13416311 [ RunTime:0.011287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40475587 LIMIT 5 [ RunTime:0.002506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475587 ORDER BY `minOrder` ASC [ RunTime:0.005374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40475587 ORDER BY `unit` DESC [ RunTime:0.003256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40475587 LIMIT 2 [ RunTime:0.004569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475587 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
select * from pdf where partno='1945-39J' and brandshort='Delevan' limit 1 [ RunTime:0.000485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945-39J' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.001538s ]
SELECT `id` FROM `stock` WHERE `id` <> 40475587 AND `partno` = '1945-39J' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.004629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13416266 [ RunTime:0.002463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484532 LIMIT 5 [ RunTime:0.003590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484532 ORDER BY `minOrder` ASC [ RunTime:0.003421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484532 ORDER BY `unit` DESC [ RunTime:0.001206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484532 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484532 ORDER BY `minOrder` ASC [ RunTime:0.001475s ]
select * from pdf where partno='1945135' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945135' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40475588 LIMIT 5 [ RunTime:0.014607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475588 ORDER BY `minOrder` ASC [ RunTime:0.002483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40475588 ORDER BY `unit` DESC [ RunTime:0.026837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40475588 LIMIT 2 [ RunTime:0.010815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475588 ORDER BY `minOrder` ASC [ RunTime:0.009478s ]
select * from pdf where partno='1945-08K' and brandshort='Delevan' limit 1 [ RunTime:0.007154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945-08K' OR `brand` LIKE 'Delevan%' ) ) LIMIT 1 [ RunTime:0.014747s ]
SELECT `id` FROM `stock` WHERE `id` <> 40475588 AND `partno` = '1945-08K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%delevan%' ) [ RunTime:0.004089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13416343 [ RunTime:0.001294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484533 LIMIT 5 [ RunTime:0.010687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484533 ORDER BY `minOrder` ASC [ RunTime:0.002646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484533 ORDER BY `unit` DESC [ RunTime:0.018797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484533 LIMIT 2 [ RunTime:0.007654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484533 ORDER BY `minOrder` ASC [ RunTime:0.002786s ]
select * from pdf where partno='1945177' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945177' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60479946 LIMIT 5 [ RunTime:0.009919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479946 ORDER BY `minOrder` ASC [ RunTime:0.018611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60479946 ORDER BY `unit` DESC [ RunTime:0.021958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60479946 LIMIT 2 [ RunTime:0.025488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479946 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='1945216' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945216' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478688 LIMIT 5 [ RunTime:0.008457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478688 ORDER BY `minOrder` ASC [ RunTime:0.012315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478688 ORDER BY `unit` DESC [ RunTime:0.016998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478688 LIMIT 2 [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478688 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='1945232' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.018886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945232' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478546 LIMIT 5 [ RunTime:0.008620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478546 ORDER BY `minOrder` ASC [ RunTime:0.003262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478546 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478546 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478546 ORDER BY `minOrder` ASC [ RunTime:0.002170s ]
select * from pdf where partno='1945193' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945193' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60480202 LIMIT 5 [ RunTime:0.000800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480202 ORDER BY `minOrder` ASC [ RunTime:0.001220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60480202 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60480202 LIMIT 2 [ RunTime:0.003479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480202 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
select * from pdf where partno='1945080000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945080000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004777s ]
SELECT `id` FROM `stock` WHERE `id` <> 60480202 AND `partno` = '1945080000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.011710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16148593 [ RunTime:0.002689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484091 LIMIT 5 [ RunTime:0.000904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484091 ORDER BY `minOrder` ASC [ RunTime:0.001417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484091 ORDER BY `unit` DESC [ RunTime:0.003034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484091 LIMIT 2 [ RunTime:0.010406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484091 ORDER BY `minOrder` ASC [ RunTime:0.005089s ]
select * from pdf where partno='1945120000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945120000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003833s ]
SELECT `id` FROM `stock` WHERE `id` <> 60484091 AND `partno` = '1945120000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.022497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19641357 [ RunTime:0.014224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60487033 LIMIT 5 [ RunTime:0.004637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60487033 ORDER BY `minOrder` ASC [ RunTime:0.006921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60487033 ORDER BY `unit` DESC [ RunTime:0.004549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60487033 LIMIT 2 [ RunTime:0.002278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60487033 ORDER BY `minOrder` ASC [ RunTime:0.005895s ]
select * from pdf where partno='1945060000' and brandshort='Weidmüller' limit 1 [ RunTime:0.022385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1945060000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.013657s ]
SELECT `id` FROM `stock` WHERE `id` <> 60487033 AND `partno` = '1945060000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661765 [ RunTime:0.003891s ]
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 '1945%' OR `brand` LIKE '1945%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019231s ]
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 '1945%' OR `brand` LIKE '1945%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005674s ]
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 '1945%' OR `brand` LIKE '1945%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001621s ]
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 '1945%' OR `brand` LIKE '1945%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023677s ]
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 '1945%' OR `brand` LIKE '1945%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042818s ]
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 '1945%' OR `brand` LIKE '1945%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006134s ]
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 '1945%' OR `brand` LIKE '1945%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005986s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1945%' OR `brand` LIKE '1945%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008999s ]