SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002540s ]
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=228&page=62&srecordnum=10000' [ RunTime:0.002171s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002513s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000504s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002841s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.011009s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002040s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000777s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001869s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.001977s ]
UPDATE `stock_search` SET `count` = 1186 , `updatetime` = '2026-06-12 02:53:42' WHERE `partno` = '228' [ RunTime:0.016535s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.004314s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.006728s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000812s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002203s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.235990s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 1220,20 [ RunTime:0.106717s ]
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 ( (s.isDisplay = 1) ) AND `s`.`id` IN ('32925702','32925701','32925700','32925699','32925698','32925697','32925696','32925695','32925694','32925693','32925692','32925691','32925690','32925689','32925688','32925687','32925686','32925685','32925684','32925683') ORDER BY FIELD(s.id, 32925702,32925701,32925700,32925699,32925698,32925697,32925696,32925695,32925694,32925693,32925692,32925691,32925690,32925689,32925688,32925687,32925686,32925685,32925684,32925683) [ RunTime:0.010414s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925702 LIMIT 4 [ RunTime:0.021662s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925702 ORDER BY `minOrder` ASC [ RunTime:0.064203s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925702 ORDER BY `unit` DESC [ RunTime:0.004753s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925702 LIMIT 2 [ RunTime:0.014094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925702 ORDER BY `minOrder` ASC [ RunTime:0.017554s ]
select * from pdf where partno='228ADS1AAFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.016353s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.005096s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925702 AND `partno` = '228ADS1AAFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449823 [ RunTime:0.010652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925701 LIMIT 4 [ RunTime:0.020337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925701 ORDER BY `minOrder` ASC [ RunTime:0.021142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925701 ORDER BY `unit` DESC [ RunTime:0.009415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925701 LIMIT 2 [ RunTime:0.033753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925701 ORDER BY `minOrder` ASC [ RunTime:0.008429s ]
select * from pdf where partno='228ADS1ARBFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010477s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925701 AND `partno` = '228ADS1ARBFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449822 [ RunTime:0.010341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925700 LIMIT 4 [ RunTime:0.016685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925700 ORDER BY `minOrder` ASC [ RunTime:0.036957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925700 ORDER BY `unit` DESC [ RunTime:0.015039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925700 LIMIT 2 [ RunTime:0.008943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925700 ORDER BY `minOrder` ASC [ RunTime:0.025537s ]
select * from pdf where partno='228ADS1AAWFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010482s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925700 AND `partno` = '228ADS1AAWFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.026661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449821 [ RunTime:0.043587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925699 LIMIT 4 [ RunTime:0.020792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925699 ORDER BY `minOrder` ASC [ RunTime:0.052204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925699 ORDER BY `unit` DESC [ RunTime:0.020061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925699 LIMIT 2 [ RunTime:0.053221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925699 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
select * from pdf where partno='228ADS1ARBFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008579s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925699 AND `partno` = '228ADS1ARBFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.011937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449820 [ RunTime:0.005462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925698 LIMIT 4 [ RunTime:0.030036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925698 ORDER BY `minOrder` ASC [ RunTime:0.019309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925698 ORDER BY `unit` DESC [ RunTime:0.011718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925698 LIMIT 2 [ RunTime:0.028296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925698 ORDER BY `minOrder` ASC [ RunTime:0.004916s ]
select * from pdf where partno='228ADS1ARAFCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002686s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925698 AND `partno` = '228ADS1ARAFCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449819 [ RunTime:0.003032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925697 LIMIT 4 [ RunTime:0.008799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925697 ORDER BY `minOrder` ASC [ RunTime:0.016995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925697 ORDER BY `unit` DESC [ RunTime:0.015256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925697 LIMIT 2 [ RunTime:0.006269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925697 ORDER BY `minOrder` ASC [ RunTime:0.007381s ]
select * from pdf where partno='228ADS1ARBFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002899s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.001269s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925697 AND `partno` = '228ADS1ARBFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.031774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449818 [ RunTime:0.010661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925696 LIMIT 4 [ RunTime:0.027673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925696 ORDER BY `minOrder` ASC [ RunTime:0.026227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925696 ORDER BY `unit` DESC [ RunTime:0.009061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925696 LIMIT 2 [ RunTime:0.032310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925696 ORDER BY `minOrder` ASC [ RunTime:0.018069s ]
select * from pdf where partno='228ADS1AYGFCMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002963s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925696 AND `partno` = '228ADS1AYGFCMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.015346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449817 [ RunTime:0.018121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925695 LIMIT 4 [ RunTime:0.012909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925695 ORDER BY `minOrder` ASC [ RunTime:0.023914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925695 ORDER BY `unit` DESC [ RunTime:0.010061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925695 LIMIT 2 [ RunTime:0.028003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925695 ORDER BY `minOrder` ASC [ RunTime:0.015594s ]
select * from pdf where partno='228ADS1ARAFCBBE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.011155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCBBE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.009000s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925695 AND `partno` = '228ADS1ARAFCBBE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449816 [ RunTime:0.002125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925694 LIMIT 4 [ RunTime:0.010214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925694 ORDER BY `minOrder` ASC [ RunTime:0.002731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925694 ORDER BY `unit` DESC [ RunTime:0.002426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925694 LIMIT 2 [ RunTime:0.006574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925694 ORDER BY `minOrder` ASC [ RunTime:0.003617s ]
select * from pdf where partno='228ADS1AYGFCMSE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.001788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCMSE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013464s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925694 AND `partno` = '228ADS1AYGFCMSE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.025595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449815 [ RunTime:0.003055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925693 LIMIT 4 [ RunTime:0.008342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925693 ORDER BY `minOrder` ASC [ RunTime:0.014620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925693 ORDER BY `unit` DESC [ RunTime:0.023417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925693 LIMIT 2 [ RunTime:0.026703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925693 ORDER BY `minOrder` ASC [ RunTime:0.014096s ]
select * from pdf where partno='228ADS1ARBFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.022273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021551s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925693 AND `partno` = '228ADS1ARBFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.036317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449814 [ RunTime:0.015680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925692 LIMIT 4 [ RunTime:0.020711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925692 ORDER BY `minOrder` ASC [ RunTime:0.028490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925692 ORDER BY `unit` DESC [ RunTime:0.007154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925692 LIMIT 2 [ RunTime:0.010935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925692 ORDER BY `minOrder` ASC [ RunTime:0.015898s ]
select * from pdf where partno='228ADS1ARAFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.015029s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925692 AND `partno` = '228ADS1ARAFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.039724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449813 [ RunTime:0.003216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925691 LIMIT 4 [ RunTime:0.008165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925691 ORDER BY `minOrder` ASC [ RunTime:0.052058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925691 ORDER BY `unit` DESC [ RunTime:0.025767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925691 LIMIT 2 [ RunTime:0.027528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925691 ORDER BY `minOrder` ASC [ RunTime:0.002099s ]
select * from pdf where partno='228ADS1AYGFCMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011376s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925691 AND `partno` = '228ADS1AYGFCMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925690 LIMIT 4 [ RunTime:0.027205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925690 ORDER BY `minOrder` ASC [ RunTime:0.028953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925690 ORDER BY `unit` DESC [ RunTime:0.012928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925690 LIMIT 2 [ RunTime:0.012457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925690 ORDER BY `minOrder` ASC [ RunTime:0.005736s ]
select * from pdf where partno='228ADS1ARGFCRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARGFCRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.011210s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925690 AND `partno` = '228ADS1ARGFCRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.027382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925689 LIMIT 4 [ RunTime:0.033093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925689 ORDER BY `minOrder` ASC [ RunTime:0.030734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925689 ORDER BY `unit` DESC [ RunTime:0.007693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925689 LIMIT 2 [ RunTime:0.004525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925689 ORDER BY `minOrder` ASC [ RunTime:0.009821s ]
select * from pdf where partno='228ADS1ARAFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006585s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925689 AND `partno` = '228ADS1ARAFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925688 LIMIT 4 [ RunTime:0.013377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925688 ORDER BY `minOrder` ASC [ RunTime:0.027482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925688 ORDER BY `unit` DESC [ RunTime:0.002562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925688 LIMIT 2 [ RunTime:0.010847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925688 ORDER BY `minOrder` ASC [ RunTime:0.018894s ]
select * from pdf where partno='228ADS1AAWFCRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AAWFCRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007112s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925688 AND `partno` = '228ADS1AAWFCRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.020346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366509 [ RunTime:0.020761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925687 LIMIT 4 [ RunTime:0.019175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925687 ORDER BY `minOrder` ASC [ RunTime:0.026028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925687 ORDER BY `unit` DESC [ RunTime:0.030866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925687 LIMIT 2 [ RunTime:0.034678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925687 ORDER BY `minOrder` ASC [ RunTime:0.008311s ]
select * from pdf where partno='228ADS1AYGFCMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.037221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023205s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925687 AND `partno` = '228ADS1AYGFCMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.070388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366508 [ RunTime:0.019859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925686 LIMIT 4 [ RunTime:0.023620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925686 ORDER BY `minOrder` ASC [ RunTime:0.035753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925686 ORDER BY `unit` DESC [ RunTime:0.023218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925686 LIMIT 2 [ RunTime:0.020960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925686 ORDER BY `minOrder` ASC [ RunTime:0.048647s ]
select * from pdf where partno='228ADS1AYGFCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.004450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYGFCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010252s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925686 AND `partno` = '228ADS1AYGFCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366507 [ RunTime:0.024348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925685 LIMIT 4 [ RunTime:0.028848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925685 ORDER BY `minOrder` ASC [ RunTime:0.026270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925685 ORDER BY `unit` DESC [ RunTime:0.010103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925685 LIMIT 2 [ RunTime:0.012343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925685 ORDER BY `minOrder` ASC [ RunTime:0.002189s ]
select * from pdf where partno='228ADS1ARAFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARAFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.004236s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925685 AND `partno` = '228ADS1ARAFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366506 [ RunTime:0.007410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925684 LIMIT 4 [ RunTime:0.006646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925684 ORDER BY `minOrder` ASC [ RunTime:0.016046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925684 ORDER BY `unit` DESC [ RunTime:0.003377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925684 LIMIT 2 [ RunTime:0.003364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925684 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
select * from pdf where partno='228ADS1AYFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.005630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1AYFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002641s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925684 AND `partno` = '228ADS1AYFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.003756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366505 [ RunTime:0.001035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32925683 LIMIT 4 [ RunTime:0.011037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925683 ORDER BY `minOrder` ASC [ RunTime:0.011763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32925683 ORDER BY `unit` DESC [ RunTime:0.003742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32925683 LIMIT 2 [ RunTime:0.005789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32925683 ORDER BY `minOrder` ASC [ RunTime:0.003218s ]
select * from pdf where partno='228ADS1ARBFCBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.003537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADS1ARBFCBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002900s ]
SELECT `id` FROM `stock` WHERE `id` <> 32925683 AND `partno` = '228ADS1ARBFCBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.010079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366504 [ RunTime:0.000618s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.128996s ]