SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002782s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=56107&search=1' [ RunTime:0.001911s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002140s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000608s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002843s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002129s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000330s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002573s ]
SELECT * FROM `stock_search` WHERE `partno` = '56107' LIMIT 1 [ RunTime:0.003413s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 02:44:53' WHERE `partno` = '56107' [ RunTime:0.011305s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002180s ]
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 '56107%' OR `brand` LIKE '56107%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017481s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18276688 LIMIT 5 [ RunTime:0.022580s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18276688 ORDER BY `minOrder` ASC [ RunTime:0.017528s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18276688 ORDER BY `unit` DESC [ RunTime:0.024919s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18276688 LIMIT 2 [ RunTime:0.021243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18276688 ORDER BY `minOrder` ASC [ RunTime:0.002215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15839736 LIMIT 5 [ RunTime:0.006286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15839736 ORDER BY `minOrder` ASC [ RunTime:0.014084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15839736 ORDER BY `unit` DESC [ RunTime:0.019958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15839736 LIMIT 2 [ RunTime:0.034247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15839736 ORDER BY `minOrder` ASC [ RunTime:0.016499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15839737 LIMIT 5 [ RunTime:0.012904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15839737 ORDER BY `minOrder` ASC [ RunTime:0.025830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15839737 ORDER BY `unit` DESC [ RunTime:0.009716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15839737 LIMIT 2 [ RunTime:0.041984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15839737 ORDER BY `minOrder` ASC [ RunTime:0.024793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18287923 LIMIT 5 [ RunTime:0.035520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18287923 ORDER BY `minOrder` ASC [ RunTime:0.009924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18287923 ORDER BY `unit` DESC [ RunTime:0.037713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18287923 LIMIT 2 [ RunTime:0.037034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18287923 ORDER BY `minOrder` ASC [ RunTime:0.005060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15845874 LIMIT 5 [ RunTime:0.015779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15845874 ORDER BY `minOrder` ASC [ RunTime:0.009057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15845874 ORDER BY `unit` DESC [ RunTime:0.008421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15845874 LIMIT 2 [ RunTime:0.011660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15845874 ORDER BY `minOrder` ASC [ RunTime:0.005709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18287924 LIMIT 5 [ RunTime:0.009239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18287924 ORDER BY `minOrder` ASC [ RunTime:0.006317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18287924 ORDER BY `unit` DESC [ RunTime:0.003530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18287924 LIMIT 2 [ RunTime:0.014494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18287924 ORDER BY `minOrder` ASC [ RunTime:0.005007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15066850 LIMIT 5 [ RunTime:0.007783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15066850 ORDER BY `minOrder` ASC [ RunTime:0.007790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15066850 ORDER BY `unit` DESC [ RunTime:0.006095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15066850 LIMIT 2 [ RunTime:0.024240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15066850 ORDER BY `minOrder` ASC [ RunTime:0.020110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15089491 LIMIT 5 [ RunTime:0.037947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15089491 ORDER BY `minOrder` ASC [ RunTime:0.014591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15089491 ORDER BY `unit` DESC [ RunTime:0.012943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15089491 LIMIT 2 [ RunTime:0.002528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15089491 ORDER BY `minOrder` ASC [ RunTime:0.008364s ]
select * from pdf where partno='561070332080' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.023503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335872 LIMIT 5 [ RunTime:0.023803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335872 ORDER BY `minOrder` ASC [ RunTime:0.012443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11335872 ORDER BY `unit` DESC [ RunTime:0.095496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11335872 LIMIT 2 [ RunTime:0.014102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11335872 ORDER BY `minOrder` ASC [ RunTime:0.008207s ]
select * from pdf where partno='56107' and brandshort='Kitronik Ltd.' limit 1 [ RunTime:0.023512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18362132 LIMIT 5 [ RunTime:0.050023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18362132 ORDER BY `minOrder` ASC [ RunTime:0.042207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18362132 ORDER BY `unit` DESC [ RunTime:0.021685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18362132 LIMIT 2 [ RunTime:0.043642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18362132 ORDER BY `minOrder` ASC [ RunTime:0.036137s ]
select * from pdf where partno='561070332057' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.019210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15884723 LIMIT 5 [ RunTime:0.026420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15884723 ORDER BY `minOrder` ASC [ RunTime:0.036545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15884723 ORDER BY `unit` DESC [ RunTime:0.006544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15884723 LIMIT 2 [ RunTime:0.030108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15884723 ORDER BY `minOrder` ASC [ RunTime:0.024359s ]
select * from pdf where partno='561070332081' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.006447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15884722 LIMIT 5 [ RunTime:0.010542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15884722 ORDER BY `minOrder` ASC [ RunTime:0.035496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15884722 ORDER BY `unit` DESC [ RunTime:0.019932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15884722 LIMIT 2 [ RunTime:0.014173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15884722 ORDER BY `minOrder` ASC [ RunTime:0.015779s ]
select * from pdf where partno='561070332079' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.030614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15884721 LIMIT 5 [ RunTime:0.014788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15884721 ORDER BY `minOrder` ASC [ RunTime:0.012415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15884721 ORDER BY `unit` DESC [ RunTime:0.027476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15884721 LIMIT 2 [ RunTime:0.063737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15884721 ORDER BY `minOrder` ASC [ RunTime:0.011012s ]
select * from pdf where partno='561070332076' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.032655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15109057 LIMIT 5 [ RunTime:0.026502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15109057 ORDER BY `minOrder` ASC [ RunTime:0.066402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15109057 ORDER BY `unit` DESC [ RunTime:0.077972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15109057 LIMIT 2 [ RunTime:0.034559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15109057 ORDER BY `minOrder` ASC [ RunTime:0.030305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15109056 LIMIT 5 [ RunTime:0.029090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15109056 ORDER BY `minOrder` ASC [ RunTime:0.029584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15109056 ORDER BY `unit` DESC [ RunTime:0.052092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15109056 LIMIT 2 [ RunTime:0.068472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15109056 ORDER BY `minOrder` ASC [ RunTime:0.051216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13535656 LIMIT 5 [ RunTime:0.058255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13535656 ORDER BY `minOrder` ASC [ RunTime:0.032301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13535656 ORDER BY `unit` DESC [ RunTime:0.034237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13535656 LIMIT 2 [ RunTime:0.025730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13535656 ORDER BY `minOrder` ASC [ RunTime:0.017819s ]
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 '56107%' OR `brand` LIKE '56107%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025990s ]
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 '56107%' OR `brand` LIKE '56107%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33153451 LIMIT 5 [ RunTime:0.019107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33153451 ORDER BY `minOrder` ASC [ RunTime:0.074337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33153451 ORDER BY `unit` DESC [ RunTime:0.064773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33153451 LIMIT 2 [ RunTime:0.039678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33153451 ORDER BY `minOrder` ASC [ RunTime:0.036271s ]
select * from pdf where partno='561070332051' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.023460s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '561070332051' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.022796s ]
SELECT `id` FROM `stock` WHERE `id` <> 33153451 AND `partno` = '561070332051' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.077668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18276688 [ RunTime:0.041711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33254856 LIMIT 5 [ RunTime:0.101944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33254856 ORDER BY `minOrder` ASC [ RunTime:0.063212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33254856 ORDER BY `unit` DESC [ RunTime:0.015561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33254856 LIMIT 2 [ RunTime:0.056514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33254856 ORDER BY `minOrder` ASC [ RunTime:0.022913s ]
select * from pdf where partno='561070332078' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.024972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '561070332078' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.044722s ]
SELECT `id` FROM `stock` WHERE `id` <> 33254856 AND `partno` = '561070332078' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.063853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15839736 [ RunTime:0.099095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33258434 LIMIT 5 [ RunTime:0.076840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33258434 ORDER BY `minOrder` ASC [ RunTime:0.136986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33258434 ORDER BY `unit` DESC [ RunTime:0.036808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33258434 LIMIT 2 [ RunTime:0.071944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33258434 ORDER BY `minOrder` ASC [ RunTime:0.042092s ]
select * from pdf where partno='561070350078' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.035805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '561070350078' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.031333s ]
SELECT `id` FROM `stock` WHERE `id` <> 33258434 AND `partno` = '561070350078' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.034423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18287923 [ RunTime:0.025238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33258433 LIMIT 5 [ RunTime:0.026587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33258433 ORDER BY `minOrder` ASC [ RunTime:0.028227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33258433 ORDER BY `unit` DESC [ RunTime:0.061639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33258433 LIMIT 2 [ RunTime:0.010150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33258433 ORDER BY `minOrder` ASC [ RunTime:0.014996s ]
select * from pdf where partno='561070350055' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.047001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '561070350055' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.072800s ]
SELECT `id` FROM `stock` WHERE `id` <> 33258433 AND `partno` = '561070350055' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.054477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15845874 [ RunTime:0.148529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33258435 LIMIT 5 [ RunTime:0.118002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33258435 ORDER BY `minOrder` ASC [ RunTime:0.289768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33258435 ORDER BY `unit` DESC [ RunTime:0.120946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33258435 LIMIT 2 [ RunTime:0.077164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33258435 ORDER BY `minOrder` ASC [ RunTime:0.015009s ]
select * from pdf where partno='561070350077' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.030029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '561070350077' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002990s ]
SELECT `id` FROM `stock` WHERE `id` <> 33258435 AND `partno` = '561070350077' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.136893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18287924 [ RunTime:0.036559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33254864 LIMIT 5 [ RunTime:0.044983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33254864 ORDER BY `minOrder` ASC [ RunTime:0.019840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33254864 ORDER BY `unit` DESC [ RunTime:0.078586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33254864 LIMIT 2 [ RunTime:0.024611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33254864 ORDER BY `minOrder` ASC [ RunTime:0.024660s ]
select * from pdf where partno='561070332071' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.020093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '561070332071' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.018331s ]
SELECT `id` FROM `stock` WHERE `id` <> 33254864 AND `partno` = '561070332071' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.011868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15839737 [ RunTime:0.028831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33254867 LIMIT 5 [ RunTime:0.013776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33254867 ORDER BY `minOrder` ASC [ RunTime:0.043143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33254867 ORDER BY `unit` DESC [ RunTime:0.022907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33254867 LIMIT 2 [ RunTime:0.040783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33254867 ORDER BY `minOrder` ASC [ RunTime:0.087770s ]
select * from pdf where partno='561070332055' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.095031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '561070332055' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.071226s ]
SELECT `id` FROM `stock` WHERE `id` <> 33254867 AND `partno` = '561070332055' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.137585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15066850 [ RunTime:0.033298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50238858 LIMIT 5 [ RunTime:0.017076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50238858 ORDER BY `minOrder` ASC [ RunTime:0.077231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50238858 ORDER BY `unit` DESC [ RunTime:0.075503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50238858 LIMIT 2 [ RunTime:0.079729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50238858 ORDER BY `minOrder` ASC [ RunTime:0.012378s ]
select * from pdf where partno='56107' and brandshort='Kitronik Ltd.' limit 1 [ RunTime:0.026025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56107' OR `brand` LIKE 'Kitronik Ltd.%' ) ) LIMIT 1 [ RunTime:0.048575s ]
SELECT `id` FROM `stock` WHERE `id` <> 50238858 AND `partno` = '56107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kitronik ltd.%' ) [ RunTime:0.037723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335872 [ RunTime:0.039647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37437548 LIMIT 5 [ RunTime:0.060370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37437548 ORDER BY `minOrder` ASC [ RunTime:0.093634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37437548 ORDER BY `unit` DESC [ RunTime:0.063998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37437548 LIMIT 2 [ RunTime:0.142724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37437548 ORDER BY `minOrder` ASC [ RunTime:0.044096s ]
select * from pdf where partno='56107' and brandshort='Kitronik Ltd.' limit 1 [ RunTime:0.024396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56107' OR `brand` LIKE 'Kitronik Ltd.%' ) ) LIMIT 1 [ RunTime:0.016819s ]
SELECT `id` FROM `stock` WHERE `id` <> 37437548 AND `partno` = '56107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kitronik ltd.%' ) [ RunTime:0.052329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11335872 [ RunTime:0.032205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56361003 LIMIT 5 [ RunTime:0.039038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56361003 ORDER BY `minOrder` ASC [ RunTime:0.059701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56361003 ORDER BY `unit` DESC [ RunTime:0.015202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56361003 LIMIT 2 [ RunTime:0.018403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56361003 ORDER BY `minOrder` ASC [ RunTime:0.015654s ]
select * from pdf where partno='56107' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.040849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56107' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.059577s ]
SELECT `id` FROM `stock` WHERE `id` <> 56361003 AND `partno` = '56107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.090436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13535656 [ RunTime:0.055521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33585698 LIMIT 5 [ RunTime:0.028002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33585698 ORDER BY `minOrder` ASC [ RunTime:0.069787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33585698 ORDER BY `unit` DESC [ RunTime:0.034392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33585698 LIMIT 2 [ RunTime:0.073043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33585698 ORDER BY `minOrder` ASC [ RunTime:0.056532s ]
select * from pdf where partno='561070332080' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.026336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '561070332080' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.048676s ]
SELECT `id` FROM `stock` WHERE `id` <> 33585698 AND `partno` = '561070332080' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.029179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15089491 [ RunTime:0.041987s ]
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 '56107%' OR `brand` LIKE '56107%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060531s ]
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 '56107%' OR `brand` LIKE '56107%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069789s ]
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 '56107%' OR `brand` LIKE '56107%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039472s ]
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 '56107%' OR `brand` LIKE '56107%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053216s ]
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 '56107%' OR `brand` LIKE '56107%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055629s ]
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 '56107%' OR `brand` LIKE '56107%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054107s ]
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 '56107%' OR `brand` LIKE '56107%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047812s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '56107%' OR `brand` LIKE '56107%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.068448s ]