SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001397s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=69130&search=1' [ RunTime:0.001689s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001139s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000493s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001649s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001355s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001728s ]
SELECT * FROM `stock_search` WHERE `partno` = '69130' LIMIT 1 [ RunTime:0.015555s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-05 03:04:48' WHERE `partno` = '69130' [ RunTime:0.004792s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001221s ]
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 '69130%' OR `brand` LIKE '69130%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033732s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15446748 LIMIT 5 [ RunTime:0.012572s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15446748 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15446748 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15446748 LIMIT 2 [ RunTime:0.009819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15446748 ORDER BY `minOrder` ASC [ RunTime:0.003060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310470 LIMIT 5 [ RunTime:0.011923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310470 ORDER BY `minOrder` ASC [ RunTime:0.000765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17310470 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17310470 LIMIT 2 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310470 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19612039 LIMIT 5 [ RunTime:0.002420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19612039 ORDER BY `minOrder` ASC [ RunTime:0.003273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19612039 ORDER BY `unit` DESC [ RunTime:0.002607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19612039 LIMIT 2 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19612039 ORDER BY `minOrder` ASC [ RunTime:0.000188s ]
select * from pdf where partno='691305140003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15451527 LIMIT 5 [ RunTime:0.003646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451527 ORDER BY `minOrder` ASC [ RunTime:0.006953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15451527 ORDER BY `unit` DESC [ RunTime:0.000952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15451527 LIMIT 2 [ RunTime:0.000802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15451527 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648610 LIMIT 5 [ RunTime:0.000832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648610 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19648610 ORDER BY `unit` DESC [ RunTime:0.000300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19648610 LIMIT 2 [ RunTime:0.002170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648610 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643845 LIMIT 5 [ RunTime:0.005664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643845 ORDER BY `minOrder` ASC [ RunTime:0.002120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19643845 ORDER BY `unit` DESC [ RunTime:0.000891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19643845 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643845 ORDER BY `minOrder` ASC [ RunTime:0.000193s ]
select * from pdf where partno='691307300002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17303670 LIMIT 5 [ RunTime:0.006058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17303670 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17303670 ORDER BY `unit` DESC [ RunTime:0.003353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17303670 LIMIT 2 [ RunTime:0.004177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17303670 ORDER BY `minOrder` ASC [ RunTime:0.005028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307119 LIMIT 5 [ RunTime:0.002229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17307119 ORDER BY `minOrder` ASC [ RunTime:0.005044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17307119 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17307119 LIMIT 2 [ RunTime:0.002746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17307119 ORDER BY `minOrder` ASC [ RunTime:0.000232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634688 LIMIT 5 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634688 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634688 ORDER BY `unit` DESC [ RunTime:0.001939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634688 LIMIT 2 [ RunTime:0.004610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634688 ORDER BY `minOrder` ASC [ RunTime:0.000940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643833 LIMIT 5 [ RunTime:0.000763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643833 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19643833 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19643833 LIMIT 2 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643833 ORDER BY `minOrder` ASC [ RunTime:0.000215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19633989 LIMIT 5 [ RunTime:0.000555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19633989 ORDER BY `minOrder` ASC [ RunTime:0.009042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19633989 ORDER BY `unit` DESC [ RunTime:0.001700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19633989 LIMIT 2 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19633989 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19612853 LIMIT 5 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19612853 ORDER BY `minOrder` ASC [ RunTime:0.001087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19612853 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19612853 LIMIT 2 [ RunTime:0.002437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19612853 ORDER BY `minOrder` ASC [ RunTime:0.002187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19612790 LIMIT 5 [ RunTime:0.003412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19612790 ORDER BY `minOrder` ASC [ RunTime:0.005723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19612790 ORDER BY `unit` DESC [ RunTime:0.004835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19612790 LIMIT 2 [ RunTime:0.000841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19612790 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
select * from pdf where partno='691305140004' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643828 LIMIT 5 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643828 ORDER BY `minOrder` ASC [ RunTime:0.003771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19643828 ORDER BY `unit` DESC [ RunTime:0.006655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19643828 LIMIT 2 [ RunTime:0.002371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643828 ORDER BY `minOrder` ASC [ RunTime:0.010730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648589 LIMIT 5 [ RunTime:0.007319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648589 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19648589 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19648589 LIMIT 2 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648589 ORDER BY `minOrder` ASC [ RunTime:0.002298s ]
select * from pdf where partno='691305340003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.008361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17302285 LIMIT 5 [ RunTime:0.004816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17302285 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17302285 ORDER BY `unit` DESC [ RunTime:0.000326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17302285 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17302285 ORDER BY `minOrder` ASC [ RunTime:0.005109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605788 LIMIT 5 [ RunTime:0.014734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605788 ORDER BY `minOrder` ASC [ RunTime:0.003944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605788 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605788 LIMIT 2 [ RunTime:0.010049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605788 ORDER BY `minOrder` ASC [ RunTime:0.010234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19616001 LIMIT 5 [ RunTime:0.006607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19616001 ORDER BY `minOrder` ASC [ RunTime:0.008752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19616001 ORDER BY `unit` DESC [ RunTime:0.006633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19616001 LIMIT 2 [ RunTime:0.007866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19616001 ORDER BY `minOrder` ASC [ RunTime:0.000673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19623255 LIMIT 5 [ RunTime:0.001772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19623255 ORDER BY `minOrder` ASC [ RunTime:0.013746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19623255 ORDER BY `unit` DESC [ RunTime:0.033931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19623255 LIMIT 2 [ RunTime:0.014441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19623255 ORDER BY `minOrder` ASC [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19606823 LIMIT 5 [ RunTime:0.007804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606823 ORDER BY `minOrder` ASC [ RunTime:0.004056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19606823 ORDER BY `unit` DESC [ RunTime:0.001264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19606823 LIMIT 2 [ RunTime:0.010896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19606823 ORDER BY `minOrder` ASC [ RunTime:0.011875s ]
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 '69130%' OR `brand` LIKE '69130%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275505 LIMIT 5 [ RunTime:0.011760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275505 ORDER BY `minOrder` ASC [ RunTime:0.004660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275505 ORDER BY `unit` DESC [ RunTime:0.004737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275505 LIMIT 2 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275505 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
select * from pdf where partno='691307300002' and brandshort='wurth elektronik' limit 1 [ RunTime:0.012574s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691307300002' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.008144s ]
SELECT `id` FROM `stock` WHERE `id` <> 32275505 AND `partno` = '691307300002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.007465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643845 [ RunTime:0.002656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275177 LIMIT 5 [ RunTime:0.014369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275177 ORDER BY `minOrder` ASC [ RunTime:0.015773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275177 ORDER BY `unit` DESC [ RunTime:0.002785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275177 LIMIT 2 [ RunTime:0.029578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275177 ORDER BY `minOrder` ASC [ RunTime:0.007996s ]
select * from pdf where partno='691305340003' and brandshort='wurth elektronik' limit 1 [ RunTime:0.010909s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305340003' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.001010s ]
SELECT `id` FROM `stock` WHERE `id` <> 32275177 AND `partno` = '691305340003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.000846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648589 [ RunTime:0.003805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275424 LIMIT 5 [ RunTime:0.013911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275424 ORDER BY `minOrder` ASC [ RunTime:0.018489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275424 ORDER BY `unit` DESC [ RunTime:0.003207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275424 LIMIT 2 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275424 ORDER BY `minOrder` ASC [ RunTime:0.003993s ]
select * from pdf where partno='691309310004' and brandshort='wurth elektronik' limit 1 [ RunTime:0.010160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691309310004' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.015262s ]
SELECT `id` FROM `stock` WHERE `id` <> 32275424 AND `partno` = '691309310004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.000825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15445530 [ RunTime:0.004052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275423 LIMIT 5 [ RunTime:0.008004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275423 ORDER BY `minOrder` ASC [ RunTime:0.004689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275423 ORDER BY `unit` DESC [ RunTime:0.030287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275423 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275423 ORDER BY `minOrder` ASC [ RunTime:0.003730s ]
select * from pdf where partno='691304130003' and brandshort='wurth elektronik' limit 1 [ RunTime:0.009422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691304130003' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.013036s ]
SELECT `id` FROM `stock` WHERE `id` <> 32275423 AND `partno` = '691304130003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.005604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19618457 [ RunTime:0.012167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276419 LIMIT 5 [ RunTime:0.011348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276419 ORDER BY `minOrder` ASC [ RunTime:0.017120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276419 ORDER BY `unit` DESC [ RunTime:0.002869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276419 LIMIT 2 [ RunTime:0.002473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276419 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='691307400008' and brandshort='wurth elektronik' limit 1 [ RunTime:0.010116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691307400008' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.016891s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276419 AND `partno` = '691307400008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.016894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19640282 [ RunTime:0.015531s ]
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 '69130%' OR `brand` LIKE '69130%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478958 LIMIT 5 [ RunTime:0.016155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478958 ORDER BY `minOrder` ASC [ RunTime:0.019020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478958 ORDER BY `unit` DESC [ RunTime:0.007780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478958 LIMIT 2 [ RunTime:0.017239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478958 ORDER BY `minOrder` ASC [ RunTime:0.033545s ]
select * from pdf where partno='691304130002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.052457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691304130002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.011945s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478958 AND `partno` = '691304130002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.021427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11444677 [ RunTime:0.017907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60479786 LIMIT 5 [ RunTime:0.015263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479786 ORDER BY `minOrder` ASC [ RunTime:0.016124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60479786 ORDER BY `unit` DESC [ RunTime:0.002257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60479786 LIMIT 2 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479786 ORDER BY `minOrder` ASC [ RunTime:0.006640s ]
select * from pdf where partno='691305340002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305340002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004694s ]
SELECT `id` FROM `stock` WHERE `id` <> 60479786 AND `partno` = '691305340002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.008298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15446748 [ RunTime:0.005437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478451 LIMIT 5 [ RunTime:0.006065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478451 ORDER BY `minOrder` ASC [ RunTime:0.016235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478451 ORDER BY `unit` DESC [ RunTime:0.002258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478451 LIMIT 2 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478451 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='691305140003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305140003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001381s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478451 AND `partno` = '691305140003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19612039 [ RunTime:0.003425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478955 LIMIT 5 [ RunTime:0.001144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478955 ORDER BY `minOrder` ASC [ RunTime:0.007148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478955 ORDER BY `unit` DESC [ RunTime:0.005453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478955 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478955 ORDER BY `minOrder` ASC [ RunTime:0.003127s ]
select * from pdf where partno='691307300005' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.017361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691307300005' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.007737s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478955 AND `partno` = '691307300005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.022942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644576 [ RunTime:0.018987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60480774 LIMIT 5 [ RunTime:0.009803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480774 ORDER BY `minOrder` ASC [ RunTime:0.024341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60480774 ORDER BY `unit` DESC [ RunTime:0.023537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60480774 LIMIT 2 [ RunTime:0.016733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480774 ORDER BY `minOrder` ASC [ RunTime:0.023414s ]
select * from pdf where partno='691304500004' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.061585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691304500004' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.045661s ]
SELECT `id` FROM `stock` WHERE `id` <> 60480774 AND `partno` = '691304500004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.046471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634688 [ RunTime:0.025755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60479889 LIMIT 5 [ RunTime:0.041565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479889 ORDER BY `minOrder` ASC [ RunTime:0.007297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60479889 ORDER BY `unit` DESC [ RunTime:0.019931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60479889 LIMIT 2 [ RunTime:0.006133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60479889 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='691305130004' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305130004' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.015956s ]
SELECT `id` FROM `stock` WHERE `id` <> 60479889 AND `partno` = '691305130004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.029828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661940 [ RunTime:0.020505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60481327 LIMIT 5 [ RunTime:0.021400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481327 ORDER BY `minOrder` ASC [ RunTime:0.021229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60481327 ORDER BY `unit` DESC [ RunTime:0.043658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60481327 LIMIT 2 [ RunTime:0.013016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481327 ORDER BY `minOrder` ASC [ RunTime:0.001474s ]
select * from pdf where partno='691309410002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691309410002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.025524s ]
SELECT `id` FROM `stock` WHERE `id` <> 60481327 AND `partno` = '691309410002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.035702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17303670 [ RunTime:0.034195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60480461 LIMIT 5 [ RunTime:0.034396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480461 ORDER BY `minOrder` ASC [ RunTime:0.029005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60480461 ORDER BY `unit` DESC [ RunTime:0.012813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60480461 LIMIT 2 [ RunTime:0.018561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480461 ORDER BY `minOrder` ASC [ RunTime:0.005063s ]
select * from pdf where partno='691304500002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691304500002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.025079s ]
SELECT `id` FROM `stock` WHERE `id` <> 60480461 AND `partno` = '691304500002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.005446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17307119 [ RunTime:0.015502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60484565 LIMIT 5 [ RunTime:0.007422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484565 ORDER BY `minOrder` ASC [ RunTime:0.005894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60484565 ORDER BY `unit` DESC [ RunTime:0.008003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60484565 LIMIT 2 [ RunTime:0.002572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60484565 ORDER BY `minOrder` ASC [ RunTime:0.002739s ]
select * from pdf where partno='691305140002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.012381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305140002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.019454s ]
SELECT `id` FROM `stock` WHERE `id` <> 60484565 AND `partno` = '691305140002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.024849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310470 [ RunTime:0.036262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60480588 LIMIT 5 [ RunTime:0.016301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480588 ORDER BY `minOrder` ASC [ RunTime:0.001947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60480588 ORDER BY `unit` DESC [ RunTime:0.002904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60480588 LIMIT 2 [ RunTime:0.009421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480588 ORDER BY `minOrder` ASC [ RunTime:0.003137s ]
select * from pdf where partno='691307300008' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.006602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691307300008' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002883s ]
SELECT `id` FROM `stock` WHERE `id` <> 60480588 AND `partno` = '691307300008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.009730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19607012 [ RunTime:0.003728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60481381 LIMIT 5 [ RunTime:0.010513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481381 ORDER BY `minOrder` ASC [ RunTime:0.018883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60481381 ORDER BY `unit` DESC [ RunTime:0.006859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60481381 LIMIT 2 [ RunTime:0.009023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481381 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
select * from pdf where partno='691305130008' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305130008' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001143s ]
SELECT `id` FROM `stock` WHERE `id` <> 60481381 AND `partno` = '691305130008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.017003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19614446 [ RunTime:0.015140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60480047 LIMIT 5 [ RunTime:0.016001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480047 ORDER BY `minOrder` ASC [ RunTime:0.007996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60480047 ORDER BY `unit` DESC [ RunTime:0.016005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60480047 LIMIT 2 [ RunTime:0.028664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480047 ORDER BY `minOrder` ASC [ RunTime:0.004771s ]
select * from pdf where partno='691305330008' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305330008' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009930s ]
SELECT `id` FROM `stock` WHERE `id` <> 60480047 AND `partno` = '691305330008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.019092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19630369 [ RunTime:0.003800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478692 LIMIT 5 [ RunTime:0.009929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478692 ORDER BY `minOrder` ASC [ RunTime:0.005993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478692 ORDER BY `unit` DESC [ RunTime:0.005882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478692 LIMIT 2 [ RunTime:0.020060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478692 ORDER BY `minOrder` ASC [ RunTime:0.007527s ]
select * from pdf where partno='691307300003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691307300003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.013476s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478692 AND `partno` = '691307300003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.024824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644566 [ RunTime:0.008104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60481176 LIMIT 5 [ RunTime:0.011345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481176 ORDER BY `minOrder` ASC [ RunTime:0.019356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60481176 ORDER BY `unit` DESC [ RunTime:0.020252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60481176 LIMIT 2 [ RunTime:0.002755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481176 ORDER BY `minOrder` ASC [ RunTime:0.005152s ]
select * from pdf where partno='691305340004' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305340004' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.014855s ]
SELECT `id` FROM `stock` WHERE `id` <> 60481176 AND `partno` = '691305340004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.022491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19612791 [ RunTime:0.019125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60481243 LIMIT 5 [ RunTime:0.014724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481243 ORDER BY `minOrder` ASC [ RunTime:0.019281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60481243 ORDER BY `unit` DESC [ RunTime:0.014227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60481243 LIMIT 2 [ RunTime:0.031958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481243 ORDER BY `minOrder` ASC [ RunTime:0.002981s ]
select * from pdf where partno='691305330007' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305330007' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.010678s ]
SELECT `id` FROM `stock` WHERE `id` <> 60481243 AND `partno` = '691305330007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.028882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19612861 [ RunTime:0.005169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60480109 LIMIT 5 [ RunTime:0.015430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480109 ORDER BY `minOrder` ASC [ RunTime:0.010822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60480109 ORDER BY `unit` DESC [ RunTime:0.016063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60480109 LIMIT 2 [ RunTime:0.003267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480109 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='691307400002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.012580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691307400002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005410s ]
SELECT `id` FROM `stock` WHERE `id` <> 60480109 AND `partno` = '691307400002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.012234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19614396 [ RunTime:0.016979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60481540 LIMIT 5 [ RunTime:0.010630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481540 ORDER BY `minOrder` ASC [ RunTime:0.014817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60481540 ORDER BY `unit` DESC [ RunTime:0.009234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60481540 LIMIT 2 [ RunTime:0.007525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60481540 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
select * from pdf where partno='691309310007' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.006696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691309310007' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009828s ]
SELECT `id` FROM `stock` WHERE `id` <> 60481540 AND `partno` = '691309310007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.005106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19616032 [ RunTime:0.005254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60480048 LIMIT 5 [ RunTime:0.010199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480048 ORDER BY `minOrder` ASC [ RunTime:0.003935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60480048 ORDER BY `unit` DESC [ RunTime:0.004670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60480048 LIMIT 2 [ RunTime:0.023968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480048 ORDER BY `minOrder` ASC [ RunTime:0.017558s ]
select * from pdf where partno='691305140006' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305140006' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.034510s ]
SELECT `id` FROM `stock` WHERE `id` <> 60480048 AND `partno` = '691305140006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.049893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19613635 [ RunTime:0.028367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60480088 LIMIT 5 [ RunTime:0.020776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480088 ORDER BY `minOrder` ASC [ RunTime:0.068949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60480088 ORDER BY `unit` DESC [ RunTime:0.035569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60480088 LIMIT 2 [ RunTime:0.020233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60480088 ORDER BY `minOrder` ASC [ RunTime:0.013666s ]
select * from pdf where partno='691305540005' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691305540005' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.037593s ]
SELECT `id` FROM `stock` WHERE `id` <> 60480088 AND `partno` = '691305540005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.050968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19623255 [ RunTime:0.020928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60478515 LIMIT 5 [ RunTime:0.021974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478515 ORDER BY `minOrder` ASC [ RunTime:0.086916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60478515 ORDER BY `unit` DESC [ RunTime:0.033526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60478515 LIMIT 2 [ RunTime:0.024858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60478515 ORDER BY `minOrder` ASC [ RunTime:0.025518s ]
select * from pdf where partno='691309310002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.034804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691309310002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.015279s ]
SELECT `id` FROM `stock` WHERE `id` <> 60478515 AND `partno` = '691309310002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.005488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648610 [ RunTime:0.031150s ]
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 '69130%' OR `brand` LIKE '69130%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023223s ]
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 '69130%' OR `brand` LIKE '69130%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043301s ]
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 '69130%' OR `brand` LIKE '69130%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.072035s ]
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 '69130%' OR `brand` LIKE '69130%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006185s ]
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 '69130%' OR `brand` LIKE '69130%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031716s ]
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 '69130%' OR `brand` LIKE '69130%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019269s ]
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 '69130%' OR `brand` LIKE '69130%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037016s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69130%' OR `brand` LIKE '69130%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.048597s ]