SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002274s ]
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=92&srecordnum=10000' [ RunTime:0.004266s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002435s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000581s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003281s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.001391s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.004039s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.005948s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.000725s ]
UPDATE `stock_search` SET `count` = 1983 , `updatetime` = '2026-06-12 13:50:43' WHERE `partno` = '228' [ RunTime:0.007617s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002979s ]
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.004431s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002518s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.229913s ]
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 1820,20 [ RunTime:0.091328s ]
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 ('32924895','32924894','32924893','32924892','32924891','32924890','32924889','32924888','32924887','32924886','32924885','32924884','32924883','32924882','32924881','32924880','32924879','32924878','32924877','32924876') ORDER BY FIELD(s.id, 32924895,32924894,32924893,32924892,32924891,32924890,32924889,32924888,32924887,32924886,32924885,32924884,32924883,32924882,32924881,32924880,32924879,32924878,32924877,32924876) [ RunTime:0.002115s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924895 LIMIT 4 [ RunTime:0.014443s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924895 ORDER BY `minOrder` ASC [ RunTime:0.003188s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924895 ORDER BY `unit` DESC [ RunTime:0.015868s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924895 LIMIT 2 [ RunTime:0.003395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924895 ORDER BY `minOrder` ASC [ RunTime:0.002030s ]
select * from pdf where partno='228CDVAWFAAB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009536s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFAAB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013872s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924895 AND `partno` = '228CDVAWFAAB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924894 LIMIT 4 [ RunTime:0.009345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924894 ORDER BY `minOrder` ASC [ RunTime:0.008947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924894 ORDER BY `unit` DESC [ RunTime:0.024135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924894 LIMIT 2 [ RunTime:0.042970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924894 ORDER BY `minOrder` ASC [ RunTime:0.021783s ]
select * from pdf where partno='228CDVAGFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.021655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027309s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924894 AND `partno` = '228CDVAGFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.009218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449523 [ RunTime:0.032857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924893 LIMIT 4 [ RunTime:0.028098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924893 ORDER BY `minOrder` ASC [ RunTime:0.041514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924893 ORDER BY `unit` DESC [ RunTime:0.045402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924893 LIMIT 2 [ RunTime:0.065010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924893 ORDER BY `minOrder` ASC [ RunTime:0.050957s ]
select * from pdf where partno='228CDVAGFCWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.057700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.065035s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924893 AND `partno` = '228CDVAGFCWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.033584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924892 LIMIT 4 [ RunTime:0.057314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924892 ORDER BY `minOrder` ASC [ RunTime:0.012671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924892 ORDER BY `unit` DESC [ RunTime:0.022148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924892 LIMIT 2 [ RunTime:0.014983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924892 ORDER BY `minOrder` ASC [ RunTime:0.015722s ]
select * from pdf where partno='228CDVAWFCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.033600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.086515s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924892 AND `partno` = '228CDVAWFCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.031248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924891 LIMIT 4 [ RunTime:0.040971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924891 ORDER BY `minOrder` ASC [ RunTime:0.017450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924891 ORDER BY `unit` DESC [ RunTime:0.018269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924891 LIMIT 2 [ RunTime:0.022511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924891 ORDER BY `minOrder` ASC [ RunTime:0.014719s ]
select * from pdf where partno='228CDVAYFDRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFDRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017249s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924891 AND `partno` = '228CDVAYFDRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.045687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924890 LIMIT 4 [ RunTime:0.013697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924890 ORDER BY `minOrder` ASC [ RunTime:0.032336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924890 ORDER BY `unit` DESC [ RunTime:0.025643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924890 LIMIT 2 [ RunTime:0.024870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924890 ORDER BY `minOrder` ASC [ RunTime:0.012037s ]
select * from pdf where partno='228CDVARGBFDWA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFDWA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006925s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924890 AND `partno` = '228CDVARGBFDWA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.027751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449522 [ RunTime:0.032799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924889 LIMIT 4 [ RunTime:0.022157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924889 ORDER BY `minOrder` ASC [ RunTime:0.014813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924889 ORDER BY `unit` DESC [ RunTime:0.021980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924889 LIMIT 2 [ RunTime:0.022247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924889 ORDER BY `minOrder` ASC [ RunTime:0.008391s ]
select * from pdf where partno='228CDVAAFDMSD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAFDMSD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014335s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924889 AND `partno` = '228CDVAAFDMSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.007457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449521 [ RunTime:0.002215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924888 LIMIT 4 [ RunTime:0.005189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924888 ORDER BY `minOrder` ASC [ RunTime:0.020490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924888 ORDER BY `unit` DESC [ RunTime:0.023046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924888 LIMIT 2 [ RunTime:0.010932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924888 ORDER BY `minOrder` ASC [ RunTime:0.006615s ]
select * from pdf where partno='228CDVAAWFDMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.024729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAAWFDMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.027314s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924888 AND `partno` = '228CDVAAWFDMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449520 [ RunTime:0.019543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924887 LIMIT 4 [ RunTime:0.011159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924887 ORDER BY `minOrder` ASC [ RunTime:0.010280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924887 ORDER BY `unit` DESC [ RunTime:0.016050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924887 LIMIT 2 [ RunTime:0.013140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924887 ORDER BY `minOrder` ASC [ RunTime:0.033326s ]
select * from pdf where partno='228CDVAYFEBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFEBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007950s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924887 AND `partno` = '228CDVAYFEBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.017327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449519 [ RunTime:0.019675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924886 LIMIT 4 [ RunTime:0.010476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924886 ORDER BY `minOrder` ASC [ RunTime:0.032765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924886 ORDER BY `unit` DESC [ RunTime:0.015292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924886 LIMIT 2 [ RunTime:0.016327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924886 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
select * from pdf where partno='228CDVARGFFAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.002799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFFAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008306s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924886 AND `partno` = '228CDVARGFFAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.030940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449518 [ RunTime:0.027083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924885 LIMIT 4 [ RunTime:0.013098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924885 ORDER BY `minOrder` ASC [ RunTime:0.021850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924885 ORDER BY `unit` DESC [ RunTime:0.032903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924885 LIMIT 2 [ RunTime:0.012097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924885 ORDER BY `minOrder` ASC [ RunTime:0.005911s ]
select * from pdf where partno='228CDVAGFCWB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.017166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCWB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.016901s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924885 AND `partno` = '228CDVAGFCWB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449517 [ RunTime:0.013833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924884 LIMIT 4 [ RunTime:0.018579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924884 ORDER BY `minOrder` ASC [ RunTime:0.024736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924884 ORDER BY `unit` DESC [ RunTime:0.006937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924884 LIMIT 2 [ RunTime:0.028687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924884 ORDER BY `minOrder` ASC [ RunTime:0.010762s ]
select * from pdf where partno='228CDVARGFFMBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGFFMBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.013715s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924884 AND `partno` = '228CDVARGFFMBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449516 [ RunTime:0.053059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924883 LIMIT 4 [ RunTime:0.011014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924883 ORDER BY `minOrder` ASC [ RunTime:0.035341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924883 ORDER BY `unit` DESC [ RunTime:0.032740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924883 LIMIT 2 [ RunTime:0.032575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924883 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='228CDVARGBFEBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARGBFEBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.045226s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924883 AND `partno` = '228CDVARGBFEBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.062416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449515 [ RunTime:0.077550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924882 LIMIT 4 [ RunTime:0.039784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924882 ORDER BY `minOrder` ASC [ RunTime:0.033590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924882 ORDER BY `unit` DESC [ RunTime:0.003439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924882 LIMIT 2 [ RunTime:0.023813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924882 ORDER BY `minOrder` ASC [ RunTime:0.013363s ]
select * from pdf where partno='228CDVAYFFAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFFAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017552s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924882 AND `partno` = '228CDVAYFFAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.024918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366308 [ RunTime:0.007795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924881 LIMIT 4 [ RunTime:0.014841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924881 ORDER BY `minOrder` ASC [ RunTime:0.024675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924881 ORDER BY `unit` DESC [ RunTime:0.009888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924881 LIMIT 2 [ RunTime:0.007734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924881 ORDER BY `minOrder` ASC [ RunTime:0.033942s ]
select * from pdf where partno='228CDVABFAMSB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.030664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVABFAMSB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.018665s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924881 AND `partno` = '228CDVABFAMSB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366307 [ RunTime:0.011038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924880 LIMIT 4 [ RunTime:0.011211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924880 ORDER BY `minOrder` ASC [ RunTime:0.018558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924880 ORDER BY `unit` DESC [ RunTime:0.018257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924880 LIMIT 2 [ RunTime:0.050084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924880 ORDER BY `minOrder` ASC [ RunTime:0.003276s ]
select * from pdf where partno='228CDVAYFFBBD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.067475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFFBBD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.023645s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924880 AND `partno` = '228CDVAYFFBBD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449514 [ RunTime:0.036819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924879 LIMIT 4 [ RunTime:0.039444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924879 ORDER BY `minOrder` ASC [ RunTime:0.032963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924879 ORDER BY `unit` DESC [ RunTime:0.009653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924879 LIMIT 2 [ RunTime:0.014549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924879 ORDER BY `minOrder` ASC [ RunTime:0.007681s ]
select * from pdf where partno='228CDVAGFCBBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAGFCBBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022068s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924879 AND `partno` = '228CDVAGFCBBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.021983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366306 [ RunTime:0.013526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924878 LIMIT 4 [ RunTime:0.029911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924878 ORDER BY `minOrder` ASC [ RunTime:0.035343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924878 ORDER BY `unit` DESC [ RunTime:0.009613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924878 LIMIT 2 [ RunTime:0.032923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924878 ORDER BY `minOrder` ASC [ RunTime:0.023331s ]
select * from pdf where partno='228CDVARFARA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.034539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVARFARA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.020559s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924878 AND `partno` = '228CDVARFARA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.023213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12449513 [ RunTime:0.005549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924877 LIMIT 4 [ RunTime:0.039673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924877 ORDER BY `minOrder` ASC [ RunTime:0.015693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924877 ORDER BY `unit` DESC [ RunTime:0.009671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924877 LIMIT 2 [ RunTime:0.018838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924877 ORDER BY `minOrder` ASC [ RunTime:0.005819s ]
select * from pdf where partno='228CDVAYFFMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.013194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAYFFMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012348s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924877 AND `partno` = '228CDVAYFFMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366305 [ RunTime:0.012072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32924876 LIMIT 4 [ RunTime:0.006118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924876 ORDER BY `minOrder` ASC [ RunTime:0.013476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32924876 ORDER BY `unit` DESC [ RunTime:0.013650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32924876 LIMIT 2 [ RunTime:0.037949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32924876 ORDER BY `minOrder` ASC [ RunTime:0.005206s ]
select * from pdf where partno='228CDVAWFCAA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.053529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228CDVAWFCAA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.008641s ]
SELECT `id` FROM `stock` WHERE `id` <> 32924876 AND `partno` = '228CDVAWFCAA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.014390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11366304 [ RunTime:0.028329s ]
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.119214s ]