SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002117s ]
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=15322&search=1' [ RunTime:0.003308s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000907s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000407s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001410s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000286s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001051s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001138s ]
SELECT * FROM `stock_search` WHERE `partno` = '15322' LIMIT 1 [ RunTime:0.003992s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-23 09:23:49' WHERE `partno` = '15322' [ RunTime:0.002011s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001364s ]
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 '15322%' OR `brand` LIKE '15322%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012890s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684439 LIMIT 5 [ RunTime:0.003699s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684439 ORDER BY `minOrder` ASC [ RunTime:0.000644s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12684439 ORDER BY `unit` DESC [ RunTime:0.006685s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12684439 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684439 ORDER BY `minOrder` ASC [ RunTime:0.002587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13810002 LIMIT 5 [ RunTime:0.009948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13810002 ORDER BY `minOrder` ASC [ RunTime:0.012032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13810002 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13810002 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13810002 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13155737 LIMIT 5 [ RunTime:0.001099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13155737 ORDER BY `minOrder` ASC [ RunTime:0.001099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13155737 ORDER BY `unit` DESC [ RunTime:0.002224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13155737 LIMIT 2 [ RunTime:0.003865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13155737 ORDER BY `minOrder` ASC [ RunTime:0.005632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13155696 LIMIT 5 [ RunTime:0.002196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13155696 ORDER BY `minOrder` ASC [ RunTime:0.004376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13155696 ORDER BY `unit` DESC [ RunTime:0.003327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13155696 LIMIT 2 [ RunTime:0.004024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13155696 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13147062 LIMIT 5 [ RunTime:0.001101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13147062 ORDER BY `minOrder` ASC [ RunTime:0.006177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13147062 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13147062 LIMIT 2 [ RunTime:0.002913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13147062 ORDER BY `minOrder` ASC [ RunTime:0.007055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11895632 LIMIT 5 [ RunTime:0.003090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11895632 ORDER BY `minOrder` ASC [ RunTime:0.008780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11895632 ORDER BY `unit` DESC [ RunTime:0.006763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11895632 LIMIT 2 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11895632 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13155699 LIMIT 5 [ RunTime:0.004004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13155699 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13155699 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13155699 LIMIT 2 [ RunTime:0.020828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13155699 ORDER BY `minOrder` ASC [ RunTime:0.008517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16621597 LIMIT 5 [ RunTime:0.003061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621597 ORDER BY `minOrder` ASC [ RunTime:0.002257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16621597 ORDER BY `unit` DESC [ RunTime:0.010217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16621597 LIMIT 2 [ RunTime:0.012963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621597 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16621592 LIMIT 5 [ RunTime:0.004252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621592 ORDER BY `minOrder` ASC [ RunTime:0.001494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16621592 ORDER BY `unit` DESC [ RunTime:0.010018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16621592 LIMIT 2 [ RunTime:0.005232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16621592 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11905733 LIMIT 5 [ RunTime:0.000920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11905733 ORDER BY `minOrder` ASC [ RunTime:0.013106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11905733 ORDER BY `unit` DESC [ RunTime:0.003152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11905733 LIMIT 2 [ RunTime:0.005436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11905733 ORDER BY `minOrder` ASC [ RunTime:0.002234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13586901 LIMIT 5 [ RunTime:0.004359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13586901 ORDER BY `minOrder` ASC [ RunTime:0.018547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13586901 ORDER BY `unit` DESC [ RunTime:0.018218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13586901 LIMIT 2 [ RunTime:0.005051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13586901 ORDER BY `minOrder` ASC [ RunTime:0.009098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13169754 LIMIT 5 [ RunTime:0.004280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13169754 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13169754 ORDER BY `unit` DESC [ RunTime:0.000695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13169754 LIMIT 2 [ RunTime:0.002481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13169754 ORDER BY `minOrder` ASC [ RunTime:0.005740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13169479 LIMIT 5 [ RunTime:0.003516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13169479 ORDER BY `minOrder` ASC [ RunTime:0.000919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13169479 ORDER BY `unit` DESC [ RunTime:0.015130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13169479 LIMIT 2 [ RunTime:0.001889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13169479 ORDER BY `minOrder` ASC [ RunTime:0.006788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130431 LIMIT 5 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130431 ORDER BY `minOrder` ASC [ RunTime:0.009301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130431 ORDER BY `unit` DESC [ RunTime:0.006604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130431 LIMIT 2 [ RunTime:0.004080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130431 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='1532285-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130404 LIMIT 5 [ RunTime:0.003467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130404 ORDER BY `minOrder` ASC [ RunTime:0.002744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130404 ORDER BY `unit` DESC [ RunTime:0.005238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130404 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130404 ORDER BY `minOrder` ASC [ RunTime:0.008533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127605 LIMIT 5 [ RunTime:0.003800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127605 ORDER BY `minOrder` ASC [ RunTime:0.005327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127605 ORDER BY `unit` DESC [ RunTime:0.004895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127605 LIMIT 2 [ RunTime:0.001546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127605 ORDER BY `minOrder` ASC [ RunTime:0.011287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127090 LIMIT 5 [ RunTime:0.006935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127090 ORDER BY `minOrder` ASC [ RunTime:0.001960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127090 ORDER BY `unit` DESC [ RunTime:0.002053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127090 LIMIT 2 [ RunTime:0.008828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127090 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127084 LIMIT 5 [ RunTime:0.006984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127084 ORDER BY `minOrder` ASC [ RunTime:0.008643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127084 ORDER BY `unit` DESC [ RunTime:0.002689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127084 LIMIT 2 [ RunTime:0.005581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127084 ORDER BY `minOrder` ASC [ RunTime:0.006105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13126411 LIMIT 5 [ RunTime:0.001087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13126411 ORDER BY `minOrder` ASC [ RunTime:0.002193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13126411 ORDER BY `unit` DESC [ RunTime:0.003727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13126411 LIMIT 2 [ RunTime:0.001999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13126411 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13126350 LIMIT 5 [ RunTime:0.002404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13126350 ORDER BY `minOrder` ASC [ RunTime:0.001577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13126350 ORDER BY `unit` DESC [ RunTime:0.000737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13126350 LIMIT 2 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13126350 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
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 '15322%' OR `brand` LIKE '15322%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32266501 LIMIT 5 [ RunTime:0.003541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32266501 ORDER BY `minOrder` ASC [ RunTime:0.029044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32266501 ORDER BY `unit` DESC [ RunTime:0.001956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32266501 LIMIT 2 [ RunTime:0.009295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32266501 ORDER BY `minOrder` ASC [ RunTime:0.005923s ]
select * from pdf where partno='1532207-1' and brandshort='te connectivity' limit 1 [ RunTime:0.020897s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532207-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.035550s ]
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 '15322%' OR `brand` LIKE '15322%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59752853 LIMIT 5 [ RunTime:0.006890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752853 ORDER BY `minOrder` ASC [ RunTime:0.010423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59752853 ORDER BY `unit` DESC [ RunTime:0.016679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59752853 LIMIT 2 [ RunTime:0.023623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752853 ORDER BY `minOrder` ASC [ RunTime:0.009803s ]
select * from pdf where partno='153220-2020-RB-WC' and brandshort='3M' limit 1 [ RunTime:0.004188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '153220-2020-RB-WC' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.024660s ]
SELECT `id` FROM `stock` WHERE `id` <> 59752853 AND `partno` = '153220-2020-RB-WC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.009328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684439 [ RunTime:0.004317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61939784 LIMIT 5 [ RunTime:0.014185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61939784 ORDER BY `minOrder` ASC [ RunTime:0.011899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61939784 ORDER BY `unit` DESC [ RunTime:0.004939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61939784 LIMIT 2 [ RunTime:0.013252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61939784 ORDER BY `minOrder` ASC [ RunTime:0.007476s ]
select * from pdf where partno='1532209-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.011676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532209-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.020167s ]
SELECT `id` FROM `stock` WHERE `id` <> 61939784 AND `partno` = '1532209-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.016740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61935175 LIMIT 5 [ RunTime:0.021781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61935175 ORDER BY `minOrder` ASC [ RunTime:0.026348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61935175 ORDER BY `unit` DESC [ RunTime:0.012835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61935175 LIMIT 2 [ RunTime:0.009135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61935175 ORDER BY `minOrder` ASC [ RunTime:0.002059s ]
select * from pdf where partno='1532210-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.006512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532210-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.022773s ]
SELECT `id` FROM `stock` WHERE `id` <> 61935175 AND `partno` = '1532210-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.012089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62972335 LIMIT 5 [ RunTime:0.002595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62972335 ORDER BY `minOrder` ASC [ RunTime:0.005995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62972335 ORDER BY `unit` DESC [ RunTime:0.000690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62972335 LIMIT 2 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62972335 ORDER BY `minOrder` ASC [ RunTime:0.008024s ]
select * from pdf where partno='1532251-4' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.010603s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532251-4' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.009597s ]
SELECT `id` FROM `stock` WHERE `id` <> 62972335 AND `partno` = '1532251-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.011295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13810002 [ RunTime:0.005368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61935199 LIMIT 5 [ RunTime:0.015150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61935199 ORDER BY `minOrder` ASC [ RunTime:0.019193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61935199 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61935199 LIMIT 2 [ RunTime:0.010500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61935199 ORDER BY `minOrder` ASC [ RunTime:0.001437s ]
select * from pdf where partno='1532212-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.004942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532212-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000789s ]
SELECT `id` FROM `stock` WHERE `id` <> 61935199 AND `partno` = '1532212-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.000766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13155699 [ RunTime:0.000644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35295631 LIMIT 5 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35295631 ORDER BY `minOrder` ASC [ RunTime:0.001387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35295631 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35295631 LIMIT 2 [ RunTime:0.003787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35295631 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='1532210-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532210-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001687s ]
SELECT `id` FROM `stock` WHERE `id` <> 35295631 AND `partno` = '1532210-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13147062 [ RunTime:0.006480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61935209 LIMIT 5 [ RunTime:0.002779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61935209 ORDER BY `minOrder` ASC [ RunTime:0.003639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61935209 ORDER BY `unit` DESC [ RunTime:0.001857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61935209 LIMIT 2 [ RunTime:0.007302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61935209 ORDER BY `minOrder` ASC [ RunTime:0.006243s ]
select * from pdf where partno='1532204-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532204-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.015211s ]
SELECT `id` FROM `stock` WHERE `id` <> 61935209 AND `partno` = '1532204-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.002171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61944047 LIMIT 5 [ RunTime:0.005877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61944047 ORDER BY `minOrder` ASC [ RunTime:0.029939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61944047 ORDER BY `unit` DESC [ RunTime:0.006637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61944047 LIMIT 2 [ RunTime:0.021143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61944047 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='1532214-2' and brandshort='TE Connectivity' limit 1 [ RunTime:0.002494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532214-2' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.024549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61936571 LIMIT 5 [ RunTime:0.001240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61936571 ORDER BY `minOrder` ASC [ RunTime:0.001300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61936571 ORDER BY `unit` DESC [ RunTime:0.006607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61936571 LIMIT 2 [ RunTime:0.011171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61936571 ORDER BY `minOrder` ASC [ RunTime:0.003810s ]
select * from pdf where partno='1532213-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.016150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532213-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000930s ]
SELECT `id` FROM `stock` WHERE `id` <> 61936571 AND `partno` = '1532213-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.001558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61944049 LIMIT 5 [ RunTime:0.003735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61944049 ORDER BY `minOrder` ASC [ RunTime:0.001648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61944049 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61944049 LIMIT 2 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61944049 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='1532203-2' and brandshort='TE Connectivity' limit 1 [ RunTime:0.014611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532203-2' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.039789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61935157 LIMIT 5 [ RunTime:0.003668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61935157 ORDER BY `minOrder` ASC [ RunTime:0.002952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61935157 ORDER BY `unit` DESC [ RunTime:0.004512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61935157 LIMIT 2 [ RunTime:0.007130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61935157 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='1532209-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532209-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000778s ]
SELECT `id` FROM `stock` WHERE `id` <> 61935157 AND `partno` = '1532209-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.011417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61948605 LIMIT 5 [ RunTime:0.017444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61948605 ORDER BY `minOrder` ASC [ RunTime:0.007748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61948605 ORDER BY `unit` DESC [ RunTime:0.008621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61948605 LIMIT 2 [ RunTime:0.001663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61948605 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
select * from pdf where partno='1532207-2' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532207-2' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.022658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975604 LIMIT 5 [ RunTime:0.002851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975604 ORDER BY `minOrder` ASC [ RunTime:0.004949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975604 ORDER BY `unit` DESC [ RunTime:0.001717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975604 LIMIT 2 [ RunTime:0.003077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975604 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='1532273-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532273-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.003247s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975604 AND `partno` = '1532273-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.000552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16621597 [ RunTime:0.003743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61935235 LIMIT 5 [ RunTime:0.000899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61935235 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61935235 ORDER BY `unit` DESC [ RunTime:0.000275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61935235 LIMIT 2 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61935235 ORDER BY `minOrder` ASC [ RunTime:0.000985s ]
select * from pdf where partno='1532215-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532215-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000996s ]
SELECT `id` FROM `stock` WHERE `id` <> 61935235 AND `partno` = '1532215-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13155737 [ RunTime:0.003465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62975568 LIMIT 5 [ RunTime:0.000879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975568 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62975568 ORDER BY `unit` DESC [ RunTime:0.000277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62975568 LIMIT 2 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62975568 ORDER BY `minOrder` ASC [ RunTime:0.004164s ]
select * from pdf where partno='1532250-2' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532250-2' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.000951s ]
SELECT `id` FROM `stock` WHERE `id` <> 62975568 AND `partno` = '1532250-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.001727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16621592 [ RunTime:0.004842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61947953 LIMIT 5 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61947953 ORDER BY `minOrder` ASC [ RunTime:0.002053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61947953 ORDER BY `unit` DESC [ RunTime:0.002296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61947953 LIMIT 2 [ RunTime:0.004408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61947953 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='1532277-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532277-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004350s ]
SELECT `id` FROM `stock` WHERE `id` <> 61947953 AND `partno` = '1532277-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11905733 [ RunTime:0.003921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59386594 LIMIT 5 [ RunTime:0.002052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386594 ORDER BY `minOrder` ASC [ RunTime:0.002043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59386594 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59386594 LIMIT 2 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59386594 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
select * from pdf where partno='1532210000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532210000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004384s ]
SELECT `id` FROM `stock` WHERE `id` <> 59386594 AND `partno` = '1532210000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40495052 LIMIT 5 [ RunTime:0.008469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40495052 ORDER BY `minOrder` ASC [ RunTime:0.001782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40495052 ORDER BY `unit` DESC [ RunTime:0.017389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40495052 LIMIT 2 [ RunTime:0.012278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40495052 ORDER BY `minOrder` ASC [ RunTime:0.006831s ]
select * from pdf where partno='153222' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '153222' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002293s ]
SELECT `id` FROM `stock` WHERE `id` <> 40495052 AND `partno` = '153222' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.001179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61948045 LIMIT 5 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61948045 ORDER BY `minOrder` ASC [ RunTime:0.001028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61948045 ORDER BY `unit` DESC [ RunTime:0.000788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61948045 LIMIT 2 [ RunTime:0.010607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61948045 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='1532233-8' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1532233-8' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.013879s ]
SELECT `id` FROM `stock` WHERE `id` <> 61948045 AND `partno` = '1532233-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.022462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40495051 LIMIT 5 [ RunTime:0.004714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40495051 ORDER BY `minOrder` ASC [ RunTime:0.007433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40495051 ORDER BY `unit` DESC [ RunTime:0.011592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40495051 LIMIT 2 [ RunTime:0.003853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40495051 ORDER BY `minOrder` ASC [ RunTime:0.007116s ]
select * from pdf where partno='153223' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '153223' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000540s ]
SELECT `id` FROM `stock` WHERE `id` <> 40495051 AND `partno` = '153223' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.001331s ]
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 '15322%' OR `brand` LIKE '15322%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001846s ]
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 '15322%' OR `brand` LIKE '15322%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002396s ]
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 '15322%' OR `brand` LIKE '15322%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006889s ]
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 '15322%' OR `brand` LIKE '15322%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000737s ]
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 '15322%' OR `brand` LIKE '15322%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015006s ]
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 '15322%' OR `brand` LIKE '15322%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011766s ]
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 '15322%' OR `brand` LIKE '15322%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004996s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15322%' OR `brand` LIKE '15322%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002017s ]