SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001312s ]
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=8328&search=1' [ RunTime:0.005089s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002226s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000566s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002428s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.003257s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002388s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004513s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002146s ]
SELECT * FROM `stock_search` WHERE `partno` = '8328' LIMIT 1 [ RunTime:0.027290s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-23 16:08:12' WHERE `partno` = '8328' [ RunTime:0.012357s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002742s ]
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 '8328%' OR `brand` LIKE '8328%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053878s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14391746 LIMIT 5 [ RunTime:0.032752s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14391746 ORDER BY `minOrder` ASC [ RunTime:0.032430s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.022343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14391746 ORDER BY `unit` DESC [ RunTime:0.004257s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14391746 LIMIT 2 [ RunTime:0.033038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14391746 ORDER BY `minOrder` ASC [ RunTime:0.023539s ]
select * from pdf where partno='83284 0091000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.038265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12455552 LIMIT 5 [ RunTime:0.047892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12455552 ORDER BY `minOrder` ASC [ RunTime:0.077025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12455552 ORDER BY `unit` DESC [ RunTime:0.065374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12455552 LIMIT 2 [ RunTime:0.059134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12455552 ORDER BY `minOrder` ASC [ RunTime:0.021543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18910840 LIMIT 5 [ RunTime:0.039425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18910840 ORDER BY `minOrder` ASC [ RunTime:0.050262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18910840 ORDER BY `unit` DESC [ RunTime:0.081378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18910840 LIMIT 2 [ RunTime:0.065148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18910840 ORDER BY `minOrder` ASC [ RunTime:0.010470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15432055 LIMIT 5 [ RunTime:0.038335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15432055 ORDER BY `minOrder` ASC [ RunTime:0.032624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15432055 ORDER BY `unit` DESC [ RunTime:0.038043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15432055 LIMIT 2 [ RunTime:0.056688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15432055 ORDER BY `minOrder` ASC [ RunTime:0.051939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13519949 LIMIT 5 [ RunTime:0.066046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13519949 ORDER BY `minOrder` ASC [ RunTime:0.076750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13519949 ORDER BY `unit` DESC [ RunTime:0.020744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13519949 LIMIT 2 [ RunTime:0.073010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13519949 ORDER BY `minOrder` ASC [ RunTime:0.014002s ]
select * from pdf where partno='83284 009100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.100971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14393474 LIMIT 5 [ RunTime:0.052824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393474 ORDER BY `minOrder` ASC [ RunTime:0.020567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14393474 ORDER BY `unit` DESC [ RunTime:0.074111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14393474 LIMIT 2 [ RunTime:0.033427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14393474 ORDER BY `minOrder` ASC [ RunTime:0.036572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531439 LIMIT 5 [ RunTime:0.090108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19531439 ORDER BY `minOrder` ASC [ RunTime:0.109797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19531439 ORDER BY `unit` DESC [ RunTime:0.073249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19531439 LIMIT 2 [ RunTime:0.073511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19531439 ORDER BY `minOrder` ASC [ RunTime:0.037418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19021422 LIMIT 5 [ RunTime:0.030717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19021422 ORDER BY `minOrder` ASC [ RunTime:0.046554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19021422 ORDER BY `unit` DESC [ RunTime:0.083578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19021422 LIMIT 2 [ RunTime:0.020385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19021422 ORDER BY `minOrder` ASC [ RunTime:0.023868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19020810 LIMIT 5 [ RunTime:0.082246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19020810 ORDER BY `minOrder` ASC [ RunTime:0.046763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19020810 ORDER BY `unit` DESC [ RunTime:0.038425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19020810 LIMIT 2 [ RunTime:0.044428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19020810 ORDER BY `minOrder` ASC [ RunTime:0.021265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14392325 LIMIT 5 [ RunTime:0.026817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14392325 ORDER BY `minOrder` ASC [ RunTime:0.039299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14392325 ORDER BY `unit` DESC [ RunTime:0.009661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14392325 LIMIT 2 [ RunTime:0.037288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14392325 ORDER BY `minOrder` ASC [ RunTime:0.031852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13336289 LIMIT 5 [ RunTime:0.042178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13336289 ORDER BY `minOrder` ASC [ RunTime:0.023417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13336289 ORDER BY `unit` DESC [ RunTime:0.044795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13336289 LIMIT 2 [ RunTime:0.030199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13336289 ORDER BY `minOrder` ASC [ RunTime:0.059137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13335346 LIMIT 5 [ RunTime:0.025029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13335346 ORDER BY `minOrder` ASC [ RunTime:0.024074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13335346 ORDER BY `unit` DESC [ RunTime:0.025832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13335346 LIMIT 2 [ RunTime:0.052711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13335346 ORDER BY `minOrder` ASC [ RunTime:0.004822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12174272 LIMIT 5 [ RunTime:0.020706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174272 ORDER BY `minOrder` ASC [ RunTime:0.023387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12174272 ORDER BY `unit` DESC [ RunTime:0.000583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12174272 LIMIT 2 [ RunTime:0.002644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174272 ORDER BY `minOrder` ASC [ RunTime:0.009069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12056932 LIMIT 5 [ RunTime:0.030080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12056932 ORDER BY `minOrder` ASC [ RunTime:0.026540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12056932 ORDER BY `unit` DESC [ RunTime:0.005051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12056932 LIMIT 2 [ RunTime:0.012467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12056932 ORDER BY `minOrder` ASC [ RunTime:0.065471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11369797 LIMIT 5 [ RunTime:0.021610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11369797 ORDER BY `minOrder` ASC [ RunTime:0.015474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11369797 ORDER BY `unit` DESC [ RunTime:0.006640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11369797 LIMIT 2 [ RunTime:0.001318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11369797 ORDER BY `minOrder` ASC [ RunTime:0.002884s ]
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 '8328%' OR `brand` LIKE '8328%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51136640 LIMIT 5 [ RunTime:0.012320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136640 ORDER BY `minOrder` ASC [ RunTime:0.037573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51136640 ORDER BY `unit` DESC [ RunTime:0.011112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51136640 LIMIT 2 [ RunTime:0.032406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136640 ORDER BY `minOrder` ASC [ RunTime:0.010006s ]
select * from pdf where partno='83284 009100' and brandshort='belden wire & cable' limit 1 [ RunTime:0.014781s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83284 009100' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.015695s ]
SELECT `id` FROM `stock` WHERE `id` <> 51136640 AND `partno` = '83284 009100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.027928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51136427 LIMIT 5 [ RunTime:0.007667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136427 ORDER BY `minOrder` ASC [ RunTime:0.019314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51136427 ORDER BY `unit` DESC [ RunTime:0.011561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51136427 LIMIT 2 [ RunTime:0.002324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136427 ORDER BY `minOrder` ASC [ RunTime:0.009921s ]
select * from pdf where partno='83284 009500' and brandshort='belden wire & cable' limit 1 [ RunTime:0.017634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83284 009500' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.010634s ]
SELECT `id` FROM `stock` WHERE `id` <> 51136427 AND `partno` = '83284 009500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.017839s ]
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 '8328%' OR `brand` LIKE '8328%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63064304 LIMIT 5 [ RunTime:0.024519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63064304 ORDER BY `minOrder` ASC [ RunTime:0.066004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63064304 ORDER BY `unit` DESC [ RunTime:0.033488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63064304 LIMIT 2 [ RunTime:0.045606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63064304 ORDER BY `minOrder` ASC [ RunTime:0.026317s ]
select * from pdf where partno='83284 0091000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.010494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83284 0091000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.025556s ]
SELECT `id` FROM `stock` WHERE `id` <> 63064304 AND `partno` = '83284 0091000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.041146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14391746 [ RunTime:0.024373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58464581 LIMIT 5 [ RunTime:0.020477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464581 ORDER BY `minOrder` ASC [ RunTime:0.113379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58464581 ORDER BY `unit` DESC [ RunTime:0.062810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58464581 LIMIT 2 [ RunTime:0.052383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464581 ORDER BY `minOrder` ASC [ RunTime:0.021934s ]
select * from pdf where partno='83280' and brandshort='Cole Hersee' limit 1 [ RunTime:0.049513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83280' OR `brand` LIKE 'Cole Hersee%' ) ) LIMIT 1 [ RunTime:0.023329s ]
SELECT `id` FROM `stock` WHERE `id` <> 58464581 AND `partno` = '83280' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cole hersee%' ) [ RunTime:0.052467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12455552 [ RunTime:0.051588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58464512 LIMIT 5 [ RunTime:0.065593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464512 ORDER BY `minOrder` ASC [ RunTime:0.035975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58464512 ORDER BY `unit` DESC [ RunTime:0.024176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58464512 LIMIT 2 [ RunTime:0.017523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464512 ORDER BY `minOrder` ASC [ RunTime:0.013651s ]
select * from pdf where partno='83280-02' and brandshort='Cole Hersee' limit 1 [ RunTime:0.026979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83280-02' OR `brand` LIKE 'Cole Hersee%' ) ) LIMIT 1 [ RunTime:0.020139s ]
SELECT `id` FROM `stock` WHERE `id` <> 58464512 AND `partno` = '83280-02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cole hersee%' ) [ RunTime:0.028776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58123158 LIMIT 5 [ RunTime:0.027305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58123158 ORDER BY `minOrder` ASC [ RunTime:0.016709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58123158 ORDER BY `unit` DESC [ RunTime:0.030089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58123158 LIMIT 2 [ RunTime:0.008162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58123158 ORDER BY `minOrder` ASC [ RunTime:0.014004s ]
select * from pdf where partno='8328' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.035499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8328' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.010384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58471051 LIMIT 5 [ RunTime:0.024417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471051 ORDER BY `minOrder` ASC [ RunTime:0.019002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58471051 ORDER BY `unit` DESC [ RunTime:0.027454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58471051 LIMIT 2 [ RunTime:0.031866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58471051 ORDER BY `minOrder` ASC [ RunTime:0.007759s ]
select * from pdf where partno='83285-01' and brandshort='Cole Hersee' limit 1 [ RunTime:0.009153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83285-01' OR `brand` LIKE 'Cole Hersee%' ) ) LIMIT 1 [ RunTime:0.007576s ]
SELECT `id` FROM `stock` WHERE `id` <> 58471051 AND `partno` = '83285-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cole hersee%' ) [ RunTime:0.023043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15432055 [ RunTime:0.015834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58464511 LIMIT 5 [ RunTime:0.017457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464511 ORDER BY `minOrder` ASC [ RunTime:0.012867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58464511 ORDER BY `unit` DESC [ RunTime:0.011772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58464511 LIMIT 2 [ RunTime:0.007204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58464511 ORDER BY `minOrder` ASC [ RunTime:0.011543s ]
select * from pdf where partno='83280-03' and brandshort='Cole Hersee' limit 1 [ RunTime:0.043904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83280-03' OR `brand` LIKE 'Cole Hersee%' ) ) LIMIT 1 [ RunTime:0.067621s ]
SELECT `id` FROM `stock` WHERE `id` <> 58464511 AND `partno` = '83280-03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cole hersee%' ) [ RunTime:0.009544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63064270 LIMIT 5 [ RunTime:0.021981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63064270 ORDER BY `minOrder` ASC [ RunTime:0.026659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63064270 ORDER BY `unit` DESC [ RunTime:0.053218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63064270 LIMIT 2 [ RunTime:0.008381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63064270 ORDER BY `minOrder` ASC [ RunTime:0.011573s ]
select * from pdf where partno='83284 009100' and brandshort='Belden Inc.' limit 1 [ RunTime:0.002419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83284 009100' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.025818s ]
SELECT `id` FROM `stock` WHERE `id` <> 63064270 AND `partno` = '83284 009100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.032141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13519949 [ RunTime:0.036617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63083926 LIMIT 5 [ RunTime:0.011608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083926 ORDER BY `minOrder` ASC [ RunTime:0.027748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63083926 ORDER BY `unit` DESC [ RunTime:0.033324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63083926 LIMIT 2 [ RunTime:0.012177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63083926 ORDER BY `minOrder` ASC [ RunTime:0.009472s ]
select * from pdf where partno='8328' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.005436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8328' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.010097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63415008 LIMIT 5 [ RunTime:0.038658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63415008 ORDER BY `minOrder` ASC [ RunTime:0.026349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63415008 ORDER BY `unit` DESC [ RunTime:0.006846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63415008 LIMIT 2 [ RunTime:0.011369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63415008 ORDER BY `minOrder` ASC [ RunTime:0.015877s ]
select * from pdf where partno='8328-145' and brandshort='80/20, LLC' limit 1 [ RunTime:0.001504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8328-145' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.008572s ]
SELECT `id` FROM `stock` WHERE `id` <> 63415008 AND `partno` = '8328-145' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.006493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63414703 LIMIT 5 [ RunTime:0.008510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63414703 ORDER BY `minOrder` ASC [ RunTime:0.017270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63414703 ORDER BY `unit` DESC [ RunTime:0.015883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63414703 LIMIT 2 [ RunTime:0.006252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63414703 ORDER BY `minOrder` ASC [ RunTime:0.001640s ]
select * from pdf where partno='8328-144' and brandshort='80/20, LLC' limit 1 [ RunTime:0.015387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8328-144' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.013400s ]
SELECT `id` FROM `stock` WHERE `id` <> 63414703 AND `partno` = '8328-144' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.010917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63404624 LIMIT 5 [ RunTime:0.017811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63404624 ORDER BY `minOrder` ASC [ RunTime:0.015795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63404624 ORDER BY `unit` DESC [ RunTime:0.004212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63404624 LIMIT 2 [ RunTime:0.001552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63404624 ORDER BY `minOrder` ASC [ RunTime:0.003457s ]
select * from pdf where partno='8328' and brandshort='ABBATRON' limit 1 [ RunTime:0.005192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8328' OR `brand` LIKE 'ABBATRON%' ) ) LIMIT 1 [ RunTime:0.009708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63373185 LIMIT 5 [ RunTime:0.019104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63373185 ORDER BY `minOrder` ASC [ RunTime:0.019027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63373185 ORDER BY `unit` DESC [ RunTime:0.004170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63373185 LIMIT 2 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63373185 ORDER BY `minOrder` ASC [ RunTime:0.001188s ]
select * from pdf where partno='8328' and brandshort='Cole Hersee' limit 1 [ RunTime:0.005486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8328' OR `brand` LIKE 'Cole Hersee%' ) ) LIMIT 1 [ RunTime:0.010282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63227437 LIMIT 5 [ RunTime:0.030482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63227437 ORDER BY `minOrder` ASC [ RunTime:0.014706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63227437 ORDER BY `unit` DESC [ RunTime:0.000660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63227437 LIMIT 2 [ RunTime:0.017794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63227437 ORDER BY `minOrder` ASC [ RunTime:0.005177s ]
select * from pdf where partno='83282-00000100-05' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.001106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83282-00000100-05' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.003835s ]
SELECT `id` FROM `stock` WHERE `id` <> 63227437 AND `partno` = '83282-00000100-05' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.005489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13335346 [ RunTime:0.020452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63115341 LIMIT 5 [ RunTime:0.026233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63115341 ORDER BY `minOrder` ASC [ RunTime:0.027596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63115341 ORDER BY `unit` DESC [ RunTime:0.015755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63115341 LIMIT 2 [ RunTime:0.005063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63115341 ORDER BY `minOrder` ASC [ RunTime:0.001613s ]
select * from pdf where partno='83280005' and brandshort='LAPP' limit 1 [ RunTime:0.005530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83280005' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.006893s ]
SELECT `id` FROM `stock` WHERE `id` <> 63115341 AND `partno` = '83280005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.010866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63086851 LIMIT 5 [ RunTime:0.014751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086851 ORDER BY `minOrder` ASC [ RunTime:0.023046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63086851 ORDER BY `unit` DESC [ RunTime:0.008708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63086851 LIMIT 2 [ RunTime:0.012919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086851 ORDER BY `minOrder` ASC [ RunTime:0.021330s ]
select * from pdf where partno='83281064' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.010307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83281064' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.010142s ]
SELECT `id` FROM `stock` WHERE `id` <> 63086851 AND `partno` = '83281064' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.017913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63086777 LIMIT 5 [ RunTime:0.043040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086777 ORDER BY `minOrder` ASC [ RunTime:0.017091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63086777 ORDER BY `unit` DESC [ RunTime:0.036755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63086777 LIMIT 2 [ RunTime:0.033241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086777 ORDER BY `minOrder` ASC [ RunTime:0.010676s ]
select * from pdf where partno='83281068' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.013791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83281068' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.025600s ]
SELECT `id` FROM `stock` WHERE `id` <> 63086777 AND `partno` = '83281068' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.092838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63086753 LIMIT 5 [ RunTime:0.032272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086753 ORDER BY `minOrder` ASC [ RunTime:0.012635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63086753 ORDER BY `unit` DESC [ RunTime:0.025761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63086753 LIMIT 2 [ RunTime:0.020908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086753 ORDER BY `minOrder` ASC [ RunTime:0.007738s ]
select * from pdf where partno='83281062' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.004718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83281062' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.009562s ]
SELECT `id` FROM `stock` WHERE `id` <> 63086753 AND `partno` = '83281062' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.023944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63086628 LIMIT 5 [ RunTime:0.027048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086628 ORDER BY `minOrder` ASC [ RunTime:0.042187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63086628 ORDER BY `unit` DESC [ RunTime:0.016441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63086628 LIMIT 2 [ RunTime:0.023655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086628 ORDER BY `minOrder` ASC [ RunTime:0.008001s ]
select * from pdf where partno='83281066' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.012765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83281066' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.060234s ]
SELECT `id` FROM `stock` WHERE `id` <> 63086628 AND `partno` = '83281066' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.021958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63086497 LIMIT 5 [ RunTime:0.036556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086497 ORDER BY `minOrder` ASC [ RunTime:0.024202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63086497 ORDER BY `unit` DESC [ RunTime:0.003383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63086497 LIMIT 2 [ RunTime:0.015539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086497 ORDER BY `minOrder` ASC [ RunTime:0.008420s ]
select * from pdf where partno='83281060' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.016560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83281060' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.035701s ]
SELECT `id` FROM `stock` WHERE `id` <> 63086497 AND `partno` = '83281060' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.037444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63086429 LIMIT 5 [ RunTime:0.015339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086429 ORDER BY `minOrder` ASC [ RunTime:0.035520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63086429 ORDER BY `unit` DESC [ RunTime:0.042484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63086429 LIMIT 2 [ RunTime:0.060354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63086429 ORDER BY `minOrder` ASC [ RunTime:0.014524s ]
select * from pdf where partno='83281058' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.055019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '83281058' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.037143s ]
SELECT `id` FROM `stock` WHERE `id` <> 63086429 AND `partno` = '83281058' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.077682s ]
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 '8328%' OR `brand` LIKE '8328%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.101437s ]
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 '8328%' OR `brand` LIKE '8328%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.080882s ]
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 '8328%' OR `brand` LIKE '8328%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029837s ]
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 '8328%' OR `brand` LIKE '8328%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074823s ]
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 '8328%' OR `brand` LIKE '8328%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020428s ]
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 '8328%' OR `brand` LIKE '8328%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030082s ]
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 '8328%' OR `brand` LIKE '8328%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029619s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '8328%' OR `brand` LIKE '8328%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.032432s ]