Quadro M6000 24 GB vs. GeForce RTX 4070 SUPER
Puntuación agregada de rendimiento
Hemos comparado Quadro M6000 24 GB con GeForce RTX 4070 SUPER, incluyendo especificaciones y datos de rendimiento.
RTX 4070 SUPER supera a M6000 24 GB en un enorme 153% según nuestros resultados de referencia agregados.
Detalles principales
Información sobre el tipo (para desktops o computadoras portátiles) y la arquitectura de Quadro M6000 24 GB y GeForce RTX 4070 SUPER, así como el momento de las ventas y el costo en el momento.
| Lugar en el rankng de rendimiento | 167 | 8 |
| Lugar por popularidad | no en el top-100 | 28 |
| Evaluación coste-eficacia | 5.48 | 33.57 |
| Arquitectura | Maxwell 2.0 (2015−2019) | Ada Lovelace |
| Nombre de código | GM200 | AD104 |
| Tipo | Para las estaciones de trabajo | de escritorio |
| Fecha de lanzamiento | 5 de Marzo 2016 (8 años hace) | 17 de Enero 2024 (hace menos de un año) |
| El precio en el momento del lanzamiento | $4,999 | $699 |
Evaluación coste-eficacia
Para obtener un índice, comparamos el rendimiento de las tarjetas de vídeo y su coste, teniendo en cuenta el coste de otras tarjetas de vídeo.
La relación calidad-precio de RTX 4070 SUPER es un 513% mejor que la de M6000 24 GB.
Especificaciones detalladas
Parámetros generales del Quadro M6000 24 GB y GeForce RTX 4070 SUPER: el número de sombreadores, la frecuencia del núcleo de video, la tecnología de proceso, la velocidad de texturizado y computación. Indirectamente respaldan el rendimiento del Quadro M6000 24 GB y GeForce RTX 4070 SUPER, aunque para una evaluación precisa es necesario considerar los resultados de los benchmarks y las pruebas del juego.
| La cantidad de los procesadores de sombreado | 3072 | 7168 |
| La frecuencia del núcleo | 988 MHz | 1980 MHz |
| La frecuencia de modo Boost | 1114 MHz | 2475 MHz |
| Cantidad de los transistores | 8,000 million | 35,800 million |
| El proceso tecnológico de fabricación | 28 nm | 5 nm |
| El consumo de energia (TDP) | 250 Watt | 220 Watt |
| La velocidad de textura | 285.2 | 584.6 |
| El rendimiento con el punto flotante | 6,844 gflops | sin datos |
Factor de forma y compatibilidad
Parámetros responsables de la compatibilidad de Quadro M6000 24 GB y GeForce RTX 4070 SUPER con otros componentes de la computadora. Útil por ejemplo, al elegir una configuración de computadora futura o para actualizar una configuración existente. Para las tarjetas de video de desktops es una interfaz de bus de conexión (compatibilidad con la placa base), el tamaño físico de la tarjeta de video (placa base y cuerpo compatible), más conectores de alimentación (compatible con la fuente de alimentación) de alimentación).
| Interfaz | PCIe 3.0 x16 | PCIe 4.0 x16 |
| Longitud | 267 mm | 285 mm |
| Ancho | 2-slot | 2-slot |
| Conectores de alimentación adicionales | 1x 8-pin | 1x 16-pin |
Capacidad y tipo de VRAM
Parámetros de memoria instalada en Quadro M6000 24 GB y GeForce RTX 4070 SUPER - tipo, tamaño, bus, frecuencia y capacidad del canal. Para las tarjetas de video integradas en el procesador que no tienen su propia memoria, se utiliza una porción compartida de RAM.
| Tipo de memoria | GDDR5 | GDDR6X |
| La capacidad máxima de RAM | 24 GB | 12 GB |
| El ancho del bus de memoria | 384 Bit | 192 Bit |
| La frecuencia de la memoria | 6612 MHz | 21000 MHz |
| El ancho de banda de memoria | 317.4 GB/s | 504.2 GB/s |
| La memoria compartida | sin datos | - |
Conectividad y salidas
Se enumeran los conectores de video disponibles en Quadro M6000 24 GB y GeForce RTX 4070 SUPER. Como regla general, esta sección es relevante solo para tarjetas de video de referencia de escritorio, ya que para las portátiles la disponibilidad de ciertas salidas de video depende del modelo de computadora portátil.
| Conectores de vídeo | 1x DVI, 4x DisplayPort | 1x HDMI 2.1, 3x DisplayPort 1.4a |
| HDMI | sin datos | + |
Compatibilidad API
Se enumeran Quadro M6000 24 GB y GeForce RTX 4070 SUPER las APIs compatibles incluyendo sus versiones.
| DirectX | 12 (12_1) | 12 Ultimate (12_2) |
| El modelo de sombreado | 6.4 | 6.7 |
| OpenGL | 4.6 | 4.6 |
| OpenCL | 1.2 | 3.0 |
| Vulkan | + | 1.3 |
| CUDA | 5.2 | 8.9 |
Rendimiento sintético de referencia
Estos son los resultados de las pruebas Quadro M6000 24 GB y GeForce RTX 4070 SUPER sobre el rendimiento de renderización en los puntos de referencia no relacionados en los juegos. La puntuación total se establece de 0 a 100, donde 100 es la tarjeta de video más rápida en este momento.
Puntuación sintética combinada de los puntos de referencia
Esta es nuestra clasificación de rendimiento de referencia combinada. Estamos mejorando regularmente nuestros algoritmos de combinación, pero si encuentras algunas inconsistencias percibidas, no dudes en hablar en la sección de comentarios, solemos solucionar los problemas rápidamente.
GeForce RTX 4070 SUPER supera a Quadro M6000 24 GB en un 153% en nuestros resultados de referencia combinados.
Passmark
Este es probablemente el benchmark más omnipresente, parte de la suite Passmark PerformanceTest. Ofrece una evaluación exhaustiva de la tarjeta gráfica, proporcionando cuatro pruebas separadas para las versiones 9, 10, 11 y 12 de Direct3D (la última se realiza en resolución 4K si es posible), y algunas pruebas más que involucran las capacidades de DirectCompute.
Cobertura de referencia: 25%
GeForce RTX 4070 SUPER supera a Quadro M6000 24 GB en un 153% en Passmark.
Rendimiento de juego
Los resultados de Quadro M6000 24 GB y GeForce RTX 4070 SUPER en juegos, los valores se miden en FPS.
FPS medios de todos los juegos de PC
Aquí se muestra la media de fotogramas por segundo en un amplio conjunto de juegos populares en diferentes resoluciones:
| Full HD | 80−85
−161%
| 209
+161%
|
| 1440p | 50−55
−166%
| 133
+166%
|
| 4K | 30−35
−180%
| 84
+180%
|
Rendimiento de FPS en juegos populares
Full HD
Medium Preset
| Assassin's Creed Odyssey | 150−160
+0%
|
150−160
+0%
|
| Assassin's Creed Valhalla | 140−150
+0%
|
140−150
+0%
|
| Battlefield 5 | 240−250
+0%
|
240−250
+0%
|
| Call of Duty: Modern Warfare | 120−130
+0%
|
120−130
+0%
|
| Far Cry 5 | 110−120
+0%
|
110−120
+0%
|
| Far Cry New Dawn | 190−200
+0%
|
190−200
+0%
|
| Forza Horizon 4 | 240−250
+0%
|
240−250
+0%
|
| Hitman 3 | 120−130
+0%
|
120−130
+0%
|
| Horizon Zero Dawn | 270−280
+0%
|
270−280
+0%
|
| Metro Exodus | 150−160
+0%
|
150−160
+0%
|
| Red Dead Redemption 2 | 120−130
+0%
|
120−130
+0%
|
| Shadow of the Tomb Raider | 300−350
+0%
|
300−350
+0%
|
| Watch Dogs: Legion | 150−160
+0%
|
150−160
+0%
|
Full HD
High Preset
| Assassin's Creed Odyssey | 150−160
+0%
|
150−160
+0%
|
| Assassin's Creed Valhalla | 140−150
+0%
|
140−150
+0%
|
| Battlefield 5 | 240−250
+0%
|
240−250
+0%
|
| Call of Duty: Modern Warfare | 120−130
+0%
|
120−130
+0%
|
| Far Cry 5 | 110−120
+0%
|
110−120
+0%
|
| Far Cry New Dawn | 190−200
+0%
|
190−200
+0%
|
| Forza Horizon 4 | 240−250
+0%
|
240−250
+0%
|
| Hitman 3 | 120−130
+0%
|
120−130
+0%
|
| Horizon Zero Dawn | 270−280
+0%
|
270−280
+0%
|
| Metro Exodus | 150−160
+0%
|
150−160
+0%
|
| Red Dead Redemption 2 | 120−130
+0%
|
120−130
+0%
|
| Shadow of the Tomb Raider | 428
+0%
|
428
+0%
|
| The Witcher 3: Wild Hunt | 170−180
+0%
|
170−180
+0%
|
| Watch Dogs: Legion | 150−160
+0%
|
150−160
+0%
|
Full HD
Ultra Preset
| Assassin's Creed Odyssey | 150−160
+0%
|
150−160
+0%
|
| Assassin's Creed Valhalla | 140−150
+0%
|
140−150
+0%
|
| Call of Duty: Modern Warfare | 120−130
+0%
|
120−130
+0%
|
| Far Cry 5 | 110−120
+0%
|
110−120
+0%
|
| Forza Horizon 4 | 240−250
+0%
|
240−250
+0%
|
| Hitman 3 | 120−130
+0%
|
120−130
+0%
|
| Horizon Zero Dawn | 270−280
+0%
|
270−280
+0%
|
| Shadow of the Tomb Raider | 381
+0%
|
381
+0%
|
| The Witcher 3: Wild Hunt | 201
+0%
|
201
+0%
|
| Watch Dogs: Legion | 139
+0%
|
139
+0%
|
Full HD
Epic Preset
| Red Dead Redemption 2 | 120−130
+0%
|
120−130
+0%
|
1440p
High Preset
| Battlefield 5 | 160−170
+0%
|
160−170
+0%
|
| Far Cry New Dawn | 110−120
+0%
|
110−120
+0%
|
1440p
Ultra Preset
| Assassin's Creed Odyssey | 90−95
+0%
|
90−95
+0%
|
| Assassin's Creed Valhalla | 100−110
+0%
|
100−110
+0%
|
| Call of Duty: Modern Warfare | 80−85
+0%
|
80−85
+0%
|
| Far Cry 5 | 80−85
+0%
|
80−85
+0%
|
| Forza Horizon 4 | 270−280
+0%
|
270−280
+0%
|
| Hitman 3 | 110−120
+0%
|
110−120
+0%
|
| Horizon Zero Dawn | 200−210
+0%
|
200−210
+0%
|
| Metro Exodus | 120−130
+0%
|
120−130
+0%
|
| Shadow of the Tomb Raider | 265
+0%
|
265
+0%
|
| The Witcher 3: Wild Hunt | 154
+0%
|
154
+0%
|
| Watch Dogs: Legion | 240−250
+0%
|
240−250
+0%
|
1440p
Epic Preset
| Red Dead Redemption 2 | 120−130
+0%
|
120−130
+0%
|
4K
High Preset
| Battlefield 5 | 85−90
+0%
|
85−90
+0%
|
| Far Cry New Dawn | 65−70
+0%
|
65−70
+0%
|
| Hitman 3 | 70−75
+0%
|
70−75
+0%
|
| Horizon Zero Dawn | 220−230
+0%
|
220−230
+0%
|
| Metro Exodus | 130−140
+0%
|
130−140
+0%
|
| The Witcher 3: Wild Hunt | 133
+0%
|
133
+0%
|
4K
Ultra Preset
| Assassin's Creed Odyssey | 65−70
+0%
|
65−70
+0%
|
| Assassin's Creed Valhalla | 60−65
+0%
|
60−65
+0%
|
| Call of Duty: Modern Warfare | 50−55
+0%
|
50−55
+0%
|
| Far Cry 5 | 50−55
+0%
|
50−55
+0%
|
| Forza Horizon 4 | 140−150
+0%
|
140−150
+0%
|
| Shadow of the Tomb Raider | 132
+0%
|
132
+0%
|
| Watch Dogs: Legion | 62
+0%
|
62
+0%
|
4K
Epic Preset
| Red Dead Redemption 2 | 90−95
+0%
|
90−95
+0%
|
Así compiten M6000 24 GB y RTX 4070 SUPER en los juegos populares:
- RTX 4070 SUPER es 161% más rápido en 1080p
- RTX 4070 SUPER es 166% más rápido en 1440p
- RTX 4070 SUPER es 180% más rápido en 4K
En definitiva, en juegos populares:
- hay un empate en 66 pruebas (100%)
Resumen de pros y contras
| Clasificación de las prestaciones | 30.80 | 77.82 |
| Novedad | 5 de Marzo 2016 | 17 de Enero 2024 |
| La capacidad máxima de RAM | 24 GB | 12 GB |
| El proceso tecnológico | 28 nm | 5 nm |
| El consumo de energia (TDP) | 250 Vatio | 220 Vatio |
M6000 24 GB tiene un 100% mayor cantidad máxima de VRAM.
RTX 4070 SUPER, por otro lado, tiene un 152.7% más de puntuación agregada de rendimiento, una ventaja de edad de 7 años, un proceso litográfico 460% más avanzado, y 13.6% menor consumo de energía.
El GeForce RTX 4070 SUPER es nuestra opción recomendada, ya que supera al Quadro M6000 24 GB en las pruebas de rendimiento.
Tenga en cuenta que Quadro M6000 24 GB esta destinada para las estaciones de trabajo es GeForce RTX 4070 SUPER - para los ordenadores de sobremesa.
Para cualquier duda sobre que elegir Quadro M6000 24 GB y GeForce RTX 4070 SUPER deja tus preguntas en los Comentarios. Las responderemos lo antes posible.
Comparaciones con GPU similares
Hemos seleccionado varias comparaciones de tarjetas gráficas con un rendimiento más o menos cercano a las revisadas, lo que le proporciona más opciones probables a considerar.
Ошибка: Запрос select b.card_id from ss_benchmarks_results as b left join ss_cards as i on i._id=b.card_id and i._disabled=0 and i.redirect_to=0 left join ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_stat_exist as pop on pop.item_type="video" and pop.item1=i._id and pop.item2=2460 and pop.lang="4" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="4" where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2016-03-05","-00","-01"))<=366/2 OR to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2 ) ) having !isnull(i._id) order by abs(30.8 - b.result) asc /* # 1 */ limit 6 вызвал ошибку Unknown column 'i._id' in 'having clause'
Array
(
[0] => Array
(
[file] => /var/www/web/data/www/technical.city/system/lib/db.php
[line] => 151
[function] => db_query
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2460 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(30.8 - b.result) asc /* # 1 */ limit 6
)
)
[1] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/85/85
[line] => 150
[function] => db_getItems
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2460 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(30.8 - b.result) asc /* # 1 */ limit 6
)
)
[2] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
[line] => 16525
[function] => db_cache
[args] => Array
(
[0] => nearest_video_desktop_1_2460_L4
[1] => db_getItems
[2] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2460 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(30.8 - b.result) asc /* # 1 */ limit 6
[3] => Array
(
[0] => ss_benchmarks_results
[1] => ss_cards
)
)
)
[3] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
[line] => 15
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
)
[function] => include
)
[4] => Array
(
[file] => /var/www/web/data/www/technical.city/system/handler/index.php
[line] => 372
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
)
[function] => require
)
)
Ошибка: Запрос select b.card_id from ss_benchmarks_results as b left join ss_cards as i on i._id=b.card_id and i._disabled=0 and i.redirect_to=0 left join ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_stat_exist as pop on pop.item_type="video" and pop.item1=i._id and pop.item2=10742 and pop.lang="4" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=10742 and pop2.item2=i._id and pop2.lang="4" where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2024-01-17","-00","-01"))<=366/2 OR to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2 ) ) having !isnull(i._id) order by abs(77.82 - b.result) asc /* # 2 */ limit 6 вызвал ошибку Unknown column 'i._id' in 'having clause'
Array
(
[0] => Array
(
[file] => /var/www/web/data/www/technical.city/system/lib/db.php
[line] => 151
[function] => db_query
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=10742 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=10742 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2024-01-17","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(77.82 - b.result) asc /* # 2 */ limit 6
)
)
[1] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/85/85
[line] => 150
[function] => db_getItems
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=10742 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=10742 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2024-01-17","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(77.82 - b.result) asc /* # 2 */ limit 6
)
)
[2] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
[line] => 16525
[function] => db_cache
[args] => Array
(
[0] => nearest_video_desktop_1_10742_L4
[1] => db_getItems
[2] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=10742 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=10742 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2024-01-17","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(77.82 - b.result) asc /* # 2 */ limit 6
[3] => Array
(
[0] => ss_benchmarks_results
[1] => ss_cards
)
)
)
[3] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
[line] => 15
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
)
[function] => include
)
[4] => Array
(
[file] => /var/www/web/data/www/technical.city/system/handler/index.php
[line] => 372
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
)
[function] => require
)
)
Ошибка: Запрос select b.card_id from ss_benchmarks_results as b left join ss_cards as i on i._id=b.card_id and i._disabled=0 and i.redirect_to=0 left join ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0 left join ss_stat_exist as pop on pop.item_type="video" and pop.item1=i._id and pop.item2=2460 and pop.lang="4" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="4" where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2016-03-05","-00","-01"))<=366/2 OR to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2 ) ) having !isnull(i._id) order by abs(30.8 - b.result) asc /* # 1 */ limit 6 вызвал ошибку Unknown column 'i._id' in 'having clause'
Array
(
[0] => Array
(
[file] => /var/www/web/data/www/technical.city/system/lib/db.php
[line] => 151
[function] => db_query
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2460 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(30.8 - b.result) asc /* # 1 */ limit 6
)
)
[1] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/85/85
[line] => 150
[function] => db_getItems
[args] => Array
(
[0] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2460 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(30.8 - b.result) asc /* # 1 */ limit 6
)
)
[2] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
[line] => 16525
[function] => db_cache
[args] => Array
(
[0] => nearest_video_desktop_1_2460_L4
[1] => db_getItems
[2] => select b.card_id from ss_benchmarks_results as b
left join ss_cards as i
on i._id=b.card_id and i._disabled=0 and i.redirect_to=0
left join
ss_cards_custom as custom on custom.filename=i.filename and custom._disabled=0
left join
ss_stat_exist as pop
on pop.item_type="video" and pop.item1=i._id and pop.item2=2460 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=2460 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="1" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2016-03-05","-00","-01"))<=366/2
OR
to_days(now()) - to_days(replace(if(custom.date_of_announcement AND custom.date_of_announcement!="0000-01-00",custom.date_of_announcement,i.date_of_announcement),"-00","-01"))<=366/2
)
)
having !isnull(i._id)
order by abs(30.8 - b.result) asc /* # 1 */ limit 6
[3] => Array
(
[0] => ss_benchmarks_results
[1] => ss_cards
)
)
)
[3] => Array
(
[file] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
[line] => 15
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/textblocks/text/22/222
)
[function] => include
)
[4] => Array
(
[file] => /var/www/web/data/www/technical.city/system/handler/index.php
[line] => 372
[args] => Array
(
[0] => /var/www/web/data/www/technical.city/_content/pages/text/23/323_1
)
[function] => require
)
)
