SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001176s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.202' , `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=AN310&search=1' [ RunTime:0.015037s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002530s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011900s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002580s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.202' ) [ RunTime:0.003857s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002303s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004044s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002467s ]
SELECT * FROM `stock_search` WHERE `partno` = 'AN310' LIMIT 1 [ RunTime:0.006795s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-06 03:42:09' WHERE `partno` = 'AN310' [ RunTime:0.009153s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002682s ]
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 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055726s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850779 LIMIT 5 [ RunTime:0.015743s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850779 ORDER BY `minOrder` ASC [ RunTime:0.018450s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17850779 ORDER BY `unit` DESC [ RunTime:0.024831s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17850779 LIMIT 2 [ RunTime:0.003209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17850779 ORDER BY `minOrder` ASC [ RunTime:0.012378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800604 LIMIT 5 [ RunTime:0.019849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800604 ORDER BY `minOrder` ASC [ RunTime:0.013367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16800604 ORDER BY `unit` DESC [ RunTime:0.012266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16800604 LIMIT 2 [ RunTime:0.007769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16800604 ORDER BY `minOrder` ASC [ RunTime:0.002075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13034813 LIMIT 5 [ RunTime:0.003856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13034813 ORDER BY `minOrder` ASC [ RunTime:0.021749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13034813 ORDER BY `unit` DESC [ RunTime:0.012565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13034813 LIMIT 2 [ RunTime:0.024895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13034813 ORDER BY `minOrder` ASC [ RunTime:0.009004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13034182 LIMIT 5 [ RunTime:0.021898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13034182 ORDER BY `minOrder` ASC [ RunTime:0.010213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13034182 ORDER BY `unit` DESC [ RunTime:0.001279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13034182 LIMIT 2 [ RunTime:0.005525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13034182 ORDER BY `minOrder` ASC [ RunTime:0.029519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13033627 LIMIT 5 [ RunTime:0.025642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13033627 ORDER BY `minOrder` ASC [ RunTime:0.035611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13033627 ORDER BY `unit` DESC [ RunTime:0.022124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13033627 LIMIT 2 [ RunTime:0.011924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13033627 ORDER BY `minOrder` ASC [ RunTime:0.008945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13033317 LIMIT 5 [ RunTime:0.014863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13033317 ORDER BY `minOrder` ASC [ RunTime:0.030107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13033317 ORDER BY `unit` DESC [ RunTime:0.020142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13033317 LIMIT 2 [ RunTime:0.015258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13033317 ORDER BY `minOrder` ASC [ RunTime:0.014987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13032651 LIMIT 5 [ RunTime:0.031222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13032651 ORDER BY `minOrder` ASC [ RunTime:0.029485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13032651 ORDER BY `unit` DESC [ RunTime:0.020605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13032651 LIMIT 2 [ RunTime:0.018161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13032651 ORDER BY `minOrder` ASC [ RunTime:0.036804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13032454 LIMIT 5 [ RunTime:0.011684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13032454 ORDER BY `minOrder` ASC [ RunTime:0.009705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13032454 ORDER BY `unit` DESC [ RunTime:0.012508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13032454 LIMIT 2 [ RunTime:0.027659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13032454 ORDER BY `minOrder` ASC [ RunTime:0.001113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13031841 LIMIT 5 [ RunTime:0.000959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13031841 ORDER BY `minOrder` ASC [ RunTime:0.005062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13031841 ORDER BY `unit` DESC [ RunTime:0.010685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13031841 LIMIT 2 [ RunTime:0.019741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13031841 ORDER BY `minOrder` ASC [ RunTime:0.000645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13030608 LIMIT 5 [ RunTime:0.008391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13030608 ORDER BY `minOrder` ASC [ RunTime:0.008110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13030608 ORDER BY `unit` DESC [ RunTime:0.018911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13030608 LIMIT 2 [ RunTime:0.007818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13030608 ORDER BY `minOrder` ASC [ RunTime:0.003228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13028918 LIMIT 5 [ RunTime:0.007838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13028918 ORDER BY `minOrder` ASC [ RunTime:0.016113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13028918 ORDER BY `unit` DESC [ RunTime:0.009589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13028918 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13028918 ORDER BY `minOrder` ASC [ RunTime:0.007683s ]
select * from pdf where partno='AN3102C-32-3S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.013307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13028434 LIMIT 5 [ RunTime:0.002360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13028434 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13028434 ORDER BY `unit` DESC [ RunTime:0.000328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13028434 LIMIT 2 [ RunTime:0.008113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13028434 ORDER BY `minOrder` ASC [ RunTime:0.001757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13028239 LIMIT 5 [ RunTime:0.004188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13028239 ORDER BY `minOrder` ASC [ RunTime:0.001080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13028239 ORDER BY `unit` DESC [ RunTime:0.000330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13028239 LIMIT 2 [ RunTime:0.010116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13028239 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13024034 LIMIT 5 [ RunTime:0.001169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13024034 ORDER BY `minOrder` ASC [ RunTime:0.005563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13024034 ORDER BY `unit` DESC [ RunTime:0.000329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13024034 LIMIT 2 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13024034 ORDER BY `minOrder` ASC [ RunTime:0.020643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13023075 LIMIT 5 [ RunTime:0.003225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13023075 ORDER BY `minOrder` ASC [ RunTime:0.005588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13023075 ORDER BY `unit` DESC [ RunTime:0.003917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13023075 LIMIT 2 [ RunTime:0.006074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13023075 ORDER BY `minOrder` ASC [ RunTime:0.003639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13022715 LIMIT 5 [ RunTime:0.003086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13022715 ORDER BY `minOrder` ASC [ RunTime:0.007844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13022715 ORDER BY `unit` DESC [ RunTime:0.011158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13022715 LIMIT 2 [ RunTime:0.000816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13022715 ORDER BY `minOrder` ASC [ RunTime:0.003524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13022711 LIMIT 5 [ RunTime:0.005994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13022711 ORDER BY `minOrder` ASC [ RunTime:0.000782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13022711 ORDER BY `unit` DESC [ RunTime:0.010338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13022711 LIMIT 2 [ RunTime:0.022625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13022711 ORDER BY `minOrder` ASC [ RunTime:0.008618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13021738 LIMIT 5 [ RunTime:0.015679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13021738 ORDER BY `minOrder` ASC [ RunTime:0.008205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13021738 ORDER BY `unit` DESC [ RunTime:0.000829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13021738 LIMIT 2 [ RunTime:0.005946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13021738 ORDER BY `minOrder` ASC [ RunTime:0.007744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13021551 LIMIT 5 [ RunTime:0.001218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13021551 ORDER BY `minOrder` ASC [ RunTime:0.009453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13021551 ORDER BY `unit` DESC [ RunTime:0.009722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13021551 LIMIT 2 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13021551 ORDER BY `minOrder` ASC [ RunTime:0.008842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13020831 LIMIT 5 [ RunTime:0.005976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13020831 ORDER BY `minOrder` ASC [ RunTime:0.039858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13020831 ORDER BY `unit` DESC [ RunTime:0.025447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13020831 LIMIT 2 [ RunTime:0.003072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13020831 ORDER BY `minOrder` ASC [ RunTime:0.001608s ]
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 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013996s ]
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 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.078052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63522798 LIMIT 5 [ RunTime:0.011274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522798 ORDER BY `minOrder` ASC [ RunTime:0.010248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63522798 ORDER BY `unit` DESC [ RunTime:0.003002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63522798 LIMIT 2 [ RunTime:0.006527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522798 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
select * from pdf where partno='AN310-NIST' and brandshort='FLIR Extech' limit 1 [ RunTime:0.011724s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN310-NIST' OR `brand` LIKE 'FLIR Extech%' ) ) LIMIT 1 [ RunTime:0.011079s ]
SELECT `id` FROM `stock` WHERE `id` <> 63522798 AND `partno` = 'AN310-NIST' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flir extech%' ) [ RunTime:0.013431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16800604 [ RunTime:0.019878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63522741 LIMIT 5 [ RunTime:0.007500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522741 ORDER BY `minOrder` ASC [ RunTime:0.015976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63522741 ORDER BY `unit` DESC [ RunTime:0.013468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63522741 LIMIT 2 [ RunTime:0.006856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63522741 ORDER BY `minOrder` ASC [ RunTime:0.011324s ]
select * from pdf where partno='AN310' and brandshort='FLIR Extech' limit 1 [ RunTime:0.002704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN310' OR `brand` LIKE 'FLIR Extech%' ) ) LIMIT 1 [ RunTime:0.001624s ]
SELECT `id` FROM `stock` WHERE `id` <> 63522741 AND `partno` = 'AN310' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flir extech%' ) [ RunTime:0.017702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17850779 [ RunTime:0.011983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61452164 LIMIT 5 [ RunTime:0.001127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61452164 ORDER BY `minOrder` ASC [ RunTime:0.023588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61452164 ORDER BY `unit` DESC [ RunTime:0.008228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61452164 LIMIT 2 [ RunTime:0.017367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61452164 ORDER BY `minOrder` ASC [ RunTime:0.013768s ]
select * from pdf where partno='AN3100C-40-10S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.012623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-40-10S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.006924s ]
SELECT `id` FROM `stock` WHERE `id` <> 61452164 AND `partno` = 'AN3100C-40-10S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.014739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61427528 LIMIT 5 [ RunTime:0.020158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61427528 ORDER BY `minOrder` ASC [ RunTime:0.028570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61427528 ORDER BY `unit` DESC [ RunTime:0.031574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61427528 LIMIT 2 [ RunTime:0.032628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61427528 ORDER BY `minOrder` ASC [ RunTime:0.012938s ]
select * from pdf where partno='AN3102C-40-10S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.016735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3102C-40-10S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.018823s ]
SELECT `id` FROM `stock` WHERE `id` <> 61427528 AND `partno` = 'AN3102C-40-10S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.010660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10872853 [ RunTime:0.007920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61417957 LIMIT 5 [ RunTime:0.007905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61417957 ORDER BY `minOrder` ASC [ RunTime:0.015415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61417957 ORDER BY `unit` DESC [ RunTime:0.010984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61417957 LIMIT 2 [ RunTime:0.034708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61417957 ORDER BY `minOrder` ASC [ RunTime:0.002496s ]
select * from pdf where partno='AN3100C-40-9S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.008525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-40-9S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.008598s ]
SELECT `id` FROM `stock` WHERE `id` <> 61417957 AND `partno` = 'AN3100C-40-9S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.004230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10865081 [ RunTime:0.008666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61409678 LIMIT 5 [ RunTime:0.002004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61409678 ORDER BY `minOrder` ASC [ RunTime:0.014281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61409678 ORDER BY `unit` DESC [ RunTime:0.003527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61409678 LIMIT 2 [ RunTime:0.008414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61409678 ORDER BY `minOrder` ASC [ RunTime:0.009008s ]
select * from pdf where partno='AN3100C-36-17S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.014397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-17S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.007228s ]
SELECT `id` FROM `stock` WHERE `id` <> 61409678 AND `partno` = 'AN3100C-36-17S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.003961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10858070 [ RunTime:0.017506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61405476 LIMIT 5 [ RunTime:0.002888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61405476 ORDER BY `minOrder` ASC [ RunTime:0.023062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61405476 ORDER BY `unit` DESC [ RunTime:0.015826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61405476 LIMIT 2 [ RunTime:0.010121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61405476 ORDER BY `minOrder` ASC [ RunTime:0.004879s ]
select * from pdf where partno='AN3100C-36-11S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.000905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-11S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.018935s ]
SELECT `id` FROM `stock` WHERE `id` <> 61405476 AND `partno` = 'AN3100C-36-11S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.017946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10854077 [ RunTime:0.003190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61405370 LIMIT 5 [ RunTime:0.003277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61405370 ORDER BY `minOrder` ASC [ RunTime:0.001990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61405370 ORDER BY `unit` DESC [ RunTime:0.009267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61405370 LIMIT 2 [ RunTime:0.017287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61405370 ORDER BY `minOrder` ASC [ RunTime:0.007700s ]
select * from pdf where partno='AN3100C-36-16S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.033498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-16S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.024328s ]
SELECT `id` FROM `stock` WHERE `id` <> 61405370 AND `partno` = 'AN3100C-36-16S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.008982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10853947 [ RunTime:0.018876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61404244 LIMIT 5 [ RunTime:0.009836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61404244 ORDER BY `minOrder` ASC [ RunTime:0.017414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61404244 ORDER BY `unit` DESC [ RunTime:0.029302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61404244 LIMIT 2 [ RunTime:0.011333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61404244 ORDER BY `minOrder` ASC [ RunTime:0.009312s ]
select * from pdf where partno='AN3100C-36-18S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.008217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-18S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.009771s ]
SELECT `id` FROM `stock` WHERE `id` <> 61404244 AND `partno` = 'AN3100C-36-18S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.010818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10852980 [ RunTime:0.028887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61400505 LIMIT 5 [ RunTime:0.006088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61400505 ORDER BY `minOrder` ASC [ RunTime:0.004123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61400505 ORDER BY `unit` DESC [ RunTime:0.012186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61400505 LIMIT 2 [ RunTime:0.013963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61400505 ORDER BY `minOrder` ASC [ RunTime:0.020764s ]
select * from pdf where partno='AN3100C-36-12S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.022889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-12S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.005742s ]
SELECT `id` FROM `stock` WHERE `id` <> 61400505 AND `partno` = 'AN3100C-36-12S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.005217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10849157 [ RunTime:0.006148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61398138 LIMIT 5 [ RunTime:0.004315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61398138 ORDER BY `minOrder` ASC [ RunTime:0.003745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61398138 ORDER BY `unit` DESC [ RunTime:0.007116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61398138 LIMIT 2 [ RunTime:0.023502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61398138 ORDER BY `minOrder` ASC [ RunTime:0.003460s ]
select * from pdf where partno='AN3100C-40-10P' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.007130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-40-10P' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.011966s ]
SELECT `id` FROM `stock` WHERE `id` <> 61398138 AND `partno` = 'AN3100C-40-10P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.006680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10847005 [ RunTime:0.002332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61393017 LIMIT 5 [ RunTime:0.001429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61393017 ORDER BY `minOrder` ASC [ RunTime:0.005880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61393017 ORDER BY `unit` DESC [ RunTime:0.004841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61393017 LIMIT 2 [ RunTime:0.005980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61393017 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
select * from pdf where partno='AN3100C-36-21S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.012339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-21S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.014596s ]
SELECT `id` FROM `stock` WHERE `id` <> 61393017 AND `partno` = 'AN3100C-36-21S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.000719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10843077 [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61388898 LIMIT 5 [ RunTime:0.003044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61388898 ORDER BY `minOrder` ASC [ RunTime:0.012700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61388898 ORDER BY `unit` DESC [ RunTime:0.004424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61388898 LIMIT 2 [ RunTime:0.015597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61388898 ORDER BY `minOrder` ASC [ RunTime:0.001008s ]
select * from pdf where partno='AN3100C-36-7S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.004759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-7S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.015945s ]
SELECT `id` FROM `stock` WHERE `id` <> 61388898 AND `partno` = 'AN3100C-36-7S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.003474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10839880 [ RunTime:0.001196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61386123 LIMIT 5 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61386123 ORDER BY `minOrder` ASC [ RunTime:0.003257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61386123 ORDER BY `unit` DESC [ RunTime:0.007069s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61386123 LIMIT 2 [ RunTime:0.001353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61386123 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='AN3100C-36-10S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.009577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-10S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.000923s ]
SELECT `id` FROM `stock` WHERE `id` <> 61386123 AND `partno` = 'AN3100C-36-10S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.003238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10837464 [ RunTime:0.010619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61384581 LIMIT 5 [ RunTime:0.004875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61384581 ORDER BY `minOrder` ASC [ RunTime:0.003705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61384581 ORDER BY `unit` DESC [ RunTime:0.003222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61384581 LIMIT 2 [ RunTime:0.007144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61384581 ORDER BY `minOrder` ASC [ RunTime:0.003752s ]
select * from pdf where partno='AN3100C-36-8S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.020412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-8S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.002201s ]
SELECT `id` FROM `stock` WHERE `id` <> 61384581 AND `partno` = 'AN3100C-36-8S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.009669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10835794 [ RunTime:0.001914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61381822 LIMIT 5 [ RunTime:0.001824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61381822 ORDER BY `minOrder` ASC [ RunTime:0.002231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61381822 ORDER BY `unit` DESC [ RunTime:0.011836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61381822 LIMIT 2 [ RunTime:0.010845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61381822 ORDER BY `minOrder` ASC [ RunTime:0.004367s ]
select * from pdf where partno='AN3100C-36-9S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.006990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-9S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.016787s ]
SELECT `id` FROM `stock` WHERE `id` <> 61381822 AND `partno` = 'AN3100C-36-9S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.000928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10833455 [ RunTime:0.005350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61378601 LIMIT 5 [ RunTime:0.002086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61378601 ORDER BY `minOrder` ASC [ RunTime:0.001081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61378601 ORDER BY `unit` DESC [ RunTime:0.008793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61378601 LIMIT 2 [ RunTime:0.009803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61378601 ORDER BY `minOrder` ASC [ RunTime:0.006165s ]
select * from pdf where partno='AN3100C-40-9P' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.006408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-40-9P' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.005539s ]
SELECT `id` FROM `stock` WHERE `id` <> 61378601 AND `partno` = 'AN3100C-40-9P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.009684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13034813 [ RunTime:0.004779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61377187 LIMIT 5 [ RunTime:0.001418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61377187 ORDER BY `minOrder` ASC [ RunTime:0.003482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61377187 ORDER BY `unit` DESC [ RunTime:0.003190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61377187 LIMIT 2 [ RunTime:0.010541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61377187 ORDER BY `minOrder` ASC [ RunTime:0.002105s ]
select * from pdf where partno='AN3102C-40-9S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.001923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3102C-40-9S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.001142s ]
SELECT `id` FROM `stock` WHERE `id` <> 61377187 AND `partno` = 'AN3102C-40-9S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.002429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13034182 [ RunTime:0.001457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61376010 LIMIT 5 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61376010 ORDER BY `minOrder` ASC [ RunTime:0.001202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61376010 ORDER BY `unit` DESC [ RunTime:0.004401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61376010 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61376010 ORDER BY `minOrder` ASC [ RunTime:0.001867s ]
select * from pdf where partno='AN3102C-36-17S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.006647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3102C-36-17S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.000685s ]
SELECT `id` FROM `stock` WHERE `id` <> 61376010 AND `partno` = 'AN3102C-36-17S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.002876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13033627 [ RunTime:0.004431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61375213 LIMIT 5 [ RunTime:0.004937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61375213 ORDER BY `minOrder` ASC [ RunTime:0.001953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61375213 ORDER BY `unit` DESC [ RunTime:0.001170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61375213 LIMIT 2 [ RunTime:0.007562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61375213 ORDER BY `minOrder` ASC [ RunTime:0.004502s ]
select * from pdf where partno='AN3100C-36-6S' and brandshort='Amphenol Industrial Operations' limit 1 [ RunTime:0.010749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AN3100C-36-6S' OR `brand` LIKE 'Amphenol Industrial Operations%' ) ) LIMIT 1 [ RunTime:0.013078s ]
SELECT `id` FROM `stock` WHERE `id` <> 61375213 AND `partno` = 'AN3100C-36-6S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial operations%' ) [ RunTime:0.004303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13033317 [ RunTime:0.005437s ]
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 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001535s ]
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 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004986s ]
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 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001125s ]
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 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007766s ]
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 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005164s ]
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 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007082s ]
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 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002644s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'AN310%' OR `brand` LIKE 'AN310%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017391s ]