SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001522s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.165' , `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=26478&search=1' [ RunTime:0.016020s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002723s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.027150s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001574s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.165' ) [ RunTime:0.024729s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001387s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.017031s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002518s ]
SELECT * FROM `stock_search` WHERE `partno` = '26478' LIMIT 1 [ RunTime:0.060587s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-26 04:54:53' WHERE `partno` = '26478' [ RunTime:0.027396s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002569s ]
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 '26478%' OR `brand` LIKE '26478%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069848s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656391 LIMIT 5 [ RunTime:0.062690s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.029316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656391 ORDER BY `minOrder` ASC [ RunTime:0.068248s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.037478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19656391 ORDER BY `unit` DESC [ RunTime:0.029625s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.056132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19656391 LIMIT 2 [ RunTime:0.036846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656391 ORDER BY `minOrder` ASC [ RunTime:0.037215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656078 LIMIT 5 [ RunTime:0.048668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656078 ORDER BY `minOrder` ASC [ RunTime:0.017322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19656078 ORDER BY `unit` DESC [ RunTime:0.033695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19656078 LIMIT 2 [ RunTime:0.076568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656078 ORDER BY `minOrder` ASC [ RunTime:0.016924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655688 LIMIT 5 [ RunTime:0.063923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655688 ORDER BY `minOrder` ASC [ RunTime:0.050973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19655688 ORDER BY `unit` DESC [ RunTime:0.058961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19655688 LIMIT 2 [ RunTime:0.068508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655688 ORDER BY `minOrder` ASC [ RunTime:0.059169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655354 LIMIT 5 [ RunTime:0.037686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655354 ORDER BY `minOrder` ASC [ RunTime:0.146967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19655354 ORDER BY `unit` DESC [ RunTime:0.066051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19655354 LIMIT 2 [ RunTime:0.072301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19655354 ORDER BY `minOrder` ASC [ RunTime:0.030837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19654913 LIMIT 5 [ RunTime:0.029610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654913 ORDER BY `minOrder` ASC [ RunTime:0.142076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19654913 ORDER BY `unit` DESC [ RunTime:0.079286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19654913 LIMIT 2 [ RunTime:0.040481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654913 ORDER BY `minOrder` ASC [ RunTime:0.037970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19654446 LIMIT 5 [ RunTime:0.053683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654446 ORDER BY `minOrder` ASC [ RunTime:0.022946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19654446 ORDER BY `unit` DESC [ RunTime:0.045313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19654446 LIMIT 2 [ RunTime:0.037422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654446 ORDER BY `minOrder` ASC [ RunTime:0.015655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652973 LIMIT 5 [ RunTime:0.038926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652973 ORDER BY `minOrder` ASC [ RunTime:0.007700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19652973 ORDER BY `unit` DESC [ RunTime:0.024946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19652973 LIMIT 2 [ RunTime:0.013547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652973 ORDER BY `minOrder` ASC [ RunTime:0.020831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652305 LIMIT 5 [ RunTime:0.048462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652305 ORDER BY `minOrder` ASC [ RunTime:0.024408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19652305 ORDER BY `unit` DESC [ RunTime:0.038520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19652305 LIMIT 2 [ RunTime:0.074066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652305 ORDER BY `minOrder` ASC [ RunTime:0.023615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17311367 LIMIT 5 [ RunTime:0.029023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17311367 ORDER BY `minOrder` ASC [ RunTime:0.051491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17311367 ORDER BY `unit` DESC [ RunTime:0.063452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17311367 LIMIT 2 [ RunTime:0.022700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17311367 ORDER BY `minOrder` ASC [ RunTime:0.024542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310868 LIMIT 5 [ RunTime:0.034831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310868 ORDER BY `minOrder` ASC [ RunTime:0.091633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17310868 ORDER BY `unit` DESC [ RunTime:0.045609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17310868 LIMIT 2 [ RunTime:0.051041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310868 ORDER BY `minOrder` ASC [ RunTime:0.037334s ]
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 '26478%' OR `brand` LIKE '26478%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057788s ]
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 '26478%' OR `brand` LIKE '26478%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53733735 LIMIT 5 [ RunTime:0.028192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53733735 ORDER BY `minOrder` ASC [ RunTime:0.024888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53733735 ORDER BY `unit` DESC [ RunTime:0.042551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53733735 LIMIT 2 [ RunTime:0.053304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53733735 ORDER BY `minOrder` ASC [ RunTime:0.017952s ]
select * from pdf where partno='2647890000' and brandshort='Weidmüller' limit 1 [ RunTime:0.056155s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2647890000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.075333s ]
SELECT `id` FROM `stock` WHERE `id` <> 53733735 AND `partno` = '2647890000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.045563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656391 [ RunTime:0.048252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53733196 LIMIT 5 [ RunTime:0.103563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53733196 ORDER BY `minOrder` ASC [ RunTime:0.122663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53733196 ORDER BY `unit` DESC [ RunTime:0.084244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53733196 LIMIT 2 [ RunTime:0.081719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53733196 ORDER BY `minOrder` ASC [ RunTime:0.003489s ]
select * from pdf where partno='2647880000' and brandshort='Weidmüller' limit 1 [ RunTime:0.047005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2647880000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.076841s ]
SELECT `id` FROM `stock` WHERE `id` <> 53733196 AND `partno` = '2647880000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.039534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656078 [ RunTime:0.046158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53732792 LIMIT 5 [ RunTime:0.016893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53732792 ORDER BY `minOrder` ASC [ RunTime:0.062197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53732792 ORDER BY `unit` DESC [ RunTime:0.025778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53732792 LIMIT 2 [ RunTime:0.017721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53732792 ORDER BY `minOrder` ASC [ RunTime:0.012696s ]
select * from pdf where partno='2647870000' and brandshort='Weidmüller' limit 1 [ RunTime:0.046884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2647870000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.058873s ]
SELECT `id` FROM `stock` WHERE `id` <> 53732792 AND `partno` = '2647870000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.032527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655688 [ RunTime:0.016508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53732325 LIMIT 5 [ RunTime:0.038479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53732325 ORDER BY `minOrder` ASC [ RunTime:0.017951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53732325 ORDER BY `unit` DESC [ RunTime:0.032357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53732325 LIMIT 2 [ RunTime:0.066261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53732325 ORDER BY `minOrder` ASC [ RunTime:0.002454s ]
select * from pdf where partno='2647860000' and brandshort='Weidmüller' limit 1 [ RunTime:0.032591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2647860000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007818s ]
SELECT `id` FROM `stock` WHERE `id` <> 53732325 AND `partno` = '2647860000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19655354 [ RunTime:0.042601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53731762 LIMIT 5 [ RunTime:0.022981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731762 ORDER BY `minOrder` ASC [ RunTime:0.056268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53731762 ORDER BY `unit` DESC [ RunTime:0.037953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53731762 LIMIT 2 [ RunTime:0.053961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731762 ORDER BY `minOrder` ASC [ RunTime:0.039488s ]
select * from pdf where partno='2647850000' and brandshort='Weidmüller' limit 1 [ RunTime:0.067687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2647850000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.066700s ]
SELECT `id` FROM `stock` WHERE `id` <> 53731762 AND `partno` = '2647850000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.042458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19654913 [ RunTime:0.051666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53731151 LIMIT 5 [ RunTime:0.033991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731151 ORDER BY `minOrder` ASC [ RunTime:0.042069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53731151 ORDER BY `unit` DESC [ RunTime:0.027450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53731151 LIMIT 2 [ RunTime:0.026375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731151 ORDER BY `minOrder` ASC [ RunTime:0.033221s ]
select * from pdf where partno='2647840000' and brandshort='Weidmüller' limit 1 [ RunTime:0.034100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2647840000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.066964s ]
SELECT `id` FROM `stock` WHERE `id` <> 53731151 AND `partno` = '2647840000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.053187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19654446 [ RunTime:0.066199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53730347 LIMIT 5 [ RunTime:0.026182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53730347 ORDER BY `minOrder` ASC [ RunTime:0.038942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53730347 ORDER BY `unit` DESC [ RunTime:0.032884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53730347 LIMIT 2 [ RunTime:0.033239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53730347 ORDER BY `minOrder` ASC [ RunTime:0.021552s ]
select * from pdf where partno='2647830000' and brandshort='Weidmüller' limit 1 [ RunTime:0.029304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2647830000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.045022s ]
SELECT `id` FROM `stock` WHERE `id` <> 53730347 AND `partno` = '2647830000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.035871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17311367 [ RunTime:0.052235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53729289 LIMIT 5 [ RunTime:0.026758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53729289 ORDER BY `minOrder` ASC [ RunTime:0.094239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53729289 ORDER BY `unit` DESC [ RunTime:0.046469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53729289 LIMIT 2 [ RunTime:0.022605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53729289 ORDER BY `minOrder` ASC [ RunTime:0.021306s ]
select * from pdf where partno='2647820000' and brandshort='Weidmüller' limit 1 [ RunTime:0.017895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2647820000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.030549s ]
SELECT `id` FROM `stock` WHERE `id` <> 53729289 AND `partno` = '2647820000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.042905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652973 [ RunTime:0.039201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53728349 LIMIT 5 [ RunTime:0.057681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728349 ORDER BY `minOrder` ASC [ RunTime:0.045618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53728349 ORDER BY `unit` DESC [ RunTime:0.104736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53728349 LIMIT 2 [ RunTime:0.097311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728349 ORDER BY `minOrder` ASC [ RunTime:0.021882s ]
select * from pdf where partno='2647810000' and brandshort='Weidmüller' limit 1 [ RunTime:0.046830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2647810000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.051996s ]
SELECT `id` FROM `stock` WHERE `id` <> 53728349 AND `partno` = '2647810000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.134301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652305 [ RunTime:0.002994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53727092 LIMIT 5 [ RunTime:0.032939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727092 ORDER BY `minOrder` ASC [ RunTime:0.138364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53727092 ORDER BY `unit` DESC [ RunTime:0.097430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53727092 LIMIT 2 [ RunTime:0.080469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727092 ORDER BY `minOrder` ASC [ RunTime:0.016375s ]
select * from pdf where partno='2647800000' and brandshort='Weidmüller' limit 1 [ RunTime:0.173931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2647800000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.051329s ]
SELECT `id` FROM `stock` WHERE `id` <> 53727092 AND `partno` = '2647800000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.050578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310868 [ RunTime:0.071505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32393269 LIMIT 5 [ RunTime:0.095946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393269 ORDER BY `minOrder` ASC [ RunTime:0.171538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32393269 ORDER BY `unit` DESC [ RunTime:0.177874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32393269 LIMIT 2 [ RunTime:0.081077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32393269 ORDER BY `minOrder` ASC [ RunTime:0.049640s ]
select * from pdf where partno='26478' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.031593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26478' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.110021s ]
SELECT `id` FROM `stock` WHERE `id` <> 32393269 AND `partno` = '26478' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.078607s ]
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 '26478%' OR `brand` LIKE '26478%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058985s ]
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 '26478%' OR `brand` LIKE '26478%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037613s ]
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 '26478%' OR `brand` LIKE '26478%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060465s ]
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 '26478%' OR `brand` LIKE '26478%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061559s ]
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 '26478%' OR `brand` LIKE '26478%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075797s ]
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 '26478%' OR `brand` LIKE '26478%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.154549s ]
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 '26478%' OR `brand` LIKE '26478%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093444s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '26478%' OR `brand` LIKE '26478%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.147228s ]