SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002488s ]
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=8213&search=1' [ RunTime:0.004723s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003700s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000537s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001548s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000246s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001462s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000260s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001366s ]
SELECT * FROM `stock_search` WHERE `partno` = '8213' LIMIT 1 [ RunTime:0.003730s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-23 13:33:31' WHERE `partno` = '8213' [ RunTime:0.004274s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002248s ]
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 '8213%' OR `brand` LIKE '8213%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049694s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512688 LIMIT 5 [ RunTime:0.007657s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512688 ORDER BY `minOrder` ASC [ RunTime:0.013939s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512688 ORDER BY `unit` DESC [ RunTime:0.011990s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512688 LIMIT 2 [ RunTime:0.011551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512688 ORDER BY `minOrder` ASC [ RunTime:0.001317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11692163 LIMIT 5 [ RunTime:0.025864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11692163 ORDER BY `minOrder` ASC [ RunTime:0.018090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11692163 ORDER BY `unit` DESC [ RunTime:0.008009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11692163 LIMIT 2 [ RunTime:0.002688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11692163 ORDER BY `minOrder` ASC [ RunTime:0.006333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17262518 LIMIT 5 [ RunTime:0.015012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17262518 ORDER BY `minOrder` ASC [ RunTime:0.005751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17262518 ORDER BY `unit` DESC [ RunTime:0.007322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17262518 LIMIT 2 [ RunTime:0.012526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17262518 ORDER BY `minOrder` ASC [ RunTime:0.012242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20090644 LIMIT 5 [ RunTime:0.003348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20090644 ORDER BY `minOrder` ASC [ RunTime:0.005986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20090644 ORDER BY `unit` DESC [ RunTime:0.009173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20090644 LIMIT 2 [ RunTime:0.008933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20090644 ORDER BY `minOrder` ASC [ RunTime:0.001689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19020996 LIMIT 5 [ RunTime:0.014216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19020996 ORDER BY `minOrder` ASC [ RunTime:0.023325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19020996 ORDER BY `unit` DESC [ RunTime:0.019582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19020996 LIMIT 2 [ RunTime:0.013633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19020996 ORDER BY `minOrder` ASC [ RunTime:0.014850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18841143 LIMIT 5 [ RunTime:0.011442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18841143 ORDER BY `minOrder` ASC [ RunTime:0.014756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18841143 ORDER BY `unit` DESC [ RunTime:0.009989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18841143 LIMIT 2 [ RunTime:0.004738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18841143 ORDER BY `minOrder` ASC [ RunTime:0.009032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16413755 LIMIT 5 [ RunTime:0.013718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16413755 ORDER BY `minOrder` ASC [ RunTime:0.009078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16413755 ORDER BY `unit` DESC [ RunTime:0.003661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16413755 LIMIT 2 [ RunTime:0.003039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16413755 ORDER BY `minOrder` ASC [ RunTime:0.003571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15237204 LIMIT 5 [ RunTime:0.003408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15237204 ORDER BY `minOrder` ASC [ RunTime:0.004494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15237204 ORDER BY `unit` DESC [ RunTime:0.002598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15237204 LIMIT 2 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15237204 ORDER BY `minOrder` ASC [ RunTime:0.003299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14392221 LIMIT 5 [ RunTime:0.004936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14392221 ORDER BY `minOrder` ASC [ RunTime:0.006950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14392221 ORDER BY `unit` DESC [ RunTime:0.004449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14392221 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14392221 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13520273 LIMIT 5 [ RunTime:0.000966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13520273 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13520273 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13520273 LIMIT 2 [ RunTime:0.002378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13520273 ORDER BY `minOrder` ASC [ RunTime:0.000814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12177198 LIMIT 5 [ RunTime:0.001422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177198 ORDER BY `minOrder` ASC [ RunTime:0.000739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12177198 ORDER BY `unit` DESC [ RunTime:0.000462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12177198 LIMIT 2 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177198 ORDER BY `minOrder` ASC [ RunTime:0.000267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12177130 LIMIT 5 [ RunTime:0.009328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177130 ORDER BY `minOrder` ASC [ RunTime:0.008074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12177130 ORDER BY `unit` DESC [ RunTime:0.000714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12177130 LIMIT 2 [ RunTime:0.002356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177130 ORDER BY `minOrder` ASC [ RunTime:0.009355s ]
select * from pdf where partno='82131' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.001646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12177129 LIMIT 5 [ RunTime:0.011836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177129 ORDER BY `minOrder` ASC [ RunTime:0.009639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12177129 ORDER BY `unit` DESC [ RunTime:0.000883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12177129 LIMIT 2 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177129 ORDER BY `minOrder` ASC [ RunTime:0.002416s ]
select * from pdf where partno='82130' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.001320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11433561 LIMIT 5 [ RunTime:0.001239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11433561 ORDER BY `minOrder` ASC [ RunTime:0.001429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11433561 ORDER BY `unit` DESC [ RunTime:0.006212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11433561 LIMIT 2 [ RunTime:0.011014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11433561 ORDER BY `minOrder` ASC [ RunTime:0.004194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11251841 LIMIT 5 [ RunTime:0.009821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11251841 ORDER BY `minOrder` ASC [ RunTime:0.020554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11251841 ORDER BY `unit` DESC [ RunTime:0.003577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11251841 LIMIT 2 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11251841 ORDER BY `minOrder` ASC [ RunTime:0.002176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190723 LIMIT 5 [ RunTime:0.002105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190723 ORDER BY `minOrder` ASC [ RunTime:0.002960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11190723 ORDER BY `unit` DESC [ RunTime:0.001471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11190723 LIMIT 2 [ RunTime:0.006744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190723 ORDER BY `minOrder` ASC [ RunTime:0.002702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190722 LIMIT 5 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190722 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11190722 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11190722 LIMIT 2 [ RunTime:0.002536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190722 ORDER BY `minOrder` ASC [ RunTime:0.001453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190671 LIMIT 5 [ RunTime:0.003463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190671 ORDER BY `minOrder` ASC [ RunTime:0.003811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11190671 ORDER BY `unit` DESC [ RunTime:0.001630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11190671 LIMIT 2 [ RunTime:0.003705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190671 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190670 LIMIT 5 [ RunTime:0.000816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190670 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11190670 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11190670 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190670 ORDER BY `minOrder` ASC [ RunTime:0.000794s ]
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 '8213%' OR `brand` LIKE '8213%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095251 LIMIT 5 [ RunTime:0.001503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095251 ORDER BY `minOrder` ASC [ RunTime:0.001529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095251 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095251 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095251 ORDER BY `minOrder` ASC [ RunTime:0.001478s ]
select * from pdf where partno='8213' and brandshort='scs' limit 1 [ RunTime:0.001329s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001811s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8213' OR `brand` LIKE 'scs%' ) ) LIMIT 1 [ RunTime:0.003044s ]
SELECT `id` FROM `stock` WHERE `id` <> 51095251 AND `partno` = '8213' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.014143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17262518 [ RunTime:0.001788s ]
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 '8213%' OR `brand` LIKE '8213%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63491670 LIMIT 5 [ RunTime:0.006343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63491670 ORDER BY `minOrder` ASC [ RunTime:0.002816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63491670 ORDER BY `unit` DESC [ RunTime:0.014162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63491670 LIMIT 2 [ RunTime:0.015946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63491670 ORDER BY `minOrder` ASC [ RunTime:0.007477s ]
select * from pdf where partno='8213' and brandshort='SCS' limit 1 [ RunTime:0.001388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8213' OR `brand` LIKE 'SCS%' ) ) LIMIT 1 [ RunTime:0.010730s ]
SELECT `id` FROM `stock` WHERE `id` <> 63491670 AND `partno` = '8213' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.008132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17262518 [ RunTime:0.020017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60616641 LIMIT 5 [ RunTime:0.038130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60616641 ORDER BY `minOrder` ASC [ RunTime:0.013040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60616641 ORDER BY `unit` DESC [ RunTime:0.007276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60616641 LIMIT 2 [ RunTime:0.003493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60616641 ORDER BY `minOrder` ASC [ RunTime:0.007568s ]
select * from pdf where partno='821313-000' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.002170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '821313-000' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.004739s ]
SELECT `id` FROM `stock` WHERE `id` <> 60616641 AND `partno` = '821313-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.014065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11692163 [ RunTime:0.002552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64287545 LIMIT 5 [ RunTime:0.010729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64287545 ORDER BY `minOrder` ASC [ RunTime:0.010864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64287545 ORDER BY `unit` DESC [ RunTime:0.005355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64287545 LIMIT 2 [ RunTime:0.004052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64287545 ORDER BY `minOrder` ASC [ RunTime:0.000480s ]
select * from pdf where partno='8213' and brandshort='3M' limit 1 [ RunTime:0.001266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8213' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.003905s ]
SELECT `id` FROM `stock` WHERE `id` <> 64287545 AND `partno` = '8213' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11251841 [ RunTime:0.000630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63414384 LIMIT 5 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63414384 ORDER BY `minOrder` ASC [ RunTime:0.002190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63414384 ORDER BY `unit` DESC [ RunTime:0.002578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63414384 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63414384 ORDER BY `minOrder` ASC [ RunTime:0.005096s ]
select * from pdf where partno='8213-145' and brandshort='80/20, LLC' limit 1 [ RunTime:0.001597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8213-145' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000613s ]
SELECT `id` FROM `stock` WHERE `id` <> 63414384 AND `partno` = '8213-145' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.000570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066163 LIMIT 5 [ RunTime:0.001732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066163 ORDER BY `minOrder` ASC [ RunTime:0.001134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066163 ORDER BY `unit` DESC [ RunTime:0.004618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066163 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066163 ORDER BY `minOrder` ASC [ RunTime:0.001207s ]
select * from pdf where partno='8213 0101000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.000627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8213 0101000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.000701s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066163 AND `partno` = '8213 0101000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.001893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16413755 [ RunTime:0.000531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066043 LIMIT 5 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066043 ORDER BY `minOrder` ASC [ RunTime:0.005004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066043 ORDER BY `unit` DESC [ RunTime:0.004691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066043 LIMIT 2 [ RunTime:0.001569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066043 ORDER BY `minOrder` ASC [ RunTime:0.003596s ]
select * from pdf where partno='8213 010500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.004679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8213 010500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.003710s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066043 AND `partno` = '8213 010500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.010428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14392221 [ RunTime:0.002665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63066007 LIMIT 5 [ RunTime:0.010138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066007 ORDER BY `minOrder` ASC [ RunTime:0.003910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63066007 ORDER BY `unit` DESC [ RunTime:0.000833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63066007 LIMIT 2 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63066007 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
select * from pdf where partno='8213 0102000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8213 0102000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.003443s ]
SELECT `id` FROM `stock` WHERE `id` <> 63066007 AND `partno` = '8213 0102000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.001167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13520273 [ RunTime:0.000841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61002523 LIMIT 5 [ RunTime:0.001685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61002523 ORDER BY `minOrder` ASC [ RunTime:0.001879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61002523 ORDER BY `unit` DESC [ RunTime:0.001813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61002523 LIMIT 2 [ RunTime:0.001289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61002523 ORDER BY `minOrder` ASC [ RunTime:0.001438s ]
select * from pdf where partno='8213470000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8213470000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001242s ]
SELECT `id` FROM `stock` WHERE `id` <> 61002523 AND `partno` = '8213470000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11433561 [ RunTime:0.004577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58570167 LIMIT 5 [ RunTime:0.005789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58570167 ORDER BY `minOrder` ASC [ RunTime:0.003305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58570167 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58570167 LIMIT 2 [ RunTime:0.001361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58570167 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='82139' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.001046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '82139' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.005904s ]
SELECT `id` FROM `stock` WHERE `id` <> 58570167 AND `partno` = '82139' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.005655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190723 [ RunTime:0.006247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58570166 LIMIT 5 [ RunTime:0.000807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58570166 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58570166 ORDER BY `unit` DESC [ RunTime:0.006108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58570166 LIMIT 2 [ RunTime:0.007397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58570166 ORDER BY `minOrder` ASC [ RunTime:0.012007s ]
select * from pdf where partno='82137' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.014229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '82137' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.005849s ]
SELECT `id` FROM `stock` WHERE `id` <> 58570166 AND `partno` = '82137' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.000744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12177198 [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58570165 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58570165 ORDER BY `minOrder` ASC [ RunTime:0.002151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58570165 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58570165 LIMIT 2 [ RunTime:0.000945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58570165 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
select * from pdf where partno='82136' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.000982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '82136' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.000549s ]
SELECT `id` FROM `stock` WHERE `id` <> 58570165 AND `partno` = '82136' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.001827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190722 [ RunTime:0.003606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58570067 LIMIT 5 [ RunTime:0.001164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58570067 ORDER BY `minOrder` ASC [ RunTime:0.001839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58570067 ORDER BY `unit` DESC [ RunTime:0.000374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58570067 LIMIT 2 [ RunTime:0.003694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58570067 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='82134' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.002816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '82134' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.001686s ]
SELECT `id` FROM `stock` WHERE `id` <> 58570067 AND `partno` = '82134' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.001737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190671 [ RunTime:0.002960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58570066 LIMIT 5 [ RunTime:0.002592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58570066 ORDER BY `minOrder` ASC [ RunTime:0.001979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58570066 ORDER BY `unit` DESC [ RunTime:0.003100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58570066 LIMIT 2 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58570066 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='82130' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.000532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '82130' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.000466s ]
SELECT `id` FROM `stock` WHERE `id` <> 58570066 AND `partno` = '82130' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12177129 [ RunTime:0.001602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32658649 LIMIT 5 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32658649 ORDER BY `minOrder` ASC [ RunTime:0.001681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32658649 ORDER BY `unit` DESC [ RunTime:0.003509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32658649 LIMIT 2 [ RunTime:0.001422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32658649 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='821344' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.003151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '821344' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.000759s ]
SELECT `id` FROM `stock` WHERE `id` <> 32658649 AND `partno` = '821344' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.007376s ]
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 '8213%' OR `brand` LIKE '8213%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012663s ]
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 '8213%' OR `brand` LIKE '8213%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003296s ]
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 '8213%' OR `brand` LIKE '8213%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001506s ]
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 '8213%' OR `brand` LIKE '8213%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005062s ]
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 '8213%' OR `brand` LIKE '8213%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001076s ]
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 '8213%' OR `brand` LIKE '8213%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004047s ]
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 '8213%' OR `brand` LIKE '8213%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001123s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '8213%' OR `brand` LIKE '8213%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000816s ]