SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002671s ]
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=7443835&search=1' [ RunTime:0.003582s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002528s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007646s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002027s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.005696s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001111s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000249s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002597s ]
SELECT * FROM `stock_search` WHERE `partno` = '7443835' LIMIT 1 [ RunTime:0.022825s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-27 07:40:06' WHERE `partno` = '7443835' [ RunTime:0.012058s ]
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 '7443835%' OR `brand` LIKE '7443835%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023388s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13443765 LIMIT 5 [ RunTime:0.021299s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13443765 ORDER BY `minOrder` ASC [ RunTime:0.005923s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13443765 ORDER BY `unit` DESC [ RunTime:0.038276s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13443765 LIMIT 2 [ RunTime:0.014594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13443765 ORDER BY `minOrder` ASC [ RunTime:0.008283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14332899 LIMIT 5 [ RunTime:0.051301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14332899 ORDER BY `minOrder` ASC [ RunTime:0.056947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14332899 ORDER BY `unit` DESC [ RunTime:0.051566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14332899 LIMIT 2 [ RunTime:0.033581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14332899 ORDER BY `minOrder` ASC [ RunTime:0.032364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14336860 LIMIT 5 [ RunTime:0.021620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14336860 ORDER BY `minOrder` ASC [ RunTime:0.066841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14336860 ORDER BY `unit` DESC [ RunTime:0.016749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14336860 LIMIT 2 [ RunTime:0.027836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14336860 ORDER BY `minOrder` ASC [ RunTime:0.013106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14328078 LIMIT 5 [ RunTime:0.043111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14328078 ORDER BY `minOrder` ASC [ RunTime:0.098265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14328078 ORDER BY `unit` DESC [ RunTime:0.033000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14328078 LIMIT 2 [ RunTime:0.050433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14328078 ORDER BY `minOrder` ASC [ RunTime:0.023458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13448778 LIMIT 5 [ RunTime:0.043836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13448778 ORDER BY `minOrder` ASC [ RunTime:0.026992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13448778 ORDER BY `unit` DESC [ RunTime:0.030377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13448778 LIMIT 2 [ RunTime:0.065052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13448778 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14332900 LIMIT 5 [ RunTime:0.053783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14332900 ORDER BY `minOrder` ASC [ RunTime:0.040138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14332900 ORDER BY `unit` DESC [ RunTime:0.001003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14332900 LIMIT 2 [ RunTime:0.028958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14332900 ORDER BY `minOrder` ASC [ RunTime:0.008462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14289539 LIMIT 5 [ RunTime:0.055997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14289539 ORDER BY `minOrder` ASC [ RunTime:0.015062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14289539 ORDER BY `unit` DESC [ RunTime:0.010694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14289539 LIMIT 2 [ RunTime:0.026962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14289539 ORDER BY `minOrder` ASC [ RunTime:0.006130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16384817 LIMIT 5 [ RunTime:0.012731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16384817 ORDER BY `minOrder` ASC [ RunTime:0.055554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16384817 ORDER BY `unit` DESC [ RunTime:0.014478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16384817 LIMIT 2 [ RunTime:0.022647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16384817 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13443755 LIMIT 5 [ RunTime:0.007729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13443755 ORDER BY `minOrder` ASC [ RunTime:0.014291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13443755 ORDER BY `unit` DESC [ RunTime:0.013565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13443755 LIMIT 2 [ RunTime:0.005286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13443755 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13443763 LIMIT 5 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13443763 ORDER BY `minOrder` ASC [ RunTime:0.007565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13443763 ORDER BY `unit` DESC [ RunTime:0.001364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13443763 LIMIT 2 [ RunTime:0.017656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13443763 ORDER BY `minOrder` ASC [ RunTime:0.010410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13435316 LIMIT 5 [ RunTime:0.008380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13435316 ORDER BY `minOrder` ASC [ RunTime:0.010902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13435316 ORDER BY `unit` DESC [ RunTime:0.004134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13435316 LIMIT 2 [ RunTime:0.019427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13435316 ORDER BY `minOrder` ASC [ RunTime:0.007255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13436013 LIMIT 5 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13436013 ORDER BY `minOrder` ASC [ RunTime:0.005029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13436013 ORDER BY `unit` DESC [ RunTime:0.005038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13436013 LIMIT 2 [ RunTime:0.004265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13436013 ORDER BY `minOrder` ASC [ RunTime:0.002656s ]
select * from pdf where partno='74438356022HT' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.005205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16384807 LIMIT 5 [ RunTime:0.004460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16384807 ORDER BY `minOrder` ASC [ RunTime:0.013607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16384807 ORDER BY `unit` DESC [ RunTime:0.017810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16384807 LIMIT 2 [ RunTime:0.005002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16384807 ORDER BY `minOrder` ASC [ RunTime:0.016549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13448776 LIMIT 5 [ RunTime:0.006587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13448776 ORDER BY `minOrder` ASC [ RunTime:0.002635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13448776 ORDER BY `unit` DESC [ RunTime:0.004203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13448776 LIMIT 2 [ RunTime:0.002925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13448776 ORDER BY `minOrder` ASC [ RunTime:0.008088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16384806 LIMIT 5 [ RunTime:0.004621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16384806 ORDER BY `minOrder` ASC [ RunTime:0.002527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16384806 ORDER BY `unit` DESC [ RunTime:0.000603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16384806 LIMIT 2 [ RunTime:0.003988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16384806 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14289540 LIMIT 5 [ RunTime:0.005173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14289540 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14289540 ORDER BY `unit` DESC [ RunTime:0.002472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14289540 LIMIT 2 [ RunTime:0.001569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14289540 ORDER BY `minOrder` ASC [ RunTime:0.002487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13436778 LIMIT 5 [ RunTime:0.001915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13436778 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13436778 ORDER BY `unit` DESC [ RunTime:0.006490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13436778 LIMIT 2 [ RunTime:0.009510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13436778 ORDER BY `minOrder` ASC [ RunTime:0.006065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14327688 LIMIT 5 [ RunTime:0.007873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14327688 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14327688 ORDER BY `unit` DESC [ RunTime:0.007184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14327688 LIMIT 2 [ RunTime:0.005980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14327688 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13436036 LIMIT 5 [ RunTime:0.001168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13436036 ORDER BY `minOrder` ASC [ RunTime:0.003322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13436036 ORDER BY `unit` DESC [ RunTime:0.015227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13436036 LIMIT 2 [ RunTime:0.001321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13436036 ORDER BY `minOrder` ASC [ RunTime:0.006896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14336866 LIMIT 5 [ RunTime:0.002091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14336866 ORDER BY `minOrder` ASC [ RunTime:0.002746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14336866 ORDER BY `unit` DESC [ RunTime:0.011360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14336866 LIMIT 2 [ RunTime:0.007932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14336866 ORDER BY `minOrder` ASC [ RunTime:0.008978s ]
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 '7443835%' OR `brand` LIKE '7443835%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51119537 LIMIT 5 [ RunTime:0.001959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51119537 ORDER BY `minOrder` ASC [ RunTime:0.008967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51119537 ORDER BY `unit` DESC [ RunTime:0.015581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51119537 LIMIT 2 [ RunTime:0.001419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51119537 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='74438357100' and brandshort='wurth elektronik' limit 1 [ RunTime:0.001546s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438357100' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.004301s ]
SELECT `id` FROM `stock` WHERE `id` <> 51119537 AND `partno` = '74438357100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.012360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14332891 [ RunTime:0.015442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51119541 LIMIT 5 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51119541 ORDER BY `minOrder` ASC [ RunTime:0.000897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51119541 ORDER BY `unit` DESC [ RunTime:0.012602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51119541 LIMIT 2 [ RunTime:0.017064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51119541 ORDER BY `minOrder` ASC [ RunTime:0.002429s ]
select * from pdf where partno='74438356022' and brandshort='wurth elektronik' limit 1 [ RunTime:0.000903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356022' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.006981s ]
SELECT `id` FROM `stock` WHERE `id` <> 51119541 AND `partno` = '74438356022' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.003043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13443765 [ RunTime:0.006700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51120337 LIMIT 5 [ RunTime:0.005155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51120337 ORDER BY `minOrder` ASC [ RunTime:0.009855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51120337 ORDER BY `unit` DESC [ RunTime:0.004433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51120337 LIMIT 2 [ RunTime:0.020168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51120337 ORDER BY `minOrder` ASC [ RunTime:0.029213s ]
select * from pdf where partno='74438356010ht' and brandshort='wurth elektronik' limit 1 [ RunTime:0.007062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356010ht' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.004247s ]
SELECT `id` FROM `stock` WHERE `id` <> 51120337 AND `partno` = '74438356010ht' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.002802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14328458 [ RunTime:0.000993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51120336 LIMIT 5 [ RunTime:0.004968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51120336 ORDER BY `minOrder` ASC [ RunTime:0.003161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51120336 ORDER BY `unit` DESC [ RunTime:0.008600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51120336 LIMIT 2 [ RunTime:0.023337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51120336 ORDER BY `minOrder` ASC [ RunTime:0.008656s ]
select * from pdf where partno='744383560033ht' and brandshort='wurth elektronik' limit 1 [ RunTime:0.006248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '744383560033ht' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.017911s ]
SELECT `id` FROM `stock` WHERE `id` <> 51120336 AND `partno` = '744383560033ht' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.024419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14278216 [ RunTime:0.022093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51105068 LIMIT 5 [ RunTime:0.013035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105068 ORDER BY `minOrder` ASC [ RunTime:0.027593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51105068 ORDER BY `unit` DESC [ RunTime:0.008673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51105068 LIMIT 2 [ RunTime:0.031586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51105068 ORDER BY `minOrder` ASC [ RunTime:0.014148s ]
select * from pdf where partno='7443835' and brandshort='wurth elektronik' limit 1 [ RunTime:0.011321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7443835' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.011152s ]
SELECT `id` FROM `stock` WHERE `id` <> 51105068 AND `partno` = '7443835' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.014562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13269457 [ RunTime:0.040612s ]
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 '7443835%' OR `brand` LIKE '7443835%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456407 LIMIT 5 [ RunTime:0.011112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456407 ORDER BY `minOrder` ASC [ RunTime:0.017560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456407 ORDER BY `unit` DESC [ RunTime:0.005269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456407 LIMIT 2 [ RunTime:0.001222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456407 ORDER BY `minOrder` ASC [ RunTime:0.006185s ]
select * from pdf where partno='74438357100' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.018526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438357100' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.027659s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456407 AND `partno` = '74438357100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.046560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14332891 [ RunTime:0.016079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461333 LIMIT 5 [ RunTime:0.021436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461333 ORDER BY `minOrder` ASC [ RunTime:0.037271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461333 ORDER BY `unit` DESC [ RunTime:0.024867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461333 LIMIT 2 [ RunTime:0.012590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461333 ORDER BY `minOrder` ASC [ RunTime:0.008899s ]
select * from pdf where partno='74438356012' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356012' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.023664s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461333 AND `partno` = '74438356012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.027233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13448779 [ RunTime:0.034501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456449 LIMIT 5 [ RunTime:0.005365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456449 ORDER BY `minOrder` ASC [ RunTime:0.018657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456449 ORDER BY `unit` DESC [ RunTime:0.023263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456449 LIMIT 2 [ RunTime:0.008493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456449 ORDER BY `minOrder` ASC [ RunTime:0.005399s ]
select * from pdf where partno='74438356220' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.038053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356220' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.027925s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456449 AND `partno` = '74438356220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.020034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14336866 [ RunTime:0.013339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456450 LIMIT 5 [ RunTime:0.002168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456450 ORDER BY `minOrder` ASC [ RunTime:0.006105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456450 ORDER BY `unit` DESC [ RunTime:0.062324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456450 LIMIT 2 [ RunTime:0.023402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456450 ORDER BY `minOrder` ASC [ RunTime:0.003759s ]
select * from pdf where partno='74438356150' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.011953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356150' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000797s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456450 AND `partno` = '74438356150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.032508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13448776 [ RunTime:0.025270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456432 LIMIT 5 [ RunTime:0.019255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456432 ORDER BY `minOrder` ASC [ RunTime:0.035396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456432 ORDER BY `unit` DESC [ RunTime:0.043023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456432 LIMIT 2 [ RunTime:0.015336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456432 ORDER BY `minOrder` ASC [ RunTime:0.016029s ]
select * from pdf where partno='74438356010' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356010' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.036394s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456432 AND `partno` = '74438356010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14336860 [ RunTime:0.028767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456408 LIMIT 5 [ RunTime:0.037133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456408 ORDER BY `minOrder` ASC [ RunTime:0.019153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456408 ORDER BY `unit` DESC [ RunTime:0.007027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456408 LIMIT 2 [ RunTime:0.015255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456408 ORDER BY `minOrder` ASC [ RunTime:0.017134s ]
select * from pdf where partno='74438357010' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438357010' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.031701s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456408 AND `partno` = '74438357010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.030780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16384806 [ RunTime:0.006457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461335 LIMIT 5 [ RunTime:0.009610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461335 ORDER BY `minOrder` ASC [ RunTime:0.011709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461335 ORDER BY `unit` DESC [ RunTime:0.001124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461335 LIMIT 2 [ RunTime:0.003927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461335 ORDER BY `minOrder` ASC [ RunTime:0.013151s ]
select * from pdf where partno='74438356018' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022348s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356018' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.056782s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461335 AND `partno` = '74438356018' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.024818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13435316 [ RunTime:0.051864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456409 LIMIT 5 [ RunTime:0.023948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456409 ORDER BY `minOrder` ASC [ RunTime:0.023254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456409 ORDER BY `unit` DESC [ RunTime:0.020126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456409 LIMIT 2 [ RunTime:0.042598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456409 ORDER BY `minOrder` ASC [ RunTime:0.029621s ]
select * from pdf where partno='74438357047' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.042331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438357047' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.022003s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456409 AND `partno` = '74438357047' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.026693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13443763 [ RunTime:0.022345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456410 LIMIT 5 [ RunTime:0.027622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456410 ORDER BY `minOrder` ASC [ RunTime:0.062387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456410 ORDER BY `unit` DESC [ RunTime:0.041949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456410 LIMIT 2 [ RunTime:0.056238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456410 ORDER BY `minOrder` ASC [ RunTime:0.012370s ]
select * from pdf where partno='74438357082' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438357082' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.025689s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456410 AND `partno` = '74438357082' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.033399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13443755 [ RunTime:0.079668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456434 LIMIT 5 [ RunTime:0.035124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456434 ORDER BY `minOrder` ASC [ RunTime:0.017282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456434 ORDER BY `unit` DESC [ RunTime:0.059054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456434 LIMIT 2 [ RunTime:0.048115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456434 ORDER BY `minOrder` ASC [ RunTime:0.003481s ]
select * from pdf where partno='744383560068' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.027047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '744383560068' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.051464s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456434 AND `partno` = '744383560068' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.019304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456435 LIMIT 5 [ RunTime:0.026720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456435 ORDER BY `minOrder` ASC [ RunTime:0.031043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456435 ORDER BY `unit` DESC [ RunTime:0.039670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456435 LIMIT 2 [ RunTime:0.034821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456435 ORDER BY `minOrder` ASC [ RunTime:0.023805s ]
select * from pdf where partno='744383560033' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '744383560033' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.040400s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456435 AND `partno` = '744383560033' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.077072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13436036 [ RunTime:0.030085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40468599 LIMIT 5 [ RunTime:0.009904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40468599 ORDER BY `minOrder` ASC [ RunTime:0.081480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40468599 ORDER BY `unit` DESC [ RunTime:0.037283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40468599 LIMIT 2 [ RunTime:0.034969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40468599 ORDER BY `minOrder` ASC [ RunTime:0.048447s ]
select * from pdf where partno='74438356018HT' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.028541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356018HT' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009568s ]
SELECT `id` FROM `stock` WHERE `id` <> 40468599 AND `partno` = '74438356018HT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.018478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14289539 [ RunTime:0.047824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456436 LIMIT 5 [ RunTime:0.020870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456436 ORDER BY `minOrder` ASC [ RunTime:0.011318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456436 ORDER BY `unit` DESC [ RunTime:0.008815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456436 LIMIT 2 [ RunTime:0.011566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456436 ORDER BY `minOrder` ASC [ RunTime:0.035971s ]
select * from pdf where partno='74438356033' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356033' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.021012s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456436 AND `partno` = '74438356033' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.020868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14328078 [ RunTime:0.027649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461328 LIMIT 5 [ RunTime:0.012466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461328 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461328 ORDER BY `unit` DESC [ RunTime:0.000765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461328 LIMIT 2 [ RunTime:0.019014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461328 ORDER BY `minOrder` ASC [ RunTime:0.024736s ]
select * from pdf where partno='7443835400068' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.014290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7443835400068' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.015081s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461328 AND `partno` = '7443835400068' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.040659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13415956 [ RunTime:0.030551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456411 LIMIT 5 [ RunTime:0.006296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456411 ORDER BY `minOrder` ASC [ RunTime:0.048716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456411 ORDER BY `unit` DESC [ RunTime:0.014771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456411 LIMIT 2 [ RunTime:0.021439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456411 ORDER BY `minOrder` ASC [ RunTime:0.004895s ]
select * from pdf where partno='74438357068' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.011017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438357068' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.035048s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456411 AND `partno` = '74438357068' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.031942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14332900 [ RunTime:0.095069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461210 LIMIT 5 [ RunTime:0.017781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461210 ORDER BY `minOrder` ASC [ RunTime:0.046013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461210 ORDER BY `unit` DESC [ RunTime:0.022935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461210 LIMIT 2 [ RunTime:0.025125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461210 ORDER BY `minOrder` ASC [ RunTime:0.018617s ]
select * from pdf where partno='74438357018' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438357018' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.011877s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461210 AND `partno` = '74438357018' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.029632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13434567 [ RunTime:0.077189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461431 LIMIT 5 [ RunTime:0.031188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461431 ORDER BY `minOrder` ASC [ RunTime:0.069940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461431 ORDER BY `unit` DESC [ RunTime:0.034890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461431 LIMIT 2 [ RunTime:0.053844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461431 ORDER BY `minOrder` ASC [ RunTime:0.023965s ]
select * from pdf where partno='74438356022HT' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356022HT' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.038968s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461431 AND `partno` = '74438356022HT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.063720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13436013 [ RunTime:0.018860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461235 LIMIT 5 [ RunTime:0.047946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461235 ORDER BY `minOrder` ASC [ RunTime:0.067868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461235 ORDER BY `unit` DESC [ RunTime:0.050484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461235 LIMIT 2 [ RunTime:0.031042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461235 ORDER BY `minOrder` ASC [ RunTime:0.000902s ]
select * from pdf where partno='74438357033' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.017806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438357033' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.037150s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461235 AND `partno` = '74438357033' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.052760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13434593 [ RunTime:0.028971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40461432 LIMIT 5 [ RunTime:0.046543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461432 ORDER BY `minOrder` ASC [ RunTime:0.041919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40461432 ORDER BY `unit` DESC [ RunTime:0.016651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40461432 LIMIT 2 [ RunTime:0.051330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40461432 ORDER BY `minOrder` ASC [ RunTime:0.024098s ]
select * from pdf where partno='74438356056HT' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.031470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438356056HT' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.101839s ]
SELECT `id` FROM `stock` WHERE `id` <> 40461432 AND `partno` = '74438356056HT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.053149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13436778 [ RunTime:0.060670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40456412 LIMIT 5 [ RunTime:0.051228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456412 ORDER BY `minOrder` ASC [ RunTime:0.071479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40456412 ORDER BY `unit` DESC [ RunTime:0.056176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40456412 LIMIT 2 [ RunTime:0.034107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40456412 ORDER BY `minOrder` ASC [ RunTime:0.025014s ]
select * from pdf where partno='74438357022' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74438357022' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.025931s ]
SELECT `id` FROM `stock` WHERE `id` <> 40456412 AND `partno` = '74438357022' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.039057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14332899 [ RunTime:0.019725s ]
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 '7443835%' OR `brand` LIKE '7443835%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033579s ]
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 '7443835%' OR `brand` LIKE '7443835%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077110s ]
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 '7443835%' OR `brand` LIKE '7443835%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047407s ]
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 '7443835%' OR `brand` LIKE '7443835%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042145s ]
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 '7443835%' OR `brand` LIKE '7443835%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054602s ]
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 '7443835%' OR `brand` LIKE '7443835%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033394s ]
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 '7443835%' OR `brand` LIKE '7443835%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030206s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7443835%' OR `brand` LIKE '7443835%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030049s ]