SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001395s ]
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=427&srecordnum=10000' [ RunTime:0.002936s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001421s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001570s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000291s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001212s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000277s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002011s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.004849s ]
UPDATE `stock_search` SET `count` = 1990 , `updatetime` = '2026-06-12 14:29:40' WHERE `partno` = '228' [ RunTime:0.006581s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001588s ]
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 '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) LIMIT 8520,20 [ RunTime:0.195717s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920185 LIMIT 4 [ RunTime:0.014062s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920185 ORDER BY `minOrder` ASC [ RunTime:0.015132s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920185 ORDER BY `unit` DESC [ RunTime:0.004124s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920185 LIMIT 2 [ RunTime:0.009164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920185 ORDER BY `minOrder` ASC [ RunTime:0.003114s ]
select * from pdf where partno='228ADVAAWFCWE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.007427s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAWFCWE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.007541s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920185 AND `partno` = '228ADVAAWFCWE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.044987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450827 [ RunTime:0.041249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920186 LIMIT 4 [ RunTime:0.009983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920186 ORDER BY `minOrder` ASC [ RunTime:0.009089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920186 ORDER BY `unit` DESC [ RunTime:0.011402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920186 LIMIT 2 [ RunTime:0.014148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920186 ORDER BY `minOrder` ASC [ RunTime:0.034123s ]
select * from pdf where partno='228ADVAAWFCBBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAWFCBBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014440s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920186 AND `partno` = '228ADVAAWFCBBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.013631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450828 [ RunTime:0.034380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920187 LIMIT 4 [ RunTime:0.012511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920187 ORDER BY `minOrder` ASC [ RunTime:0.032320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920187 ORDER BY `unit` DESC [ RunTime:0.039542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920187 LIMIT 2 [ RunTime:0.058292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920187 ORDER BY `minOrder` ASC [ RunTime:0.005331s ]
select * from pdf where partno='228ADVAWFCRC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.026477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAWFCRC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.032258s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920187 AND `partno` = '228ADVAWFCRC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.080391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450829 [ RunTime:0.023997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920188 LIMIT 4 [ RunTime:0.038761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920188 ORDER BY `minOrder` ASC [ RunTime:0.036913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920188 ORDER BY `unit` DESC [ RunTime:0.034150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920188 LIMIT 2 [ RunTime:0.019897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920188 ORDER BY `minOrder` ASC [ RunTime:0.030342s ]
select * from pdf where partno='228ADVAWFCMBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.023097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAWFCMBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022986s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920188 AND `partno` = '228ADVAWFCMBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.083315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450830 [ RunTime:0.026463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920189 LIMIT 4 [ RunTime:0.013203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920189 ORDER BY `minOrder` ASC [ RunTime:0.015756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920189 ORDER BY `unit` DESC [ RunTime:0.019447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920189 LIMIT 2 [ RunTime:0.035876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920189 ORDER BY `minOrder` ASC [ RunTime:0.010864s ]
select * from pdf where partno='228ADVAWFCMSE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.044584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAWFCMSE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.060290s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920189 AND `partno` = '228ADVAWFCMSE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.032888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450831 [ RunTime:0.025994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920190 LIMIT 4 [ RunTime:0.063558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920190 ORDER BY `minOrder` ASC [ RunTime:0.021365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920190 ORDER BY `unit` DESC [ RunTime:0.031625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920190 LIMIT 2 [ RunTime:0.010500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920190 ORDER BY `minOrder` ASC [ RunTime:0.017664s ]
select * from pdf where partno='228ADVAAWFCMSE' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.018915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAWFCMSE' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.012816s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920190 AND `partno` = '228ADVAAWFCMSE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.021954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450832 [ RunTime:0.005502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920191 LIMIT 4 [ RunTime:0.011338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920191 ORDER BY `minOrder` ASC [ RunTime:0.018909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920191 ORDER BY `unit` DESC [ RunTime:0.015316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920191 LIMIT 2 [ RunTime:0.025951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920191 ORDER BY `minOrder` ASC [ RunTime:0.010311s ]
select * from pdf where partno='228ADVAAFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.019142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.017480s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920191 AND `partno` = '228ADVAAFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367100 [ RunTime:0.023023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920192 LIMIT 4 [ RunTime:0.024389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920192 ORDER BY `minOrder` ASC [ RunTime:0.013460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920192 ORDER BY `unit` DESC [ RunTime:0.052021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920192 LIMIT 2 [ RunTime:0.016850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920192 ORDER BY `minOrder` ASC [ RunTime:0.018380s ]
select * from pdf where partno='228ADVAAWFABBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.031316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAWFABBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.022319s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920192 AND `partno` = '228ADVAAWFABBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.018074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450833 [ RunTime:0.028358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920193 LIMIT 4 [ RunTime:0.030373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920193 ORDER BY `minOrder` ASC [ RunTime:0.025482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920193 ORDER BY `unit` DESC [ RunTime:0.066337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920193 LIMIT 2 [ RunTime:0.035184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920193 ORDER BY `minOrder` ASC [ RunTime:0.017761s ]
select * from pdf where partno='228ADVARFCMBB' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.029353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARFCMBB' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.014889s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920193 AND `partno` = '228ADVARFCMBB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.022110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920194 LIMIT 4 [ RunTime:0.030522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920194 ORDER BY `minOrder` ASC [ RunTime:0.037260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920194 ORDER BY `unit` DESC [ RunTime:0.019333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920194 LIMIT 2 [ RunTime:0.043650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920194 ORDER BY `minOrder` ASC [ RunTime:0.035752s ]
select * from pdf where partno='228ADVAAWFBMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.081022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAWFBMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.032366s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920194 AND `partno` = '228ADVAAWFBMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.081470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920195 LIMIT 4 [ RunTime:0.022638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920195 ORDER BY `minOrder` ASC [ RunTime:0.029361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920195 ORDER BY `unit` DESC [ RunTime:0.070376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920195 LIMIT 2 [ RunTime:0.042468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920195 ORDER BY `minOrder` ASC [ RunTime:0.032399s ]
select * from pdf where partno='228ADVARFCRD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.033741s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARFCRD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.034580s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920195 AND `partno` = '228ADVARFCRD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.069906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367101 [ RunTime:0.028865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920196 LIMIT 4 [ RunTime:0.047545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920196 ORDER BY `minOrder` ASC [ RunTime:0.020503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920196 ORDER BY `unit` DESC [ RunTime:0.039143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920196 LIMIT 2 [ RunTime:0.032737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920196 ORDER BY `minOrder` ASC [ RunTime:0.034281s ]
select * from pdf where partno='228ADVABFCBBA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.081738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVABFCBBA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.085461s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920196 AND `partno` = '228ADVABFCBBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.047702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367102 [ RunTime:0.061337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920197 LIMIT 4 [ RunTime:0.093603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920197 ORDER BY `minOrder` ASC [ RunTime:0.106799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920197 ORDER BY `unit` DESC [ RunTime:0.032977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920197 LIMIT 2 [ RunTime:0.031899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920197 ORDER BY `minOrder` ASC [ RunTime:0.030351s ]
select * from pdf where partno='228ADVABBMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.034076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVABBMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.048194s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920197 AND `partno` = '228ADVABBMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.038632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367103 [ RunTime:0.010007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920198 LIMIT 4 [ RunTime:0.030622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920198 ORDER BY `minOrder` ASC [ RunTime:0.009103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920198 ORDER BY `unit` DESC [ RunTime:0.011306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920198 LIMIT 2 [ RunTime:0.005108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920198 ORDER BY `minOrder` ASC [ RunTime:0.011915s ]
select * from pdf where partno='228ADVAGFCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.015644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAGFCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.024460s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920198 AND `partno` = '228ADVAGFCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.016342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367104 [ RunTime:0.012032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920199 LIMIT 4 [ RunTime:0.006605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920199 ORDER BY `minOrder` ASC [ RunTime:0.013817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920199 ORDER BY `unit` DESC [ RunTime:0.016404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920199 LIMIT 2 [ RunTime:0.004539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920199 ORDER BY `minOrder` ASC [ RunTime:0.001366s ]
select * from pdf where partno='228ADVABCAD' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.009749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVABCAD' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010645s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920199 AND `partno` = '228ADVABCAD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367105 [ RunTime:0.004640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920200 LIMIT 4 [ RunTime:0.004683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920200 ORDER BY `minOrder` ASC [ RunTime:0.005805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920200 ORDER BY `unit` DESC [ RunTime:0.002989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920200 LIMIT 2 [ RunTime:0.004129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920200 ORDER BY `minOrder` ASC [ RunTime:0.002272s ]
select * from pdf where partno='228ADVAYGFCWC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.006666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAYGFCWC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.002319s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920200 AND `partno` = '228ADVAYGFCWC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.005975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450834 [ RunTime:0.013617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920201 LIMIT 4 [ RunTime:0.014813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920201 ORDER BY `minOrder` ASC [ RunTime:0.019997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920201 ORDER BY `unit` DESC [ RunTime:0.012431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920201 LIMIT 2 [ RunTime:0.036256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920201 ORDER BY `minOrder` ASC [ RunTime:0.009684s ]
select * from pdf where partno='228ADVAYCAC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.037979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAYCAC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.028713s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920201 AND `partno` = '228ADVAYCAC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.034260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12450835 [ RunTime:0.023525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920202 LIMIT 4 [ RunTime:0.032339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920202 ORDER BY `minOrder` ASC [ RunTime:0.014775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920202 ORDER BY `unit` DESC [ RunTime:0.024583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920202 LIMIT 2 [ RunTime:0.030396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920202 ORDER BY `minOrder` ASC [ RunTime:0.012662s ]
select * from pdf where partno='228ADVARFBMBC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVARFBMBC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.021745s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920202 AND `partno` = '228ADVARFBMBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.012756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11367106 [ RunTime:0.050113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920203 LIMIT 4 [ RunTime:0.038288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920203 ORDER BY `minOrder` ASC [ RunTime:0.015461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920203 ORDER BY `unit` DESC [ RunTime:0.007521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920203 LIMIT 2 [ RunTime:0.009650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920203 ORDER BY `minOrder` ASC [ RunTime:0.006849s ]
select * from pdf where partno='228ADVAAWFCRA' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.008353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAAWFCRA' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.010452s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920203 AND `partno` = '228ADVAAWFCRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.008874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32920204 LIMIT 4 [ RunTime:0.004092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920204 ORDER BY `minOrder` ASC [ RunTime:0.007191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32920204 ORDER BY `unit` DESC [ RunTime:0.007816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32920204 LIMIT 2 [ RunTime:0.004375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32920204 ORDER BY `minOrder` ASC [ RunTime:0.006141s ]
select * from pdf where partno='228ADVAGFBMSC' and brandshort='CTS Electrocomponents' limit 1 [ RunTime:0.010080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '228ADVAGFBMSC' OR `brand` LIKE 'CTS Electrocomponents%' ) ) LIMIT 1 [ RunTime:0.006947s ]
SELECT `id` FROM `stock` WHERE `id` <> 32920204 AND `partno` = '228ADVAGFBMSC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts electrocomponents%' ) [ RunTime:0.002394s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) AND ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) LIMIT 8520,20 [ RunTime:0.139539s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.128207s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '228%' OR `brand` LIKE '228%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.073888s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 643 [ RunTime:0.000647s ]