SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002686s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.134' , `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=9603&search=1' [ RunTime:0.002728s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002197s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005846s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002710s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.134' ) [ RunTime:0.001968s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002885s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001356s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002344s ]
SELECT * FROM `stock_search` WHERE `partno` = '9603' LIMIT 1 [ RunTime:0.012848s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-11 17:55:17' WHERE `partno` = '9603' [ RunTime:0.002200s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002570s ]
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 '9603%' OR `brand` LIKE '9603%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020963s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13325364 LIMIT 5 [ RunTime:0.008590s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325364 ORDER BY `minOrder` ASC [ RunTime:0.005447s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13325364 ORDER BY `unit` DESC [ RunTime:0.009711s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13325364 LIMIT 2 [ RunTime:0.003931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13325364 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042408 LIMIT 5 [ RunTime:0.005832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042408 ORDER BY `minOrder` ASC [ RunTime:0.006175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042408 ORDER BY `unit` DESC [ RunTime:0.012033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042408 LIMIT 2 [ RunTime:0.014509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042408 ORDER BY `minOrder` ASC [ RunTime:0.013004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11183187 LIMIT 5 [ RunTime:0.001474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11183187 ORDER BY `minOrder` ASC [ RunTime:0.003708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11183187 ORDER BY `unit` DESC [ RunTime:0.009280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11183187 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11183187 ORDER BY `minOrder` ASC [ RunTime:0.013186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16429146 LIMIT 5 [ RunTime:0.016814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16429146 ORDER BY `minOrder` ASC [ RunTime:0.013856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16429146 ORDER BY `unit` DESC [ RunTime:0.001605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16429146 LIMIT 2 [ RunTime:0.010482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16429146 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12165803 LIMIT 5 [ RunTime:0.008057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12165803 ORDER BY `minOrder` ASC [ RunTime:0.020620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12165803 ORDER BY `unit` DESC [ RunTime:0.003419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12165803 LIMIT 2 [ RunTime:0.016604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12165803 ORDER BY `minOrder` ASC [ RunTime:0.009110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042106 LIMIT 5 [ RunTime:0.016794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042106 ORDER BY `minOrder` ASC [ RunTime:0.013921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042106 ORDER BY `unit` DESC [ RunTime:0.009173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042106 LIMIT 2 [ RunTime:0.019207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042106 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16004302 LIMIT 5 [ RunTime:0.007374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004302 ORDER BY `minOrder` ASC [ RunTime:0.015118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16004302 ORDER BY `unit` DESC [ RunTime:0.009920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16004302 LIMIT 2 [ RunTime:0.016085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16004302 ORDER BY `minOrder` ASC [ RunTime:0.003293s ]
select * from pdf where partno='9603-2-4039-1' and brandshort='ebm-papst Inc.' limit 1 [ RunTime:0.002464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13309379 LIMIT 5 [ RunTime:0.013751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13309379 ORDER BY `minOrder` ASC [ RunTime:0.018306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13309379 ORDER BY `unit` DESC [ RunTime:0.004119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13309379 LIMIT 2 [ RunTime:0.001940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13309379 ORDER BY `minOrder` ASC [ RunTime:0.006106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13295207 LIMIT 5 [ RunTime:0.017038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13295207 ORDER BY `minOrder` ASC [ RunTime:0.004509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13295207 ORDER BY `unit` DESC [ RunTime:0.010777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13295207 LIMIT 2 [ RunTime:0.035795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13295207 ORDER BY `minOrder` ASC [ RunTime:0.013362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293301 LIMIT 5 [ RunTime:0.004792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293301 ORDER BY `minOrder` ASC [ RunTime:0.016760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13293301 ORDER BY `unit` DESC [ RunTime:0.005401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13293301 LIMIT 2 [ RunTime:0.002783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293301 ORDER BY `minOrder` ASC [ RunTime:0.001334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293184 LIMIT 5 [ RunTime:0.007466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293184 ORDER BY `minOrder` ASC [ RunTime:0.011347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13293184 ORDER BY `unit` DESC [ RunTime:0.014606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13293184 LIMIT 2 [ RunTime:0.011931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13293184 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292342 LIMIT 5 [ RunTime:0.018230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292342 ORDER BY `minOrder` ASC [ RunTime:0.022571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13292342 ORDER BY `unit` DESC [ RunTime:0.011276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13292342 LIMIT 2 [ RunTime:0.016781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292342 ORDER BY `minOrder` ASC [ RunTime:0.005605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292276 LIMIT 5 [ RunTime:0.018385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292276 ORDER BY `minOrder` ASC [ RunTime:0.021908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13292276 ORDER BY `unit` DESC [ RunTime:0.007755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13292276 LIMIT 2 [ RunTime:0.024842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292276 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13291199 LIMIT 5 [ RunTime:0.016333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291199 ORDER BY `minOrder` ASC [ RunTime:0.010972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13291199 ORDER BY `unit` DESC [ RunTime:0.011869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13291199 LIMIT 2 [ RunTime:0.027061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13291199 ORDER BY `minOrder` ASC [ RunTime:0.033298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290678 LIMIT 5 [ RunTime:0.025384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290678 ORDER BY `minOrder` ASC [ RunTime:0.011492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290678 ORDER BY `unit` DESC [ RunTime:0.034481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290678 LIMIT 2 [ RunTime:0.022061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290678 ORDER BY `minOrder` ASC [ RunTime:0.001856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290388 LIMIT 5 [ RunTime:0.022100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290388 ORDER BY `minOrder` ASC [ RunTime:0.011770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290388 ORDER BY `unit` DESC [ RunTime:0.013945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290388 LIMIT 2 [ RunTime:0.047661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290388 ORDER BY `minOrder` ASC [ RunTime:0.011655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13290366 LIMIT 5 [ RunTime:0.008678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290366 ORDER BY `minOrder` ASC [ RunTime:0.014125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13290366 ORDER BY `unit` DESC [ RunTime:0.043406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13290366 LIMIT 2 [ RunTime:0.027756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13290366 ORDER BY `minOrder` ASC [ RunTime:0.028872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289703 LIMIT 5 [ RunTime:0.033975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289703 ORDER BY `minOrder` ASC [ RunTime:0.016011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13289703 ORDER BY `unit` DESC [ RunTime:0.055688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13289703 LIMIT 2 [ RunTime:0.033863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289703 ORDER BY `minOrder` ASC [ RunTime:0.004387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288965 LIMIT 5 [ RunTime:0.008819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288965 ORDER BY `minOrder` ASC [ RunTime:0.029629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288965 ORDER BY `unit` DESC [ RunTime:0.053905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288965 LIMIT 2 [ RunTime:0.067692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288965 ORDER BY `minOrder` ASC [ RunTime:0.055503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288903 LIMIT 5 [ RunTime:0.055201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288903 ORDER BY `minOrder` ASC [ RunTime:0.029002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288903 ORDER BY `unit` DESC [ RunTime:0.032579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288903 LIMIT 2 [ RunTime:0.080419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288903 ORDER BY `minOrder` ASC [ RunTime:0.030267s ]
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 '9603%' OR `brand` LIKE '9603%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215080 LIMIT 5 [ RunTime:0.061794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32215080 ORDER BY `minOrder` ASC [ RunTime:0.044747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32215080 ORDER BY `unit` DESC [ RunTime:0.022805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32215080 LIMIT 2 [ RunTime:0.067602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32215080 ORDER BY `minOrder` ASC [ RunTime:0.019186s ]
select * from pdf where partno='960300010' and brandshort='wurth elektronik' limit 1 [ RunTime:0.027177s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '960300010' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.040278s ]
SELECT `id` FROM `stock` WHERE `id` <> 32215080 AND `partno` = '960300010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.038565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63402167 [ RunTime:0.073764s ]
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 '9603%' OR `brand` LIKE '9603%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63372493 LIMIT 5 [ RunTime:0.054944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63372493 ORDER BY `minOrder` ASC [ RunTime:0.031642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63372493 ORDER BY `unit` DESC [ RunTime:0.031965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63372493 LIMIT 2 [ RunTime:0.051863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63372493 ORDER BY `minOrder` ASC [ RunTime:0.037096s ]
select * from pdf where partno='9603' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.029253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9603' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.020961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63394907 LIMIT 5 [ RunTime:0.019621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63394907 ORDER BY `minOrder` ASC [ RunTime:0.021888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63394907 ORDER BY `unit` DESC [ RunTime:0.044357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63394907 LIMIT 2 [ RunTime:0.035622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63394907 ORDER BY `minOrder` ASC [ RunTime:0.026322s ]
select * from pdf where partno='960300084' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.047657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '960300084' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.035449s ]
SELECT `id` FROM `stock` WHERE `id` <> 63394907 AND `partno` = '960300084' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.015198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63395470 LIMIT 5 [ RunTime:0.014394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395470 ORDER BY `minOrder` ASC [ RunTime:0.041371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63395470 ORDER BY `unit` DESC [ RunTime:0.033869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63395470 LIMIT 2 [ RunTime:0.032224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395470 ORDER BY `minOrder` ASC [ RunTime:0.001953s ]
select * from pdf where partno='960350084' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.018646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '960350084' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.025136s ]
SELECT `id` FROM `stock` WHERE `id` <> 63395470 AND `partno` = '960350084' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.018299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042408 [ RunTime:0.018990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63395473 LIMIT 5 [ RunTime:0.027684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395473 ORDER BY `minOrder` ASC [ RunTime:0.031232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63395473 ORDER BY `unit` DESC [ RunTime:0.027016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63395473 LIMIT 2 [ RunTime:0.030400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395473 ORDER BY `minOrder` ASC [ RunTime:0.028065s ]
select * from pdf where partno='960340126' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.035888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '960340126' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.047831s ]
SELECT `id` FROM `stock` WHERE `id` <> 63395473 AND `partno` = '960340126' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.046896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042106 [ RunTime:0.031020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63395559 LIMIT 5 [ RunTime:0.025285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395559 ORDER BY `minOrder` ASC [ RunTime:0.013365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63395559 ORDER BY `unit` DESC [ RunTime:0.012761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63395559 LIMIT 2 [ RunTime:0.073201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63395559 ORDER BY `minOrder` ASC [ RunTime:0.023613s ]
select * from pdf where partno='960360116' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.036101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '960360116' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.025915s ]
SELECT `id` FROM `stock` WHERE `id` <> 63395559 AND `partno` = '960360116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.043712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58562980 LIMIT 5 [ RunTime:0.018056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58562980 ORDER BY `minOrder` ASC [ RunTime:0.038362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58562980 ORDER BY `unit` DESC [ RunTime:0.009913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58562980 LIMIT 2 [ RunTime:0.012663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58562980 ORDER BY `minOrder` ASC [ RunTime:0.018175s ]
select * from pdf where partno='96035' and brandshort='Wiha' limit 1 [ RunTime:0.023222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96035' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.018601s ]
SELECT `id` FROM `stock` WHERE `id` <> 58562980 AND `partno` = '96035' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.021435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12165803 [ RunTime:0.011091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58562961 LIMIT 5 [ RunTime:0.008776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58562961 ORDER BY `minOrder` ASC [ RunTime:0.018897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58562961 ORDER BY `unit` DESC [ RunTime:0.029381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58562961 LIMIT 2 [ RunTime:0.003650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58562961 ORDER BY `minOrder` ASC [ RunTime:0.038236s ]
select * from pdf where partno='96030' and brandshort='Wiha' limit 1 [ RunTime:0.010443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96030' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.028155s ]
SELECT `id` FROM `stock` WHERE `id` <> 58562961 AND `partno` = '96030' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.021468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11183187 [ RunTime:0.039131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63138507 LIMIT 5 [ RunTime:0.014275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63138507 ORDER BY `minOrder` ASC [ RunTime:0.026867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63138507 ORDER BY `unit` DESC [ RunTime:0.014523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63138507 LIMIT 2 [ RunTime:0.019239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63138507 ORDER BY `minOrder` ASC [ RunTime:0.003960s ]
select * from pdf where partno='96032' and brandshort='Helukabel USA' limit 1 [ RunTime:0.005157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '96032' OR `brand` LIKE 'Helukabel USA%' ) ) LIMIT 1 [ RunTime:0.016547s ]
SELECT `id` FROM `stock` WHERE `id` <> 63138507 AND `partno` = '96032' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%helukabel usa%' ) [ RunTime:0.023245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16429146 [ RunTime:0.009837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63402169 LIMIT 5 [ RunTime:0.038264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63402169 ORDER BY `minOrder` ASC [ RunTime:0.020045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63402169 ORDER BY `unit` DESC [ RunTime:0.017367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63402169 LIMIT 2 [ RunTime:0.161356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63402169 ORDER BY `minOrder` ASC [ RunTime:0.009776s ]
select * from pdf where partno='960300042' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.020903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '960300042' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.022626s ]
SELECT `id` FROM `stock` WHERE `id` <> 63402169 AND `partno` = '960300042' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.028980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13309379 [ RunTime:0.050678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63402168 LIMIT 5 [ RunTime:0.075851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63402168 ORDER BY `minOrder` ASC [ RunTime:0.051527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63402168 ORDER BY `unit` DESC [ RunTime:0.054706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63402168 LIMIT 2 [ RunTime:0.076073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63402168 ORDER BY `minOrder` ASC [ RunTime:0.035521s ]
select * from pdf where partno='960300021' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.060517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '960300021' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.038691s ]
SELECT `id` FROM `stock` WHERE `id` <> 63402168 AND `partno` = '960300021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.040988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12036585 [ RunTime:0.108037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63402167 LIMIT 5 [ RunTime:0.090439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63402167 ORDER BY `minOrder` ASC [ RunTime:0.134044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63402167 ORDER BY `unit` DESC [ RunTime:0.014856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63402167 LIMIT 2 [ RunTime:0.068951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63402167 ORDER BY `minOrder` ASC [ RunTime:0.032573s ]
select * from pdf where partno='960300010' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.051355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '960300010' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.077147s ]
SELECT `id` FROM `stock` WHERE `id` <> 63402167 AND `partno` = '960300010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.097252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215080 [ RunTime:0.131006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61921347 LIMIT 5 [ RunTime:0.169857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61921347 ORDER BY `minOrder` ASC [ RunTime:0.057933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61921347 ORDER BY `unit` DESC [ RunTime:0.055100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61921347 LIMIT 2 [ RunTime:0.048242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61921347 ORDER BY `minOrder` ASC [ RunTime:0.058475s ]
select * from pdf where partno='9603' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.031059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9603' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.047685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32750039 LIMIT 5 [ RunTime:0.082829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32750039 ORDER BY `minOrder` ASC [ RunTime:0.049565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32750039 ORDER BY `unit` DESC [ RunTime:0.034793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32750039 LIMIT 2 [ RunTime:0.056703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32750039 ORDER BY `minOrder` ASC [ RunTime:0.037155s ]
select * from pdf where partno='9603327-0000' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.021789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9603327-0000' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.033980s ]
SELECT `id` FROM `stock` WHERE `id` <> 32750039 AND `partno` = '9603327-0000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.034250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32737197 LIMIT 5 [ RunTime:0.033872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32737197 ORDER BY `minOrder` ASC [ RunTime:0.032281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32737197 ORDER BY `unit` DESC [ RunTime:0.021619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32737197 LIMIT 2 [ RunTime:0.046284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32737197 ORDER BY `minOrder` ASC [ RunTime:0.011623s ]
select * from pdf where partno='9603707-0002' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.029530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9603707-0002' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.025880s ]
SELECT `id` FROM `stock` WHERE `id` <> 32737197 AND `partno` = '9603707-0002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.030124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32711652 LIMIT 5 [ RunTime:0.034931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32711652 ORDER BY `minOrder` ASC [ RunTime:0.032260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32711652 ORDER BY `unit` DESC [ RunTime:0.015630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32711652 LIMIT 2 [ RunTime:0.014659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32711652 ORDER BY `minOrder` ASC [ RunTime:0.017572s ]
select * from pdf where partno='9603976-0001' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.025546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9603976-0001' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.019846s ]
SELECT `id` FROM `stock` WHERE `id` <> 32711652 AND `partno` = '9603976-0001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.015478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32684311 LIMIT 5 [ RunTime:0.021521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32684311 ORDER BY `minOrder` ASC [ RunTime:0.041100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32684311 ORDER BY `unit` DESC [ RunTime:0.031004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32684311 LIMIT 2 [ RunTime:0.050615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32684311 ORDER BY `minOrder` ASC [ RunTime:0.022898s ]
select * from pdf where partno='9603986-0550' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.040657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9603986-0550' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.039252s ]
SELECT `id` FROM `stock` WHERE `id` <> 32684311 AND `partno` = '9603986-0550' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.035451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13295207 [ RunTime:0.037260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32681723 LIMIT 5 [ RunTime:0.044450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32681723 ORDER BY `minOrder` ASC [ RunTime:0.030257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32681723 ORDER BY `unit` DESC [ RunTime:0.029801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32681723 LIMIT 2 [ RunTime:0.019327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32681723 ORDER BY `minOrder` ASC [ RunTime:0.011922s ]
select * from pdf where partno='9603820-0000' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.030253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9603820-0000' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.066539s ]
SELECT `id` FROM `stock` WHERE `id` <> 32681723 AND `partno` = '9603820-0000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.036617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32670528 LIMIT 5 [ RunTime:0.004496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32670528 ORDER BY `minOrder` ASC [ RunTime:0.063347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32670528 ORDER BY `unit` DESC [ RunTime:0.057959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32670528 LIMIT 2 [ RunTime:0.030724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32670528 ORDER BY `minOrder` ASC [ RunTime:0.023607s ]
select * from pdf where partno='9603820-0001' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.054589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9603820-0001' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.024268s ]
SELECT `id` FROM `stock` WHERE `id` <> 32670528 AND `partno` = '9603820-0001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.036340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32658642 LIMIT 5 [ RunTime:0.058180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32658642 ORDER BY `minOrder` ASC [ RunTime:0.066571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32658642 ORDER BY `unit` DESC [ RunTime:0.056027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32658642 LIMIT 2 [ RunTime:0.070007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32658642 ORDER BY `minOrder` ASC [ RunTime:0.016499s ]
select * from pdf where partno='9603658-0000' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.043870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9603658-0000' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.020084s ]
SELECT `id` FROM `stock` WHERE `id` <> 32658642 AND `partno` = '9603658-0000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.047785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12026373 [ RunTime:0.022659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32654845 LIMIT 5 [ RunTime:0.022782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32654845 ORDER BY `minOrder` ASC [ RunTime:0.020837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32654845 ORDER BY `unit` DESC [ RunTime:0.042929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32654845 LIMIT 2 [ RunTime:0.026396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32654845 ORDER BY `minOrder` ASC [ RunTime:0.013086s ]
select * from pdf where partno='9603873-1200' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.023224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9603873-1200' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.020773s ]
SELECT `id` FROM `stock` WHERE `id` <> 32654845 AND `partno` = '9603873-1200' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.040070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13293301 [ RunTime:0.011606s ]
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 '9603%' OR `brand` LIKE '9603%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017050s ]
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 '9603%' OR `brand` LIKE '9603%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027789s ]
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 '9603%' OR `brand` LIKE '9603%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017593s ]
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 '9603%' OR `brand` LIKE '9603%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012696s ]
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 '9603%' OR `brand` LIKE '9603%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022219s ]
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 '9603%' OR `brand` LIKE '9603%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030408s ]
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 '9603%' OR `brand` LIKE '9603%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035105s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9603%' OR `brand` LIKE '9603%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015400s ]