GeForce GTX 1070 Ti vs. GTS 450
Puntuación agregada de rendimiento
Hemos comparado GeForce GTX 1070 Ti y GeForce GTS 450, incluyendo especificaciones y todos los puntos de referencia relevantes.
GTX 1070 Ti supera a GTS 450 en un enorme 1013% según nuestros resultados de referencia agregados.
Detalles principales
Información sobre el tipo (para desktops o computadoras portátiles) y la arquitectura de GeForce GTX 1070 Ti y GeForce GTS 450, así como el momento de las ventas y el costo en el momento.
| Lugar en el rankng de rendimiento | 111 | 696 |
| Lugar por popularidad | 63 | 83 |
| Evaluación coste-eficacia | 32.16 | 0.32 |
| Arquitectura | Pascal (2016−2021) | Fermi (2010−2014) |
| Nombre de código | Pascal GP104 | GF106 |
| Tipo | de escritorio | de escritorio |
| Fecha de lanzamiento | 2 de Noviembre 2017 (6 años hace) | 13 de Septiembre 2010 (13 años hace) |
| El precio en el momento del lanzamiento | $399 | $129 |
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 GTX 1070 Ti es un 9950% mejor que la de GTS 450.
Especificaciones detalladas
Parámetros generales del GeForce GTX 1070 Ti y GeForce GTS 450: 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 GeForce GTX 1070 Ti y GeForce GTS 450, 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 | 2432 | 192 |
| La frecuencia del núcleo | 1607 MHz | 783 MHz |
| La frecuencia de modo Boost | 1683 MHz | sin datos |
| Cantidad de los transistores | 7,200 million | 1,170 million |
| El proceso tecnológico de fabricación | 16 nm | 40 nm |
| El consumo de energia (TDP) | 180 Watt | 106 Watt |
| La velocidad de textura | 255.8 | 25.06 |
| El rendimiento con el punto flotante | 8,186 gflops | 601.3 gflops |
Factor de forma y compatibilidad
Parámetros responsables de la compatibilidad de GeForce GTX 1070 Ti y GeForce GTS 450 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 2.0 x16 |
| Longitud | 267 mm | 210 mm |
| Ancho | 2-slot | 2-slot |
| Conectores de alimentación adicionales | 1x 8-pin | 1x 6-pin |
Capacidad y tipo de VRAM
Parámetros de memoria instalada en GeForce GTX 1070 Ti y GeForce GTS 450 - 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 | GDDR5 |
| La capacidad máxima de RAM | 8 GB | 1 GB |
| El ancho del bus de memoria | 256 Bit | 128 Bit |
| La frecuencia de la memoria | 8000 MHz | 1600 MHz |
| El ancho de banda de memoria | 256.3 GB/s | 57.73 GB/s |
| La memoria compartida | - | sin datos |
Conectividad y salidas
Se enumeran los conectores de video disponibles en GeForce GTX 1070 Ti y GeForce GTS 450. 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, 1x HDMI, 3x DisplayPort | 2x DVI, 1x mini-HDMI |
| HDMI | + | + |
| Compatible con G-SYNC | + | sin datos |
Tecnologías compatibles
Aquí se enumeran las soluciones tecnológicas y las API compatibles con GeForce GTX 1070 Ti y GeForce GTS 450. Esta información es necesaria si su tarjeta de video requiere soporte para tecnologías específicas.
| VR Ready | + | sin datos |
Compatibilidad API
Se enumeran GeForce GTX 1070 Ti y GeForce GTS 450 las APIs compatibles incluyendo sus versiones.
| DirectX | 12 (12_1) | 12 (11_0) |
| El modelo de sombreado | 6.4 | 5.1 |
| OpenGL | 4.6 | 4.6 |
| OpenCL | 1.2 | 1.1 |
| Vulkan | 1.2.131 | N/A |
| CUDA | 6.1 | 2.1 |
Rendimiento sintético de referencia
Estos son los resultados de las pruebas GeForce GTX 1070 Ti y GeForce GTS 450 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.
GTX 1070 Ti supera a GTS 450 en un 1013% 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%
GTX 1070 Ti supera a GTS 450 en un 1012% en Passmark.
3DMark 11 Performance GPU
3DMark 11 es un benchmark obsoleto de DirectX 11 realizado por Futuremark. Utiliza cuatro pruebas basadas en dos escenas, una de ellas con unos submarinos explorando los restos sumergidos de un barco hundido, y la otra con un templo abandonado en lo profundo de la selva. Todas las pruebas están cargadas de iluminación volumétrica y teselación, y a pesar de estar hechas en una resolución de 1280x720, son relativamente exigentes. Descatalogado en enero de 2020, 3DMark 11 ha sido sustituido por Time Spy.
Cobertura de referencia: 17%
GTX 1070 Ti supera a GTS 450 en un 1357% en 3DMark 11 Performance GPU.
3DMark Fire Strike Graphics
Fire Strike es un benchmark DirectX 11 para PCs de juegos. Presenta dos pruebas separadas que muestran una lucha entre un humanoide y una criatura ardiente aparentemente hecha de lava. Con una resolución de 1920x1080, Fire Strike muestra unos gráficos bastante realistas y exige bastante al hardware.
Cobertura de referencia: 14%
GTX 1070 Ti supera a GTS 450 en un 1091% en 3DMark Fire Strike Graphics.
3DMark Cloud Gate GPU
Cloud Gate es un benchmark anticuado de DirectX 11 de nivel 10 que se utilizaba para PCs domésticos y portátiles básicos. Mostraba algunas escenas de algún extraño dispositivo de teletransporte espacial que lanzaba naves espaciales hacia lo desconocido, utilizando una resolución fija de 1280x720. Al igual que el benchmark Ice Storm, ha sido descontinuado en enero de 2020 y reemplazado por 3DMark Night Raid.
Cobertura de referencia: 14%
GTX 1070 Ti supera a GTS 450 en un 608% en 3DMark Cloud Gate GPU.
GeekBench 5 OpenCL
Geekbench 5 es un punto de referencia generalizado de tarjetas gráficas combinado a partir de 11 escenarios de prueba diferentes. Todos estos escenarios se basan en el uso directo de la potencia de procesamiento de la GPU, no se trata de renderizado 3D. Esta variación utiliza la API OpenCL de Khronos Group.
Cobertura de referencia: 9%
GTX 1070 Ti supera a GTS 450 en un 952% en GeekBench 5 OpenCL.
Rendimiento de juego
Los resultados de GeForce GTX 1070 Ti y GeForce GTS 450 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:
| 900p | 300−350
+971%
| 28
−971%
|
| Full HD | 120
+200%
| 40
−200%
|
| 1200p | 300−350
+1011%
| 27
−1011%
|
| 1440p | 78
+1014%
| 7−8
−1014%
|
| 4K | 58
+1060%
| 5−6
−1060%
|
Rendimiento de FPS en juegos populares
Full HD
Low Preset
| Cyberpunk 2077 | 65−70
+1000%
|
6−7
−1000%
|
Full HD
Medium Preset
| Assassin's Creed Odyssey | 80−85
+710%
|
10−11
−710%
|
| Assassin's Creed Valhalla | 65−70
+3200%
|
2−3
−3200%
|
| Battlefield 5 | 120−130
+1657%
|
7−8
−1657%
|
| Call of Duty: Modern Warfare | 75−80
+863%
|
8−9
−863%
|
| Cyberpunk 2077 | 65−70
+1000%
|
6−7
−1000%
|
| Far Cry 5 | 100
+1329%
|
7−8
−1329%
|
| Far Cry New Dawn | 95−100
+956%
|
9−10
−956%
|
| Forza Horizon 4 | 180−190
+895%
|
18−20
−895%
|
| Hitman 3 | 80−85
+913%
|
8−9
−913%
|
| Horizon Zero Dawn | 160−170
+540%
|
24−27
−540%
|
| Metro Exodus | 138
+2660%
|
5−6
−2660%
|
| Red Dead Redemption 2 | 90−95
+900%
|
9−10
−900%
|
| Shadow of the Tomb Raider | 130−140
+886%
|
14−16
−886%
|
| Watch Dogs: Legion | 120−130
+210%
|
40−45
−210%
|
Full HD
High Preset
| Assassin's Creed Odyssey | 80−85
+710%
|
10−11
−710%
|
| Assassin's Creed Valhalla | 65−70
+3200%
|
2−3
−3200%
|
| Battlefield 5 | 60
+757%
|
7−8
−757%
|
| Call of Duty: Modern Warfare | 75−80
+863%
|
8−9
−863%
|
| Cyberpunk 2077 | 65−70
+1000%
|
6−7
−1000%
|
| Far Cry 5 | 82
+1071%
|
7−8
−1071%
|
| Far Cry New Dawn | 44
+389%
|
9−10
−389%
|
| Forza Horizon 4 | 180−190
+895%
|
18−20
−895%
|
| Hitman 3 | 80−85
+913%
|
8−9
−913%
|
| Horizon Zero Dawn | 160−170
+540%
|
24−27
−540%
|
| Metro Exodus | 122
+2340%
|
5−6
−2340%
|
| Red Dead Redemption 2 | 90−95
+900%
|
9−10
−900%
|
| Shadow of the Tomb Raider | 130−140
+886%
|
14−16
−886%
|
| The Witcher 3: Wild Hunt | 75−80
+427%
|
14−16
−427%
|
| Watch Dogs: Legion | 120−130
+210%
|
40−45
−210%
|
Full HD
Ultra Preset
| Assassin's Creed Odyssey | 63
+530%
|
10−11
−530%
|
| Assassin's Creed Valhalla | 65−70
+3200%
|
2−3
−3200%
|
| Call of Duty: Modern Warfare | 75−80
+863%
|
8−9
−863%
|
| Cyberpunk 2077 | 65−70
+1000%
|
6−7
−1000%
|
| Far Cry 5 | 59
+743%
|
7−8
−743%
|
| Forza Horizon 4 | 100
+426%
|
18−20
−426%
|
| Hitman 3 | 80−85
+913%
|
8−9
−913%
|
| Horizon Zero Dawn | 160−170
+540%
|
24−27
−540%
|
| Shadow of the Tomb Raider | 130−140
+886%
|
14−16
−886%
|
| The Witcher 3: Wild Hunt | 72
+380%
|
14−16
−380%
|
| Watch Dogs: Legion | 120−130
+210%
|
40−45
−210%
|
Full HD
Epic Preset
| Red Dead Redemption 2 | 90−95
+900%
|
9−10
−900%
|
1440p
High Preset
| Battlefield 5 | 80
+1233%
|
6−7
−1233%
|
| Far Cry New Dawn | 64
+1180%
|
5−6
−1180%
|
1440p
Ultra Preset
| Assassin's Creed Odyssey | 48
+1500%
|
3−4
−1500%
|
| Assassin's Creed Valhalla | 40−45
+1300%
|
3−4
−1300%
|
| Call of Duty: Modern Warfare | 45−50
+1400%
|
3−4
−1400%
|
| Cyberpunk 2077 | 30−33
+1400%
|
2−3
−1400%
|
| Far Cry 5 | 42
+950%
|
4−5
−950%
|
| Forza Horizon 4 | 210−220
+21400%
|
1−2
−21400%
|
| Hitman 3 | 45−50
+513%
|
8−9
−513%
|
| Horizon Zero Dawn | 80−85
+925%
|
8−9
−925%
|
| Metro Exodus | 76
+1167%
|
6−7
−1167%
|
| Shadow of the Tomb Raider | 90−95
+1050%
|
8−9
−1050%
|
| The Witcher 3: Wild Hunt | 55−60
+2650%
|
2−3
−2650%
|
| Watch Dogs: Legion | 180−190
+800%
|
21−24
−800%
|
1440p
Epic Preset
| Red Dead Redemption 2 | 65−70
+829%
|
7−8
−829%
|
4K
High Preset
| Battlefield 5 | 40
+1900%
|
2−3
−1900%
|
| Far Cry New Dawn | 35
+1650%
|
2−3
−1650%
|
| Hitman 3 | 30−35
+1450%
|
2−3
−1450%
|
| Horizon Zero Dawn | 170−180
+1171%
|
14−16
−1171%
|
| Metro Exodus | 42
+1300%
|
3−4
−1300%
|
| The Witcher 3: Wild Hunt | 47
+1075%
|
4−5
−1075%
|
4K
Ultra Preset
| Assassin's Creed Odyssey | 27
+1250%
|
2−3
−1250%
|
| Assassin's Creed Valhalla | 24−27
+2300%
|
1−2
−2300%
|
| Call of Duty: Modern Warfare | 24−27
+2300%
|
1−2
−2300%
|
| Cyberpunk 2077 | 12−14 | 0−1 |
| Far Cry 5 | 23
+1050%
|
2−3
−1050%
|
| Forza Horizon 4 | 55
+5400%
|
1−2
−5400%
|
| Shadow of the Tomb Raider | 50−55
+1200%
|
4−5
−1200%
|
| Watch Dogs: Legion | 18−20
+1800%
|
1−2
−1800%
|
4K
Epic Preset
| Red Dead Redemption 2 | 30−35
+750%
|
4−5
−750%
|
Así compiten GTX 1070 Ti y GTS 450 en los juegos populares:
- GTX 1070 Ti es 971% más rápido en 900p
- GTX 1070 Ti es 200% más rápido en 1080p
- GTX 1070 Ti es 1011% más rápido en 1200p
- GTX 1070 Ti es 1014% más rápido en 1440p
- GTX 1070 Ti es 1060% más rápido en 4K
Estas son las diferencias de rendimiento observadas en los juegos más populares:
- en Forza Horizon 4, con 1440p resolución y el Ultra Preset, el GTX 1070 Ti es 21400% más rápido.
En definitiva, en juegos populares:
- Sin excepción, GTX 1070 Ti superó a GTS 450 en todas 63 nuestras pruebas.
Resumen de pros y contras
| Clasificación de las prestaciones | 38.05 | 3.42 |
| Novedad | 2 de Noviembre 2017 | 13 de Septiembre 2010 |
| La capacidad máxima de RAM | 8 GB | 1 GB |
| El proceso tecnológico | 16 nm | 40 nm |
| El consumo de energia (TDP) | 180 Vatio | 106 Vatio |
GTX 1070 Ti tiene un 1012.6% más de puntuación agregada de rendimiento, una ventaja de edad de 7 años, un 700% mayor cantidad máxima de VRAM, y un proceso litográfico 150% más avanzado.
GTS 450, por otro lado, tiene 69.8% menor consumo de energía.
El GeForce GTX 1070 Ti es nuestra opción recomendada, ya que supera al GeForce GTS 450 en las pruebas de rendimiento.
Para cualquier duda sobre que elegir GeForce GTX 1070 Ti y GeForce GTS 450 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=3405 and pop.lang="4" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=3405 and pop2.item2=i._id and pop2.lang="4" where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2017-11-02","-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(38.05 - 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=3405 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=3405 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2017-11-02","-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(38.05 - 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=3405 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=3405 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2017-11-02","-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(38.05 - 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_0_3405_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=3405 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=3405 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2017-11-02","-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(38.05 - 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=474 and pop.lang="4" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=474 and pop2.item2=i._id and pop2.lang="4" where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2010-09-13","-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(3.42 - 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=474 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=474 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2010-09-13","-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(3.42 - 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=474 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=474 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2010-09-13","-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(3.42 - 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_0_474_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=474 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=474 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2010-09-13","-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(3.42 - 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=3405 and pop.lang="4" left join ss_stat_exist as pop2 on pop2.item_type="video" and pop2.item1=3405 and pop2.item2=i._id and pop2.lang="4" where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0 and ( if(pop.visits,pop.visits,pop2.visits)>=1 OR ( to_days(now()) - to_days(replace("2017-11-02","-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(38.05 - 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=3405 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=3405 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2017-11-02","-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(38.05 - 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=3405 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=3405 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2017-11-02","-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(38.05 - 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_0_3405_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=3405 and pop.lang="4"
left join
ss_stat_exist as pop2
on pop2.item_type="video" and pop2.item1=3405 and pop2.item2=i._id and pop2.lang="4"
where b.benchmark_id=-1 and i.type="desktop" and i.prof="0" and i._disabled=0
and
(
if(pop.visits,pop.visits,pop2.visits)>=1
OR
(
to_days(now()) - to_days(replace("2017-11-02","-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(38.05 - 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
)
)
