SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001545s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=9431&search=1' [ RunTime:0.003002s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001489s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000818s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002052s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000273s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001125s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000257s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001167s ]
SELECT * FROM `stock_search` WHERE `partno` = '9431' LIMIT 1 [ RunTime:0.005944s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-26 12:29:22' WHERE `partno` = '9431' [ RunTime:0.025697s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003294s ]
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 '9431%' OR `brand` LIKE '9431%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029096s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13501896 LIMIT 5 [ RunTime:0.021622s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13501896 ORDER BY `minOrder` ASC [ RunTime:0.024277s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13501896 ORDER BY `unit` DESC [ RunTime:0.024469s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13501896 LIMIT 2 [ RunTime:0.049775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13501896 ORDER BY `minOrder` ASC [ RunTime:0.025587s ]
select * from pdf where partno='9431 060500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.044482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387693 LIMIT 5 [ RunTime:0.028487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387693 ORDER BY `minOrder` ASC [ RunTime:0.022210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14387693 ORDER BY `unit` DESC [ RunTime:0.036227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14387693 LIMIT 2 [ RunTime:0.029382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14387693 ORDER BY `minOrder` ASC [ RunTime:0.025677s ]
select * from pdf where partno='9431 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.016846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505252 LIMIT 5 [ RunTime:0.067106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505252 ORDER BY `minOrder` ASC [ RunTime:0.056125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13505252 ORDER BY `unit` DESC [ RunTime:0.025961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13505252 LIMIT 2 [ RunTime:0.040570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13505252 ORDER BY `minOrder` ASC [ RunTime:0.017367s ]
select * from pdf where partno='9431 0601000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.024900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13329173 LIMIT 5 [ RunTime:0.049348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13329173 ORDER BY `minOrder` ASC [ RunTime:0.061477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13329173 ORDER BY `unit` DESC [ RunTime:0.039578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13329173 LIMIT 2 [ RunTime:0.048167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13329173 ORDER BY `minOrder` ASC [ RunTime:0.026601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881206 LIMIT 5 [ RunTime:0.052733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881206 ORDER BY `minOrder` ASC [ RunTime:0.018573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881206 ORDER BY `unit` DESC [ RunTime:0.011671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881206 LIMIT 2 [ RunTime:0.025494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881206 ORDER BY `minOrder` ASC [ RunTime:0.020653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19600633 LIMIT 5 [ RunTime:0.041456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19600633 ORDER BY `minOrder` ASC [ RunTime:0.041324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19600633 ORDER BY `unit` DESC [ RunTime:0.011585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19600633 LIMIT 2 [ RunTime:0.006343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19600633 ORDER BY `minOrder` ASC [ RunTime:0.002393s ]
select * from pdf where partno='943138' and brandshort='Weidmüller' limit 1 [ RunTime:0.020951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379205 LIMIT 5 [ RunTime:0.032201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379205 ORDER BY `minOrder` ASC [ RunTime:0.026789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14379205 ORDER BY `unit` DESC [ RunTime:0.055070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14379205 LIMIT 2 [ RunTime:0.043656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14379205 ORDER BY `minOrder` ASC [ RunTime:0.013201s ]
select * from pdf where partno='9431 0605000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.005984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12876263 LIMIT 5 [ RunTime:0.054657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12876263 ORDER BY `minOrder` ASC [ RunTime:0.028106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12876263 ORDER BY `unit` DESC [ RunTime:0.050488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12876263 LIMIT 2 [ RunTime:0.033599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12876263 ORDER BY `minOrder` ASC [ RunTime:0.022838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12411900 LIMIT 5 [ RunTime:0.010403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12411900 ORDER BY `minOrder` ASC [ RunTime:0.056419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12411900 ORDER BY `unit` DESC [ RunTime:0.023748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12411900 LIMIT 2 [ RunTime:0.016709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12411900 ORDER BY `minOrder` ASC [ RunTime:0.011547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12411812 LIMIT 5 [ RunTime:0.013244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12411812 ORDER BY `minOrder` ASC [ RunTime:0.013299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12411812 ORDER BY `unit` DESC [ RunTime:0.022761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12411812 LIMIT 2 [ RunTime:0.003584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12411812 ORDER BY `minOrder` ASC [ RunTime:0.004755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12411713 LIMIT 5 [ RunTime:0.033934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12411713 ORDER BY `minOrder` ASC [ RunTime:0.015312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12411713 ORDER BY `unit` DESC [ RunTime:0.027681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12411713 LIMIT 2 [ RunTime:0.021330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12411713 ORDER BY `minOrder` ASC [ RunTime:0.011225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12411608 LIMIT 5 [ RunTime:0.013892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12411608 ORDER BY `minOrder` ASC [ RunTime:0.011578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12411608 ORDER BY `unit` DESC [ RunTime:0.004191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12411608 LIMIT 2 [ RunTime:0.015479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12411608 ORDER BY `minOrder` ASC [ RunTime:0.005097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12411517 LIMIT 5 [ RunTime:0.002736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12411517 ORDER BY `minOrder` ASC [ RunTime:0.040238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12411517 ORDER BY `unit` DESC [ RunTime:0.013610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12411517 LIMIT 2 [ RunTime:0.031882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12411517 ORDER BY `minOrder` ASC [ RunTime:0.011419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11678684 LIMIT 5 [ RunTime:0.015312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11678684 ORDER BY `minOrder` ASC [ RunTime:0.026396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11678684 ORDER BY `unit` DESC [ RunTime:0.022223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11678684 LIMIT 2 [ RunTime:0.023050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11678684 ORDER BY `minOrder` ASC [ RunTime:0.009488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11347583 LIMIT 5 [ RunTime:0.032138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11347583 ORDER BY `minOrder` ASC [ RunTime:0.012490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11347583 ORDER BY `unit` DESC [ RunTime:0.004300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11347583 LIMIT 2 [ RunTime:0.024865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11347583 ORDER BY `minOrder` ASC [ RunTime:0.015312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11347511 LIMIT 5 [ RunTime:0.032535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11347511 ORDER BY `minOrder` ASC [ RunTime:0.024234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11347511 ORDER BY `unit` DESC [ RunTime:0.003356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11347511 LIMIT 2 [ RunTime:0.058398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11347511 ORDER BY `minOrder` ASC [ RunTime:0.004216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11347422 LIMIT 5 [ RunTime:0.017196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11347422 ORDER BY `minOrder` ASC [ RunTime:0.004667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11347422 ORDER BY `unit` DESC [ RunTime:0.001651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11347422 LIMIT 2 [ RunTime:0.015685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11347422 ORDER BY `minOrder` ASC [ RunTime:0.002470s ]
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 '9431%' OR `brand` LIKE '9431%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137496 LIMIT 5 [ RunTime:0.022398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137496 ORDER BY `minOrder` ASC [ RunTime:0.017199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137496 ORDER BY `unit` DESC [ RunTime:0.006753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137496 LIMIT 2 [ RunTime:0.028779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137496 ORDER BY `minOrder` ASC [ RunTime:0.017704s ]
select * from pdf where partno='9431 060100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.027921s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431 060100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.026124s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137496 AND `partno` = '9431 060100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.010947s ]
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 '9431%' OR `brand` LIKE '9431%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997702 LIMIT 5 [ RunTime:0.016330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997702 ORDER BY `minOrder` ASC [ RunTime:0.052337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997702 ORDER BY `unit` DESC [ RunTime:0.007152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997702 LIMIT 2 [ RunTime:0.005307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997702 ORDER BY `minOrder` ASC [ RunTime:0.002369s ]
select * from pdf where partno='9431 060500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.004511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431 060500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.004188s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997702 AND `partno` = '9431 060500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.016380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13501896 [ RunTime:0.021554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63000699 LIMIT 5 [ RunTime:0.005424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000699 ORDER BY `minOrder` ASC [ RunTime:0.016241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63000699 ORDER BY `unit` DESC [ RunTime:0.036059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63000699 LIMIT 2 [ RunTime:0.028568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63000699 ORDER BY `minOrder` ASC [ RunTime:0.024226s ]
select * from pdf where partno='9431 0601000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431 0601000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.009695s ]
SELECT `id` FROM `stock` WHERE `id` <> 63000699 AND `partno` = '9431 0601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.028609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13505252 [ RunTime:0.040989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63365751 LIMIT 5 [ RunTime:0.009943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63365751 ORDER BY `minOrder` ASC [ RunTime:0.043806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63365751 ORDER BY `unit` DESC [ RunTime:0.021440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63365751 LIMIT 2 [ RunTime:0.008258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63365751 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='9431' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.022636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.017211s ]
SELECT `id` FROM `stock` WHERE `id` <> 63365751 AND `partno` = '9431' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.029336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13329173 [ RunTime:0.021464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62997758 LIMIT 5 [ RunTime:0.012948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997758 ORDER BY `minOrder` ASC [ RunTime:0.023017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62997758 ORDER BY `unit` DESC [ RunTime:0.042980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62997758 LIMIT 2 [ RunTime:0.031186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62997758 ORDER BY `minOrder` ASC [ RunTime:0.004720s ]
select * from pdf where partno='9431 060100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431 060100' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.013256s ]
SELECT `id` FROM `stock` WHERE `id` <> 62997758 AND `partno` = '9431 060100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.029218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14387693 [ RunTime:0.040703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64016922 LIMIT 5 [ RunTime:0.035101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016922 ORDER BY `minOrder` ASC [ RunTime:0.024921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64016922 ORDER BY `unit` DESC [ RunTime:0.018327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64016922 LIMIT 2 [ RunTime:0.011026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016922 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
select * from pdf where partno='943156496' and brandshort='Hirschmann' limit 1 [ RunTime:0.033763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943156496' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.011863s ]
SELECT `id` FROM `stock` WHERE `id` <> 64016922 AND `partno` = '943156496' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.011387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12411900 [ RunTime:0.020302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64016911 LIMIT 5 [ RunTime:0.025272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016911 ORDER BY `minOrder` ASC [ RunTime:0.006814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64016911 ORDER BY `unit` DESC [ RunTime:0.024310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64016911 LIMIT 2 [ RunTime:0.007105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016911 ORDER BY `minOrder` ASC [ RunTime:0.006024s ]
select * from pdf where partno='943156248' and brandshort='Hirschmann' limit 1 [ RunTime:0.025306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943156248' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.031129s ]
SELECT `id` FROM `stock` WHERE `id` <> 64016911 AND `partno` = '943156248' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.040952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11347583 [ RunTime:0.011597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64016816 LIMIT 5 [ RunTime:0.014693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016816 ORDER BY `minOrder` ASC [ RunTime:0.008511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64016816 ORDER BY `unit` DESC [ RunTime:0.054456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64016816 LIMIT 2 [ RunTime:0.037378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016816 ORDER BY `minOrder` ASC [ RunTime:0.028856s ]
select * from pdf where partno='943156124' and brandshort='Hirschmann' limit 1 [ RunTime:0.045615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943156124' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.020913s ]
SELECT `id` FROM `stock` WHERE `id` <> 64016816 AND `partno` = '943156124' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.015192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12411812 [ RunTime:0.070583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64016739 LIMIT 5 [ RunTime:0.023673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016739 ORDER BY `minOrder` ASC [ RunTime:0.060765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64016739 ORDER BY `unit` DESC [ RunTime:0.038193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64016739 LIMIT 2 [ RunTime:0.035515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016739 ORDER BY `minOrder` ASC [ RunTime:0.019220s ]
select * from pdf where partno='943156512' and brandshort='Hirschmann' limit 1 [ RunTime:0.028176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943156512' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.035890s ]
SELECT `id` FROM `stock` WHERE `id` <> 64016739 AND `partno` = '943156512' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.032574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11347511 [ RunTime:0.063727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64016653 LIMIT 5 [ RunTime:0.090306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016653 ORDER BY `minOrder` ASC [ RunTime:0.030108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64016653 ORDER BY `unit` DESC [ RunTime:0.022068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64016653 LIMIT 2 [ RunTime:0.014712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016653 ORDER BY `minOrder` ASC [ RunTime:0.022295s ]
select * from pdf where partno='943156256' and brandshort='Hirschmann' limit 1 [ RunTime:0.052456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943156256' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.022089s ]
SELECT `id` FROM `stock` WHERE `id` <> 64016653 AND `partno` = '943156256' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.055492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12411713 [ RunTime:0.074010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64016442 LIMIT 5 [ RunTime:0.061550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016442 ORDER BY `minOrder` ASC [ RunTime:0.065569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64016442 ORDER BY `unit` DESC [ RunTime:0.033724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64016442 LIMIT 2 [ RunTime:0.110564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016442 ORDER BY `minOrder` ASC [ RunTime:0.050718s ]
select * from pdf where partno='943156064' and brandshort='Hirschmann' limit 1 [ RunTime:0.036775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943156064' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.049974s ]
SELECT `id` FROM `stock` WHERE `id` <> 64016442 AND `partno` = '943156064' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.064130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12411608 [ RunTime:0.086272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64016403 LIMIT 5 [ RunTime:0.109017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016403 ORDER BY `minOrder` ASC [ RunTime:0.045914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64016403 ORDER BY `unit` DESC [ RunTime:0.083897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64016403 LIMIT 2 [ RunTime:0.017441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016403 ORDER BY `minOrder` ASC [ RunTime:0.062850s ]
select * from pdf where partno='943156128' and brandshort='Hirschmann' limit 1 [ RunTime:0.049555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943156128' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.053900s ]
SELECT `id` FROM `stock` WHERE `id` <> 64016403 AND `partno` = '943156128' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.105903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11347422 [ RunTime:0.027880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64016307 LIMIT 5 [ RunTime:0.065601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016307 ORDER BY `minOrder` ASC [ RunTime:0.038865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64016307 ORDER BY `unit` DESC [ RunTime:0.058622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64016307 LIMIT 2 [ RunTime:0.043212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64016307 ORDER BY `minOrder` ASC [ RunTime:0.006327s ]
select * from pdf where partno='943156032' and brandshort='Hirschmann' limit 1 [ RunTime:0.062894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943156032' OR `brand` LIKE 'Hirschmann%' ) ) LIMIT 1 [ RunTime:0.012074s ]
SELECT `id` FROM `stock` WHERE `id` <> 64016307 AND `partno` = '943156032' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirschmann%' ) [ RunTime:0.039595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12411517 [ RunTime:0.041761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63023899 LIMIT 5 [ RunTime:0.027884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63023899 ORDER BY `minOrder` ASC [ RunTime:0.033558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63023899 ORDER BY `unit` DESC [ RunTime:0.033216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63023899 LIMIT 2 [ RunTime:0.017459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63023899 ORDER BY `minOrder` ASC [ RunTime:0.008859s ]
select * from pdf where partno='9431 0605000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.022769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431 0605000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.033143s ]
SELECT `id` FROM `stock` WHERE `id` <> 63023899 AND `partno` = '9431 0605000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.038140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14379205 [ RunTime:0.019698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61928566 LIMIT 5 [ RunTime:0.009533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61928566 ORDER BY `minOrder` ASC [ RunTime:0.028143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61928566 ORDER BY `unit` DESC [ RunTime:0.042118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61928566 LIMIT 2 [ RunTime:0.012908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61928566 ORDER BY `minOrder` ASC [ RunTime:0.012556s ]
select * from pdf where partno='9431-7583-010' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.022201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431-7583-010' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.067338s ]
SELECT `id` FROM `stock` WHERE `id` <> 61928566 AND `partno` = '9431-7583-010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radiall usa, inc.%' ) [ RunTime:0.044167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12876263 [ RunTime:0.019252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61926959 LIMIT 5 [ RunTime:0.037518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61926959 ORDER BY `minOrder` ASC [ RunTime:0.064159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61926959 ORDER BY `unit` DESC [ RunTime:0.007835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61926959 LIMIT 2 [ RunTime:0.031186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61926959 ORDER BY `minOrder` ASC [ RunTime:0.009465s ]
select * from pdf where partno='9431-1083-009' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.012866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431-1083-009' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.011000s ]
SELECT `id` FROM `stock` WHERE `id` <> 61926959 AND `partno` = '9431-1083-009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radiall usa, inc.%' ) [ RunTime:0.009386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11678684 [ RunTime:0.016487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61925736 LIMIT 5 [ RunTime:0.004405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61925736 ORDER BY `minOrder` ASC [ RunTime:0.026528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61925736 ORDER BY `unit` DESC [ RunTime:0.012041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61925736 LIMIT 2 [ RunTime:0.017927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61925736 ORDER BY `minOrder` ASC [ RunTime:0.010061s ]
select * from pdf where partno='9431-7083-010' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.023160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431-7083-010' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.010998s ]
SELECT `id` FROM `stock` WHERE `id` <> 61925736 AND `partno` = '9431-7083-010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radiall usa, inc.%' ) [ RunTime:0.004518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61925719 LIMIT 5 [ RunTime:0.008788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61925719 ORDER BY `minOrder` ASC [ RunTime:0.006605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61925719 ORDER BY `unit` DESC [ RunTime:0.012885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61925719 LIMIT 2 [ RunTime:0.019506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61925719 ORDER BY `minOrder` ASC [ RunTime:0.011730s ]
select * from pdf where partno='9431-1083-010' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.006294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431-1083-010' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.003656s ]
SELECT `id` FROM `stock` WHERE `id` <> 61925719 AND `partno` = '9431-1083-010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radiall usa, inc.%' ) [ RunTime:0.003294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61916955 LIMIT 5 [ RunTime:0.004132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61916955 ORDER BY `minOrder` ASC [ RunTime:0.004711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61916955 ORDER BY `unit` DESC [ RunTime:0.011655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61916955 LIMIT 2 [ RunTime:0.014899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61916955 ORDER BY `minOrder` ASC [ RunTime:0.033059s ]
select * from pdf where partno='9431-1583-010' and brandshort='Radiall USA, Inc.' limit 1 [ RunTime:0.039522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9431-1583-010' OR `brand` LIKE 'Radiall USA, Inc.%' ) ) LIMIT 1 [ RunTime:0.024194s ]
SELECT `id` FROM `stock` WHERE `id` <> 61916955 AND `partno` = '9431-1583-010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%radiall usa, inc.%' ) [ RunTime:0.028405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881206 [ RunTime:0.022425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60310473 LIMIT 5 [ RunTime:0.022930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60310473 ORDER BY `minOrder` ASC [ RunTime:0.019821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60310473 ORDER BY `unit` DESC [ RunTime:0.016577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60310473 LIMIT 2 [ RunTime:0.023186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60310473 ORDER BY `minOrder` ASC [ RunTime:0.010399s ]
select * from pdf where partno='943138' and brandshort='Weidmüller' limit 1 [ RunTime:0.016029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '943138' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.052781s ]
SELECT `id` FROM `stock` WHERE `id` <> 60310473 AND `partno` = '943138' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.022733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19600633 [ RunTime:0.021154s ]
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 '9431%' OR `brand` LIKE '9431%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065257s ]
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 '9431%' OR `brand` LIKE '9431%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047268s ]
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 '9431%' OR `brand` LIKE '9431%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055015s ]
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 '9431%' OR `brand` LIKE '9431%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051033s ]
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 '9431%' OR `brand` LIKE '9431%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021222s ]
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 '9431%' OR `brand` LIKE '9431%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021026s ]
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 '9431%' OR `brand` LIKE '9431%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029020s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9431%' OR `brand` LIKE '9431%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.057195s ]