SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001548s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=49569&search=1' [ RunTime:0.003938s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001504s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008542s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001236s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.002051s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001139s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000485s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001423s ]
SELECT * FROM `stock_search` WHERE `partno` = '49569' LIMIT 1 [ RunTime:0.006712s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-20 23:57:41' WHERE `partno` = '49569' [ RunTime:0.019324s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002500s ]
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 '49569%' OR `brand` LIKE '49569%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006086s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16437180 LIMIT 5 [ RunTime:0.008394s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437180 ORDER BY `minOrder` ASC [ RunTime:0.012098s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16437180 ORDER BY `unit` DESC [ RunTime:0.009012s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16437180 LIMIT 2 [ RunTime:0.030688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16437180 ORDER BY `minOrder` ASC [ RunTime:0.065768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434899 LIMIT 5 [ RunTime:0.009692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16434899 ORDER BY `minOrder` ASC [ RunTime:0.018995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16434899 ORDER BY `unit` DESC [ RunTime:0.009772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16434899 LIMIT 2 [ RunTime:0.009070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16434899 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434873 LIMIT 5 [ RunTime:0.015501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16434873 ORDER BY `minOrder` ASC [ RunTime:0.056539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16434873 ORDER BY `unit` DESC [ RunTime:0.030447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16434873 LIMIT 2 [ RunTime:0.009685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16434873 ORDER BY `minOrder` ASC [ RunTime:0.004158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434851 LIMIT 5 [ RunTime:0.023597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16434851 ORDER BY `minOrder` ASC [ RunTime:0.018575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16434851 ORDER BY `unit` DESC [ RunTime:0.031327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16434851 LIMIT 2 [ RunTime:0.022970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16434851 ORDER BY `minOrder` ASC [ RunTime:0.015500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434831 LIMIT 5 [ RunTime:0.032347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16434831 ORDER BY `minOrder` ASC [ RunTime:0.031490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16434831 ORDER BY `unit` DESC [ RunTime:0.016920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16434831 LIMIT 2 [ RunTime:0.069807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16434831 ORDER BY `minOrder` ASC [ RunTime:0.015502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426621 LIMIT 5 [ RunTime:0.010326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426621 ORDER BY `minOrder` ASC [ RunTime:0.006581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14426621 ORDER BY `unit` DESC [ RunTime:0.011053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14426621 LIMIT 2 [ RunTime:0.011997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426621 ORDER BY `minOrder` ASC [ RunTime:0.009394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426571 LIMIT 5 [ RunTime:0.005725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426571 ORDER BY `minOrder` ASC [ RunTime:0.007719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14426571 ORDER BY `unit` DESC [ RunTime:0.005231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14426571 LIMIT 2 [ RunTime:0.024375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426571 ORDER BY `minOrder` ASC [ RunTime:0.013781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426538 LIMIT 5 [ RunTime:0.002366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426538 ORDER BY `minOrder` ASC [ RunTime:0.003842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14426538 ORDER BY `unit` DESC [ RunTime:0.018434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14426538 LIMIT 2 [ RunTime:0.000817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426538 ORDER BY `minOrder` ASC [ RunTime:0.010649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426526 LIMIT 5 [ RunTime:0.019493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426526 ORDER BY `minOrder` ASC [ RunTime:0.016711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14426526 ORDER BY `unit` DESC [ RunTime:0.009294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14426526 LIMIT 2 [ RunTime:0.011170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14426526 ORDER BY `minOrder` ASC [ RunTime:0.009674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557838 LIMIT 5 [ RunTime:0.016769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13557838 ORDER BY `minOrder` ASC [ RunTime:0.003000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13557838 ORDER BY `unit` DESC [ RunTime:0.013734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13557838 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13557838 ORDER BY `minOrder` ASC [ RunTime:0.007236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521774 LIMIT 5 [ RunTime:0.010040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521774 ORDER BY `minOrder` ASC [ RunTime:0.006330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13521774 ORDER BY `unit` DESC [ RunTime:0.009583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13521774 LIMIT 2 [ RunTime:0.011123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521774 ORDER BY `minOrder` ASC [ RunTime:0.007445s ]
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 '49569%' OR `brand` LIKE '49569%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001022s ]
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 '49569%' OR `brand` LIKE '49569%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49272324 LIMIT 5 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49272324 ORDER BY `minOrder` ASC [ RunTime:0.007809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49272324 ORDER BY `unit` DESC [ RunTime:0.017561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49272324 LIMIT 2 [ RunTime:0.011324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49272324 ORDER BY `minOrder` ASC [ RunTime:0.021094s ]
select * from pdf where partno='495699' and brandshort='Essentra Components' limit 1 [ RunTime:0.001602s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495699' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.007637s ]
SELECT `id` FROM `stock` WHERE `id` <> 49272324 AND `partno` = '495699' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.014926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16437180 [ RunTime:0.007406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36475796 LIMIT 5 [ RunTime:0.005634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36475796 ORDER BY `minOrder` ASC [ RunTime:0.004824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36475796 ORDER BY `unit` DESC [ RunTime:0.000895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36475796 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36475796 ORDER BY `minOrder` ASC [ RunTime:0.007063s ]
select * from pdf where partno='495699' and brandshort='Essentra Components' limit 1 [ RunTime:0.000510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495699' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000528s ]
SELECT `id` FROM `stock` WHERE `id` <> 36475796 AND `partno` = '495699' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.001054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16437180 [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50692294 LIMIT 5 [ RunTime:0.003209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50692294 ORDER BY `minOrder` ASC [ RunTime:0.007878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50692294 ORDER BY `unit` DESC [ RunTime:0.002595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50692294 LIMIT 2 [ RunTime:0.003580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50692294 ORDER BY `minOrder` ASC [ RunTime:0.001410s ]
select * from pdf where partno='49569' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '49569' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000424s ]
SELECT `id` FROM `stock` WHERE `id` <> 50692294 AND `partno` = '49569' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521774 [ RunTime:0.000359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49281813 LIMIT 5 [ RunTime:0.002468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281813 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49281813 ORDER BY `unit` DESC [ RunTime:0.003703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49281813 LIMIT 2 [ RunTime:0.002608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281813 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='495698' and brandshort='Essentra Components' limit 1 [ RunTime:0.000421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495698' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000382s ]
SELECT `id` FROM `stock` WHERE `id` <> 49281813 AND `partno` = '495698' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.005014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426621 [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49281791 LIMIT 5 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281791 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49281791 ORDER BY `unit` DESC [ RunTime:0.000311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49281791 LIMIT 2 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281791 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
select * from pdf where partno='495697' and brandshort='Essentra Components' limit 1 [ RunTime:0.000368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495697' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000646s ]
SELECT `id` FROM `stock` WHERE `id` <> 49281791 AND `partno` = '495697' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434899 [ RunTime:0.000297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49281749 LIMIT 5 [ RunTime:0.007454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281749 ORDER BY `minOrder` ASC [ RunTime:0.002229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49281749 ORDER BY `unit` DESC [ RunTime:0.004628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49281749 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281749 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='495694' and brandshort='Essentra Components' limit 1 [ RunTime:0.000621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495694' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000305s ]
SELECT `id` FROM `stock` WHERE `id` <> 49281749 AND `partno` = '495694' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434873 [ RunTime:0.006389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49281703 LIMIT 5 [ RunTime:0.002179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281703 ORDER BY `minOrder` ASC [ RunTime:0.001125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49281703 ORDER BY `unit` DESC [ RunTime:0.000548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49281703 LIMIT 2 [ RunTime:0.005362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281703 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
select * from pdf where partno='495696' and brandshort='Essentra Components' limit 1 [ RunTime:0.000503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495696' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.003214s ]
SELECT `id` FROM `stock` WHERE `id` <> 49281703 AND `partno` = '495696' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.001821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426571 [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49281686 LIMIT 5 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281686 ORDER BY `minOrder` ASC [ RunTime:0.004624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49281686 ORDER BY `unit` DESC [ RunTime:0.006564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49281686 LIMIT 2 [ RunTime:0.003874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281686 ORDER BY `minOrder` ASC [ RunTime:0.001449s ]
select * from pdf where partno='495692' and brandshort='Essentra Components' limit 1 [ RunTime:0.003957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495692' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.001746s ]
SELECT `id` FROM `stock` WHERE `id` <> 49281686 AND `partno` = '495692' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434851 [ RunTime:0.006073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49281643 LIMIT 5 [ RunTime:0.008197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281643 ORDER BY `minOrder` ASC [ RunTime:0.014809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49281643 ORDER BY `unit` DESC [ RunTime:0.004993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49281643 LIMIT 2 [ RunTime:0.005478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281643 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='495691' and brandshort='Essentra Components' limit 1 [ RunTime:0.012836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495691' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.011087s ]
SELECT `id` FROM `stock` WHERE `id` <> 49281643 AND `partno` = '495691' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.004633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426538 [ RunTime:0.000746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49281637 LIMIT 5 [ RunTime:0.008204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281637 ORDER BY `minOrder` ASC [ RunTime:0.010977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49281637 ORDER BY `unit` DESC [ RunTime:0.001316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49281637 LIMIT 2 [ RunTime:0.008129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281637 ORDER BY `minOrder` ASC [ RunTime:0.009349s ]
select * from pdf where partno='495695' and brandshort='Essentra Components' limit 1 [ RunTime:0.006135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495695' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000343s ]
SELECT `id` FROM `stock` WHERE `id` <> 49281637 AND `partno` = '495695' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.003436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434831 [ RunTime:0.000303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49281627 LIMIT 5 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281627 ORDER BY `minOrder` ASC [ RunTime:0.002529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49281627 ORDER BY `unit` DESC [ RunTime:0.001995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49281627 LIMIT 2 [ RunTime:0.006713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281627 ORDER BY `minOrder` ASC [ RunTime:0.001378s ]
select * from pdf where partno='495693' and brandshort='Essentra Components' limit 1 [ RunTime:0.001577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495693' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.003533s ]
SELECT `id` FROM `stock` WHERE `id` <> 49281627 AND `partno` = '495693' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.014230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13557838 [ RunTime:0.006304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49281568 LIMIT 5 [ RunTime:0.001586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281568 ORDER BY `minOrder` ASC [ RunTime:0.001594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49281568 ORDER BY `unit` DESC [ RunTime:0.008678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49281568 LIMIT 2 [ RunTime:0.020576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49281568 ORDER BY `minOrder` ASC [ RunTime:0.005338s ]
select * from pdf where partno='495690' and brandshort='Essentra Components' limit 1 [ RunTime:0.004580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495690' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.006990s ]
SELECT `id` FROM `stock` WHERE `id` <> 49281568 AND `partno` = '495690' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.007148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426526 [ RunTime:0.001652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38063744 LIMIT 5 [ RunTime:0.001904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38063744 ORDER BY `minOrder` ASC [ RunTime:0.001482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38063744 ORDER BY `unit` DESC [ RunTime:0.000230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38063744 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38063744 ORDER BY `minOrder` ASC [ RunTime:0.002507s ]
select * from pdf where partno='49569' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '49569' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000391s ]
SELECT `id` FROM `stock` WHERE `id` <> 38063744 AND `partno` = '49569' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521774 [ RunTime:0.001401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36484926 LIMIT 5 [ RunTime:0.002067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484926 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36484926 ORDER BY `unit` DESC [ RunTime:0.000364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36484926 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484926 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='495698' and brandshort='Essentra Components' limit 1 [ RunTime:0.001823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495698' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000332s ]
SELECT `id` FROM `stock` WHERE `id` <> 36484926 AND `partno` = '495698' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.001036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426621 [ RunTime:0.000333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36484905 LIMIT 5 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484905 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36484905 ORDER BY `unit` DESC [ RunTime:0.000310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36484905 LIMIT 2 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484905 ORDER BY `minOrder` ASC [ RunTime:0.002820s ]
select * from pdf where partno='495697' and brandshort='Essentra Components' limit 1 [ RunTime:0.002663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495697' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000315s ]
SELECT `id` FROM `stock` WHERE `id` <> 36484905 AND `partno` = '495697' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434899 [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36484864 LIMIT 5 [ RunTime:0.006074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484864 ORDER BY `minOrder` ASC [ RunTime:0.044309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36484864 ORDER BY `unit` DESC [ RunTime:0.001294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36484864 LIMIT 2 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484864 ORDER BY `minOrder` ASC [ RunTime:0.001969s ]
select * from pdf where partno='495694' and brandshort='Essentra Components' limit 1 [ RunTime:0.000611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495694' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000467s ]
SELECT `id` FROM `stock` WHERE `id` <> 36484864 AND `partno` = '495694' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434873 [ RunTime:0.009073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36484822 LIMIT 5 [ RunTime:0.011189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484822 ORDER BY `minOrder` ASC [ RunTime:0.009239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36484822 ORDER BY `unit` DESC [ RunTime:0.000921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36484822 LIMIT 2 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484822 ORDER BY `minOrder` ASC [ RunTime:0.001431s ]
select * from pdf where partno='495696' and brandshort='Essentra Components' limit 1 [ RunTime:0.008522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495696' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.002476s ]
SELECT `id` FROM `stock` WHERE `id` <> 36484822 AND `partno` = '495696' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426571 [ RunTime:0.009977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36484806 LIMIT 5 [ RunTime:0.007176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484806 ORDER BY `minOrder` ASC [ RunTime:0.016568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36484806 ORDER BY `unit` DESC [ RunTime:0.012880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36484806 LIMIT 2 [ RunTime:0.019030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484806 ORDER BY `minOrder` ASC [ RunTime:0.002575s ]
select * from pdf where partno='495692' and brandshort='Essentra Components' limit 1 [ RunTime:0.000720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495692' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000489s ]
SELECT `id` FROM `stock` WHERE `id` <> 36484806 AND `partno` = '495692' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.001037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434851 [ RunTime:0.009945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36484771 LIMIT 5 [ RunTime:0.004142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484771 ORDER BY `minOrder` ASC [ RunTime:0.023942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36484771 ORDER BY `unit` DESC [ RunTime:0.015287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36484771 LIMIT 2 [ RunTime:0.027167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484771 ORDER BY `minOrder` ASC [ RunTime:0.002928s ]
select * from pdf where partno='495691' and brandshort='Essentra Components' limit 1 [ RunTime:0.006432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495691' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000516s ]
SELECT `id` FROM `stock` WHERE `id` <> 36484771 AND `partno` = '495691' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.001099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14426538 [ RunTime:0.002654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36484765 LIMIT 5 [ RunTime:0.026184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484765 ORDER BY `minOrder` ASC [ RunTime:0.003593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36484765 ORDER BY `unit` DESC [ RunTime:0.002583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36484765 LIMIT 2 [ RunTime:0.008799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36484765 ORDER BY `minOrder` ASC [ RunTime:0.004605s ]
select * from pdf where partno='495695' and brandshort='Essentra Components' limit 1 [ RunTime:0.000700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '495695' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.000453s ]
SELECT `id` FROM `stock` WHERE `id` <> 36484765 AND `partno` = '495695' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16434831 [ RunTime:0.000463s ]
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 '49569%' OR `brand` LIKE '49569%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012839s ]
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 '49569%' OR `brand` LIKE '49569%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006583s ]
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 '49569%' OR `brand` LIKE '49569%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002827s ]
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 '49569%' OR `brand` LIKE '49569%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001259s ]
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 '49569%' OR `brand` LIKE '49569%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002922s ]
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 '49569%' OR `brand` LIKE '49569%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001002s ]
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 '49569%' OR `brand` LIKE '49569%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006141s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '49569%' OR `brand` LIKE '49569%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010490s ]