SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001698s ]
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=4453&search=1' [ RunTime:0.003640s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.004095s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009638s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001649s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.001746s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002029s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002530s ]
SELECT * FROM `stock_search` WHERE `partno` = '4453' LIMIT 1 [ RunTime:0.011577s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-28 01:17:19' WHERE `partno` = '4453' [ RunTime:0.004007s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001285s ]
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 '4453%' OR `brand` LIKE '4453%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029072s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509944 LIMIT 5 [ RunTime:0.025799s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509944 ORDER BY `minOrder` ASC [ RunTime:0.024067s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19509944 ORDER BY `unit` DESC [ RunTime:0.017397s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19509944 LIMIT 2 [ RunTime:0.011835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19509944 ORDER BY `minOrder` ASC [ RunTime:0.013816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11174117 LIMIT 5 [ RunTime:0.021703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11174117 ORDER BY `minOrder` ASC [ RunTime:0.010116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11174117 ORDER BY `unit` DESC [ RunTime:0.005914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11174117 LIMIT 2 [ RunTime:0.033812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11174117 ORDER BY `minOrder` ASC [ RunTime:0.018513s ]
select * from pdf where partno='44530-501' and brandshort='Tark Thermal Solutions' limit 1 [ RunTime:0.023116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18717070 LIMIT 5 [ RunTime:0.041155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18717070 ORDER BY `minOrder` ASC [ RunTime:0.036506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18717070 ORDER BY `unit` DESC [ RunTime:0.055972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18717070 LIMIT 2 [ RunTime:0.067196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18717070 ORDER BY `minOrder` ASC [ RunTime:0.021481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542686 LIMIT 5 [ RunTime:0.004271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19542686 ORDER BY `minOrder` ASC [ RunTime:0.090089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19542686 ORDER BY `unit` DESC [ RunTime:0.040740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19542686 LIMIT 2 [ RunTime:0.024091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19542686 ORDER BY `minOrder` ASC [ RunTime:0.004319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542341 LIMIT 5 [ RunTime:0.046417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19542341 ORDER BY `minOrder` ASC [ RunTime:0.029512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19542341 ORDER BY `unit` DESC [ RunTime:0.037829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19542341 LIMIT 2 [ RunTime:0.020840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19542341 ORDER BY `minOrder` ASC [ RunTime:0.041227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18717869 LIMIT 5 [ RunTime:0.017676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18717869 ORDER BY `minOrder` ASC [ RunTime:0.052843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18717869 ORDER BY `unit` DESC [ RunTime:0.012242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18717869 LIMIT 2 [ RunTime:0.035876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18717869 ORDER BY `minOrder` ASC [ RunTime:0.009525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18717297 LIMIT 5 [ RunTime:0.016565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18717297 ORDER BY `minOrder` ASC [ RunTime:0.010837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18717297 ORDER BY `unit` DESC [ RunTime:0.012658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18717297 LIMIT 2 [ RunTime:0.041799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18717297 ORDER BY `minOrder` ASC [ RunTime:0.009345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12772595 LIMIT 5 [ RunTime:0.064358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12772595 ORDER BY `minOrder` ASC [ RunTime:0.026366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12772595 ORDER BY `unit` DESC [ RunTime:0.036960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12772595 LIMIT 2 [ RunTime:0.005397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12772595 ORDER BY `minOrder` ASC [ RunTime:0.011707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406813 LIMIT 5 [ RunTime:0.026411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406813 ORDER BY `minOrder` ASC [ RunTime:0.037393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11406813 ORDER BY `unit` DESC [ RunTime:0.031095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11406813 LIMIT 2 [ RunTime:0.028394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11406813 ORDER BY `minOrder` ASC [ RunTime:0.039307s ]
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 '4453%' OR `brand` LIKE '4453%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082932 LIMIT 5 [ RunTime:0.029181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082932 ORDER BY `minOrder` ASC [ RunTime:0.077180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082932 ORDER BY `unit` DESC [ RunTime:0.018710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082932 LIMIT 2 [ RunTime:0.092579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082932 ORDER BY `minOrder` ASC [ RunTime:0.037450s ]
select * from pdf where partno='44536-0120' and brandshort='omron automation and safety' limit 1 [ RunTime:0.074653s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44536-0120' OR `brand` LIKE 'omron automation and safety%' ) ) LIMIT 1 [ RunTime:0.055034s ]
SELECT `id` FROM `stock` WHERE `id` <> 51082932 AND `partno` = '44536-0120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.065150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32180758 LIMIT 5 [ RunTime:0.082825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32180758 ORDER BY `minOrder` ASC [ RunTime:0.036154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32180758 ORDER BY `unit` DESC [ RunTime:0.050553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32180758 LIMIT 2 [ RunTime:0.133018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32180758 ORDER BY `minOrder` ASC [ RunTime:0.008767s ]
select * from pdf where partno='44531-0010' and brandshort='omron automation and safety' limit 1 [ RunTime:0.033693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44531-0010' OR `brand` LIKE 'omron automation and safety%' ) ) LIMIT 1 [ RunTime:0.060364s ]
SELECT `id` FROM `stock` WHERE `id` <> 32180758 AND `partno` = '44531-0010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.076197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32175920 LIMIT 5 [ RunTime:0.048766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32175920 ORDER BY `minOrder` ASC [ RunTime:0.081471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32175920 ORDER BY `unit` DESC [ RunTime:0.038328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32175920 LIMIT 2 [ RunTime:0.023318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32175920 ORDER BY `minOrder` ASC [ RunTime:0.017890s ]
select * from pdf where partno='44535-8015' and brandshort='omron automation and safety' limit 1 [ RunTime:0.018239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44535-8015' OR `brand` LIKE 'omron automation and safety%' ) ) LIMIT 1 [ RunTime:0.040345s ]
SELECT `id` FROM `stock` WHERE `id` <> 32175920 AND `partno` = '44535-8015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.041487s ]
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 '4453%' OR `brand` LIKE '4453%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64046218 LIMIT 5 [ RunTime:0.016035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64046218 ORDER BY `minOrder` ASC [ RunTime:0.084811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64046218 ORDER BY `unit` DESC [ RunTime:0.026750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64046218 LIMIT 2 [ RunTime:0.065836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64046218 ORDER BY `minOrder` ASC [ RunTime:0.028451s ]
select * from pdf where partno='4453' and brandshort='Pololu' limit 1 [ RunTime:0.021291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4453' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.014140s ]
SELECT `id` FROM `stock` WHERE `id` <> 64046218 AND `partno` = '4453' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.036885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19509944 [ RunTime:0.051082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58509711 LIMIT 5 [ RunTime:0.036371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58509711 ORDER BY `minOrder` ASC [ RunTime:0.035036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58509711 ORDER BY `unit` DESC [ RunTime:0.022182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58509711 LIMIT 2 [ RunTime:0.019464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58509711 ORDER BY `minOrder` ASC [ RunTime:0.011041s ]
select * from pdf where partno='44530-501' and brandshort='Tark Thermal Solutions' limit 1 [ RunTime:0.011520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44530-501' OR `brand` LIKE 'Tark Thermal Solutions%' ) ) LIMIT 1 [ RunTime:0.017204s ]
SELECT `id` FROM `stock` WHERE `id` <> 58509711 AND `partno` = '44530-501' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tark thermal solutions%' ) [ RunTime:0.061907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11174117 [ RunTime:0.018981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58566062 LIMIT 5 [ RunTime:0.089043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58566062 ORDER BY `minOrder` ASC [ RunTime:0.066375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58566062 ORDER BY `unit` DESC [ RunTime:0.071259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58566062 LIMIT 2 [ RunTime:0.074180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58566062 ORDER BY `minOrder` ASC [ RunTime:0.049320s ]
select * from pdf where partno='44531' and brandshort='Wiha' limit 1 [ RunTime:0.028844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44531' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.039277s ]
SELECT `id` FROM `stock` WHERE `id` <> 58566062 AND `partno` = '44531' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.032970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18717070 [ RunTime:0.076147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43835815 LIMIT 5 [ RunTime:0.071606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43835815 ORDER BY `minOrder` ASC [ RunTime:0.069811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43835815 ORDER BY `unit` DESC [ RunTime:0.008256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43835815 LIMIT 2 [ RunTime:0.009080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43835815 ORDER BY `minOrder` ASC [ RunTime:0.027729s ]
select * from pdf where partno='445340050' and brandshort='Omron Electronics Inc-EMC Div' limit 1 [ RunTime:0.031244s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '445340050' OR `brand` LIKE 'Omron Electronics Inc-EMC Div%' ) ) LIMIT 1 [ RunTime:0.020351s ]
SELECT `id` FROM `stock` WHERE `id` <> 43835815 AND `partno` = '445340050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron electronics inc-emc div%' ) [ RunTime:0.030602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58566687 LIMIT 5 [ RunTime:0.030742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58566687 ORDER BY `minOrder` ASC [ RunTime:0.073361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58566687 ORDER BY `unit` DESC [ RunTime:0.028465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58566687 LIMIT 2 [ RunTime:0.049553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58566687 ORDER BY `minOrder` ASC [ RunTime:0.010647s ]
select * from pdf where partno='44532' and brandshort='Wiha' limit 1 [ RunTime:0.016090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44532' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.041444s ]
SELECT `id` FROM `stock` WHERE `id` <> 58566687 AND `partno` = '44532' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.022276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18717869 [ RunTime:0.108512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63415185 LIMIT 5 [ RunTime:0.032553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63415185 ORDER BY `minOrder` ASC [ RunTime:0.040163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63415185 ORDER BY `unit` DESC [ RunTime:0.063857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63415185 LIMIT 2 [ RunTime:0.070458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63415185 ORDER BY `minOrder` ASC [ RunTime:0.009508s ]
select * from pdf where partno='4453-BLACK' and brandshort='80/20, LLC' limit 1 [ RunTime:0.038080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4453-BLACK' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.035415s ]
SELECT `id` FROM `stock` WHERE `id` <> 63415185 AND `partno` = '4453-BLACK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.003558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63414968 LIMIT 5 [ RunTime:0.029807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63414968 ORDER BY `minOrder` ASC [ RunTime:0.038981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63414968 ORDER BY `unit` DESC [ RunTime:0.024742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63414968 LIMIT 2 [ RunTime:0.038599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63414968 ORDER BY `minOrder` ASC [ RunTime:0.002117s ]
select * from pdf where partno='4453-HW' and brandshort='80/20, LLC' limit 1 [ RunTime:0.016256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4453-HW' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.092564s ]
SELECT `id` FROM `stock` WHERE `id` <> 63414968 AND `partno` = '4453-HW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.052824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63414847 LIMIT 5 [ RunTime:0.053911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63414847 ORDER BY `minOrder` ASC [ RunTime:0.046522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63414847 ORDER BY `unit` DESC [ RunTime:0.004741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63414847 LIMIT 2 [ RunTime:0.070247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63414847 ORDER BY `minOrder` ASC [ RunTime:0.006515s ]
select * from pdf where partno='4453' and brandshort='80/20, LLC' limit 1 [ RunTime:0.004488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4453' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.038668s ]
SELECT `id` FROM `stock` WHERE `id` <> 63414847 AND `partno` = '4453' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.047761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60633229 LIMIT 5 [ RunTime:0.069821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60633229 ORDER BY `minOrder` ASC [ RunTime:0.048606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60633229 ORDER BY `unit` DESC [ RunTime:0.040641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60633229 LIMIT 2 [ RunTime:0.084832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60633229 ORDER BY `minOrder` ASC [ RunTime:0.012583s ]
select * from pdf where partno='445389-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.016938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '445389-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.042875s ]
SELECT `id` FROM `stock` WHERE `id` <> 60633229 AND `partno` = '445389-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.047337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11406813 [ RunTime:0.057268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44507918 LIMIT 5 [ RunTime:0.020690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44507918 ORDER BY `minOrder` ASC [ RunTime:0.044823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44507918 ORDER BY `unit` DESC [ RunTime:0.051613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44507918 LIMIT 2 [ RunTime:0.033909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44507918 ORDER BY `minOrder` ASC [ RunTime:0.020408s ]
select * from pdf where partno='445344090' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.033023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '445344090' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.043332s ]
SELECT `id` FROM `stock` WHERE `id` <> 44507918 AND `partno` = '445344090' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.021925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542686 [ RunTime:0.044760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32946413 LIMIT 5 [ RunTime:0.027730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32946413 ORDER BY `minOrder` ASC [ RunTime:0.033907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32946413 ORDER BY `unit` DESC [ RunTime:0.025125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32946413 LIMIT 2 [ RunTime:0.014705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32946413 ORDER BY `minOrder` ASC [ RunTime:0.007873s ]
select * from pdf where partno='445344090' and brandshort='Omron Automation and Safety' limit 1 [ RunTime:0.000411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '445344090' OR `brand` LIKE 'Omron Automation and Safety%' ) ) LIMIT 1 [ RunTime:0.008419s ]
SELECT `id` FROM `stock` WHERE `id` <> 32946413 AND `partno` = '445344090' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omron automation and safety%' ) [ RunTime:0.017077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19542686 [ RunTime:0.024818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32629697 LIMIT 5 [ RunTime:0.023936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32629697 ORDER BY `minOrder` ASC [ RunTime:0.021955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32629697 ORDER BY `unit` DESC [ RunTime:0.042937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32629697 LIMIT 2 [ RunTime:0.044765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32629697 ORDER BY `minOrder` ASC [ RunTime:0.015716s ]
select * from pdf where partno='44530' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.016754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44530' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.026804s ]
SELECT `id` FROM `stock` WHERE `id` <> 32629697 AND `partno` = '44530' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.022448s ]
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 '4453%' OR `brand` LIKE '4453%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070137s ]
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 '4453%' OR `brand` LIKE '4453%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014053s ]
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 '4453%' OR `brand` LIKE '4453%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030883s ]
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 '4453%' OR `brand` LIKE '4453%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025239s ]
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 '4453%' OR `brand` LIKE '4453%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065241s ]
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 '4453%' OR `brand` LIKE '4453%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039430s ]
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 '4453%' OR `brand` LIKE '4453%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060688s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4453%' OR `brand` LIKE '4453%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025987s ]