0 of 0   
MySQL {#574 ▼
  #filters: ArrayCollection {#575 ▶
    -elements: []
  }
  #operationsFilters: ArrayCollection {#577 ▶
    -elements: []
  }
  #selectFields: ArrayCollection {#585 ▶
    -elements: array:1 [▶
      0 => "id_product"
    ]
  }
  #groupFields: ArrayCollection {#581 ▶
    -elements: []
  }
  #orderField: ""
  #orderDirection: "DESC"
  #limit: null
  #offset: 0
  #initialPopulation: MySQL {#576 ▶
    #filters: ArrayCollection {#580 ▶
      -elements: array:3 [▶
        "id_category" => array:1 [▶
          "=" => array:1 [▶
            0 => array:1 [▶
              0 => 1584
            ]
          ]
        ]
        "visibility" => array:1 [▶
          "=" => array:1 [▶
            0 => array:2 [▶
              0 => "both"
              1 => "catalog"
            ]
          ]
        ]
        "id_shop" => array:1 [▶
          "=" => array:1 [▶
            0 => array:1 [▶
              0 => 1
            ]
          ]
        ]
      ]
    }
    #operationsFilters: ArrayCollection {#582 ▶
      -elements: array:1 [▶
        "with_features_3" => array:1 [▶
          0 => array:1 [▶
            0 => array:2 [▶
              0 => "id_feature_value"
              1 => array:5 [▶
                0 => "37727"
                1 => "37800"
                2 => "37812"
                3 => "37816"
                4 => "30242"
              ]
            ]
          ]
        ]
      ]
    }
    #selectFields: ArrayCollection {#584 ▶
      -elements: array:7 [▶
        0 => "id_product"
        1 => "id_manufacturer"
        2 => "quantity"
        3 => "condition"
        4 => "weight"
        5 => "price"
        6 => "sales"
      ]
    }
    #groupFields: ArrayCollection {#583 ▶
      -elements: array:1 [▶
        0 => "id_product"
      ]
    }
    #orderField: ""
    #orderDirection: "DESC"
    #limit: null
    #offset: 0
    #initialPopulation: null
  }
}

"SELECT p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.date_upd FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) LEFT JOIN ps_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature_value IN (37727, 37800, 37812, 37816, 30242))) AND cp.id_category='1584' AND p.visibility IN ('both', 'catalog') AND ps.id_shop='1' GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.date_upd DESC, p.id_product DESC LIMIT 0, 12 ◀SELECT p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.date ▶"
Fundas Smartphones - Accesorios vars javascript

Filtrar por

modelo

modelo

marca

marca

Fundas Smartphones - Accesorios

Fundas Smartphones

Fundas Smartphones

Filtros activos

  • modelo: Redmi 10C
  • modelo: Redmi Note 8
  • modelo: Redmi Note 12
  • modelo: Redmi Note 13 5G
  • modelo: iPhone 15 Plus
Ir arriba
external javascript

Utilizamos cookies para mejorar su experiencia de compra. Usted podrá seleccionar las cookies nuestras y de terceros que desee utilizar en cualquier momento.

Ver política de cookies
Aceptar todo Rechazar todo Configurar cookies