SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001101s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=12151&search=1' [ RunTime:0.007366s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001366s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005054s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001325s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.005105s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001056s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009739s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000911s ]
SELECT * FROM `stock_search` WHERE `partno` = '12151' LIMIT 1 [ RunTime:0.015624s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-05 12:27:14' WHERE `partno` = '12151' [ RunTime:0.019248s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001393s ]
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 '12151%' OR `brand` LIKE '12151%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034235s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544547 LIMIT 5 [ RunTime:0.029592s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13544547 ORDER BY `minOrder` ASC [ RunTime:0.062311s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.024907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13544547 ORDER BY `unit` DESC [ RunTime:0.012948s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13544547 LIMIT 2 [ RunTime:0.017776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13544547 ORDER BY `minOrder` ASC [ RunTime:0.021653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346822 LIMIT 5 [ RunTime:0.024402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346822 ORDER BY `minOrder` ASC [ RunTime:0.007156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346822 ORDER BY `unit` DESC [ RunTime:0.037352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346822 LIMIT 2 [ RunTime:0.032558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346822 ORDER BY `minOrder` ASC [ RunTime:0.008740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414687 LIMIT 5 [ RunTime:0.021541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414687 ORDER BY `minOrder` ASC [ RunTime:0.027999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14414687 ORDER BY `unit` DESC [ RunTime:0.028785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14414687 LIMIT 2 [ RunTime:0.053593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14414687 ORDER BY `minOrder` ASC [ RunTime:0.014409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18834909 LIMIT 5 [ RunTime:0.020761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18834909 ORDER BY `minOrder` ASC [ RunTime:0.018684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18834909 ORDER BY `unit` DESC [ RunTime:0.012005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18834909 LIMIT 2 [ RunTime:0.018526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18834909 ORDER BY `minOrder` ASC [ RunTime:0.030326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013816 LIMIT 5 [ RunTime:0.054245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013816 ORDER BY `minOrder` ASC [ RunTime:0.025934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16013816 ORDER BY `unit` DESC [ RunTime:0.013559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16013816 LIMIT 2 [ RunTime:0.035288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16013816 ORDER BY `minOrder` ASC [ RunTime:0.008527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345118 LIMIT 5 [ RunTime:0.007348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345118 ORDER BY `minOrder` ASC [ RunTime:0.010417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14345118 ORDER BY `unit` DESC [ RunTime:0.022318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14345118 LIMIT 2 [ RunTime:0.030842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345118 ORDER BY `minOrder` ASC [ RunTime:0.015271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345117 LIMIT 5 [ RunTime:0.009053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345117 ORDER BY `minOrder` ASC [ RunTime:0.056841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14345117 ORDER BY `unit` DESC [ RunTime:0.009599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14345117 LIMIT 2 [ RunTime:0.048165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345117 ORDER BY `minOrder` ASC [ RunTime:0.016144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458161 LIMIT 5 [ RunTime:0.026214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458161 ORDER BY `minOrder` ASC [ RunTime:0.017785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13458161 ORDER BY `unit` DESC [ RunTime:0.007808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13458161 LIMIT 2 [ RunTime:0.009037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458161 ORDER BY `minOrder` ASC [ RunTime:0.016905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458160 LIMIT 5 [ RunTime:0.007916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458160 ORDER BY `minOrder` ASC [ RunTime:0.032091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13458160 ORDER BY `unit` DESC [ RunTime:0.080827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13458160 LIMIT 2 [ RunTime:0.012478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458160 ORDER BY `minOrder` ASC [ RunTime:0.003542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458031 LIMIT 5 [ RunTime:0.020563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458031 ORDER BY `minOrder` ASC [ RunTime:0.032168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13458031 ORDER BY `unit` DESC [ RunTime:0.052772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13458031 LIMIT 2 [ RunTime:0.089000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458031 ORDER BY `minOrder` ASC [ RunTime:0.003408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457700 LIMIT 5 [ RunTime:0.032467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457700 ORDER BY `minOrder` ASC [ RunTime:0.073897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457700 ORDER BY `unit` DESC [ RunTime:0.049417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457700 LIMIT 2 [ RunTime:0.045585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457700 ORDER BY `minOrder` ASC [ RunTime:0.010046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198114 LIMIT 5 [ RunTime:0.013752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198114 ORDER BY `minOrder` ASC [ RunTime:0.041427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12198114 ORDER BY `unit` DESC [ RunTime:0.087998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12198114 LIMIT 2 [ RunTime:0.024283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198114 ORDER BY `minOrder` ASC [ RunTime:0.019663s ]
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 '12151%' OR `brand` LIKE '12151%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025371s ]
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 '12151%' OR `brand` LIKE '12151%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409365 LIMIT 5 [ RunTime:0.021784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409365 ORDER BY `minOrder` ASC [ RunTime:0.037011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409365 ORDER BY `unit` DESC [ RunTime:0.014861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409365 LIMIT 2 [ RunTime:0.025163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409365 ORDER BY `minOrder` ASC [ RunTime:0.001365s ]
select * from pdf where partno='121510600' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.012258s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002458s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121510600' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.016226s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409365 AND `partno` = '121510600' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.015414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409492 LIMIT 5 [ RunTime:0.041261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409492 ORDER BY `minOrder` ASC [ RunTime:0.013593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409492 ORDER BY `unit` DESC [ RunTime:0.018810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409492 LIMIT 2 [ RunTime:0.012186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409492 ORDER BY `minOrder` ASC [ RunTime:0.009863s ]
select * from pdf where partno='1215116' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.019947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1215116' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.017677s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409492 AND `partno` = '1215116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.031626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409656 LIMIT 5 [ RunTime:0.015882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409656 ORDER BY `minOrder` ASC [ RunTime:0.031458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409656 ORDER BY `unit` DESC [ RunTime:0.098559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409656 LIMIT 2 [ RunTime:0.051955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409656 ORDER BY `minOrder` ASC [ RunTime:0.015514s ]
select * from pdf where partno='1215110' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.020821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1215110' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.040927s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409656 AND `partno` = '1215110' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.038731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409591 LIMIT 5 [ RunTime:0.018033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409591 ORDER BY `minOrder` ASC [ RunTime:0.094269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409591 ORDER BY `unit` DESC [ RunTime:0.033311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409591 LIMIT 2 [ RunTime:0.081099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409591 ORDER BY `minOrder` ASC [ RunTime:0.007991s ]
select * from pdf where partno='1215125' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.037942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1215125' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.020604s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409591 AND `partno` = '1215125' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.023490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409812 LIMIT 5 [ RunTime:0.019686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409812 ORDER BY `minOrder` ASC [ RunTime:0.025986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409812 ORDER BY `unit` DESC [ RunTime:0.050044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409812 LIMIT 2 [ RunTime:0.079420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409812 ORDER BY `minOrder` ASC [ RunTime:0.006889s ]
select * from pdf where partno='121510400' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.044048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121510400' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.055977s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409812 AND `partno` = '121510400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.034294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64562905 LIMIT 5 [ RunTime:0.001012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562905 ORDER BY `minOrder` ASC [ RunTime:0.010207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64562905 ORDER BY `unit` DESC [ RunTime:0.041406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64562905 LIMIT 2 [ RunTime:0.024732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64562905 ORDER BY `minOrder` ASC [ RunTime:0.014647s ]
select * from pdf where partno='12151CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.021473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12151CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.027193s ]
SELECT `id` FROM `stock` WHERE `id` <> 64562905 AND `partno` = '12151CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.025386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346822 [ RunTime:0.036507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63137690 LIMIT 5 [ RunTime:0.023998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63137690 ORDER BY `minOrder` ASC [ RunTime:0.049410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63137690 ORDER BY `unit` DESC [ RunTime:0.031860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63137690 LIMIT 2 [ RunTime:0.022049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63137690 ORDER BY `minOrder` ASC [ RunTime:0.015510s ]
select * from pdf where partno='12151800' and brandshort='Bopla Enclosures' limit 1 [ RunTime:0.038091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12151800' OR `brand` LIKE 'Bopla Enclosures%' ) ) LIMIT 1 [ RunTime:0.030723s ]
SELECT `id` FROM `stock` WHERE `id` <> 63137690 AND `partno` = '12151800' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bopla enclosures%' ) [ RunTime:0.016102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544547 [ RunTime:0.007077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60410164 LIMIT 5 [ RunTime:0.013443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60410164 ORDER BY `minOrder` ASC [ RunTime:0.025250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60410164 ORDER BY `unit` DESC [ RunTime:0.079379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60410164 LIMIT 2 [ RunTime:0.035564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60410164 ORDER BY `minOrder` ASC [ RunTime:0.019445s ]
select * from pdf where partno='121510150' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.021344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121510150' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.017540s ]
SELECT `id` FROM `stock` WHERE `id` <> 60410164 AND `partno` = '121510150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.072641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63139109 LIMIT 5 [ RunTime:0.018479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63139109 ORDER BY `minOrder` ASC [ RunTime:0.051702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63139109 ORDER BY `unit` DESC [ RunTime:0.016110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63139109 LIMIT 2 [ RunTime:0.046332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63139109 ORDER BY `minOrder` ASC [ RunTime:0.011616s ]
select * from pdf where partno='12151900' and brandshort='Bopla Enclosures' limit 1 [ RunTime:0.006046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12151900' OR `brand` LIKE 'Bopla Enclosures%' ) ) LIMIT 1 [ RunTime:0.008174s ]
SELECT `id` FROM `stock` WHERE `id` <> 63139109 AND `partno` = '12151900' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bopla enclosures%' ) [ RunTime:0.021359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14414687 [ RunTime:0.049616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521788 LIMIT 5 [ RunTime:0.018236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521788 ORDER BY `minOrder` ASC [ RunTime:0.046566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521788 ORDER BY `unit` DESC [ RunTime:0.037155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521788 LIMIT 2 [ RunTime:0.068288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521788 ORDER BY `minOrder` ASC [ RunTime:0.007474s ]
select * from pdf where partno='121518' and brandshort='Brady Corporation' limit 1 [ RunTime:0.054966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121518' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.028362s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521788 AND `partno` = '121518' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.051202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345118 [ RunTime:0.114765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521787 LIMIT 5 [ RunTime:0.059137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521787 ORDER BY `minOrder` ASC [ RunTime:0.018210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521787 ORDER BY `unit` DESC [ RunTime:0.044846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521787 LIMIT 2 [ RunTime:0.040069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521787 ORDER BY `minOrder` ASC [ RunTime:0.047872s ]
select * from pdf where partno='121515' and brandshort='Brady Corporation' limit 1 [ RunTime:0.015591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121515' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.016041s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521787 AND `partno` = '121515' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.044139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345117 [ RunTime:0.020456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521271 LIMIT 5 [ RunTime:0.026554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521271 ORDER BY `minOrder` ASC [ RunTime:0.057856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521271 ORDER BY `unit` DESC [ RunTime:0.015213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521271 LIMIT 2 [ RunTime:0.053499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521271 ORDER BY `minOrder` ASC [ RunTime:0.034362s ]
select * from pdf where partno='121519' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121519' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010448s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521271 AND `partno` = '121519' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.012063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458161 [ RunTime:0.008063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521270 LIMIT 5 [ RunTime:0.021712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521270 ORDER BY `minOrder` ASC [ RunTime:0.039642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521270 ORDER BY `unit` DESC [ RunTime:0.025949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521270 LIMIT 2 [ RunTime:0.012183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521270 ORDER BY `minOrder` ASC [ RunTime:0.018066s ]
select * from pdf where partno='121516' and brandshort='Brady Corporation' limit 1 [ RunTime:0.014008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121516' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.023674s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521270 AND `partno` = '121516' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.018753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458160 [ RunTime:0.022958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520987 LIMIT 5 [ RunTime:0.033111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520987 ORDER BY `minOrder` ASC [ RunTime:0.058968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520987 ORDER BY `unit` DESC [ RunTime:0.019257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520987 LIMIT 2 [ RunTime:0.020054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520987 ORDER BY `minOrder` ASC [ RunTime:0.020099s ]
select * from pdf where partno='121514' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121514' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.017287s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520987 AND `partno` = '121514' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.033954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458031 [ RunTime:0.013310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520521 LIMIT 5 [ RunTime:0.093987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520521 ORDER BY `minOrder` ASC [ RunTime:0.033683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520521 ORDER BY `unit` DESC [ RunTime:0.040289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520521 LIMIT 2 [ RunTime:0.040375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520521 ORDER BY `minOrder` ASC [ RunTime:0.007156s ]
select * from pdf where partno='121517' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121517' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008328s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520521 AND `partno` = '121517' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.029234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457700 [ RunTime:0.025670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64462357 LIMIT 5 [ RunTime:0.055527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462357 ORDER BY `minOrder` ASC [ RunTime:0.041732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64462357 ORDER BY `unit` DESC [ RunTime:0.035702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64462357 LIMIT 2 [ RunTime:0.075518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462357 ORDER BY `minOrder` ASC [ RunTime:0.024783s ]
select * from pdf where partno='1215105' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.041522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1215105' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008422s ]
SELECT `id` FROM `stock` WHERE `id` <> 64462357 AND `partno` = '1215105' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198114 [ RunTime:0.050369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64459781 LIMIT 5 [ RunTime:0.017029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64459781 ORDER BY `minOrder` ASC [ RunTime:0.021791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64459781 ORDER BY `unit` DESC [ RunTime:0.025723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64459781 LIMIT 2 [ RunTime:0.016674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64459781 ORDER BY `minOrder` ASC [ RunTime:0.007679s ]
select * from pdf where partno='1215139' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1215139' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015190s ]
SELECT `id` FROM `stock` WHERE `id` <> 64459781 AND `partno` = '1215139' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.034946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64459281 LIMIT 5 [ RunTime:0.038344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64459281 ORDER BY `minOrder` ASC [ RunTime:0.048612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64459281 ORDER BY `unit` DESC [ RunTime:0.023643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64459281 LIMIT 2 [ RunTime:0.017129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64459281 ORDER BY `minOrder` ASC [ RunTime:0.035457s ]
select * from pdf where partno='1215172' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.027299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1215172' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016899s ]
SELECT `id` FROM `stock` WHERE `id` <> 64459281 AND `partno` = '1215172' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013816 [ RunTime:0.020664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453890 LIMIT 5 [ RunTime:0.037773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453890 ORDER BY `minOrder` ASC [ RunTime:0.016771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453890 ORDER BY `unit` DESC [ RunTime:0.029958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453890 LIMIT 2 [ RunTime:0.019333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453890 ORDER BY `minOrder` ASC [ RunTime:0.012450s ]
select * from pdf where partno='1215171' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1215171' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015616s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453890 AND `partno` = '1215171' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.023944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18834909 [ RunTime:0.044681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63148211 LIMIT 5 [ RunTime:0.032959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63148211 ORDER BY `minOrder` ASC [ RunTime:0.043370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63148211 ORDER BY `unit` DESC [ RunTime:0.024218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63148211 LIMIT 2 [ RunTime:0.014418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63148211 ORDER BY `minOrder` ASC [ RunTime:0.008329s ]
select * from pdf where partno='121513' and brandshort='Jacob GmbH' limit 1 [ RunTime:0.028220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121513' OR `brand` LIKE 'Jacob GmbH%' ) ) LIMIT 1 [ RunTime:0.008376s ]
SELECT `id` FROM `stock` WHERE `id` <> 63148211 AND `partno` = '121513' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jacob gmbh%' ) [ RunTime:0.036963s ]
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 '12151%' OR `brand` LIKE '12151%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022985s ]
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 '12151%' OR `brand` LIKE '12151%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032048s ]
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 '12151%' OR `brand` LIKE '12151%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020575s ]
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 '12151%' OR `brand` LIKE '12151%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020556s ]
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 '12151%' OR `brand` LIKE '12151%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017976s ]
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 '12151%' OR `brand` LIKE '12151%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020768s ]
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 '12151%' OR `brand` LIKE '12151%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027589s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12151%' OR `brand` LIKE '12151%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001428s ]