SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001625s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=3400&search=1' [ RunTime:0.006016s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001564s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001606s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.006214s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.002679s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001682s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001506s ]
SELECT * FROM `stock_search` WHERE `partno` = '3400' LIMIT 1 [ RunTime:0.006057s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 15:06:00' WHERE `partno` = '3400' [ RunTime:0.020128s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001822s ]
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 '3400%' OR `brand` LIKE '3400%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050242s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13221741 LIMIT 5 [ RunTime:0.002642s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13221741 ORDER BY `minOrder` ASC [ RunTime:0.005429s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13221741 ORDER BY `unit` DESC [ RunTime:0.011457s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13221741 LIMIT 2 [ RunTime:0.009535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13221741 ORDER BY `minOrder` ASC [ RunTime:0.003411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932169 LIMIT 5 [ RunTime:0.021169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932169 ORDER BY `minOrder` ASC [ RunTime:0.008845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932169 ORDER BY `unit` DESC [ RunTime:0.020864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932169 LIMIT 2 [ RunTime:0.022476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932169 ORDER BY `minOrder` ASC [ RunTime:0.005226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932163 LIMIT 5 [ RunTime:0.019145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932163 ORDER BY `minOrder` ASC [ RunTime:0.036525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932163 ORDER BY `unit` DESC [ RunTime:0.026144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932163 LIMIT 2 [ RunTime:0.037735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932163 ORDER BY `minOrder` ASC [ RunTime:0.017915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853339 LIMIT 5 [ RunTime:0.022063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18853339 ORDER BY `minOrder` ASC [ RunTime:0.032662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18853339 ORDER BY `unit` DESC [ RunTime:0.019024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18853339 LIMIT 2 [ RunTime:0.007999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18853339 ORDER BY `minOrder` ASC [ RunTime:0.011739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16799600 LIMIT 5 [ RunTime:0.009328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16799600 ORDER BY `minOrder` ASC [ RunTime:0.017961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16799600 ORDER BY `unit` DESC [ RunTime:0.031794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16799600 LIMIT 2 [ RunTime:0.013022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16799600 ORDER BY `minOrder` ASC [ RunTime:0.011592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14066600 LIMIT 5 [ RunTime:0.006542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14066600 ORDER BY `minOrder` ASC [ RunTime:0.007347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14066600 ORDER BY `unit` DESC [ RunTime:0.019942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14066600 LIMIT 2 [ RunTime:0.007696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14066600 ORDER BY `minOrder` ASC [ RunTime:0.008614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17843949 LIMIT 5 [ RunTime:0.021387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17843949 ORDER BY `minOrder` ASC [ RunTime:0.025773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17843949 ORDER BY `unit` DESC [ RunTime:0.015225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17843949 LIMIT 2 [ RunTime:0.015134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17843949 ORDER BY `minOrder` ASC [ RunTime:0.002530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14049747 LIMIT 5 [ RunTime:0.012730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14049747 ORDER BY `minOrder` ASC [ RunTime:0.018197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14049747 ORDER BY `unit` DESC [ RunTime:0.008524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14049747 LIMIT 2 [ RunTime:0.009780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14049747 ORDER BY `minOrder` ASC [ RunTime:0.011237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14987970 LIMIT 5 [ RunTime:0.016991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14987970 ORDER BY `minOrder` ASC [ RunTime:0.027511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14987970 ORDER BY `unit` DESC [ RunTime:0.024225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14987970 LIMIT 2 [ RunTime:0.005803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14987970 ORDER BY `minOrder` ASC [ RunTime:0.011530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17843951 LIMIT 5 [ RunTime:0.008876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17843951 ORDER BY `minOrder` ASC [ RunTime:0.010485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17843951 ORDER BY `unit` DESC [ RunTime:0.009808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17843951 LIMIT 2 [ RunTime:0.014455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17843951 ORDER BY `minOrder` ASC [ RunTime:0.010810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16781147 LIMIT 5 [ RunTime:0.032066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16781147 ORDER BY `minOrder` ASC [ RunTime:0.029978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16781147 ORDER BY `unit` DESC [ RunTime:0.018160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16781147 LIMIT 2 [ RunTime:0.006736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16781147 ORDER BY `minOrder` ASC [ RunTime:0.003506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15720146 LIMIT 5 [ RunTime:0.017431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15720146 ORDER BY `minOrder` ASC [ RunTime:0.006325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15720146 ORDER BY `unit` DESC [ RunTime:0.020260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15720146 LIMIT 2 [ RunTime:0.005808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15720146 ORDER BY `minOrder` ASC [ RunTime:0.003916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394020 LIMIT 5 [ RunTime:0.022192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394020 ORDER BY `minOrder` ASC [ RunTime:0.029427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394020 ORDER BY `unit` DESC [ RunTime:0.030917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394020 LIMIT 2 [ RunTime:0.012447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394020 ORDER BY `minOrder` ASC [ RunTime:0.022514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521492 LIMIT 5 [ RunTime:0.031767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521492 ORDER BY `minOrder` ASC [ RunTime:0.020901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13521492 ORDER BY `unit` DESC [ RunTime:0.016357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13521492 LIMIT 2 [ RunTime:0.025370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521492 ORDER BY `minOrder` ASC [ RunTime:0.010425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17770500 LIMIT 5 [ RunTime:0.011411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17770500 ORDER BY `minOrder` ASC [ RunTime:0.020305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17770500 ORDER BY `unit` DESC [ RunTime:0.020641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17770500 LIMIT 2 [ RunTime:0.003689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17770500 ORDER BY `minOrder` ASC [ RunTime:0.009501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15239743 LIMIT 5 [ RunTime:0.020750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15239743 ORDER BY `minOrder` ASC [ RunTime:0.007868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15239743 ORDER BY `unit` DESC [ RunTime:0.060180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15239743 LIMIT 2 [ RunTime:0.049078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15239743 ORDER BY `minOrder` ASC [ RunTime:0.045396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15239744 LIMIT 5 [ RunTime:0.007982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15239744 ORDER BY `minOrder` ASC [ RunTime:0.017545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15239744 ORDER BY `unit` DESC [ RunTime:0.031069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15239744 LIMIT 2 [ RunTime:0.040803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15239744 ORDER BY `minOrder` ASC [ RunTime:0.005099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853692 LIMIT 5 [ RunTime:0.014527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18853692 ORDER BY `minOrder` ASC [ RunTime:0.044408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18853692 ORDER BY `unit` DESC [ RunTime:0.017318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18853692 LIMIT 2 [ RunTime:0.023042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18853692 ORDER BY `minOrder` ASC [ RunTime:0.026676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17024690 LIMIT 5 [ RunTime:0.019172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17024690 ORDER BY `minOrder` ASC [ RunTime:0.035891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17024690 ORDER BY `unit` DESC [ RunTime:0.015680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17024690 LIMIT 2 [ RunTime:0.013911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17024690 ORDER BY `minOrder` ASC [ RunTime:0.031798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853880 LIMIT 5 [ RunTime:0.019904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18853880 ORDER BY `minOrder` ASC [ RunTime:0.015317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18853880 ORDER BY `unit` DESC [ RunTime:0.015734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18853880 LIMIT 2 [ RunTime:0.003053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18853880 ORDER BY `minOrder` ASC [ RunTime:0.005970s ]
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 '3400%' OR `brand` LIKE '3400%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133255 LIMIT 5 [ RunTime:0.010152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133255 ORDER BY `minOrder` ASC [ RunTime:0.030520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133255 ORDER BY `unit` DESC [ RunTime:0.005918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133255 LIMIT 2 [ RunTime:0.020913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133255 ORDER BY `minOrder` ASC [ RunTime:0.007559s ]
select * from pdf where partno='3400.050.200.0' and brandshort='igus' limit 1 [ RunTime:0.011871s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.050.200.0' OR `brand` LIKE 'igus%' ) ) LIMIT 1 [ RunTime:0.006625s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133255 AND `partno` = '3400.050.200.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%igus%' ) [ RunTime:0.031694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133161 LIMIT 5 [ RunTime:0.003477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133161 ORDER BY `minOrder` ASC [ RunTime:0.014293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133161 ORDER BY `unit` DESC [ RunTime:0.006526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133161 LIMIT 2 [ RunTime:0.003559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133161 ORDER BY `minOrder` ASC [ RunTime:0.010221s ]
select * from pdf where partno='3400.125.200.0' and brandshort='igus' limit 1 [ RunTime:0.003666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.125.200.0' OR `brand` LIKE 'igus%' ) ) LIMIT 1 [ RunTime:0.005064s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133161 AND `partno` = '3400.125.200.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%igus%' ) [ RunTime:0.003394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133095 LIMIT 5 [ RunTime:0.019875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133095 ORDER BY `minOrder` ASC [ RunTime:0.020596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133095 ORDER BY `unit` DESC [ RunTime:0.043720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133095 LIMIT 2 [ RunTime:0.014782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133095 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='3400.125.100.0' and brandshort='igus' limit 1 [ RunTime:0.006492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.125.100.0' OR `brand` LIKE 'igus%' ) ) LIMIT 1 [ RunTime:0.015756s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133095 AND `partno` = '3400.125.100.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%igus%' ) [ RunTime:0.017818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51084178 LIMIT 5 [ RunTime:0.005654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084178 ORDER BY `minOrder` ASC [ RunTime:0.014176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51084178 ORDER BY `unit` DESC [ RunTime:0.021536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51084178 LIMIT 2 [ RunTime:0.022194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084178 ORDER BY `minOrder` ASC [ RunTime:0.011953s ]
select * from pdf where partno='3400-0000' and brandshort='trumeter' limit 1 [ RunTime:0.005387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-0000' OR `brand` LIKE 'trumeter%' ) ) LIMIT 1 [ RunTime:0.020541s ]
SELECT `id` FROM `stock` WHERE `id` <> 51084178 AND `partno` = '3400-0000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trumeter%' ) [ RunTime:0.013452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853692 [ RunTime:0.017952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133216 LIMIT 5 [ RunTime:0.025683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133216 ORDER BY `minOrder` ASC [ RunTime:0.019251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133216 ORDER BY `unit` DESC [ RunTime:0.023375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133216 LIMIT 2 [ RunTime:0.016960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133216 ORDER BY `minOrder` ASC [ RunTime:0.017712s ]
select * from pdf where partno='3400.200.200.0' and brandshort='igus' limit 1 [ RunTime:0.017829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.200.200.0' OR `brand` LIKE 'igus%' ) ) LIMIT 1 [ RunTime:0.024829s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133216 AND `partno` = '3400.200.200.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%igus%' ) [ RunTime:0.026047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51084179 LIMIT 5 [ RunTime:0.022153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084179 ORDER BY `minOrder` ASC [ RunTime:0.019836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51084179 ORDER BY `unit` DESC [ RunTime:0.031807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51084179 LIMIT 2 [ RunTime:0.025784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084179 ORDER BY `minOrder` ASC [ RunTime:0.011967s ]
select * from pdf where partno='3400-0010' and brandshort='trumeter' limit 1 [ RunTime:0.021872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-0010' OR `brand` LIKE 'trumeter%' ) ) LIMIT 1 [ RunTime:0.025376s ]
SELECT `id` FROM `stock` WHERE `id` <> 51084179 AND `partno` = '3400-0010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trumeter%' ) [ RunTime:0.017768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853339 [ RunTime:0.014062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51116721 LIMIT 5 [ RunTime:0.001321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116721 ORDER BY `minOrder` ASC [ RunTime:0.013409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51116721 ORDER BY `unit` DESC [ RunTime:0.010649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51116721 LIMIT 2 [ RunTime:0.002342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51116721 ORDER BY `minOrder` ASC [ RunTime:0.002998s ]
select * from pdf where partno='3400s-1-201l' and brandshort='bourns' limit 1 [ RunTime:0.009966s ]
select foldpath,foldpath2,filename from pdf_file where id=1565948 limit 1 [ RunTime:0.014435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400s-1-201l' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.003353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32306479 LIMIT 5 [ RunTime:0.007168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32306479 ORDER BY `minOrder` ASC [ RunTime:0.010445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32306479 ORDER BY `unit` DESC [ RunTime:0.019368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32306479 LIMIT 2 [ RunTime:0.007387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32306479 ORDER BY `minOrder` ASC [ RunTime:0.002778s ]
select * from pdf where partno='34006-2000-17-2' and brandshort='jumptec' limit 1 [ RunTime:0.003479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34006-2000-17-2' OR `brand` LIKE 'jumptec%' ) ) LIMIT 1 [ RunTime:0.010894s ]
SELECT `id` FROM `stock` WHERE `id` <> 32306479 AND `partno` = '34006-2000-17-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jumptec%' ) [ RunTime:0.013852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51084303 LIMIT 5 [ RunTime:0.007044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084303 ORDER BY `minOrder` ASC [ RunTime:0.014663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51084303 ORDER BY `unit` DESC [ RunTime:0.021793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51084303 LIMIT 2 [ RunTime:0.012569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084303 ORDER BY `minOrder` ASC [ RunTime:0.011939s ]
select * from pdf where partno='3400-1000' and brandshort='trumeter' limit 1 [ RunTime:0.009512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-1000' OR `brand` LIKE 'trumeter%' ) ) LIMIT 1 [ RunTime:0.017990s ]
SELECT `id` FROM `stock` WHERE `id` <> 51084303 AND `partno` = '3400-1000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trumeter%' ) [ RunTime:0.003640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15239744 [ RunTime:0.015771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51117941 LIMIT 5 [ RunTime:0.036251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51117941 ORDER BY `minOrder` ASC [ RunTime:0.018372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51117941 ORDER BY `unit` DESC [ RunTime:0.014029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51117941 LIMIT 2 [ RunTime:0.010910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51117941 ORDER BY `minOrder` ASC [ RunTime:0.005527s ]
select * from pdf where partno='3400s-1-202l' and brandshort='bourns' limit 1 [ RunTime:0.010117s ]
select foldpath,foldpath2,filename from pdf_file where id=1565948 limit 1 [ RunTime:0.016096s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400s-1-202l' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.014503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090233 LIMIT 5 [ RunTime:0.013573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090233 ORDER BY `minOrder` ASC [ RunTime:0.026258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090233 ORDER BY `unit` DESC [ RunTime:0.025665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090233 LIMIT 2 [ RunTime:0.014956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090233 ORDER BY `minOrder` ASC [ RunTime:0.004709s ]
select * from pdf where partno='3400-p10-h-si-2a' and brandshort='e-t-a' limit 1 [ RunTime:0.021710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-p10-h-si-2a' OR `brand` LIKE 'e-t-a%' ) ) LIMIT 1 [ RunTime:0.001172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32290224 LIMIT 5 [ RunTime:0.020685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290224 ORDER BY `minOrder` ASC [ RunTime:0.004029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32290224 ORDER BY `unit` DESC [ RunTime:0.002451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32290224 LIMIT 2 [ RunTime:0.004697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290224 ORDER BY `minOrder` ASC [ RunTime:0.002782s ]
select * from pdf where partno='34006-0000-99-0' and brandshort='jumptec' limit 1 [ RunTime:0.008044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34006-0000-99-0' OR `brand` LIKE 'jumptec%' ) ) LIMIT 1 [ RunTime:0.004731s ]
SELECT `id` FROM `stock` WHERE `id` <> 32290224 AND `partno` = '34006-0000-99-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jumptec%' ) [ RunTime:0.001072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32213893 LIMIT 5 [ RunTime:0.012783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32213893 ORDER BY `minOrder` ASC [ RunTime:0.018810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32213893 ORDER BY `unit` DESC [ RunTime:0.018018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32213893 LIMIT 2 [ RunTime:0.004494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32213893 ORDER BY `minOrder` ASC [ RunTime:0.009734s ]
select * from pdf where partno='3400-p10-h-si-15a' and brandshort='e-t-a' limit 1 [ RunTime:0.003748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-p10-h-si-15a' OR `brand` LIKE 'e-t-a%' ) ) LIMIT 1 [ RunTime:0.015478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51084304 LIMIT 5 [ RunTime:0.007226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084304 ORDER BY `minOrder` ASC [ RunTime:0.007040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51084304 ORDER BY `unit` DESC [ RunTime:0.003076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51084304 LIMIT 2 [ RunTime:0.008049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51084304 ORDER BY `minOrder` ASC [ RunTime:0.004701s ]
select * from pdf where partno='3400-2010' and brandshort='trumeter' limit 1 [ RunTime:0.008541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-2010' OR `brand` LIKE 'trumeter%' ) ) LIMIT 1 [ RunTime:0.010063s ]
SELECT `id` FROM `stock` WHERE `id` <> 51084304 AND `partno` = '3400-2010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trumeter%' ) [ RunTime:0.014165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15239777 [ RunTime:0.010747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090089 LIMIT 5 [ RunTime:0.007643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090089 ORDER BY `minOrder` ASC [ RunTime:0.008394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090089 ORDER BY `unit` DESC [ RunTime:0.038233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090089 LIMIT 2 [ RunTime:0.020673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090089 ORDER BY `minOrder` ASC [ RunTime:0.002280s ]
select * from pdf where partno='3400-ig8-p10-si-8a' and brandshort='e-t-a' limit 1 [ RunTime:0.005701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-ig8-p10-si-8a' OR `brand` LIKE 'e-t-a%' ) ) LIMIT 1 [ RunTime:0.016743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51089928 LIMIT 5 [ RunTime:0.001296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089928 ORDER BY `minOrder` ASC [ RunTime:0.006107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51089928 ORDER BY `unit` DESC [ RunTime:0.032969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51089928 LIMIT 2 [ RunTime:0.007896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089928 ORDER BY `minOrder` ASC [ RunTime:0.002786s ]
select * from pdf where partno='3400-ig2-p10-si-15a' and brandshort='e-t-a' limit 1 [ RunTime:0.005795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-ig2-p10-si-15a' OR `brand` LIKE 'e-t-a%' ) ) LIMIT 1 [ RunTime:0.017728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32290082 LIMIT 5 [ RunTime:0.003388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290082 ORDER BY `minOrder` ASC [ RunTime:0.019025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32290082 ORDER BY `unit` DESC [ RunTime:0.013933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32290082 LIMIT 2 [ RunTime:0.021686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290082 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
select * from pdf where partno='34009-0000-99-2' and brandshort='jumptec' limit 1 [ RunTime:0.003625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34009-0000-99-2' OR `brand` LIKE 'jumptec%' ) ) LIMIT 1 [ RunTime:0.007332s ]
SELECT `id` FROM `stock` WHERE `id` <> 32290082 AND `partno` = '34009-0000-99-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jumptec%' ) [ RunTime:0.011768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090032 LIMIT 5 [ RunTime:0.006997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090032 ORDER BY `minOrder` ASC [ RunTime:0.019461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090032 ORDER BY `unit` DESC [ RunTime:0.003154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090032 LIMIT 2 [ RunTime:0.007786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090032 ORDER BY `minOrder` ASC [ RunTime:0.003401s ]
select * from pdf where partno='3400-ig8-p10-15a' and brandshort='e-t-a' limit 1 [ RunTime:0.009567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-ig8-p10-15a' OR `brand` LIKE 'e-t-a%' ) ) LIMIT 1 [ RunTime:0.002329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090031 LIMIT 5 [ RunTime:0.001247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090031 ORDER BY `minOrder` ASC [ RunTime:0.012509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090031 ORDER BY `unit` DESC [ RunTime:0.011900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090031 LIMIT 2 [ RunTime:0.007773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090031 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
select * from pdf where partno='3400-ig8-p10-1.2a' and brandshort='e-t-a' limit 1 [ RunTime:0.008089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-ig8-p10-1.2a' OR `brand` LIKE 'e-t-a%' ) ) LIMIT 1 [ RunTime:0.007028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51089999 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089999 ORDER BY `minOrder` ASC [ RunTime:0.008444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51089999 ORDER BY `unit` DESC [ RunTime:0.004058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51089999 LIMIT 2 [ RunTime:0.000876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51089999 ORDER BY `minOrder` ASC [ RunTime:0.001241s ]
select * from pdf where partno='3400-ig2-k20-16a' and brandshort='e-t-a' limit 1 [ RunTime:0.005494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-ig2-k20-16a' OR `brand` LIKE 'e-t-a%' ) ) LIMIT 1 [ RunTime:0.007536s ]
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 '3400%' OR `brand` LIKE '3400%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57359808 LIMIT 5 [ RunTime:0.010945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57359808 ORDER BY `minOrder` ASC [ RunTime:0.001428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57359808 ORDER BY `unit` DESC [ RunTime:0.001445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57359808 LIMIT 2 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57359808 ORDER BY `minOrder` ASC [ RunTime:0.009288s ]
select * from pdf where partno='3400BL15A0100001E' and brandshort='Johanson Technology Inc.' limit 1 [ RunTime:0.001569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400BL15A0100001E' OR `brand` LIKE 'Johanson Technology Inc.%' ) ) LIMIT 1 [ RunTime:0.009889s ]
SELECT `id` FROM `stock` WHERE `id` <> 57359808 AND `partno` = '3400BL15A0100001E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%johanson technology inc.%' ) [ RunTime:0.002194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13221741 [ RunTime:0.002755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44056921 LIMIT 5 [ RunTime:0.006785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44056921 ORDER BY `minOrder` ASC [ RunTime:0.006466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44056921 ORDER BY `unit` DESC [ RunTime:0.009822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44056921 LIMIT 2 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44056921 ORDER BY `minOrder` ASC [ RunTime:0.003992s ]
select * from pdf where partno='3400' and brandshort='Goford Semiconductor' limit 1 [ RunTime:0.004076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400' OR `brand` LIKE 'Goford Semiconductor%' ) ) LIMIT 1 [ RunTime:0.005081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44065035 LIMIT 5 [ RunTime:0.003588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44065035 ORDER BY `minOrder` ASC [ RunTime:0.010541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44065035 ORDER BY `unit` DESC [ RunTime:0.011409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44065035 LIMIT 2 [ RunTime:0.007709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44065035 ORDER BY `minOrder` ASC [ RunTime:0.005872s ]
select * from pdf where partno='3400L' and brandshort='Goford Semiconductor' limit 1 [ RunTime:0.001561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400L' OR `brand` LIKE 'Goford Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003365s ]
SELECT `id` FROM `stock` WHERE `id` <> 44065035 AND `partno` = '3400L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%goford semiconductor%' ) [ RunTime:0.004011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52532513 LIMIT 5 [ RunTime:0.012099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52532513 ORDER BY `minOrder` ASC [ RunTime:0.022174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52532513 ORDER BY `unit` DESC [ RunTime:0.017622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52532513 LIMIT 2 [ RunTime:0.021930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52532513 ORDER BY `minOrder` ASC [ RunTime:0.007809s ]
select * from pdf where partno='34000000-05' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.006030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34000000-05' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.004230s ]
SELECT `id` FROM `stock` WHERE `id` <> 52532513 AND `partno` = '34000000-05' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%chogori technologies inc.%' ) [ RunTime:0.017746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932169 [ RunTime:0.005215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52533332 LIMIT 5 [ RunTime:0.002041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52533332 ORDER BY `minOrder` ASC [ RunTime:0.002039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52533332 ORDER BY `unit` DESC [ RunTime:0.004251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52533332 LIMIT 2 [ RunTime:0.003170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52533332 ORDER BY `minOrder` ASC [ RunTime:0.001653s ]
select * from pdf where partno='34000000-03' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.001151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34000000-03' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.006160s ]
SELECT `id` FROM `stock` WHERE `id` <> 52533332 AND `partno` = '34000000-03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%chogori technologies inc.%' ) [ RunTime:0.006036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932163 [ RunTime:0.012714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594977 LIMIT 5 [ RunTime:0.003003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594977 ORDER BY `minOrder` ASC [ RunTime:0.001429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594977 ORDER BY `unit` DESC [ RunTime:0.006224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594977 LIMIT 2 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594977 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
select * from pdf where partno='3400S-1-502L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.004985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400S-1-502L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.017416s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594977 AND `partno` = '3400S-1-502L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.003620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16799600 [ RunTime:0.005748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40595428 LIMIT 5 [ RunTime:0.002606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40595428 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40595428 ORDER BY `unit` DESC [ RunTime:0.003206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40595428 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40595428 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='3400S-1-201L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400S-1-201L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000482s ]
SELECT `id` FROM `stock` WHERE `id` <> 40595428 AND `partno` = '3400S-1-201L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.013085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15720146 [ RunTime:0.001200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57268832 LIMIT 5 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57268832 ORDER BY `minOrder` ASC [ RunTime:0.001435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57268832 ORDER BY `unit` DESC [ RunTime:0.009382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57268832 LIMIT 2 [ RunTime:0.005552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57268832 ORDER BY `minOrder` ASC [ RunTime:0.001729s ]
select * from pdf where partno='3400-0010' and brandshort='Trumeter' limit 1 [ RunTime:0.016622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-0010' OR `brand` LIKE 'Trumeter%' ) ) LIMIT 1 [ RunTime:0.009135s ]
SELECT `id` FROM `stock` WHERE `id` <> 57268832 AND `partno` = '3400-0010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trumeter%' ) [ RunTime:0.002159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853339 [ RunTime:0.002797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40595636 LIMIT 5 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40595636 ORDER BY `minOrder` ASC [ RunTime:0.009802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40595636 ORDER BY `unit` DESC [ RunTime:0.001514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40595636 LIMIT 2 [ RunTime:0.002858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40595636 ORDER BY `minOrder` ASC [ RunTime:0.001004s ]
select * from pdf where partno='3400S-1-204L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.004169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400S-1-204L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000797s ]
SELECT `id` FROM `stock` WHERE `id` <> 40595636 AND `partno` = '3400S-1-204L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.002553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14049747 [ RunTime:0.000783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594978 LIMIT 5 [ RunTime:0.007898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594978 ORDER BY `minOrder` ASC [ RunTime:0.003656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594978 ORDER BY `unit` DESC [ RunTime:0.003356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594978 LIMIT 2 [ RunTime:0.006405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594978 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='3400S-1-103L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400S-1-103L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001260s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594978 AND `partno` = '3400S-1-103L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.004741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17843949 [ RunTime:0.006116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594979 LIMIT 5 [ RunTime:0.001676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594979 ORDER BY `minOrder` ASC [ RunTime:0.003135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594979 ORDER BY `unit` DESC [ RunTime:0.002558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594979 LIMIT 2 [ RunTime:0.004374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594979 ORDER BY `minOrder` ASC [ RunTime:0.000793s ]
select * from pdf where partno='3400S-1-501L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.007940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400S-1-501L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002463s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594979 AND `partno` = '3400S-1-501L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.003448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14066600 [ RunTime:0.002260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57268834 LIMIT 5 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57268834 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57268834 ORDER BY `unit` DESC [ RunTime:0.005462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57268834 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57268834 ORDER BY `minOrder` ASC [ RunTime:0.006772s ]
select * from pdf where partno='3400-2010' and brandshort='Trumeter' limit 1 [ RunTime:0.012370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-2010' OR `brand` LIKE 'Trumeter%' ) ) LIMIT 1 [ RunTime:0.009794s ]
SELECT `id` FROM `stock` WHERE `id` <> 57268834 AND `partno` = '3400-2010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trumeter%' ) [ RunTime:0.007678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15239777 [ RunTime:0.000549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40594980 LIMIT 5 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594980 ORDER BY `minOrder` ASC [ RunTime:0.004107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40594980 ORDER BY `unit` DESC [ RunTime:0.007364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40594980 LIMIT 2 [ RunTime:0.007265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40594980 ORDER BY `minOrder` ASC [ RunTime:0.001095s ]
select * from pdf where partno='3400S-1-101L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.019190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400S-1-101L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.005443s ]
SELECT `id` FROM `stock` WHERE `id` <> 40594980 AND `partno` = '3400S-1-101L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.010316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14987970 [ RunTime:0.003141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57692560 LIMIT 5 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57692560 ORDER BY `minOrder` ASC [ RunTime:0.005858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57692560 ORDER BY `unit` DESC [ RunTime:0.001993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57692560 LIMIT 2 [ RunTime:0.001292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57692560 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='3400-R' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-R' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007898s ]
SELECT `id` FROM `stock` WHERE `id` <> 57692560 AND `partno` = '3400-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.013111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394020 [ RunTime:0.003285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57692724 LIMIT 5 [ RunTime:0.002965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57692724 ORDER BY `minOrder` ASC [ RunTime:0.011133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57692724 ORDER BY `unit` DESC [ RunTime:0.005138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57692724 LIMIT 2 [ RunTime:0.003651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57692724 ORDER BY `minOrder` ASC [ RunTime:0.005864s ]
select * from pdf where partno='3400-L' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-L' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009262s ]
SELECT `id` FROM `stock` WHERE `id` <> 57692724 AND `partno` = '3400-L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521492 [ RunTime:0.008036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40596067 LIMIT 5 [ RunTime:0.003967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40596067 ORDER BY `minOrder` ASC [ RunTime:0.001296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40596067 ORDER BY `unit` DESC [ RunTime:0.001112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40596067 LIMIT 2 [ RunTime:0.007864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40596067 ORDER BY `minOrder` ASC [ RunTime:0.005547s ]
select * from pdf where partno='3400S-1-102L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.007731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400S-1-102L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001866s ]
SELECT `id` FROM `stock` WHERE `id` <> 40596067 AND `partno` = '3400S-1-102L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.009926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16781147 [ RunTime:0.005811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40596095 LIMIT 5 [ RunTime:0.024195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40596095 ORDER BY `minOrder` ASC [ RunTime:0.011377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40596095 ORDER BY `unit` DESC [ RunTime:0.002306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40596095 LIMIT 2 [ RunTime:0.016918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40596095 ORDER BY `minOrder` ASC [ RunTime:0.000867s ]
select * from pdf where partno='3400S-1-504L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.001142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400S-1-504L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.011256s ]
SELECT `id` FROM `stock` WHERE `id` <> 40596095 AND `partno` = '3400S-1-504L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.004735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17843951 [ RunTime:0.000761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40596781 LIMIT 5 [ RunTime:0.004827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40596781 ORDER BY `minOrder` ASC [ RunTime:0.005352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40596781 ORDER BY `unit` DESC [ RunTime:0.001183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40596781 LIMIT 2 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40596781 ORDER BY `minOrder` ASC [ RunTime:0.003211s ]
select * from pdf where partno='3400S-1-202L' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400S-1-202L' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.006162s ]
SELECT `id` FROM `stock` WHERE `id` <> 40596781 AND `partno` = '3400S-1-202L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.023041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17770500 [ RunTime:0.001277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57268993 LIMIT 5 [ RunTime:0.000963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57268993 ORDER BY `minOrder` ASC [ RunTime:0.000978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57268993 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57268993 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57268993 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='3400-0000' and brandshort='Trumeter' limit 1 [ RunTime:0.003057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-0000' OR `brand` LIKE 'Trumeter%' ) ) LIMIT 1 [ RunTime:0.002975s ]
SELECT `id` FROM `stock` WHERE `id` <> 57268993 AND `partno` = '3400-0000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trumeter%' ) [ RunTime:0.001581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18853692 [ RunTime:0.002185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57268994 LIMIT 5 [ RunTime:0.000689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57268994 ORDER BY `minOrder` ASC [ RunTime:0.004213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57268994 ORDER BY `unit` DESC [ RunTime:0.003102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57268994 LIMIT 2 [ RunTime:0.002271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57268994 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
select * from pdf where partno='3400-1010' and brandshort='Trumeter' limit 1 [ RunTime:0.000963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400-1010' OR `brand` LIKE 'Trumeter%' ) ) LIMIT 1 [ RunTime:0.010612s ]
SELECT `id` FROM `stock` WHERE `id` <> 57268994 AND `partno` = '3400-1010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trumeter%' ) [ RunTime:0.001847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15239743 [ RunTime:0.012567s ]
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 '3400%' OR `brand` LIKE '3400%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013063s ]
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 '3400%' OR `brand` LIKE '3400%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007438s ]
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 '3400%' OR `brand` LIKE '3400%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003093s ]
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 '3400%' OR `brand` LIKE '3400%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007672s ]
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 '3400%' OR `brand` LIKE '3400%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001944s ]
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 '3400%' OR `brand` LIKE '3400%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005716s ]
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 '3400%' OR `brand` LIKE '3400%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003250s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3400%' OR `brand` LIKE '3400%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008084s ]