https://romancerelax.iridian.co/index.php/combos/doble-140-x-190/romance/ro

Method
GET
HTTP Status
200
IP
18.119.135.67
Profiled on
Token
72f390

Query Metrics

98 Database Queries
24 Different statements
54.24 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
24.94 ms
(0.00%) 		1 
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.nombre AS nombre_2, p0_.resumen AS resumen_3, p0_.imagen AS imagen_4, p0_.tamanio AS tamanio_5, p0_.tecnologia AS tecnologia_6, p0_.tipologia AS tipologia_7, p0_.adaptabilidad AS adaptabilidad_8, p0_.independencia AS independencia_9, p0_.gamma AS gamma_10, p0_.color_texto AS color_texto_11, p0_.descuento AS descuento_12, p0_.alt AS alt_13, p0_.tela AS tela_14, p0_.maestro AS maestro_15, p0_.principal AS principal_16, p0_.visible AS visible_17, p0_.orden AS orden_18, p0_.dctoic AS dctoic_19, p0_.incarrito AS incarrito_20, m1_.nombre AS nombre_21, m2_.nombre AS nombre_22, l3_.precio AS precio_23, p4_.visible AS visible_24, p4_.id AS id_25 FROM producto p0_ LEFT JOIN producto p4_ ON p0_.padre_id = p4_.id LEFT JOIN lista_precio_item l3_ ON p0_.id = l3_.producto_id LEFT JOIN lista_precios l5_ ON l3_.lista_id = l5_.id LEFT JOIN medidas m1_ ON p0_.medidas_id = m1_.id LEFT JOIN material m2_ ON p0_.material_id = m2_.id LEFT JOIN producto_categoria p7_ ON p0_.id = p7_.producto_id LEFT JOIN categoria c6_ ON c6_.id = p7_.categoria_id WHERE p0_.id IN (?) AND ((p0_.padre_id IS NULL AND p0_.visible = 1) OR (p4_.visible = 1)) AND l5_.id = ? AND c6_.id = 2 AND m1_.id IN (960) GROUP BY p0_.maestro ORDER BY p0_.orden ASC
Parameters: 
[
  [
    "90076168"
    "90076169"
    "90076195"
    "90076196"
    "90078497"
    "90078498"
    "90078499"
    "90078500"
    "90078501"
    "90078696"
    "90078697"
    "90078698"
    "90078699"
    "90078700"
    "90078701"
    "90078702"
    "90078703"
    "90080111"
    "90080112"
    "90080114"
    "90080115"
    "90080117"
    "90080118"
    "90080120"
    "90080121"
    "90080123"
    "90080124"
    "90080557"
    "90080558"
    "90080559"
    "90080850"
    "90080851"
    "90080852"
    "90080853"
    "90080893"
    "90080894"
    "90080895"
    "90080896"
    "90080897"
    "90080911"
    "90080912"
    "90080913"
    "90080914"
    "90080915"
    "90080916"
    "90080917"
    "90080918"
    "90080919"
    "90080920"
    "90080921"
    "90080922"
    "90080923"
    "90080924"
    "90080925"
    "90080926"
    "90080927"
    "90080938"
    "90080939"
    "90080940"
    "90080941"
    "90080956"
    "90080957"
    "90080958"
    "90080962"
    "90080963"
    "90080964"
    "90080965"
    "90080966"
    "90080970"
    "90080971"
    "90081289"
    "90081290"
    "90081291"
    "90081292"
    "90081293"
    "90081304"
    "90081305"
    "90081306"
    "90081307"
    "90081308"
    "90081484"
    "90081509"
    "90081510"
    "90081511"
    "90081512"
    "90081513"
    "90081524"
    "90081525"
    "90081526"
    "90081527"
    "90082221"
    "90082222"
    "90082223"
    "90082227"
    "90082228"
    "90082229"
    "90082661"
    "90082662"
    "90082663"
    "90082664"
    "90082665"
    "90082677"
    "90082678"
    "90082679"
    "90082680"
    "90082681"
    "90082693"
    "90082694"
    "90082695"
    "90082696"
    "90082697"
    "90082713"
    "90082715"
    "90082716"
    "90082717"
    "90082718"
    "90082719"
    "90082720"
    "90082721"
    "90082722"
    "90082723"
    "90082744"
    "90082745"
    "90082746"
    "90082747"
    "90082748"
    "90082749"
    "90082750"
    "90082751"
    "90082752"
    "90082753"
    "90082774"
    "90082775"
    "90082776"
    "90082777"
    "90082778"
    "90082779"
    "90082780"
    "90082781"
    "90082782"
    "90082783"
    "90078487"
    "90078488"
    "90078489"
    "90078490"
    "90078491"
    "90078493"
    "90078494"
    "90078495"
    "90078496"
    "90080883"
    "90080884"
    "90080885"
    "90080886"
    "90080887"
    "90080889"
    "90080890"
    "90080891"
    "90080892"
    "90080928"
    "90080929"
    "90080930"
    "90080931"
    "90080932"
    "90080934"
    "90080935"
    "90080936"
    "90080937"
    "90081279"
    "90081280"
    "90081281"
    "90081282"
    "90081283"
    "90081285"
    "90081286"
    "90081287"
    "90081288"
    "90081294"
    "90081295"
    "90081296"
    "90081297"
    "90081298"
    "90081300"
    "90081301"
    "90081302"
    "90081303"
    "90081499"
    "90081500"
    "90081501"
    "90081502"
    "90081503"
    "90081505"
    "90081506"
    "90081507"
    "90081508"
    "90081514"
    "90081515"
    "90081516"
    "90081517"
    "90081518"
    "90081520"
    "90081521"
    "90081522"
    "90081523"
    "90082656"
    "90082657"
    "90082658"
    "90082659"
    "90082660"
    "90082671"
    "90082672"
    "90082673"
    "90082675"
    "90082676"
    "90082687"
    "90082688"
    "90082690"
    "90082691"
    "90082692"
    "90082703"
    "90082704"
    "90082705"
    "90082706"
    "90082707"
    "90082708"
    "90082709"
    "90082710"
    "90082711"
    "90082712"
    "90082734"
    "90082735"
    "90082736"
    "90082737"
    "90082738"
    "90082739"
    "90082740"
    "90082741"
    "90082742"
    "90082743"
    "90082764"
    "90082765"
    "90082766"
    "90082767"
    "90082768"
    "90082769"
    "90082770"
    "90082771"
    "90082772"
    "90082773"
    "90078508"
    "90078509"
    "90078510"
    "90078511"
    "90080091"
    "90080092"
    "90080094"
    "90080095"
    "90080097"
    "90080098"
    "90080100"
    "90080101"
    "90080103"
    "90080104"
    "90080841"
    "90080842"
    "90080843"
    "90080844"
    "90080845"
    "90080846"
    "90080847"
    "90080848"
    "90080900"
    "90080901"
    "90080902"
    "90080904"
    "90080905"
    "90080906"
    "90080907"
    "90080908"
    "90080947"
    "90080948"
    "90080949"
    "90080950"
    "90080951"
    "90080952"
    "90080953"
    "90080954"
    "90080955"
    "90080959"
    "90082224"
    "90082225"
    "90082226"
    "90082666"
    "90082667"
    "90082668"
    "90082669"
    "90082670"
    "90082682"
    "90082683"
    "90082684"
    "90082685"
    "90082686"
    "90082698"
    "90082699"
    "90082700"
    "90082701"
    "90082702"
    "90082724"
    "90082725"
    "90082726"
    "90082727"
    "90082728"
    "90082729"
    "90082730"
    "90082731"
    "90082732"
    "90082733"
    "90082754"
    "90082755"
    "90082756"
    "90082757"
    "90082758"
    "90082759"
    "90082760"
    "90082761"
    "90082762"
    "90082763"
    "90082785"
    "90082786"
    "90082787"
    "90082788"
    "90082789"
    "90082790"
    "90082791"
    "90082792"
    "90082793"
    "90082794"
    "90078513"
    "90078514"
    "90078515"
    "90078516"
    "90080144"
    "90080147"
    "90080150"
    "90080153"
    "90080831"
    "90080832"
    "90080833"
    "90080834"
    "90080835"
    "90080836"
    "90080837"
    "90080838"
    "90080943"
    "90080944"
    "90080945"
    "90080946"
  ]
  1
]
View formatted query    View runnable query    Explain query
8.39 ms
(0.00%) 		1 
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.nombre AS nombre_2, p0_.resumen AS resumen_3, p0_.imagen AS imagen_4, p0_.tamanio AS tamanio_5, p0_.tecnologia AS tecnologia_6, p0_.tipologia AS tipologia_7, p0_.adaptabilidad AS adaptabilidad_8, p0_.independencia AS independencia_9, p0_.gamma AS gamma_10, p0_.color_texto AS color_texto_11, p0_.descuento AS descuento_12, p0_.alt AS alt_13, p0_.tela AS tela_14, p0_.maestro AS maestro_15, p0_.principal AS principal_16, p0_.visible AS visible_17, p0_.orden AS orden_18, p0_.dctoic AS dctoic_19, p0_.incarrito AS incarrito_20, m1_.nombre AS nombre_21, m2_.nombre AS nombre_22, l3_.precio AS precio_23 FROM producto p4_ LEFT JOIN producto p0_ ON p4_.padre_id = p0_.id LEFT JOIN lista_precio_item l3_ ON p0_.id = l3_.producto_id LEFT JOIN lista_precios l5_ ON l3_.lista_id = l5_.id LEFT JOIN medidas m1_ ON p0_.medidas_id = m1_.id LEFT JOIN material m2_ ON p0_.material_id = m2_.id LEFT JOIN producto_categoria p7_ ON p0_.id = p7_.producto_id LEFT JOIN categoria c6_ ON c6_.id = p7_.categoria_id WHERE p4_.id IN (?) AND p0_.id IS NOT NULL AND l5_.id = ? AND c6_.id = 2 AND m1_.id IN (960) GROUP BY p0_.maestro ORDER BY p0_.orden ASC
Parameters: 
[
  [
    "90076168"
    "90076169"
    "90076195"
    "90076196"
    "90078497"
    "90078498"
    "90078499"
    "90078500"
    "90078501"
    "90078696"
    "90078697"
    "90078698"
    "90078699"
    "90078700"
    "90078701"
    "90078702"
    "90078703"
    "90080111"
    "90080112"
    "90080114"
    "90080115"
    "90080117"
    "90080118"
    "90080120"
    "90080121"
    "90080123"
    "90080124"
    "90080557"
    "90080558"
    "90080559"
    "90080850"
    "90080851"
    "90080852"
    "90080853"
    "90080893"
    "90080894"
    "90080895"
    "90080896"
    "90080897"
    "90080911"
    "90080912"
    "90080913"
    "90080914"
    "90080915"
    "90080916"
    "90080917"
    "90080918"
    "90080919"
    "90080920"
    "90080921"
    "90080922"
    "90080923"
    "90080924"
    "90080925"
    "90080926"
    "90080927"
    "90080938"
    "90080939"
    "90080940"
    "90080941"
    "90080956"
    "90080957"
    "90080958"
    "90080962"
    "90080963"
    "90080964"
    "90080965"
    "90080966"
    "90080970"
    "90080971"
    "90081289"
    "90081290"
    "90081291"
    "90081292"
    "90081293"
    "90081304"
    "90081305"
    "90081306"
    "90081307"
    "90081308"
    "90081484"
    "90081509"
    "90081510"
    "90081511"
    "90081512"
    "90081513"
    "90081524"
    "90081525"
    "90081526"
    "90081527"
    "90082221"
    "90082222"
    "90082223"
    "90082227"
    "90082228"
    "90082229"
    "90082661"
    "90082662"
    "90082663"
    "90082664"
    "90082665"
    "90082677"
    "90082678"
    "90082679"
    "90082680"
    "90082681"
    "90082693"
    "90082694"
    "90082695"
    "90082696"
    "90082697"
    "90082713"
    "90082715"
    "90082716"
    "90082717"
    "90082718"
    "90082719"
    "90082720"
    "90082721"
    "90082722"
    "90082723"
    "90082744"
    "90082745"
    "90082746"
    "90082747"
    "90082748"
    "90082749"
    "90082750"
    "90082751"
    "90082752"
    "90082753"
    "90082774"
    "90082775"
    "90082776"
    "90082777"
    "90082778"
    "90082779"
    "90082780"
    "90082781"
    "90082782"
    "90082783"
    "90078487"
    "90078488"
    "90078489"
    "90078490"
    "90078491"
    "90078493"
    "90078494"
    "90078495"
    "90078496"
    "90080883"
    "90080884"
    "90080885"
    "90080886"
    "90080887"
    "90080889"
    "90080890"
    "90080891"
    "90080892"
    "90080928"
    "90080929"
    "90080930"
    "90080931"
    "90080932"
    "90080934"
    "90080935"
    "90080936"
    "90080937"
    "90081279"
    "90081280"
    "90081281"
    "90081282"
    "90081283"
    "90081285"
    "90081286"
    "90081287"
    "90081288"
    "90081294"
    "90081295"
    "90081296"
    "90081297"
    "90081298"
    "90081300"
    "90081301"
    "90081302"
    "90081303"
    "90081499"
    "90081500"
    "90081501"
    "90081502"
    "90081503"
    "90081505"
    "90081506"
    "90081507"
    "90081508"
    "90081514"
    "90081515"
    "90081516"
    "90081517"
    "90081518"
    "90081520"
    "90081521"
    "90081522"
    "90081523"
    "90082656"
    "90082657"
    "90082658"
    "90082659"
    "90082660"
    "90082671"
    "90082672"
    "90082673"
    "90082675"
    "90082676"
    "90082687"
    "90082688"
    "90082690"
    "90082691"
    "90082692"
    "90082703"
    "90082704"
    "90082705"
    "90082706"
    "90082707"
    "90082708"
    "90082709"
    "90082710"
    "90082711"
    "90082712"
    "90082734"
    "90082735"
    "90082736"
    "90082737"
    "90082738"
    "90082739"
    "90082740"
    "90082741"
    "90082742"
    "90082743"
    "90082764"
    "90082765"
    "90082766"
    "90082767"
    "90082768"
    "90082769"
    "90082770"
    "90082771"
    "90082772"
    "90082773"
    "90078508"
    "90078509"
    "90078510"
    "90078511"
    "90080091"
    "90080092"
    "90080094"
    "90080095"
    "90080097"
    "90080098"
    "90080100"
    "90080101"
    "90080103"
    "90080104"
    "90080841"
    "90080842"
    "90080843"
    "90080844"
    "90080845"
    "90080846"
    "90080847"
    "90080848"
    "90080900"
    "90080901"
    "90080902"
    "90080904"
    "90080905"
    "90080906"
    "90080907"
    "90080908"
    "90080947"
    "90080948"
    "90080949"
    "90080950"
    "90080951"
    "90080952"
    "90080953"
    "90080954"
    "90080955"
    "90080959"
    "90082224"
    "90082225"
    "90082226"
    "90082666"
    "90082667"
    "90082668"
    "90082669"
    "90082670"
    "90082682"
    "90082683"
    "90082684"
    "90082685"
    "90082686"
    "90082698"
    "90082699"
    "90082700"
    "90082701"
    "90082702"
    "90082724"
    "90082725"
    "90082726"
    "90082727"
    "90082728"
    "90082729"
    "90082730"
    "90082731"
    "90082732"
    "90082733"
    "90082754"
    "90082755"
    "90082756"
    "90082757"
    "90082758"
    "90082759"
    "90082760"
    "90082761"
    "90082762"
    "90082763"
    "90082785"
    "90082786"
    "90082787"
    "90082788"
    "90082789"
    "90082790"
    "90082791"
    "90082792"
    "90082793"
    "90082794"
    "90078513"
    "90078514"
    "90078515"
    "90078516"
    "90080144"
    "90080147"
    "90080150"
    "90080153"
    "90080831"
    "90080832"
    "90080833"
    "90080834"
    "90080835"
    "90080836"
    "90080837"
    "90080838"
    "90080943"
    "90080944"
    "90080945"
    "90080946"
  ]
  1
]
View formatted query    View runnable query    Explain query
3.47 ms
(0.00%) 		25 
SELECT p0_.principal AS principal_0, p0_.id AS id_1, p0_.medida AS medida_2, p0_.nombre AS nombre_3, p0_.tamanio AS tamanio_4, p0_.maestro AS maestro_5, m1_.nombre AS nombre_6, m1_.id AS id_7 FROM producto p0_ LEFT JOIN medidas m1_ ON p0_.medidas_id = m1_.id WHERE m1_.id IS NOT NULL AND p0_.maestro = ? ORDER BY p0_.medida ASC
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
2.61 ms
(0.00%) 		1 
SELECT Max(l0_.precio) AS sclr_0 FROM producto p1_ LEFT JOIN lista_precio_item l0_ ON p1_.id = l0_.producto_id LEFT JOIN lista_precios l2_ ON l0_.lista_id = l2_.id LEFT JOIN medidas m3_ ON p1_.medidas_id = m3_.id LEFT JOIN material m4_ ON p1_.material_id = m4_.id LEFT JOIN producto_categoria p6_ ON p1_.id = p6_.producto_id LEFT JOIN categoria c5_ ON c5_.id = p6_.categoria_id WHERE p1_.visible = 1 AND l2_.id = ? AND c5_.id = 2 AND m3_.id IN (960) LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
2.51 ms
(0.00%) 		1 
SELECT Min(l0_.precio) AS sclr_0 FROM producto p1_ LEFT JOIN lista_precio_item l0_ ON p1_.id = l0_.producto_id LEFT JOIN lista_precios l2_ ON l0_.lista_id = l2_.id LEFT JOIN medidas m3_ ON p1_.medidas_id = m3_.id LEFT JOIN material m4_ ON p1_.material_id = m4_.id LEFT JOIN producto_categoria p6_ ON p1_.id = p6_.producto_id LEFT JOIN categoria c5_ ON c5_.id = p6_.categoria_id WHERE p1_.visible = 1 AND l2_.id = ? AND c5_.id = 2 AND m3_.id IN (960) LIMIT 1
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
2.12 ms
(0.00%) 		1 
SELECT m0_.id AS id_0 FROM medidas m0_ LEFT JOIN categoria c1_ ON m0_.categoria_id = c1_.id WHERE m0_.nombre LIKE ? AND c1_.id = ? GROUP BY m0_.id
Parameters: 
[
  "%doble 140 x 190%"
  2
]
View formatted query    View runnable query    Explain query
1.77 ms
(0.00%) 		12 
SELECT i0_.id AS id_0, i0_.image AS image_1, i0_.orden AS orden_2, i0_.visible AS visible_3, i0_.updated_at AS updated_at_4, i0_.titulo AS titulo_5, i0_.descripcion AS descripcion_6, i0_.ver_mas AS ver_mas_7, i0_.llave AS llave_8, i0_.link AS link_9, i0_.alt AS alt_10, i0_.fechaini AS fechaini_11, i0_.fechafin AS fechafin_12, i0_.galeria_id AS galeria_id_13, i0_.producto_id AS producto_id_14, i0_.tienda_id AS tienda_id_15 FROM image i0_ LEFT JOIN galeria g1_ ON i0_.galeria_id = g1_.id WHERE g1_.llave = ? AND i0_.visible = 1 ORDER BY i0_.orden ASC
Parameters: 
[
  "direcciones_fabricas_footer"
]
View formatted query    View runnable query    Explain query
1.36 ms
(0.00%) 		1 
SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.titulo AS titulo_2, s0_.descripcion AS descripcion_3, s0_.imagen AS imagen_4, s0_.producto_id AS producto_id_5 FROM seo s0_ WHERE s0_.url = ? ORDER BY s0_.id DESC LIMIT 1
Parameters: 
[
  "/combos/doble-140-x-190/romance/ro"
]
View formatted query    View runnable query    Explain query
1.27 ms
(0.00%) 		9 
SELECT s0_.id AS id_0, s0_.nombre AS nombre_1, s0_.referencia AS referencia_2, s0_.icono_blanco AS icono_blanco_3, s0_.icono AS icono_4, s0_.slug AS slug_5, c1_.nombre AS nombre_6, s0_.descripcion AS descripcion_7, s0_.imagen AS imagen_8, s0_.avatar AS avatar_9, v2_.idyoutube AS idyoutube_10 FROM producto p3_ LEFT JOIN subcategoria s0_ ON p3_.subcategoria_id = s0_.id LEFT JOIN video v2_ ON s0_.id = v2_.subcategoria_id LEFT JOIN categoria c1_ ON s0_.categoria_id = c1_.id WHERE c1_.id = ? AND s0_.visible = 1 GROUP BY s0_.id ORDER BY s0_.orden ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
0.99 ms
(0.00%) 		12 
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.orden AS orden_2, c0_.clasificacion_id AS clasificacion_id_3, c0_.categoria_id AS categoria_id_4 FROM clasifconcateg c0_ LEFT JOIN categoria c1_ ON c0_.categoria_id = c1_.id WHERE c1_.id = ? GROUP BY c0_.id ORDER BY c0_.orden ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.67 ms
(0.00%) 		8 
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.referencia AS referencia_2, m0_.icono AS icono_3 FROM medidas m0_ LEFT JOIN producto p1_ ON m0_.id = p1_.medidas_id LEFT JOIN categoria c2_ ON m0_.categoria_id = c2_.id WHERE c2_.id = ? AND m0_.visible = 1 AND p1_.visible = 1 GROUP BY m0_.id ORDER BY m0_.orden ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.67 ms
(0.00%) 		1 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.imagen AS imagen_4, t0.orden AS orden_5, t0.visible AS visible_6, t0.home AS home_7, t0.referencia AS referencia_8, t0.imagen_desplegable AS imagen_desplegable_9, t0.product_destac AS product_destac_10, t0.desplegable AS desplegable_11, t0.slug AS slug_12, t0.img_banner AS img_banner_13, t0.img_banner_mobile AS img_banner_mobile_14, t0.segmento_id AS segmento_id_15 FROM categoria t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "combos"
]
View formatted query    View runnable query    Explain query
0.57 ms
(0.00%) 		7 
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.referencia AS referencia_2, m0_.icono AS icono_3 FROM material m0_ LEFT JOIN producto p1_ ON m0_.id = p1_.material_id LEFT JOIN categoria c2_ ON m0_.categoria_id = c2_.id WHERE c2_.id = ? AND m0_.visible = 1 AND p1_.visible = 1 GROUP BY m0_.id ORDER BY m0_.orden ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.47 ms
(0.00%) 		5 
SELECT DISTINCT p0_.maestro AS maestro_0, p0_.id AS id_1, p0_.nombre AS nombre_2, p0_.imagen AS imagen_3, p0_.resumen AS resumen_4, p0_.orden AS orden_5, p0_.descuento AS descuento_6, p0_.nuevo AS nuevo_7 FROM producto p0_ LEFT JOIN subcategoria s1_ ON p0_.subcategoria_id = s1_.id LEFT JOIN categoria c2_ ON s1_.categoria_id = c2_.id WHERE c2_.id = ? AND p0_.visible = 1 ORDER BY p0_.orden ASC LIMIT 5
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.37 ms
(0.00%) 		1 
SELECT i0_.id AS id_0, i0_.image AS image_1, i0_.orden AS orden_2, i0_.visible AS visible_3, i0_.updated_at AS updated_at_4, i0_.titulo AS titulo_5, i0_.descripcion AS descripcion_6, i0_.ver_mas AS ver_mas_7, i0_.llave AS llave_8, i0_.link AS link_9, i0_.alt AS alt_10, i0_.fechaini AS fechaini_11, i0_.fechafin AS fechafin_12 FROM image i0_ WHERE i0_.llave IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.34 ms
(0.00%) 		1 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.codigo AS codigo_3 FROM lista_precios t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.34 ms
(0.00%) 		1 
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.updated_at AS updated_at_3 FROM setting s0_ WHERE s0_.name IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.29 ms
(0.00%) 		1 
SELECT p0_.nombre AS nombre_0, p0_.id AS id_1 FROM codigo_descuento c1_ LEFT JOIN codigo_descuento_producto c2_ ON c1_.id = c2_.codigo_descuento_id LEFT JOIN producto p0_ ON p0_.id = c2_.producto_id WHERE c1_.incarrito = 1 AND c1_.activo = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.27 ms
(0.00%) 		3 
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.imagen AS imagen_2, c0_.imagen_desplegable AS imagen_desplegable_3, c0_.slug AS slug_4, c0_.desplegable AS desplegable_5, c0_.orden AS orden_6 FROM categoria c0_ LEFT JOIN producto_categoria p2_ ON c0_.id = p2_.categoria_id LEFT JOIN producto p1_ ON p1_.id = p2_.producto_id WHERE c0_.visible = 1 GROUP BY c0_.id, c0_.nombre, c0_.resumen, c0_.imagen, c0_.orden, c0_.visible, c0_.home, c0_.referencia, c0_.imagen_desplegable, c0_.product_destac, c0_.desplegable, c0_.slug, c0_.img_banner, c0_.img_banner_mobile, c0_.segmento_id ORDER BY c0_.orden ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.26 ms
(0.00%) 		1 
SELECT p0_.id AS id_0 FROM producto p0_ LEFT JOIN subcategoria s1_ ON p0_.subcategoria_id = s1_.id LEFT JOIN categoria c2_ ON s1_.categoria_id = c2_.id WHERE p0_.visible = 1 AND c2_.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
0.15 ms
(0.00%) 		2 
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.imagen AS imagen_4, t0.orden AS orden_5, t0.visible AS visible_6, t0.home AS home_7, t0.referencia AS referencia_8, t0.imagen_desplegable AS imagen_desplegable_9, t0.product_destac AS product_destac_10, t0.desplegable AS desplegable_11, t0.slug AS slug_12, t0.img_banner AS img_banner_13, t0.img_banner_mobile AS img_banner_mobile_14, t0.segmento_id AS segmento_id_15 FROM categoria t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.14 ms
(0.00%) 		1 
SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor_es AS valor_es_2, t0_.valor_en AS valor_en_3, t0_.valor_fr AS valor_fr_4, t0_.valor AS valor_5 FROM texto t0_ WHERE t0_.llave IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.13 ms
(0.00%) 		1 
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.orden AS orden_2 FROM clasificacion c0_ ORDER BY c0_.orden ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.13 ms
(0.00%) 		1 
SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.titulo AS titulo_2, s0_.descripcion AS descripcion_3, s0_.imagen AS imagen_4, s0_.producto_id AS producto_id_5 FROM seo s0_ ORDER BY s0_.id ASC LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Producto
  • The field App\Entity\Producto#hijos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Producto#padre does not contain the required 'inversedBy="hijos"' attribute.
App\Entity\Categoria No errors.
App\Entity\Segmento No errors.
App\Entity\SuperGrupo No errors.
App\Entity\Subcategoria No errors.
App\Entity\Combinaciones
  • The mappings App\Entity\Combinaciones#itemcombinaciones and App\Entity\Itemcombinaciones#combinacion are inconsistent with each other.
App\Entity\Medidas No errors.
App\Entity\Material No errors.
App\Entity\Descuento No errors.
App\Entity\Firmeza No errors.
App\Entity\Clasificacion No errors.
App\Entity\Clasifconcateg No errors.
App\Entity\CodigoDescuento No errors.
App\Entity\Video No errors.
App\Entity\ListaPrecios No errors.
App\Entity\ListaPrecioItem No errors.
App\Entity\Image No errors.
App\Entity\Setting No errors.
App\Entity\Seo No errors.
App\Entity\Texto No errors.
App\Entity\Galeria No errors.
App\Entity\TiendaInfo No errors.
App\Entity\Punto No errors.