SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001329s ]
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=7446&search=1' [ RunTime:0.007181s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002024s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001439s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001456s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.004941s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001312s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016133s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001287s ]
SELECT * FROM `stock_search` WHERE `partno` = '7446' LIMIT 1 [ RunTime:0.004566s ]
UPDATE `stock_search` SET `count` = 8 , `updatetime` = '2026-08-26 01:14:07' WHERE `partno` = '7446' [ RunTime:0.008781s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001398s ]
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 '7446%' OR `brand` LIKE '7446%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028942s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13203963 LIMIT 5 [ RunTime:0.019056s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13203963 ORDER BY `minOrder` ASC [ RunTime:0.006828s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13203963 ORDER BY `unit` DESC [ RunTime:0.003527s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13203963 LIMIT 2 [ RunTime:0.014049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13203963 ORDER BY `minOrder` ASC [ RunTime:0.010253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13205440 LIMIT 5 [ RunTime:0.019684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13205440 ORDER BY `minOrder` ASC [ RunTime:0.051487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13205440 ORDER BY `unit` DESC [ RunTime:0.020823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13205440 LIMIT 2 [ RunTime:0.085633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13205440 ORDER BY `minOrder` ASC [ RunTime:0.016263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11941463 LIMIT 5 [ RunTime:0.028048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11941463 ORDER BY `minOrder` ASC [ RunTime:0.022816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11941463 ORDER BY `unit` DESC [ RunTime:0.004373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11941463 LIMIT 2 [ RunTime:0.056306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11941463 ORDER BY `minOrder` ASC [ RunTime:0.036319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939452 LIMIT 5 [ RunTime:0.017508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11939452 ORDER BY `minOrder` ASC [ RunTime:0.012204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11939452 ORDER BY `unit` DESC [ RunTime:0.007220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11939452 LIMIT 2 [ RunTime:0.024281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11939452 ORDER BY `minOrder` ASC [ RunTime:0.026797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939432 LIMIT 5 [ RunTime:0.040447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11939432 ORDER BY `minOrder` ASC [ RunTime:0.042119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11939432 ORDER BY `unit` DESC [ RunTime:0.018641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11939432 LIMIT 2 [ RunTime:0.012182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11939432 ORDER BY `minOrder` ASC [ RunTime:0.002550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204032 LIMIT 5 [ RunTime:0.008441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13204032 ORDER BY `minOrder` ASC [ RunTime:0.014205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13204032 ORDER BY `unit` DESC [ RunTime:0.053120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13204032 LIMIT 2 [ RunTime:0.023014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13204032 ORDER BY `minOrder` ASC [ RunTime:0.005627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17392625 LIMIT 5 [ RunTime:0.006326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17392625 ORDER BY `minOrder` ASC [ RunTime:0.007165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17392625 ORDER BY `unit` DESC [ RunTime:0.001059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17392625 LIMIT 2 [ RunTime:0.006375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17392625 ORDER BY `minOrder` ASC [ RunTime:0.005412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939884 LIMIT 5 [ RunTime:0.016211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11939884 ORDER BY `minOrder` ASC [ RunTime:0.024927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11939884 ORDER BY `unit` DESC [ RunTime:0.032291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11939884 LIMIT 2 [ RunTime:0.029573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11939884 ORDER BY `minOrder` ASC [ RunTime:0.005222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13203964 LIMIT 5 [ RunTime:0.003256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13203964 ORDER BY `minOrder` ASC [ RunTime:0.012214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13203964 ORDER BY `unit` DESC [ RunTime:0.008150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13203964 LIMIT 2 [ RunTime:0.006286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13203964 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939453 LIMIT 5 [ RunTime:0.004079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11939453 ORDER BY `minOrder` ASC [ RunTime:0.011952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11939453 ORDER BY `unit` DESC [ RunTime:0.006410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11939453 LIMIT 2 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11939453 ORDER BY `minOrder` ASC [ RunTime:0.004257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204002 LIMIT 5 [ RunTime:0.009572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13204002 ORDER BY `minOrder` ASC [ RunTime:0.004654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13204002 ORDER BY `unit` DESC [ RunTime:0.031227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13204002 LIMIT 2 [ RunTime:0.013348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13204002 ORDER BY `minOrder` ASC [ RunTime:0.006257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17392819 LIMIT 5 [ RunTime:0.001512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17392819 ORDER BY `minOrder` ASC [ RunTime:0.014921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17392819 ORDER BY `unit` DESC [ RunTime:0.023598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17392819 LIMIT 2 [ RunTime:0.014017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17392819 ORDER BY `minOrder` ASC [ RunTime:0.010147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17393105 LIMIT 5 [ RunTime:0.016929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17393105 ORDER BY `minOrder` ASC [ RunTime:0.005963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17393105 ORDER BY `unit` DESC [ RunTime:0.001652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17393105 LIMIT 2 [ RunTime:0.007171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17393105 ORDER BY `minOrder` ASC [ RunTime:0.002966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17392820 LIMIT 5 [ RunTime:0.004190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17392820 ORDER BY `minOrder` ASC [ RunTime:0.015835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17392820 ORDER BY `unit` DESC [ RunTime:0.011957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17392820 LIMIT 2 [ RunTime:0.048959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17392820 ORDER BY `minOrder` ASC [ RunTime:0.014326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17392633 LIMIT 5 [ RunTime:0.007897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17392633 ORDER BY `minOrder` ASC [ RunTime:0.010930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17392633 ORDER BY `unit` DESC [ RunTime:0.014688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17392633 LIMIT 2 [ RunTime:0.018746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17392633 ORDER BY `minOrder` ASC [ RunTime:0.008148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939433 LIMIT 5 [ RunTime:0.027763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11939433 ORDER BY `minOrder` ASC [ RunTime:0.018230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11939433 ORDER BY `unit` DESC [ RunTime:0.027124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11939433 LIMIT 2 [ RunTime:0.068421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11939433 ORDER BY `minOrder` ASC [ RunTime:0.021569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13205787 LIMIT 5 [ RunTime:0.007043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13205787 ORDER BY `minOrder` ASC [ RunTime:0.027292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13205787 ORDER BY `unit` DESC [ RunTime:0.034176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13205787 LIMIT 2 [ RunTime:0.029287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13205787 ORDER BY `minOrder` ASC [ RunTime:0.006538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13205089 LIMIT 5 [ RunTime:0.032698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13205089 ORDER BY `minOrder` ASC [ RunTime:0.029729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13205089 ORDER BY `unit` DESC [ RunTime:0.014851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13205089 LIMIT 2 [ RunTime:0.012540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13205089 ORDER BY `minOrder` ASC [ RunTime:0.014268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13205105 LIMIT 5 [ RunTime:0.028499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13205105 ORDER BY `minOrder` ASC [ RunTime:0.017928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13205105 ORDER BY `unit` DESC [ RunTime:0.022044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13205105 LIMIT 2 [ RunTime:0.004498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13205105 ORDER BY `minOrder` ASC [ RunTime:0.020923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17393168 LIMIT 5 [ RunTime:0.011239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17393168 ORDER BY `minOrder` ASC [ RunTime:0.013146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17393168 ORDER BY `unit` DESC [ RunTime:0.022621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17393168 LIMIT 2 [ RunTime:0.028243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17393168 ORDER BY `minOrder` ASC [ RunTime:0.039477s ]
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 '7446%' OR `brand` LIKE '7446%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51130700 LIMIT 5 [ RunTime:0.017285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51130700 ORDER BY `minOrder` ASC [ RunTime:0.024257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51130700 ORDER BY `unit` DESC [ RunTime:0.004247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51130700 LIMIT 2 [ RunTime:0.007931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51130700 ORDER BY `minOrder` ASC [ RunTime:0.001562s ]
select * from pdf where partno='7446122001' and brandshort='wurth elektronik' limit 1 [ RunTime:0.003087s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446122001' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.006815s ]
SELECT `id` FROM `stock` WHERE `id` <> 51130700 AND `partno` = '7446122001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.033194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51119493 [ RunTime:0.003295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64141657 [ RunTime:0.008981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51119493 LIMIT 5 [ RunTime:0.009416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51119493 ORDER BY `minOrder` ASC [ RunTime:0.015737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51119493 ORDER BY `unit` DESC [ RunTime:0.018469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51119493 LIMIT 2 [ RunTime:0.011674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51119493 ORDER BY `minOrder` ASC [ RunTime:0.006625s ]
select * from pdf where partno='7446122001' and brandshort='wurth elektronik' limit 1 [ RunTime:0.010842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446122001' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.009008s ]
SELECT `id` FROM `stock` WHERE `id` <> 51119493 AND `partno` = '7446122001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.022307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51130700 [ RunTime:0.019657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64141657 [ RunTime:0.006750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51120339 LIMIT 5 [ RunTime:0.004822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51120339 ORDER BY `minOrder` ASC [ RunTime:0.005999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51120339 ORDER BY `unit` DESC [ RunTime:0.004075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51120339 LIMIT 2 [ RunTime:0.021096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51120339 ORDER BY `minOrder` ASC [ RunTime:0.007539s ]
select * from pdf where partno='7446630027' and brandshort='wurth elektronik' limit 1 [ RunTime:0.004621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446630027' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.019445s ]
SELECT `id` FROM `stock` WHERE `id` <> 51120339 AND `partno` = '7446630027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.006130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939452 [ RunTime:0.023654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113658 LIMIT 5 [ RunTime:0.018107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113658 ORDER BY `minOrder` ASC [ RunTime:0.018263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51113658 ORDER BY `unit` DESC [ RunTime:0.024389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51113658 LIMIT 2 [ RunTime:0.017978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113658 ORDER BY `minOrder` ASC [ RunTime:0.011573s ]
select * from pdf where partno='7446630027' and brandshort='wurth elektronik' limit 1 [ RunTime:0.012338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446630027' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.007183s ]
SELECT `id` FROM `stock` WHERE `id` <> 51113658 AND `partno` = '7446630027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.015256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939452 [ RunTime:0.005847s ]
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 '7446%' OR `brand` LIKE '7446%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64141722 LIMIT 5 [ RunTime:0.013299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141722 ORDER BY `minOrder` ASC [ RunTime:0.022688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64141722 ORDER BY `unit` DESC [ RunTime:0.020134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64141722 LIMIT 2 [ RunTime:0.030583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141722 ORDER BY `minOrder` ASC [ RunTime:0.012076s ]
select * from pdf where partno='7446622002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.023256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446622002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.030066s ]
SELECT `id` FROM `stock` WHERE `id` <> 64141722 AND `partno` = '7446622002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.062365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64141655 LIMIT 5 [ RunTime:0.018772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141655 ORDER BY `minOrder` ASC [ RunTime:0.014778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64141655 ORDER BY `unit` DESC [ RunTime:0.019562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64141655 LIMIT 2 [ RunTime:0.012450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141655 ORDER BY `minOrder` ASC [ RunTime:0.015721s ]
select * from pdf where partno='7446120027' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.025716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446120027' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.021084s ]
SELECT `id` FROM `stock` WHERE `id` <> 64141655 AND `partno` = '7446120027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.009588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13203963 [ RunTime:0.004870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64141767 LIMIT 5 [ RunTime:0.010022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141767 ORDER BY `minOrder` ASC [ RunTime:0.016200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64141767 ORDER BY `unit` DESC [ RunTime:0.018752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64141767 LIMIT 2 [ RunTime:0.010543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141767 ORDER BY `minOrder` ASC [ RunTime:0.002522s ]
select * from pdf where partno='7446632001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446632001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005478s ]
SELECT `id` FROM `stock` WHERE `id` <> 64141767 AND `partno` = '7446632001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.014267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13205027 [ RunTime:0.009428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64141723 LIMIT 5 [ RunTime:0.008861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141723 ORDER BY `minOrder` ASC [ RunTime:0.004437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64141723 ORDER BY `unit` DESC [ RunTime:0.003278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64141723 LIMIT 2 [ RunTime:0.005830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141723 ORDER BY `minOrder` ASC [ RunTime:0.005813s ]
select * from pdf where partno='7446621007' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446621007' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.020403s ]
SELECT `id` FROM `stock` WHERE `id` <> 64141723 AND `partno` = '7446621007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.017322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939432 [ RunTime:0.002866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64141657 LIMIT 5 [ RunTime:0.003354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141657 ORDER BY `minOrder` ASC [ RunTime:0.010762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64141657 ORDER BY `unit` DESC [ RunTime:0.000815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64141657 LIMIT 2 [ RunTime:0.016866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141657 ORDER BY `minOrder` ASC [ RunTime:0.005166s ]
select * from pdf where partno='7446122001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446122001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.021898s ]
SELECT `id` FROM `stock` WHERE `id` <> 64141657 AND `partno` = '7446122001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.017924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51119493 [ RunTime:0.002576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51130700 [ RunTime:0.008627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142388 LIMIT 5 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142388 ORDER BY `minOrder` ASC [ RunTime:0.005082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142388 ORDER BY `unit` DESC [ RunTime:0.000526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142388 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142388 ORDER BY `minOrder` ASC [ RunTime:0.000952s ]
select * from pdf where partno='7446631007' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446631007' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001481s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142388 AND `partno` = '7446631007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.005322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11941482 [ RunTime:0.004806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64141778 LIMIT 5 [ RunTime:0.003813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141778 ORDER BY `minOrder` ASC [ RunTime:0.003865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64141778 ORDER BY `unit` DESC [ RunTime:0.015873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64141778 LIMIT 2 [ RunTime:0.011899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141778 ORDER BY `minOrder` ASC [ RunTime:0.010124s ]
select * from pdf where partno='7446630047' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446630047' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.030951s ]
SELECT `id` FROM `stock` WHERE `id` <> 64141778 AND `partno` = '7446630047' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.015565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204032 [ RunTime:0.018475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142245 LIMIT 5 [ RunTime:0.012749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142245 ORDER BY `minOrder` ASC [ RunTime:0.007409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142245 ORDER BY `unit` DESC [ RunTime:0.001147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142245 LIMIT 2 [ RunTime:0.021689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142245 ORDER BY `minOrder` ASC [ RunTime:0.003017s ]
select * from pdf where partno='7446121010' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.014100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446121010' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009227s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142245 AND `partno` = '7446121010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.035379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17393105 [ RunTime:0.028617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64141779 LIMIT 5 [ RunTime:0.023733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141779 ORDER BY `minOrder` ASC [ RunTime:0.008730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64141779 ORDER BY `unit` DESC [ RunTime:0.011281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64141779 LIMIT 2 [ RunTime:0.040162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141779 ORDER BY `minOrder` ASC [ RunTime:0.005611s ]
select * from pdf where partno='7446630027' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.017783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446630027' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.020954s ]
SELECT `id` FROM `stock` WHERE `id` <> 64141779 AND `partno` = '7446630027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.029649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939452 [ RunTime:0.030514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142333 LIMIT 5 [ RunTime:0.020317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142333 ORDER BY `minOrder` ASC [ RunTime:0.037787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142333 ORDER BY `unit` DESC [ RunTime:0.042305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142333 LIMIT 2 [ RunTime:0.013621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142333 ORDER BY `minOrder` ASC [ RunTime:0.023325s ]
select * from pdf where partno='7446622001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.039689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446622001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003636s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142333 AND `partno` = '7446622001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.009205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17392625 [ RunTime:0.039550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142247 LIMIT 5 [ RunTime:0.024982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142247 ORDER BY `minOrder` ASC [ RunTime:0.017481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142247 ORDER BY `unit` DESC [ RunTime:0.034654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142247 LIMIT 2 [ RunTime:0.041053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142247 ORDER BY `minOrder` ASC [ RunTime:0.018790s ]
select * from pdf where partno='74461240004' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.019686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74461240004' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.020015s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142247 AND `partno` = '74461240004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.024822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13205089 [ RunTime:0.064201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142334 LIMIT 5 [ RunTime:0.068583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142334 ORDER BY `minOrder` ASC [ RunTime:0.034868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142334 ORDER BY `unit` DESC [ RunTime:0.010699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142334 LIMIT 2 [ RunTime:0.018295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142334 ORDER BY `minOrder` ASC [ RunTime:0.014268s ]
select * from pdf where partno='7446221027' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.013298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446221027' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009881s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142334 AND `partno` = '7446221027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.022055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13205096 [ RunTime:0.017223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64141199 LIMIT 5 [ RunTime:0.002239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141199 ORDER BY `minOrder` ASC [ RunTime:0.027325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64141199 ORDER BY `unit` DESC [ RunTime:0.013223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64141199 LIMIT 2 [ RunTime:0.011457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64141199 ORDER BY `minOrder` ASC [ RunTime:0.002054s ]
select * from pdf where partno='74466340007' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.011747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74466340007' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009758s ]
SELECT `id` FROM `stock` WHERE `id` <> 64141199 AND `partno` = '74466340007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13205440 [ RunTime:0.021970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142336 LIMIT 5 [ RunTime:0.030777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142336 ORDER BY `minOrder` ASC [ RunTime:0.026320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142336 ORDER BY `unit` DESC [ RunTime:0.004756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142336 LIMIT 2 [ RunTime:0.015890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142336 ORDER BY `minOrder` ASC [ RunTime:0.006406s ]
select * from pdf where partno='7446222007' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446222007' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004198s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142336 AND `partno` = '7446222007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939884 [ RunTime:0.010084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142335 LIMIT 5 [ RunTime:0.009591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142335 ORDER BY `minOrder` ASC [ RunTime:0.010382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142335 ORDER BY `unit` DESC [ RunTime:0.006626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142335 LIMIT 2 [ RunTime:0.021672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142335 ORDER BY `minOrder` ASC [ RunTime:0.004977s ]
select * from pdf where partno='7446222004' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446222004' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.019927s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142335 AND `partno` = '7446222004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.016566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17393487 [ RunTime:0.023740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142337 LIMIT 5 [ RunTime:0.022096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142337 ORDER BY `minOrder` ASC [ RunTime:0.034631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142337 ORDER BY `unit` DESC [ RunTime:0.038210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142337 LIMIT 2 [ RunTime:0.013683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142337 ORDER BY `minOrder` ASC [ RunTime:0.007003s ]
select * from pdf where partno='7446223001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.037059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446223001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.019592s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142337 AND `partno` = '7446223001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.022078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204002 [ RunTime:0.020236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142338 LIMIT 5 [ RunTime:0.015456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142338 ORDER BY `minOrder` ASC [ RunTime:0.009392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142338 ORDER BY `unit` DESC [ RunTime:0.001911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142338 LIMIT 2 [ RunTime:0.005147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142338 ORDER BY `minOrder` ASC [ RunTime:0.005127s ]
select * from pdf where partno='7446620027' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446620027' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.013352s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142338 AND `partno` = '7446620027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939433 [ RunTime:0.002605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142339 LIMIT 5 [ RunTime:0.015838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142339 ORDER BY `minOrder` ASC [ RunTime:0.017110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142339 ORDER BY `unit` DESC [ RunTime:0.008423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142339 LIMIT 2 [ RunTime:0.004823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142339 ORDER BY `minOrder` ASC [ RunTime:0.002677s ]
select * from pdf where partno='7446221012' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.006657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446221012' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.014309s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142339 AND `partno` = '7446221012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.011194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939885 [ RunTime:0.015238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142250 LIMIT 5 [ RunTime:0.015226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142250 ORDER BY `minOrder` ASC [ RunTime:0.010005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142250 ORDER BY `unit` DESC [ RunTime:0.010820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142250 LIMIT 2 [ RunTime:0.011953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142250 ORDER BY `minOrder` ASC [ RunTime:0.005187s ]
select * from pdf where partno='7446120039' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446120039' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.031251s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142250 AND `partno` = '7446120039' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.011203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13205786 [ RunTime:0.039587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64142401 LIMIT 5 [ RunTime:0.028797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142401 ORDER BY `minOrder` ASC [ RunTime:0.013500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64142401 ORDER BY `unit` DESC [ RunTime:0.016475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64142401 LIMIT 2 [ RunTime:0.012018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64142401 ORDER BY `minOrder` ASC [ RunTime:0.011139s ]
select * from pdf where partno='7446631010' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.021466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7446631010' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.026833s ]
SELECT `id` FROM `stock` WHERE `id` <> 64142401 AND `partno` = '7446631010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.024893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11939453 [ RunTime:0.033444s ]
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 '7446%' OR `brand` LIKE '7446%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039562s ]
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 '7446%' OR `brand` LIKE '7446%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023007s ]
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 '7446%' OR `brand` LIKE '7446%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017758s ]
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 '7446%' OR `brand` LIKE '7446%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038397s ]
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 '7446%' OR `brand` LIKE '7446%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033179s ]
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 '7446%' OR `brand` LIKE '7446%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010705s ]
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 '7446%' OR `brand` LIKE '7446%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021454s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '7446%' OR `brand` LIKE '7446%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018004s ]