Carnivine – SS5 Battle Styles | Carta POKEMON en México
zoom_in
    • Carnivine – SS5 Battle Styles | Carta POKEMON en México

    Carnivine

    $3.00
    Carta Carnivine de POKEMON – SS5 Battle Styles. Compra segura en ProCards México con stock disponible y envíos rápidos.
    Cantidad

    🧃 ¡Quedan 10 en stock!
    ✨ Obtendrás $0.03 en recompensa 🎁 al comprar 1 de este producto 🛒.
    Cerrar

    Carnivine – Carta POKEMON

    Compra Carnivine de la expansión SS5 Battle Styles en ProCards México. Carta original 100% auténtica.

    Detalles de la carta

    • Juego: POKEMON
    • Expansión: SS5 Battle Styles

    Stock disponible y envíos rápidos a todo México. Compra segura y atención especializada en TCG.

    SWBTS009
    10 Artículos

    Referencias Específicas

    8 otros productos en la categoría

    Bruno

    Pokemon TCG Intenational · SS5 Battle Styles

    Disponibles: 12

      Load Time 369.350 ms
      Querying Time 106 ms
      Queries 438
      Memory Peak Usage 16.9 Mb
      Included Files 978 files - 11.88 Mb
      PrestaShop Cache - Mb
      Global vars 0.91 Mb
      PrestaShop Version 8.2.4
      PHP Version 8.1.34
      MySQL Version 10.5.29-MariaDB
      Memory Limit 1024M
      Max Execution Time 300s
      Smarty Cache enabled
      Smarty Compilation never recompile
        Time Cumulated Time Memory Usage Memory Peak Usage
      config 85.841 ms 85.841 ms 3.18 Mb 3.6 Mb
      __construct 0.011 ms 85.852 ms - Mb 3.6 Mb
      init 30.169 ms 116.021 ms 1.40 Mb 4.8 Mb
      checkAccess 0.002 ms 116.023 ms - Mb 4.8 Mb
      setMedia 3.588 ms 119.611 ms 0.05 Mb 4.8 Mb
      postProcess 0.004 ms 119.615 ms - Mb 4.8 Mb
      initHeader 0.001 ms 119.616 ms - Mb 4.8 Mb
      initContent 51.936 ms 171.552 ms 1.85 Mb 6.8 Mb
      initFooter 0.002 ms 171.554 ms - Mb 6.8 Mb
      display 197.796 ms 369.350 ms 10.18 Mb 16.9 Mb
      Hook Time Memory Usage
      displayFooterProduct 120.310 ms 8.15 Mb
      DisplayProductAdditionalInfo 29.287 ms 2.38 Mb
      DisplayHeader 27.722 ms 0.21 Mb
      DisplayProductButtons 18.948 ms 1.88 Mb
      ActionOutputHTMLBefore 13.446 ms 0.18 Mb
      displayProductAdditionalInfo 9.450 ms 0.07 Mb
      DisplayProductListReviews 9.007 ms 0.54 Mb
      Header 5.407 ms 0.01 Mb
      displayFooter 4.704 ms 0.21 Mb
      displayTop 2.894 ms 0.11 Mb
      DisplayBeforeBodyClosingTag 2.668 ms 0.05 Mb
      DisplayFooter 2.201 ms 0.03 Mb
      Ybccustom1 1.745 ms 0.03 Mb
      DisplayTop 1.520 ms 0.03 Mb
      YbcCustom2 1.315 ms 0.02 Mb
      ActionFrontControllerSetMedia 1.297 ms 0.01 Mb
      DisplayProductActions 1.168 ms 0.03 Mb
      displayFooterBefore 1.101 ms 0.05 Mb
      displayNav2 0.980 ms 0.04 Mb
      DisplayMegaMenu 0.915 ms 0.08 Mb
      displayNav1 0.908 ms 0.10 Mb
      DisplayProductPriceBlock 0.853 ms 0.01 Mb
      ActionBuildFrontEndObject 0.088 ms 0.01 Mb
      ActionObjectAddAfter 0.022 ms - Mb
      ActionObjectUpdateAfter 0.010 ms - Mb
      DisplayFooterBefore 0.007 ms - Mb
      ActionFrontControllerInitAfter 0.005 ms - Mb
      ModuleRoutes 0.004 ms - Mb
      ActionDispatcherBefore 0.003 ms - Mb
      29 hook(s) 257.985 ms 14.23 Mb
      Module Time Memory Usage
      preorderandnotification 34.238 ms 2.54 Mb
      ets_superspeed 21.691 ms 0.32 Mb
      ets_onepagecheckout 1.333 ms 0.07 Mb
      ets_affiliatemarketing 32.220 ms 2.70 Mb
      ps_emailsubscription 1.858 ms 0.06 Mb
      blockreassurance 0.629 ms 0.01 Mb
      ps_socialfollow 1.484 ms 0.05 Mb
      ps_emailalerts 2.566 ms 0.02 Mb
      ps_shoppingcart 2.312 ms 0.08 Mb
      ps_searchbar 3.447 ms 0.05 Mb
      pleasewait 0.587 ms 0.18 Mb
      ets_homecategories 1.700 ms 0.04 Mb
      ybc_themeconfig 8.357 ms 0.16 Mb
      ybc_widget 7.027 ms 0.11 Mb
      ets_megamenu 6.639 ms 0.72 Mb
      eicaptcha 0.726 ms 0.07 Mb
      ets_wishlist_pres17 12.944 ms 0.32 Mb
      amazzingfilter 0.451 ms 0.01 Mb
      mercadopago 3.054 ms - Mb
      clippay 1.308 ms 0.02 Mb
      ps_languageselector 0.485 ms 0.05 Mb
      ps_currencyselector 0.674 ms 0.13 Mb
      ps_customersignin 1.099 ms 0.05 Mb
      ps_sharebuttons 9.598 ms 0.08 Mb
      ps_viewedproduct 0.507 ms 0.11 Mb
      ps_categoryproducts 120.073 ms 8.12 Mb
      ps_contactinfo 1.526 ms 0.07 Mb
      ps_customeraccountlinks 1.213 ms 0.06 Mb
      ps_linklist 1.849 ms 0.06 Mb
      statsdata 1.877 ms 0.05 Mb
      30 module(s) 283.472 ms 16.13 Mb

      Stopwatch SQL - 438 queries

      # Query Time (ms) Rows Filesort Group By Location
      166
      SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
      pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
      il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
      DATEDIFF(product_shop.`date_add`, DATE_SUB("2026-03-16 00:00:00",
      INTERVAL 365 DAY)) > 0 AS new, product_shop.price AS orderprice
      FROM `ps_category_product` cp
      LEFT JOIN `ps_product` p
      ON p.`id_product` = cp.`id_product`
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      LEFT JOIN ps_stock_available stock
      ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
      LEFT JOIN `ps_category_lang` cl
      ON (product_shop.`id_category_default` = cl.`id_category`
      AND cl.`id_lang` = 2 AND cl.id_shop = 1 )
      LEFT JOIN `ps_product_lang` pl
      ON (p.`id_product` = pl.`id_product`
      AND pl.`id_lang` = 2 AND pl.id_shop = 1 )
      LEFT JOIN `ps_image_shop` image_shop
      ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
      LEFT JOIN `ps_image_lang` il
      ON (image_shop.`id_image` = il.`id_image`
      AND il.`id_lang` = 2)
      LEFT JOIN `ps_manufacturer` m
      ON m.`id_manufacturer` = p.`id_manufacturer`
      WHERE product_shop.`id_shop` = 1
      AND cp.`id_category` = 171 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 9
      6.234 ms 306 Yes /classes/Category.php:1062
      2
      SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
      FROM `ps_configuration` c
      LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
      2.316 ms 1610 /classes/Configuration.php:180
      18
      SELECT SQL_NO_CACHE `id_hook`, `name`
      FROM `ps_hook`
      UNION
      SELECT `id_hook`, ha.`alias` as name
      FROM `ps_hook_alias` ha
      INNER JOIN `ps_hook` h ON ha.name = h.name
      1.555 ms 0 /classes/Hook.php:1348
      249
      SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
      WHERE cp.`id_category` = 171 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
      1.373 ms 306 /classes/Category.php:991
      13
      SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
      FROM `ps_module` m
      INNER JOIN ps_module_shop module_shop
      ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
      INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
      INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
      LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
      WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
      GROUP BY hm.id_hook, hm.id_module
      ORDER BY hm.`position`
      1.349 ms 146 Yes Yes /classes/Hook.php:1289
      54
      SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
      FROM `ps_hook_module` hm
      STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
      STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
      ORDER BY hm.position
      1.283 ms 494 /classes/Hook.php:459
      12
      SELECT SQL_NO_CACHE lower(name) as name
      FROM `ps_hook` h
      WHERE (h.active = 1)
      0.743 ms 1143 /classes/Hook.php:1388
      86
      SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
      pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
      image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
      DATEDIFF(
      p.`date_add`,
      DATE_SUB(
      "2026-03-16 00:00:00",
      INTERVAL 365 DAY
      )
      ) > 0 AS new
      FROM `ps_accessory`
      LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
      ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
      LEFT JOIN `ps_product_lang` pl ON (
      p.`id_product` = pl.`id_product`
      AND pl.`id_lang` = 2 AND pl.id_shop = 1 
      )
      LEFT JOIN `ps_category_lang` cl ON (
      product_shop.`id_category_default` = cl.`id_category`
      AND cl.`id_lang` = 2 AND cl.id_shop = 1 
      )
      LEFT JOIN `ps_image_shop` image_shop
      ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
      LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
      LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
      LEFT JOIN ps_stock_available stock
      ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
      WHERE `id_product_1` = 10199 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
      GROUP BY product_shop.id_product
      0.714 ms 1 Yes /classes/Product.php:4713
      250
      SELECT SQL_NO_CACHE p.*,
      ps.*,
      pl.*,
      sa.out_of_stock,
      IFNULL(sa.quantity, 0) as quantity,
      (DATEDIFF(
      p.`date_add`,
      DATE_SUB(
      '2026-03-16 00:00:00',
      INTERVAL 365 DAY
      )
      ) > 0) as new
      FROM ps_product p
      LEFT JOIN ps_product_lang pl
      ON pl.id_product = p.id_product
      AND pl.id_shop = 1
      AND pl.id_lang = 2
      LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
      AND sa.id_product_attribute = 0
      AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
      ON ps.id_product = p.id_product
      AND ps.id_shop = 1
      WHERE p.id_product IN (10242,10302,10270,10403,10320,10215,10369,10311,10203)
      0.683 ms 9 /classes/ProductAssembler.php:95
      395
      SELECT SQL_NO_CACHE w.*, wl.title, wl.subtitle, wl.description 
      FROM ps_ybc_widget_widget w
      LEFT JOIN ps_ybc_widget_widget_lang wl ON w.id_widget = wl.id_widget AND wl.id_lang = 2
      WHERE w.hook = 'ybcCustom1'  AND enabled=1 
      ORDER BY w.sort_order ASC, wl.title ASC
      0.650 ms 256 Yes /modules/ybc_widget/ybc_widget.php:828
      76
      SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
      FROM `ps_category` c
      INNER JOIN ps_category_shop category_shop
      ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
      LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
      LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
      WHERE `id_parent` = 171
      AND `active` = 1
      AND cg.`id_group` =1
      GROUP BY c.`id_category`
      ORDER BY `level_depth` ASC, category_shop.`position` ASC
      0.586 ms 1 Yes Yes /classes/Category.php:924
      405
      SELECT SQL_NO_CACHE w.*, wl.title, wl.subtitle, wl.description 
      FROM ps_ybc_widget_widget w
      LEFT JOIN ps_ybc_widget_widget_lang wl ON w.id_widget = wl.id_widget AND wl.id_lang = 2
      WHERE w.hook = 'displayFooter'  AND enabled=1 
      ORDER BY w.sort_order ASC, wl.title ASC
      0.564 ms 256 Yes /modules/ybc_widget/ybc_widget.php:828
      15
      SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
      0.560 ms 1143 /classes/Hook.php:1348
      140
      SELECT SQL_NO_CACHE w.*, wl.title, wl.subtitle, wl.description 
      FROM ps_ybc_widget_widget w
      LEFT JOIN ps_ybc_widget_widget_lang wl ON w.id_widget = wl.id_widget AND wl.id_lang = 2
      WHERE w.hook = 'displayTop'  AND enabled=1 
      ORDER BY w.sort_order ASC, wl.title ASC
      0.524 ms 256 Yes /modules/ybc_widget/ybc_widget.php:828
      410
      INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('7741587', '', 'dev.procardsmexico.com.mx/ss5-battle-styles/10199-carnivine.html', '', '2026-03-16 09:10:44')
      0.521 ms 1 /classes/ObjectModel.php:622
      406
      SELECT SQL_NO_CACHE w.*, wl.title, wl.subtitle, wl.description 
      FROM ps_ybc_widget_widget w
      LEFT JOIN ps_ybc_widget_widget_lang wl ON w.id_widget = wl.id_widget AND wl.id_lang = 2
      WHERE w.hook = 'ybcCustom2'  AND enabled=1 
      ORDER BY w.sort_order ASC, wl.title ASC
      0.481 ms 256 Yes /modules/ybc_widget/ybc_widget.php:828
      184
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10302 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10302 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.458 ms 0 /classes/Cart.php:1430
      85
      SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
      FROM `ps_attribute` a
      LEFT JOIN `ps_attribute_lang` al
      ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
      LEFT JOIN `ps_attribute_group_lang` agl
      ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
      LEFT JOIN `ps_product_attribute_combination` pac
      ON (a.`id_attribute` = pac.`id_attribute`)
      LEFT JOIN `ps_product_attribute` pa
      ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
      INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      INNER JOIN ps_attribute_shop attribute_shop
      ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
      WHERE pa.`id_product` = 10199
      0.455 ms 2 /classes/Product.php:7575
      413
      INSERT INTO `ps_ets_superspeed_cache_page` (`page`, `id_object`, `id_product_attribute`, `ip`, `file_cache`, `request_uri`, `id_shop`, `id_lang`, `id_currency`, `id_country`, `has_customer`, `has_cart`, `click`, `file_size`, `user_agent`, `date_add`, `date_expired`) VALUES ('product', '10199', '0', '216.73.216.44', '89606a0802de585e86e16fff1ee2a654214e16158c9033a42b217457e62e7f6c', '/ss5-battle-styles/10199-carnivine.html', '1', '2', '1', '145', '0', '0', '1', '0', 'Desktop', '2026-03-16 09:10:44', '2026-03-31 09:10:44')
      0.450 ms 1 /classes/ObjectModel.php:622
      273
      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
      FROM `ps_product_attribute` pa
      INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
      WHERE pa.`id_product` IN (10242) AND ag.`is_color_group` = 1
      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
      ORDER BY a.`position` ASC;
      0.449 ms 1 Yes Yes /classes/Product.php:4524
      428
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayFooterProduct"
      0.431 ms 1 /modules/ets_superspeed/classes/cache.php:357
      175
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10242 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10242 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.427 ms 0 /classes/Cart.php:1430
      414
      UPDATE `ps_ets_superspeed_cache_page` SET `id_cache_page` = '4638',`page` = 'product',`id_object` = '10199',`id_product_attribute` = '0',`ip` = '216.73.216.44',`file_cache` = '89606a0802de585e86e16fff1ee2a654214e16158c9033a42b217457e62e7f6c',`request_uri` = '/ss5-battle-styles/10199-carnivine.html',`id_shop` = '1',`id_lang` = '2',`id_currency` = '1',`id_country` = '145',`has_customer` = '0',`has_cart` = '0',`click` = '1',`file_size` = '94.37',`user_agent` = 'Desktop',`date_add` = '2026-03-16 09:10:44',`date_expired` = '2026-03-31 09:10:44' WHERE `id_cache_page` = 4638
      0.425 ms 1 /classes/ObjectModel.php:808
      229
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10369 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10369 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.424 ms 0 /classes/Cart.php:1430
      178
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10302) AND (b.`id_shop` = 1) LIMIT 1
      0.417 ms 1 /src/Adapter/EntityMapper.php:71
      193
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10270 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10270 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.410 ms 0 /classes/Cart.php:1430
      248
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10203 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10203 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.389 ms 0 /classes/Cart.php:1430
      220
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10215 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10215 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.388 ms 0 /classes/Cart.php:1430
      202
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10403 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10403 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.384 ms 0 /classes/Cart.php:1430
      341
      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
      FROM `ps_product_attribute` pa
      INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
      WHERE pa.`id_product` IN (10320) AND ag.`is_color_group` = 1
      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
      ORDER BY a.`position` ASC;
      0.375 ms 1 Yes Yes /classes/Product.php:4524
      88
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_customization` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10199 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_customization` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10199 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.368 ms 0 /classes/Cart.php:1430
      262
      SELECT SQL_NO_CACHE *
      FROM `ps_product_lang`
      WHERE `id_product` = 10242 AND `id_shop` = 1
      0.368 ms 1 /src/Adapter/EntityMapper.php:79
      328
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  1 LIMIT 1
      0.367 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:763
      21
      SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
      FROM `ps_meta` m
      LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
      ORDER BY LENGTH(ml.url_rewrite) DESC
      0.366 ms 67 Yes /classes/Dispatcher.php:654
      91
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10199 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10199 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.364 ms 0 /classes/Cart.php:1430
      211
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10320 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10320 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.354 ms 0 /classes/Cart.php:1430
      106
      SELECT SQL_NO_CACHE *
      FROM `ps_category` a0
      LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
      WHERE (a0.`nleft` < 450) AND (a0.`nright` > 451) AND (a1.`id_lang` = 2) AND (a1.`id_shop` = 1)
      ORDER BY a0.`nleft` asc
      0.353 ms 331 Yes /classes/PrestaShopCollection.php:383
      358
      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
      FROM `ps_product_attribute` pa
      INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
      WHERE pa.`id_product` IN (10215) AND ag.`is_color_group` = 1
      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
      ORDER BY a.`position` ASC;
      0.349 ms 1 Yes Yes /classes/Product.php:4524
      16
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
      FROM `ps_module` m
      LEFT JOIN `ps_module_shop` ms
      ON m.`id_module` = ms.`id_module`
      AND ms.`id_shop` = 1
      0.344 ms 106 /classes/module/Module.php:346
      239
      SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
      COALESCE(SUM(first_level_quantity), 0) as quantity
      FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
      FROM `ps_cart_product` cp
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND cp.`id_product` = 10311 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
      FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
      WHERE cp.`id_product_attribute` = 0
      AND cp.`id_cart` = 0 AND p.`id_product_item` = 10311 AND (pr.`pack_stock_type` IN (1,2) OR (
      pr.`pack_stock_type` = 3
      AND 0 = 1
      ))) as q LIMIT 1
      0.340 ms 0 /classes/Cart.php:1430
      205
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10320) AND (b.`id_shop` = 1) LIMIT 1
      0.338 ms 1 /src/Adapter/EntityMapper.php:71
      29
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
      FROM `ps_module` m
      LEFT JOIN `ps_module_shop` ms
      ON m.`id_module` = ms.`id_module`
      AND ms.`id_shop` = 1
      0.337 ms 106 /classes/module/Module.php:346
      272
      SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT ws.id_customer) AS `new_joined_ids`, ws.`id_product`, ws.`id_customer`, ws.`id_comb`,
      pa.`id_product_attribute`, sa.`quantity`
      FROM `ps_product_attribute` pa
      LEFT JOIN `ps_stock_available` sa
      ON (pa.id_product_attribute = sa.id_product_attribute)
      LEFT JOIN `ps_subs` ws
      ON (pa.id_product_attribute = ws.id_comb)
      WHERE pa.`id_product` = 10199
      AND sa.quantity <= 0 GROUP BY pa.id_product_attribute
      0.335 ms 34808 Yes /modules/preorderandnotification/models/PreorderModel.php:43
      290
      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
      FROM `ps_product_attribute` pa
      INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
      WHERE pa.`id_product` IN (10302) AND ag.`is_color_group` = 1
      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
      ORDER BY a.`position` ASC;
      0.332 ms 1 Yes Yes /classes/Product.php:4524
      419
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="actionBuildFrontEndObject"
      0.331 ms 1 /modules/ets_superspeed/classes/cache.php:357
      196
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10403) AND (b.`id_shop` = 1) LIMIT 1
      0.328 ms 1 /src/Adapter/EntityMapper.php:71
      324
      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
      FROM `ps_product_attribute` pa
      INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
      WHERE pa.`id_product` IN (10403) AND ag.`is_color_group` = 1
      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
      ORDER BY a.`position` ASC;
      0.328 ms 1 Yes Yes /classes/Product.php:4524
      1
      SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
      FROM ps_shop_group gs
      LEFT JOIN ps_shop s
      ON s.id_shop_group = gs.id_shop_group
      LEFT JOIN ps_shop_url su
      ON s.id_shop = su.id_shop AND su.main = 1
      WHERE s.deleted = 0
      AND gs.deleted = 0
      ORDER BY gs.name, s.name
      0.323 ms 1 Yes /classes/shop/Shop.php:715
      375
      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
      FROM `ps_product_attribute` pa
      INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
      WHERE pa.`id_product` IN (10369) AND ag.`is_color_group` = 1
      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
      ORDER BY a.`position` ASC;
      0.323 ms 1 Yes Yes /classes/Product.php:4524
      233
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10311) AND (b.`id_shop` = 1) LIMIT 1
      0.320 ms 1 /src/Adapter/EntityMapper.php:71
      392
      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
      FROM `ps_product_attribute` pa
      INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
      WHERE pa.`id_product` IN (10311) AND ag.`is_color_group` = 1
      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
      ORDER BY a.`position` ASC;
      0.320 ms 1 Yes Yes /classes/Product.php:4524
      169
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10242) AND (b.`id_shop` = 1) LIMIT 1
      0.318 ms 1 /src/Adapter/EntityMapper.php:71
      77
      SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
      FROM `ps_category` c
      LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
      INNER JOIN ps_category_shop category_shop
      ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
      WHERE `id_lang` = 2
      AND c.`id_parent` = 2
      AND `active` = 1
      GROUP BY c.`id_category`
      ORDER BY category_shop.`position` ASC
      0.315 ms 7 Yes Yes /classes/Category.php:1151
      329
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10320) LIMIT 1
      0.315 ms 1 /src/Adapter/EntityMapper.php:71
      50
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
      FROM `ps_module` m
      LEFT JOIN `ps_module_shop` ms
      ON m.`id_module` = ms.`id_module`
      AND ms.`id_shop` = 1
      0.314 ms 106 /classes/module/Module.php:346
      51
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10199) AND (b.`id_shop` = 1) LIMIT 1
      0.313 ms 1 /src/Adapter/EntityMapper.php:71
      223
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10369) AND (b.`id_shop` = 1) LIMIT 1
      0.313 ms 1 /src/Adapter/EntityMapper.php:71
      36
      SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
      FROM `ps_module` m
      LEFT JOIN `ps_module_shop` ms
      ON m.`id_module` = ms.`id_module`
      AND ms.`id_shop` = 1
      0.311 ms 106 /classes/module/Module.php:346
      429
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayProductListReviews"
      0.310 ms 1 /modules/ets_superspeed/classes/cache.php:357
      307
      SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
      FROM `ps_product_attribute` pa
      INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
      JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
      JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
      JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
      WHERE pa.`id_product` IN (10270) AND ag.`is_color_group` = 1
      GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
      ORDER BY a.`position` ASC;
      0.309 ms 1 Yes Yes /classes/Product.php:4524
      187
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10270) AND (b.`id_shop` = 1) LIMIT 1
      0.306 ms 1 /src/Adapter/EntityMapper.php:71
      430
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="ybccustom1"
      0.306 ms 1 /modules/ets_superspeed/classes/cache.php:357
      92
      SELECT SQL_NO_CACHE tr.*
      FROM `ps_tax_rule` tr
      JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
      WHERE trg.`active` = 1
      AND tr.`id_country` = 145
      AND tr.`id_tax_rules_group` = 2
      AND tr.`id_state` IN (0, 0)
      AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
      OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
      ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
      0.304 ms 1 /classes/tax/TaxRulesTaxManager.php:109
      415
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="moduleRoutes"
      0.301 ms 1 /modules/ets_superspeed/classes/cache.php:357
      312
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10403) LIMIT 1
      0.299 ms 1 /src/Adapter/EntityMapper.php:71
      267
      SELECT SQL_NO_CACHE COUNT(p.id_product)
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      WHERE p.id_product = 10199
      AND DATEDIFF("2026-03-16 00:00:00", product_shop.`date_add`) < 365 LIMIT 1
      0.296 ms 0 /classes/Product.php:1732
      411
      SELECT SQL_NO_CACHE id_cache_page FROM `ps_ets_superspeed_cache_page`
      WHERE page="product" 
      AND id_lang="2"
      AND id_country = "145"
      AND id_currency = "1"
      AND id_shop="1"
      AND user_agent="Desktop"
      AND date_add > "2026-03-16 08:55:44"AND id_object="10199" AND has_customer=0 AND has_cart=0 LIMIT 1
      0.296 ms 1 /modules/ets_superspeed/classes/cache.php:241
      432
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="ybcCustom2"
      0.294 ms 1 /modules/ets_superspeed/classes/cache.php:357
      118
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10199) LIMIT 1
      0.293 ms 1 /src/Adapter/EntityMapper.php:71
      434
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayBeforeBodyClosingTag"
      0.293 ms 1 /modules/ets_superspeed/classes/cache.php:357
      93
      SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
      WHERE i.`id_product` = 10199
      ORDER BY `position`
      0.289 ms 1 Yes /classes/Product.php:3545
      84
      SELECT SQL_NO_CACHE *,
      ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 145, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
      FROM `ps_specific_price`
      WHERE
      `id_shop` IN (0, 1) AND
      `id_currency` IN (0, 1) AND
      `id_country` IN (0, 145) AND
      `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2026-03-16 09:10:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-03-16 09:10:00' <= `to`)
      ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
      0.288 ms 2 Yes /classes/SpecificPrice.php:656
      309
      SELECT SQL_NO_CACHE po.*
      FROM `ps_preorder_product` po
      WHERE (po.id_product = 10270) LIMIT 1
      0.281 ms 1 /modules/preorderandnotification/models/PreorderProduct.php:566
      340
      SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT ws.id_customer) AS `new_joined_ids`, ws.`id_product`, ws.`id_customer`, ws.`id_comb`,
      pa.`id_product_attribute`, sa.`quantity`
      FROM `ps_product_attribute` pa
      LEFT JOIN `ps_stock_available` sa
      ON (pa.id_product_attribute = sa.id_product_attribute)
      LEFT JOIN `ps_subs` ws
      ON (pa.id_product_attribute = ws.id_comb)
      WHERE pa.`id_product` = 10199
      AND sa.quantity <= 0 GROUP BY pa.id_product_attribute
      0.281 ms 34808 Yes /modules/preorderandnotification/models/PreorderModel.php:43
      418
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="actionFrontControllerSetMedia"
      0.278 ms 1 /modules/ets_superspeed/classes/cache.php:357
      214
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10215) AND (b.`id_shop` = 1) LIMIT 1
      0.277 ms 1 /src/Adapter/EntityMapper.php:71
      416
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="actionDispatcherBefore"
      0.275 ms 1 /modules/ets_superspeed/classes/cache.php:357
      242
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10203) AND (b.`id_shop` = 1) LIMIT 1
      0.273 ms 1 /src/Adapter/EntityMapper.php:71
      435
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="actionObjectAddAfter"
      0.273 ms 1 /modules/ets_superspeed/classes/cache.php:357
      425
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayProductPriceBlock"
      0.272 ms 1 /modules/ets_superspeed/classes/cache.php:357
      158
      SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT ws.id_customer) AS `new_joined_ids`, ws.`id_product`, ws.`id_customer`, ws.`id_comb`,
      pa.`id_product_attribute`, sa.`quantity`
      FROM `ps_product_attribute` pa
      LEFT JOIN `ps_stock_available` sa
      ON (pa.id_product_attribute = sa.id_product_attribute)
      LEFT JOIN `ps_subs` ws
      ON (pa.id_product_attribute = ws.id_comb)
      WHERE pa.`id_product` = 10199
      AND sa.quantity <= 0 GROUP BY pa.id_product_attribute
      0.271 ms 34808 Yes /modules/preorderandnotification/models/PreorderModel.php:43
      261
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10242) LIMIT 1
      0.271 ms 1 /src/Adapter/EntityMapper.php:71
      278
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10302) LIMIT 1
      0.271 ms 1 /src/Adapter/EntityMapper.php:71
      422
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayNav2"
      0.271 ms 1 /modules/ets_superspeed/classes/cache.php:357
      124
      SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2026-03-16 00:00:00" AND date_to <= "2026-03-16 23:59:59") OR (date_from >= "2026-03-16 00:00:00" AND date_from <= "2026-03-16 23:59:59") OR (date_from < "2026-03-16 00:00:00" AND date_to > "2026-03-16 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
      0.270 ms 1 /classes/CartRule.php:357
      380
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10311) LIMIT 1
      0.270 ms 1 /src/Adapter/EntityMapper.php:71
      427
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayProductAdditionalInfo"
      0.269 ms 1 /modules/ets_superspeed/classes/cache.php:357
      252
      SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
      WHERE i.`id_product` = 10302
      ORDER BY `position`
      0.266 ms 1 Yes /classes/Product.php:3545
      409
      SELECT SQL_NO_CACHE `id_guest`
      FROM `ps_connections`
      WHERE `id_guest` = 9511142
      AND `date_add` > '2026-03-16 08:40:00'
      AND id_shop IN (1) 
      ORDER BY `date_add` DESC LIMIT 1
      0.266 ms 1 Yes /classes/Connection.php:168
      426
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayProductActions"
      0.266 ms 1 /modules/ets_superspeed/classes/cache.php:357
      123
      SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
      ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
      ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
      0.265 ms 1 /classes/Cart.php:4256
      424
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayMegaMenu"
      0.265 ms 1 /modules/ets_superspeed/classes/cache.php:357
      423
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayTop"
      0.264 ms 1 /modules/ets_superspeed/classes/cache.php:357
      251
      SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
      WHERE i.`id_product` = 10242
      ORDER BY `position`
      0.263 ms 1 Yes /classes/Product.php:3545
      363
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10369) LIMIT 1
      0.263 ms 1 /src/Adapter/EntityMapper.php:71
      55
      SELECT SQL_NO_CACHE tr.*
      FROM `ps_tax_rule` tr
      JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
      WHERE trg.`active` = 1
      AND tr.`id_country` = 145
      AND tr.`id_tax_rules_group` = 2
      AND tr.`id_state` IN (0, 68)
      AND ('39300 ' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
      OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '39300 ')))
      ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
      0.259 ms 1 /classes/tax/TaxRulesTaxManager.php:109
      335
      SELECT SQL_NO_CACHE COUNT(p.id_product)
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      WHERE p.id_product = 10199
      AND DATEDIFF("2026-03-16 00:00:00", product_shop.`date_add`) < 365 LIMIT 1
      0.258 ms 0 /classes/Product.php:1732
      289
      SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT ws.id_customer) AS `new_joined_ids`, ws.`id_product`, ws.`id_customer`, ws.`id_comb`,
      pa.`id_product_attribute`, sa.`quantity`
      FROM `ps_product_attribute` pa
      LEFT JOIN `ps_stock_available` sa
      ON (pa.id_product_attribute = sa.id_product_attribute)
      LEFT JOIN `ps_subs` ws
      ON (pa.id_product_attribute = ws.id_comb)
      WHERE pa.`id_product` = 10199
      AND sa.quantity <= 0 GROUP BY pa.id_product_attribute
      0.256 ms 34808 Yes /modules/preorderandnotification/models/PreorderModel.php:43
      256
      SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
      WHERE i.`id_product` = 10215
      ORDER BY `position`
      0.256 ms 1 Yes /classes/Product.php:3545
      125
      SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
      LEFT JOIN `ps_cart_rule_lang` crl 
      ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
      AND cr.`active` = 1
      AND free_shipping = 1 AND carrier_restriction = 1
      0.255 ms 1 /classes/CartRule.php:423
      346
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10215) LIMIT 1
      0.255 ms 1 /src/Adapter/EntityMapper.php:71
      357
      SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT ws.id_customer) AS `new_joined_ids`, ws.`id_product`, ws.`id_customer`, ws.`id_comb`,
      pa.`id_product_attribute`, sa.`quantity`
      FROM `ps_product_attribute` pa
      LEFT JOIN `ps_stock_available` sa
      ON (pa.id_product_attribute = sa.id_product_attribute)
      LEFT JOIN `ps_subs` ws
      ON (pa.id_product_attribute = ws.id_comb)
      WHERE pa.`id_product` = 10199
      AND sa.quantity <= 0 GROUP BY pa.id_product_attribute
      0.254 ms 34808 Yes /modules/preorderandnotification/models/PreorderModel.php:43
      254
      SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
      WHERE i.`id_product` = 10403
      ORDER BY `position`
      0.253 ms 1 Yes /classes/Product.php:3545
      271
      SELECT SQL_NO_CACHE location
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.252 ms 1 /classes/stock/StockAvailable.php:806
      431
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayFooter"
      0.252 ms 1 /modules/ets_superspeed/classes/cache.php:357
      0
      SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
      FROM ps_shop_url su
      LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
      WHERE (su.domain = 'dev.procardsmexico.com.mx' OR su.domain_ssl = 'dev.procardsmexico.com.mx')
      AND s.active = 1
      AND s.deleted = 0
      ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
      0.250 ms 1 Yes /classes/shop/Shop.php:1364
      127
      SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
      LEFT JOIN `ps_cart_rule_lang` crl 
      ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 0) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
      AND cr.`active` = 1
      AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%"
      0.250 ms 1 /classes/CartRule.php:423
      126
      SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2026-03-16 00:00:00" AND date_to <= "2026-03-16 23:59:59") OR (date_from >= "2026-03-16 00:00:00" AND date_from <= "2026-03-16 23:59:59") OR (date_from < "2026-03-16 00:00:00" AND date_to > "2026-03-16 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
      0.249 ms 1 /classes/CartRule.php:357
      437
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="actionObjectUpdateAfter"
      0.249 ms 1 /modules/ets_superspeed/classes/cache.php:357
      295
      SELECT SQL_NO_CACHE *
      FROM `ps_product` a
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
      WHERE (a.`id_product` = 10270) LIMIT 1
      0.248 ms 1 /src/Adapter/EntityMapper.php:71
      417
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="actionFrontControllerInitAfter"
      0.245 ms 1 /modules/ets_superspeed/classes/cache.php:357
      143
      SELECT SQL_NO_CACHE wp.`quantity`,w.`id_ets_wishlist`
      FROM `ps_ets_wishlist_product` wp
      JOIN `ps_ets_wishlist` w ON (w.`id_ets_wishlist` = wp.`id_ets_wishlist`)
      WHERE  w.`id_customer` = 0
      AND wp.`id_product` = 10199
      AND wp.`id_product_attribute` = 0 LIMIT 1
      0.244 ms 1 /modules/ets_wishlist_pres17/classes/Ets_wl_wishlist.php:207
      253
      SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
      WHERE i.`id_product` = 10270
      ORDER BY `position`
      0.243 ms 1 Yes /classes/Product.php:3545
      81
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2026-03-16 00:00:00' AND '2026-03-16 23:59:59' LIMIT 1
      0.241 ms 1 /classes/SpecificPrice.php:377
      113
      SELECT SQL_NO_CACHE c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
      FROM ps_cms c
      LEFT JOIN ps_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=2
      WHERE c.active=1 
      ORDER BY cl.meta_title asc
      0.239 ms 13 Yes /modules/ets_megamenu/ets_megamenu.php:997
      177
      SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 171 LIMIT 1
      0.239 ms 1 /classes/Product.php:5670
      436
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="actionOutputHTMLBefore"
      0.238 ms 1 /modules/ets_superspeed/classes/cache.php:357
      167
      SELECT SQL_NO_CACHE image_shop.`id_image`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      WHERE i.`id_product` = 10242
      AND image_shop.`cover` = 1 LIMIT 1
      0.238 ms 1 /classes/Product.php:3570
      255
      SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
      WHERE i.`id_product` = 10320
      ORDER BY `position`
      0.238 ms 1 Yes /classes/Product.php:3545
      240
      SELECT SQL_NO_CACHE image_shop.`id_image`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      WHERE i.`id_product` = 10203
      AND image_shop.`cover` = 1 LIMIT 1
      0.237 ms 1 /classes/Product.php:3570
      258
      SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
      WHERE i.`id_product` = 10311
      ORDER BY `position`
      0.236 ms 1 Yes /classes/Product.php:3545
      257
      SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
      WHERE i.`id_product` = 10369
      ORDER BY `position`
      0.235 ms 1 Yes /classes/Product.php:3545
      244
      SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
      0 as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
      WHERE (p.`id_product` = 10203)
      0.234 ms 1 /classes/Product.php:3860
      109
      SELECT SQL_NO_CACHE *
      FROM `ps_currency` c
      INNER JOIN ps_currency_shop currency_shop
      ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
      WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
      0.234 ms 2 Yes /classes/Currency.php:694
      231
      SELECT SQL_NO_CACHE image_shop.`id_image`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      WHERE i.`id_product` = 10311
      AND image_shop.`cover` = 1 LIMIT 1
      0.233 ms 1 /classes/Product.php:3570
      268
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
      FROM ps_tag t
      LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
      WHERE pt.`id_product`=10199
      0.233 ms 1 /classes/Tag.php:244
      374
      SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT ws.id_customer) AS `new_joined_ids`, ws.`id_product`, ws.`id_customer`, ws.`id_comb`,
      pa.`id_product_attribute`, sa.`quantity`
      FROM `ps_product_attribute` pa
      LEFT JOIN `ps_stock_available` sa
      ON (pa.id_product_attribute = sa.id_product_attribute)
      LEFT JOIN `ps_subs` ws
      ON (pa.id_product_attribute = ws.id_comb)
      WHERE pa.`id_product` = 10199
      AND sa.quantity <= 0 GROUP BY pa.id_product_attribute
      0.232 ms 34808 Yes /modules/preorderandnotification/models/PreorderModel.php:43
      72
      SELECT SQL_NO_CACHE *
      FROM `ps_category` a
      LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
      LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
      WHERE (a.`id_category` = 171) AND (b.`id_shop` = 1) LIMIT 1
      0.231 ms 1 /src/Adapter/EntityMapper.php:71
      274
      SELECT SQL_NO_CACHE wp.`quantity`,w.`id_ets_wishlist`
      FROM `ps_ets_wishlist_product` wp
      JOIN `ps_ets_wishlist` w ON (w.`id_ets_wishlist` = wp.`id_ets_wishlist`)
      WHERE  w.`id_customer` = 0
      AND wp.`id_product` = 10242
      AND wp.`id_product_attribute` = 0 LIMIT 1
      0.231 ms 1 /modules/ets_wishlist_pres17/classes/Ets_wl_wishlist.php:207
      420
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayHeader"
      0.230 ms 1 /modules/ets_superspeed/classes/cache.php:357
      185
      SELECT SQL_NO_CACHE image_shop.`id_image`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      WHERE i.`id_product` = 10270
      AND image_shop.`cover` = 1 LIMIT 1
      0.229 ms 1 /classes/Product.php:3570
      306
      SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT ws.id_customer) AS `new_joined_ids`, ws.`id_product`, ws.`id_customer`, ws.`id_comb`,
      pa.`id_product_attribute`, sa.`quantity`
      FROM `ps_product_attribute` pa
      LEFT JOIN `ps_stock_available` sa
      ON (pa.id_product_attribute = sa.id_product_attribute)
      LEFT JOIN `ps_subs` ws
      ON (pa.id_product_attribute = ws.id_comb)
      WHERE pa.`id_product` = 10199
      AND sa.quantity <= 0 GROUP BY pa.id_product_attribute
      0.228 ms 34808 Yes /modules/preorderandnotification/models/PreorderModel.php:43
      221
      SELECT SQL_NO_CACHE image_shop.`id_image`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      WHERE i.`id_product` = 10369
      AND image_shop.`cover` = 1 LIMIT 1
      0.228 ms 1 /classes/Product.php:3570
      421
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayNav1"
      0.228 ms 1 /modules/ets_superspeed/classes/cache.php:357
      433
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="4638", hook_name="displayFooterBefore"
      0.227 ms 1 /modules/ets_superspeed/classes/cache.php:357
      323
      SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT ws.id_customer) AS `new_joined_ids`, ws.`id_product`, ws.`id_customer`, ws.`id_comb`,
      pa.`id_product_attribute`, sa.`quantity`
      FROM `ps_product_attribute` pa
      LEFT JOIN `ps_stock_available` sa
      ON (pa.id_product_attribute = sa.id_product_attribute)
      LEFT JOIN `ps_subs` ws
      ON (pa.id_product_attribute = ws.id_comb)
      WHERE pa.`id_product` = 10199
      AND sa.quantity <= 0 GROUP BY pa.id_product_attribute
      0.226 ms 34808 Yes /modules/preorderandnotification/models/PreorderModel.php:43
      391
      SELECT SQL_NO_CACHE GROUP_CONCAT(DISTINCT ws.id_customer) AS `new_joined_ids`, ws.`id_product`, ws.`id_customer`, ws.`id_comb`,
      pa.`id_product_attribute`, sa.`quantity`
      FROM `ps_product_attribute` pa
      LEFT JOIN `ps_stock_available` sa
      ON (pa.id_product_attribute = sa.id_product_attribute)
      LEFT JOIN `ps_subs` ws
      ON (pa.id_product_attribute = ws.id_comb)
      WHERE pa.`id_product` = 10199
      AND sa.quantity <= 0 GROUP BY pa.id_product_attribute
      0.223 ms 34808 Yes /modules/preorderandnotification/models/PreorderModel.php:43
      141
      SELECT SQL_NO_CACHE *
      FROM `ps_currency` c
      INNER JOIN ps_currency_shop currency_shop
      ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
      WHERE c.`deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
      0.221 ms 2 Yes /classes/Currency.php:694
      260
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  1 LIMIT 1
      0.221 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:763
      115
      SELECT SQL_NO_CACHE c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
      FROM ps_cms c
      LEFT JOIN ps_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=2
      WHERE c.active=1 
      ORDER BY cl.meta_title asc
      0.219 ms 13 Yes /modules/ets_megamenu/ets_megamenu.php:997
      153
      SELECT SQL_NO_CACHE COUNT(p.id_product)
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      WHERE p.id_product = 10199
      AND DATEDIFF("2026-03-16 00:00:00", product_shop.`date_add`) < 365 LIMIT 1
      0.219 ms 0 /classes/Product.php:1732
      308
      SELECT SQL_NO_CACHE wp.`quantity`,w.`id_ets_wishlist`
      FROM `ps_ets_wishlist_product` wp
      JOIN `ps_ets_wishlist` w ON (w.`id_ets_wishlist` = wp.`id_ets_wishlist`)
      WHERE  w.`id_customer` = 0
      AND wp.`id_product` = 10270
      AND wp.`id_product_attribute` = 0 LIMIT 1
      0.219 ms 1 /modules/ets_wishlist_pres17/classes/Ets_wl_wishlist.php:207
      73
      SELECT SQL_NO_CACHE tr.*
      FROM `ps_tax_rule` tr
      JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
      WHERE trg.`active` = 1
      AND tr.`id_country` = 145
      AND tr.`id_tax_rules_group` = 0
      AND tr.`id_state` IN (0, 68)
      AND ('39300 ' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
      OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '39300 ')))
      ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
      0.218 ms 0 /classes/tax/TaxRulesTaxManager.php:109
      4
      SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
      FROM ps_shop s
      LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
      WHERE s.id_shop = 1
      AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
      0.216 ms 1 /classes/shop/Shop.php:218
      176
      SELECT SQL_NO_CACHE image_shop.`id_image`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      WHERE i.`id_product` = 10302
      AND image_shop.`cover` = 1 LIMIT 1
      0.216 ms 1 /classes/Product.php:3570
      203
      SELECT SQL_NO_CACHE image_shop.`id_image`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      WHERE i.`id_product` = 10320
      AND image_shop.`cover` = 1 LIMIT 1
      0.216 ms 1 /classes/Product.php:3570
      180
      SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
      0 as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
      WHERE (p.`id_product` = 10302)
      0.214 ms 1 /classes/Product.php:3860
      263
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10242 LIMIT 1
      0.214 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php:76
      97
      SELECT SQL_NO_CACHE *
      FROM `ps_manufacturer` a
      LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
      LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
      WHERE (a.`id_manufacturer` = 3) LIMIT 1
      0.213 ms 1 /src/Adapter/EntityMapper.php:71
      212
      SELECT SQL_NO_CACHE image_shop.`id_image`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      WHERE i.`id_product` = 10215
      AND image_shop.`cover` = 1 LIMIT 1
      0.213 ms 1 /classes/Product.php:3570
      30
      SELECT SQL_NO_CACHE *
      FROM `ps_group` a
      LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
      WHERE (a.`id_group` = 1) LIMIT 1
      0.212 ms 1 /src/Adapter/EntityMapper.php:71
      353
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
      FROM ps_tag t
      LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
      WHERE pt.`id_product`=10199
      0.211 ms 1 /classes/Tag.php:244
      11
      SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
      JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
      WHERE l.`active` = 1 LIMIT 1
      0.210 ms 1 /classes/Language.php:1216
      194
      SELECT SQL_NO_CACHE image_shop.`id_image`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      WHERE i.`id_product` = 10403
      AND image_shop.`cover` = 1 LIMIT 1
      0.210 ms 1 /classes/Product.php:3570
      89
      SELECT SQL_NO_CACHE image_shop.`id_image`
      FROM `ps_image` i
      INNER JOIN ps_image_shop image_shop
      ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
      WHERE i.`id_product` = 10199
      AND image_shop.`cover` = 1 LIMIT 1
      0.207 ms 1 /classes/Product.php:3570
      37
      SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
      0.206 ms 2 Yes /classes/Currency.php:709
      376
      SELECT SQL_NO_CACHE wp.`quantity`,w.`id_ets_wishlist`
      FROM `ps_ets_wishlist_product` wp
      JOIN `ps_ets_wishlist` w ON (w.`id_ets_wishlist` = wp.`id_ets_wishlist`)
      WHERE  w.`id_customer` = 0
      AND wp.`id_product` = 10369
      AND wp.`id_product_attribute` = 0 LIMIT 1
      0.206 ms 1 /modules/ets_wishlist_pres17/classes/Ets_wl_wishlist.php:207
      247
      SELECT SQL_NO_CACHE SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = 10203) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.205 ms 1 /classes/stock/StockAvailable.php:453
      31
      SELECT SQL_NO_CACHE *
      FROM `ps_group_lang`
      WHERE `id_group` = 1
      0.204 ms 1 /src/Adapter/EntityMapper.php:79
      63
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
      FROM ps_tag t
      LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
      WHERE pt.`id_product`=10199
      0.204 ms 1 /classes/Tag.php:244
      69
      SELECT SQL_NO_CACHE pa.id_product_attribute
      FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      WHERE pa.`id_product` = 10199
      0.204 ms 1 /classes/Product.php:7508
      71
      SELECT SQL_NO_CACHE ctg.`id_group`
      FROM `ps_category_product` cp
      INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
      WHERE cp.`id_product` = 10199 AND ctg.`id_group` = 1 LIMIT 1
      0.204 ms 4 /classes/Product.php:6751
      95
      SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
      0.204 ms 7 Yes /classes/ImageType.php:109
      270
      SELECT SQL_NO_CACHE depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.204 ms 1 /classes/stock/StockAvailable.php:753
      163
      SELECT SQL_NO_CACHE *
      FROM `ps_category` a
      LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
      WHERE (a.`id_category` = 171) LIMIT 1
      0.203 ms 1 /src/Adapter/EntityMapper.php:71
      216
      SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
      0 as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
      WHERE (p.`id_product` = 10215)
      0.203 ms 1 /classes/Product.php:3860
      230
      SELECT SQL_NO_CACHE tr.*
      FROM `ps_tax_rule` tr
      JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
      WHERE trg.`active` = 1
      AND tr.`id_country` = 145
      AND tr.`id_tax_rules_group` = 0
      AND tr.`id_state` IN (0, 0)
      AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
      OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
      ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
      0.202 ms 0 /classes/tax/TaxRulesTaxManager.php:109
      398
      SELECT SQL_NO_CACHE `need_identification_number`
      FROM `ps_country`
      WHERE `id_country` = 145 LIMIT 1
      0.202 ms 1 /classes/Country.php:405
      313
      SELECT SQL_NO_CACHE *
      FROM `ps_product_lang`
      WHERE `id_product` = 10403 AND `id_shop` = 1
      0.201 ms 1 /src/Adapter/EntityMapper.php:79
      41
      SELECT SQL_NO_CACHE *
      FROM `ps_currency` a
      LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
      LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
      WHERE (a.`id_currency` = 1) LIMIT 1
      0.201 ms 1 /src/Adapter/EntityMapper.php:71
      302
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
      FROM ps_tag t
      LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
      WHERE pt.`id_product`=10199
      0.201 ms 1 /classes/Tag.php:244
      6
      SELECT SQL_NO_CACHE *
      FROM `ps_country` a
      LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
      LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
      WHERE (a.`id_country` = 145) LIMIT 1
      0.200 ms 1 /src/Adapter/EntityMapper.php:71
      45
      SELECT SQL_NO_CACHE *
      FROM `ps_currency` a
      LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
      LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
      WHERE (a.`id_currency` = 2) LIMIT 1
      0.199 ms 1 /src/Adapter/EntityMapper.php:71
      14
      SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
      0.198 ms 88 /classes/Hook.php:290
      259
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 1 LIMIT 1
      0.198 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:753
      264
      SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
      WHERE `id_product` = 10242
      0.198 ms 4 /classes/Product.php:3423
      342
      SELECT SQL_NO_CACHE wp.`quantity`,w.`id_ets_wishlist`
      FROM `ps_ets_wishlist_product` wp
      JOIN `ps_ets_wishlist` w ON (w.`id_ets_wishlist` = wp.`id_ets_wishlist`)
      WHERE  w.`id_customer` = 0
      AND wp.`id_product` = 10320
      AND wp.`id_product_attribute` = 0 LIMIT 1
      0.197 ms 1 /modules/ets_wishlist_pres17/classes/Ets_wl_wishlist.php:207
      56
      SELECT SQL_NO_CACHE COUNT(p.id_product)
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      WHERE p.id_product = 10199
      AND DATEDIFF("2026-03-16 00:00:00", product_shop.`date_add`) < 365 LIMIT 1
      0.195 ms 0 /classes/Product.php:1732
      137
      SELECT SQL_NO_CACHE SUM(`quantity`)
      FROM `ps_cart_product`
      WHERE `id_cart` = 0 LIMIT 1
      0.195 ms 1 /classes/Cart.php:1303
      393
      SELECT SQL_NO_CACHE wp.`quantity`,w.`id_ets_wishlist`
      FROM `ps_ets_wishlist_product` wp
      JOIN `ps_ets_wishlist` w ON (w.`id_ets_wishlist` = wp.`id_ets_wishlist`)
      WHERE  w.`id_customer` = 0
      AND wp.`id_product` = 10311
      AND wp.`id_product_attribute` = 0 LIMIT 1
      0.195 ms 1 /modules/ets_wishlist_pres17/classes/Ets_wl_wishlist.php:207
      362
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  1 LIMIT 1
      0.193 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:763
      394
      SELECT SQL_NO_CACHE po.*
      FROM `ps_preorder_product` po
      WHERE (po.id_product = 10311) LIMIT 1
      0.193 ms 1 /modules/preorderandnotification/models/PreorderProduct.php:566
      291
      SELECT SQL_NO_CACHE wp.`quantity`,w.`id_ets_wishlist`
      FROM `ps_ets_wishlist_product` wp
      JOIN `ps_ets_wishlist` w ON (w.`id_ets_wishlist` = wp.`id_ets_wishlist`)
      WHERE  w.`id_customer` = 0
      AND wp.`id_product` = 10302
      AND wp.`id_product_attribute` = 0 LIMIT 1
      0.193 ms 1 /modules/ets_wishlist_pres17/classes/Ets_wl_wishlist.php:207
      352
      SELECT SQL_NO_CACHE COUNT(p.id_product)
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      WHERE p.id_product = 10199
      AND DATEDIFF("2026-03-16 00:00:00", product_shop.`date_add`) < 365 LIMIT 1
      0.193 ms 0 /classes/Product.php:1732
      369
      SELECT SQL_NO_CACHE COUNT(p.id_product)
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      WHERE p.id_product = 10199
      AND DATEDIFF("2026-03-16 00:00:00", product_shop.`date_add`) < 365 LIMIT 1
      0.192 ms 0 /classes/Product.php:1732
      189
      SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
      0 as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
      WHERE (p.`id_product` = 10270)
      0.191 ms 1 /classes/Product.php:3860
      311
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  1 LIMIT 1
      0.191 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:763
      378
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 1 LIMIT 1
      0.190 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:753
      412
      SELECT SQL_NO_CACHE id_cache_page FROM `ps_ets_superspeed_cache_page` WHERE file_cache = "89606a0802de585e86e16fff1ee2a654214e16158c9033a42b217457e62e7f6c" AND id_shop="1" LIMIT 1
      0.190 ms 1 /modules/ets_superspeed/classes/cache.php:270
      225
      SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
      0 as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
      WHERE (p.`id_product` = 10369)
      0.189 ms 1 /classes/Product.php:3860
      238
      SELECT SQL_NO_CACHE SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = 10311) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.188 ms 1 /classes/stock/StockAvailable.php:453
      359
      SELECT SQL_NO_CACHE wp.`quantity`,w.`id_ets_wishlist`
      FROM `ps_ets_wishlist_product` wp
      JOIN `ps_ets_wishlist` w ON (w.`id_ets_wishlist` = wp.`id_ets_wishlist`)
      WHERE  w.`id_customer` = 0
      AND wp.`id_product` = 10215
      AND wp.`id_product_attribute` = 0 LIMIT 1
      0.188 ms 1 /modules/ets_wishlist_pres17/classes/Ets_wl_wishlist.php:207
      265
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10242 AND id_shop = 1 LIMIT 1
      0.188 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:441
      266
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10242 LIMIT 1
      0.187 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:525
      277
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  1 LIMIT 1
      0.187 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:763
      319
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
      FROM ps_tag t
      LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
      WHERE pt.`id_product`=10199
      0.187 ms 1 /classes/Tag.php:244
      87
      SELECT SQL_NO_CACHE pa.id_product_attribute
      FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      WHERE pa.`id_product` = 10199
      0.186 ms 1 /classes/Product.php:7508
      293
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 1 LIMIT 1
      0.185 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:753
      5
      SELECT SQL_NO_CACHE l.*, ls.`id_shop`
      FROM `ps_lang` l
      LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
      0.184 ms 1 /classes/Language.php:1080
      183
      SELECT SQL_NO_CACHE SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = 10302) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.184 ms 1 /classes/stock/StockAvailable.php:453
      318
      SELECT SQL_NO_CACHE COUNT(p.id_product)
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      WHERE p.id_product = 10199
      AND DATEDIFF("2026-03-16 00:00:00", product_shop.`date_add`) < 365 LIMIT 1
      0.184 ms 0 /classes/Product.php:1732
      154
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
      FROM ps_tag t
      LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
      WHERE pt.`id_product`=10199
      0.183 ms 1 /classes/Tag.php:244
      336
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
      FROM ps_tag t
      LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
      WHERE pt.`id_product`=10199
      0.183 ms 1 /classes/Tag.php:244
      344
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 1 LIMIT 1
      0.183 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:753
      17
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "preorderandnotification" LIMIT 1
      0.182 ms 1 /classes/module/Module.php:2664
      146
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 1 LIMIT 1
      0.182 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:753
      269
      SELECT SQL_NO_CACHE out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.182 ms 1 /classes/stock/StockAvailable.php:778
      192
      SELECT SQL_NO_CACHE SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = 10270) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.182 ms 1 /classes/stock/StockAvailable.php:453
      228
      SELECT SQL_NO_CACHE SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = 10369) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.181 ms 1 /classes/stock/StockAvailable.php:453
      285
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
      FROM ps_tag t
      LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
      WHERE pt.`id_product`=10199
      0.181 ms 1 /classes/Tag.php:244
      301
      SELECT SQL_NO_CACHE COUNT(p.id_product)
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      WHERE p.id_product = 10199
      AND DATEDIFF("2026-03-16 00:00:00", product_shop.`date_add`) < 365 LIMIT 1
      0.181 ms 0 /classes/Product.php:1732
      330
      SELECT SQL_NO_CACHE *
      FROM `ps_product_lang`
      WHERE `id_product` = 10320 AND `id_shop` = 1
      0.181 ms 1 /src/Adapter/EntityMapper.php:79
      197
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10403 LIMIT 1
      0.180 ms 1 /classes/SpecificPrice.php:435
      310
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 1 LIMIT 1
      0.180 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:753
      103
      SELECT SQL_NO_CACHE *
      FROM `ps_country` a
      LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
      WHERE (a.`id_country` = 145) LIMIT 1
      0.179 ms 1 /src/Adapter/EntityMapper.php:71
      386
      SELECT SQL_NO_CACHE COUNT(p.id_product)
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      WHERE p.id_product = 10199
      AND DATEDIFF("2026-03-16 00:00:00", product_shop.`date_add`) < 365 LIMIT 1
      0.179 ms 0 /classes/Product.php:1732
      40
      SELECT SQL_NO_CACHE c.id_currency
      FROM `ps_currency` c
      WHERE (iso_code = 'MXN') LIMIT 1
      0.178 ms 1 /classes/Currency.php:893
      361
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 1 LIMIT 1
      0.178 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:753
      42
      SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
      WHERE `locale` = 'es-mx'
      OR `language_code` = 'es-mx' LIMIT 1
      0.178 ms 1 /classes/Language.php:883
      294
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  1 LIMIT 1
      0.178 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:763
      198
      SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
      0 as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
      WHERE (p.`id_product` = 10403)
      0.177 ms 1 /classes/Product.php:3860
      168
      SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 171 LIMIT 1
      0.177 ms 1 /classes/Product.php:5670
      276
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 1 LIMIT 1
      0.177 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:753
      226
      SELECT SQL_NO_CACHE `id_tax_rules_group`
      FROM `ps_product_shop`
      WHERE `id_product` = 10369 AND id_shop=1 LIMIT 1
      0.176 ms 1 /classes/Product.php:6887
      57
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
      0.176 ms 1 /classes/SpecificPrice.php:426
      201
      SELECT SQL_NO_CACHE SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = 10403) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.176 ms 1 /classes/stock/StockAvailable.php:453
      320
      SELECT SQL_NO_CACHE out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.176 ms 1 /classes/stock/StockAvailable.php:778
      381
      SELECT SQL_NO_CACHE *
      FROM `ps_product_lang`
      WHERE `id_product` = 10311 AND `id_shop` = 1
      0.176 ms 1 /src/Adapter/EntityMapper.php:79
      47
      SELECT SQL_NO_CACHE *
      FROM `ps_currency` a
      LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
      WHERE (a.`id_currency` = 1) LIMIT 1
      0.175 ms 1 /src/Adapter/EntityMapper.php:71
      119
      SELECT SQL_NO_CACHE *
      FROM `ps_product_lang`
      WHERE `id_product` = 10199 AND `id_shop` = 1
      0.175 ms 1 /src/Adapter/EntityMapper.php:79
      171
      SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
      0 as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
      WHERE (p.`id_product` = 10242)
      0.175 ms 1 /classes/Product.php:3860
      284
      SELECT SQL_NO_CACHE COUNT(p.id_product)
      FROM `ps_product` p
      INNER JOIN ps_product_shop product_shop
      ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
      WHERE p.id_product = 10199
      AND DATEDIFF("2026-03-16 00:00:00", product_shop.`date_add`) < 365 LIMIT 1
      0.175 ms 0 /classes/Product.php:1732
      327
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = 0 AND (`status` = -1 OR `loy` = -1 OR `loy` = -2) AND id_shop = 1 LIMIT 1
      0.175 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:753
      332
      SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
      WHERE `id_product` = 10320
      0.175 ms 4 /classes/Product.php:3423
      364
      SELECT SQL_NO_CACHE *
      FROM `ps_product_lang`
      WHERE `id_product` = 10369 AND `id_shop` = 1
      0.174 ms 1 /src/Adapter/EntityMapper.php:79
      296
      SELECT SQL_NO_CACHE *
      FROM `ps_product_lang`
      WHERE `id_product` = 10270 AND `id_shop` = 1
      0.174 ms 1 /src/Adapter/EntityMapper.php:79
      360
      SELECT SQL_NO_CACHE po.*
      FROM `ps_preorder_product` po
      WHERE (po.id_product = 10215) LIMIT 1
      0.174 ms 1 /modules/preorderandnotification/models/PreorderProduct.php:566
      78
      SELECT SQL_NO_CACHE pa.id_product_attribute
      FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop
      ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
      WHERE pa.`id_product` = 10199
      0.173 ms 1 /classes/Product.php:7508
      275
      SELECT SQL_NO_CACHE po.*
      FROM `ps_preorder_product` po
      WHERE (po.id_product = 10242) LIMIT 1
      0.173 ms 1 /modules/preorderandnotification/models/PreorderProduct.php:566
      325
      SELECT SQL_NO_CACHE wp.`quantity`,w.`id_ets_wishlist`
      FROM `ps_ets_wishlist_product` wp
      JOIN `ps_ets_wishlist` w ON (w.`id_ets_wishlist` = wp.`id_ets_wishlist`)
      WHERE  w.`id_customer` = 0
      AND wp.`id_product` = 10403
      AND wp.`id_product_attribute` = 0 LIMIT 1
      0.173 ms 1 /modules/ets_wishlist_pres17/classes/Ets_wl_wishlist.php:207
      345
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  1 LIMIT 1
      0.173 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:763
      347
      SELECT SQL_NO_CACHE *
      FROM `ps_product_lang`
      WHERE `id_product` = 10215 AND `id_shop` = 1
      0.173 ms 1 /src/Adapter/EntityMapper.php:79
      377
      SELECT SQL_NO_CACHE po.*
      FROM `ps_preorder_product` po
      WHERE (po.id_product = 10369) LIMIT 1
      0.173 ms 1 /modules/preorderandnotification/models/PreorderProduct.php:566
      39
      SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
      0.173 ms 1 /classes/shop/Shop.php:1183
      43
      SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
      WHERE `locale` = 'es-mx'
      OR `language_code` = 'es-mx' LIMIT 1
      0.173 ms 1 /classes/Language.php:883
      370
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
      FROM ps_tag t
      LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
      WHERE pt.`id_product`=10199
      0.173 ms 1 /classes/Tag.php:244
      149
      SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
      WHERE `id_product` = 10199
      0.172 ms 4 /classes/Product.php:3423
      190
      SELECT SQL_NO_CACHE `id_tax_rules_group`
      FROM `ps_product_shop`
      WHERE `id_product` = 10270 AND id_shop=1 LIMIT 1
      0.172 ms 1 /classes/Product.php:6887
      207
      SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
      0 as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
      WHERE (p.`id_product` = 10320)
      0.172 ms 1 /classes/Product.php:3860
      3
      SELECT SQL_NO_CACHE *
      FROM `ps_shop` a
      WHERE (a.`id_shop` = 1) LIMIT 1
      0.171 ms 1 /src/Adapter/EntityMapper.php:71
      174
      SELECT SQL_NO_CACHE SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = 10242) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.171 ms 1 /classes/stock/StockAvailable.php:453
      235
      SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
      0 as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
      WHERE (p.`id_product` = 10311)
      0.171 ms 1 /classes/Product.php:3860
      305
      SELECT SQL_NO_CACHE location
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.171 ms 1 /classes/stock/StockAvailable.php:806
      322
      SELECT SQL_NO_CACHE location
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.171 ms 1 /classes/stock/StockAvailable.php:806
      349
      SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
      WHERE `id_product` = 10215
      0.171 ms 4 /classes/Product.php:3423
      383
      SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
      WHERE `id_product` = 10311
      0.171 ms 4 /classes/Product.php:3423
      138
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
      0.170 ms 1 /classes/module/Module.php:2664
      147
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  1 LIMIT 1
      0.170 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:763
      204
      SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 171 LIMIT 1
      0.170 ms 1 /classes/Product.php:5670
      331
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10320 LIMIT 1
      0.170 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php:76
      379
      SELECT SQL_NO_CACHE COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = 0 AND (`status` = -1 OR `aff` = -1 OR `aff` = -2) AND id_shop =  1 LIMIT 1
      0.170 ms 2 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:763
      46
      SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
      WHERE `locale` = 'es-mx'
      OR `language_code` = 'es-mx' LIMIT 1
      0.169 ms 1 /classes/Language.php:883
      164
      SELECT SQL_NO_CACHE *
      FROM `ps_category_lang`
      WHERE `id_category` = 171 AND `id_shop` = 1
      0.169 ms 1 /src/Adapter/EntityMapper.php:79
      179
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10302 LIMIT 1
      0.169 ms 1 /classes/SpecificPrice.php:435
      243
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10203 LIMIT 1
      0.169 ms 1 /classes/SpecificPrice.php:435
      279
      SELECT SQL_NO_CACHE *
      FROM `ps_product_lang`
      WHERE `id_product` = 10302 AND `id_shop` = 1
      0.169 ms 1 /src/Adapter/EntityMapper.php:79
      282
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10302 AND id_shop = 1 LIMIT 1
      0.169 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:441
      10
      SELECT SQL_NO_CACHE domain, domain_ssl
      FROM ps_shop_url
      WHERE main = 1
      AND id_shop = 1 LIMIT 1
      0.168 ms 1 /classes/shop/ShopUrl.php:182
      245
      SELECT SQL_NO_CACHE `id_tax_rules_group`
      FROM `ps_product_shop`
      WHERE `id_product` = 10203 AND id_shop=1 LIMIT 1
      0.168 ms 1 /classes/Product.php:6887
      186
      SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 171 LIMIT 1
      0.168 ms 1 /classes/Product.php:5670
      334
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10320 LIMIT 1
      0.168 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:525
      19
      SELECT SQL_NO_CACHE * FROM ps_hook_module
      WHERE `id_hook` = 959
      AND `id_module` = 246
      AND `id_shop` = 1
      0.167 ms 1 /classes/Hook.php:518
      20
      SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
      0.167 ms 88 /classes/Hook.php:342
      281
      SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
      WHERE `id_product` = 10302
      0.167 ms 4 /classes/Product.php:3423
      215
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10215 LIMIT 1
      0.167 ms 1 /classes/SpecificPrice.php:435
      59
      SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
      0 as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
      WHERE (p.`id_product` = 10199)
      0.166 ms 1 /classes/Product.php:3860
      132
      SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
      LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
      WHERE c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
      0.166 ms 2 /classes/Currency.php:1136
      232
      SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 171 LIMIT 1
      0.166 ms 1 /classes/Product.php:5670
      234
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10311 LIMIT 1
      0.166 ms 1 /classes/SpecificPrice.php:435
      365
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10369 LIMIT 1
      0.166 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php:76
      188
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10270 LIMIT 1
      0.165 ms 1 /classes/SpecificPrice.php:435
      219
      SELECT SQL_NO_CACHE SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = 10215) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.165 ms 1 /classes/stock/StockAvailable.php:453
      298
      SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
      WHERE `id_product` = 10270
      0.165 ms 4 /classes/Product.php:3423
      98
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
      0.164 ms 0 /classes/module/Module.php:2664
      114
      SELECT SQL_NO_CACHE id_manufacturer as value,CONCAT('mm_manufacturer_',id_manufacturer) as id, name as label
      FROM ps_manufacturer            
      WHERE active=1 
      ORDER BY name asc
      0.164 ms 6 Yes /modules/ets_megamenu/ets_megamenu.php:987
      206
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10320 LIMIT 1
      0.164 ms 1 /classes/SpecificPrice.php:435
      366
      SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
      WHERE `id_product` = 10369
      0.164 ms 4 /classes/Product.php:3423
      387
      SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
      FROM ps_tag t
      LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
      WHERE pt.`id_product`=10199
      0.164 ms 1 /classes/Tag.php:244
      314
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10403 LIMIT 1
      0.164 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php:76
      64
      SELECT SQL_NO_CACHE SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.163 ms 1 /classes/stock/StockAvailable.php:453
      150
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10199 AND id_shop = 1 LIMIT 1
      0.163 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:441
      181
      SELECT SQL_NO_CACHE `id_tax_rules_group`
      FROM `ps_product_shop`
      WHERE `id_product` = 10302 AND id_shop=1 LIMIT 1
      0.163 ms 1 /classes/Product.php:6887
      210
      SELECT SQL_NO_CACHE SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = 10320) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.163 ms 1 /classes/stock/StockAvailable.php:453
      241
      SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 171 LIMIT 1
      0.162 ms 1 /classes/Product.php:5670
      316
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10403 AND id_shop = 1 LIMIT 1
      0.162 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:441
      292
      SELECT SQL_NO_CACHE po.*
      FROM `ps_preorder_product` po
      WHERE (po.id_product = 10302) LIMIT 1
      0.162 ms 1 /modules/preorderandnotification/models/PreorderProduct.php:566
      343
      SELECT SQL_NO_CACHE po.*
      FROM `ps_preorder_product` po
      WHERE (po.id_product = 10320) LIMIT 1
      0.162 ms 1 /modules/preorderandnotification/models/PreorderProduct.php:566
      388
      SELECT SQL_NO_CACHE out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.162 ms 1 /classes/stock/StockAvailable.php:778
      60
      SELECT SQL_NO_CACHE `id_tax_rules_group`
      FROM `ps_product_shop`
      WHERE `id_product` = 10199 AND id_shop=1 LIMIT 1
      0.161 ms 1 /classes/Product.php:6887
      68
      SELECT SQL_NO_CACHE cl.`link_rewrite`
      FROM `ps_category_lang` cl
      WHERE `id_lang` = 2
      AND cl.id_shop = 1 
      AND cl.`id_category` = 171 LIMIT 1
      0.161 ms 1 /classes/Category.php:1378
      112
      SELECT SQL_NO_CACHE id_manufacturer as value,CONCAT('mm_manufacturer_',id_manufacturer) as id, name as label
      FROM ps_manufacturer            
      WHERE active=1 
      ORDER BY name asc
      0.161 ms 6 Yes /modules/ets_megamenu/ets_megamenu.php:987
      371
      SELECT SQL_NO_CACHE out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.161 ms 1 /classes/stock/StockAvailable.php:778
      8
      SELECT SQL_NO_CACHE *
      FROM `ps_lang` a
      LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
      WHERE (a.`id_lang` = 2) LIMIT 1
      0.161 ms 1 /src/Adapter/EntityMapper.php:71
      90
      SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 171 LIMIT 1
      0.161 ms 1 /classes/Product.php:5670
      38
      SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
      WHERE `locale` = 'es-mx'
      OR `language_code` = 'es-mx' LIMIT 1
      0.160 ms 1 /classes/Language.php:883
      155
      SELECT SQL_NO_CACHE out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.159 ms 1 /classes/stock/StockAvailable.php:778
      222
      SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 171 LIMIT 1
      0.159 ms 1 /classes/Product.php:5670
      224
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10369 LIMIT 1
      0.159 ms 1 /classes/SpecificPrice.php:435
      337
      SELECT SQL_NO_CACHE out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.158 ms 1 /classes/stock/StockAvailable.php:778
      299
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10270 AND id_shop = 1 LIMIT 1
      0.158 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:441
      315
      SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
      WHERE `id_product` = 10403
      0.158 ms 4 /classes/Product.php:3423
      326
      SELECT SQL_NO_CACHE po.*
      FROM `ps_preorder_product` po
      WHERE (po.id_product = 10403) LIMIT 1
      0.158 ms 1 /modules/preorderandnotification/models/PreorderProduct.php:566
      384
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10311 AND id_shop = 1 LIMIT 1
      0.157 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:441
      148
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10199 LIMIT 1
      0.156 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php:76
      286
      SELECT SQL_NO_CACHE out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.156 ms 1 /classes/stock/StockAvailable.php:778
      297
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10270 LIMIT 1
      0.156 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php:76
      303
      SELECT SQL_NO_CACHE out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.156 ms 1 /classes/stock/StockAvailable.php:778
      333
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10320 AND id_shop = 1 LIMIT 1
      0.156 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:441
      94
      SELECT SQL_NO_CACHE state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
      0.155 ms 1 /classes/FeatureFlag.php:105
      117
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 61 AND `id_shop` = 1 LIMIT 1
      0.155 ms 1 /classes/module/Module.php:2137
      156
      SELECT SQL_NO_CACHE depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.155 ms 1 /classes/stock/StockAvailable.php:753
      162
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 122 AND `id_shop` = 1 LIMIT 1
      0.155 ms 1 /classes/module/Module.php:2137
      217
      SELECT SQL_NO_CACHE `id_tax_rules_group`
      FROM `ps_product_shop`
      WHERE `id_product` = 10215 AND id_shop=1 LIMIT 1
      0.155 ms 1 /classes/Product.php:6887
      350
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10215 AND id_shop = 1 LIMIT 1
      0.155 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:441
      104
      SELECT SQL_NO_CACHE *
      FROM `ps_country_lang`
      WHERE `id_country` = 145
      0.154 ms 1 /src/Adapter/EntityMapper.php:79
      128
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_languageselector" LIMIT 1
      0.154 ms 1 /classes/module/Module.php:2664
      237
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_product_group_reduction_cache`
      WHERE `id_product` = 10311 AND `id_group` = 1 LIMIT 1
      0.154 ms 0 /classes/GroupReduction.php:156
      300
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10270 LIMIT 1
      0.153 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:525
      32
      SELECT SQL_NO_CACHE id_shop
      FROM `ps_group_shop`
      WHERE `id_group` = 1
      AND id_shop = 1 LIMIT 1
      0.152 ms 1 /classes/ObjectModel.php:1732
      80
      SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
      0.152 ms 16 /classes/SpecificPrice.php:310
      139
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 29 AND `id_shop` = 1 LIMIT 1
      0.152 ms 1 /classes/module/Module.php:2137
      172
      SELECT SQL_NO_CACHE `id_tax_rules_group`
      FROM `ps_product_shop`
      WHERE `id_product` = 10242 AND id_shop=1 LIMIT 1
      0.152 ms 1 /classes/Product.php:6887
      199
      SELECT SQL_NO_CACHE `id_tax_rules_group`
      FROM `ps_product_shop`
      WHERE `id_product` = 10403 AND id_shop=1 LIMIT 1
      0.152 ms 1 /classes/Product.php:6887
      287
      SELECT SQL_NO_CACHE depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.152 ms 1 /classes/stock/StockAvailable.php:753
      304
      SELECT SQL_NO_CACHE depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.152 ms 1 /classes/stock/StockAvailable.php:753
      321
      SELECT SQL_NO_CACHE depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.152 ms 1 /classes/stock/StockAvailable.php:753
      372
      SELECT SQL_NO_CACHE depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.152 ms 1 /classes/stock/StockAvailable.php:753
      44
      SELECT SQL_NO_CACHE c.id_currency
      FROM `ps_currency` c
      WHERE (iso_code = 'USD') LIMIT 1
      0.152 ms 1 /classes/Currency.php:893
      79
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
      0.152 ms 16 /classes/SpecificPrice.php:297
      246
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_product_group_reduction_cache`
      WHERE `id_product` = 10203 AND `id_group` = 1 LIMIT 1
      0.152 ms 0 /classes/GroupReduction.php:156
      62
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_group`
      WHERE `id_group` = 1 LIMIT 1
      0.151 ms 1 /classes/Group.php:154
      144
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_sharebuttons" LIMIT 1
      0.151 ms 1 /classes/module/Module.php:2664
      182
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_product_group_reduction_cache`
      WHERE `id_product` = 10302 AND `id_group` = 1 LIMIT 1
      0.151 ms 0 /classes/GroupReduction.php:156
      354
      SELECT SQL_NO_CACHE out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.151 ms 1 /classes/stock/StockAvailable.php:778
      108
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 172 AND `id_shop` = 1 LIMIT 1
      0.151 ms 0 /classes/module/Module.php:2137
      317
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10403 LIMIT 1
      0.151 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:525
      348
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10215 LIMIT 1
      0.151 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php:76
      213
      SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 171 LIMIT 1
      0.150 ms 1 /classes/Product.php:5670
      33
      SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
      WHERE `id_shop` IN (1)
      0.150 ms 1 /classes/module/Module.php:2046
      130
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_currencyselector" LIMIT 1
      0.150 ms 1 /classes/module/Module.php:2664
      165
      SELECT SQL_NO_CACHE ctg.`id_group`
      FROM ps_category_group ctg
      WHERE ctg.`id_category` = 171 AND ctg.`id_group` = 1 LIMIT 1
      0.150 ms 1 /classes/Category.php:1754
      200
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_product_group_reduction_cache`
      WHERE `id_product` = 10403 AND `id_group` = 1 LIMIT 1
      0.150 ms 0 /classes/GroupReduction.php:156
      351
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10215 LIMIT 1
      0.150 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:525
      403
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_emailsubscription" LIMIT 1
      0.150 ms 1 /classes/module/Module.php:2664
      58
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10199 LIMIT 1
      0.149 ms 1 /classes/SpecificPrice.php:435
      170
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 10242 LIMIT 1
      0.149 ms 1 /classes/SpecificPrice.php:435
      9
      SELECT SQL_NO_CACHE id_shop
      FROM `ps_lang_shop`
      WHERE `id_lang` = 2
      AND id_shop = 1 LIMIT 1
      0.148 ms 1 /classes/ObjectModel.php:1732
      134
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 18 AND `id_shop` = 1 LIMIT 1
      0.148 ms 1 /classes/module/Module.php:2137
      280
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10302 LIMIT 1
      0.148 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php:76
      338
      SELECT SQL_NO_CACHE depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.148 ms 1 /classes/stock/StockAvailable.php:753
      102
      SELECT SQL_NO_CACHE *
      FROM `ps_state` a
      WHERE (a.`id_state` = 68) LIMIT 1
      0.147 ms 1 /src/Adapter/EntityMapper.php:71
      356
      SELECT SQL_NO_CACHE location
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.147 ms 1 /classes/stock/StockAvailable.php:806
      159
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_viewedproduct" LIMIT 1
      0.147 ms 1 /classes/module/Module.php:2664
      355
      SELECT SQL_NO_CACHE depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.147 ms 1 /classes/stock/StockAvailable.php:753
      382
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10311 LIMIT 1
      0.147 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php:76
      35
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
      0.146 ms 0 /classes/module/Module.php:2137
      74
      SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
      FROM `ps_category` c
      WHERE (c.`id_category` = 2) LIMIT 1
      0.146 ms 1 /classes/Category.php:1974
      142
      SELECT SQL_NO_CACHE *
      FROM `ps_preorder_dynamic`
      WHERE (id_product =10199) LIMIT 1
      0.146 ms 1 /modules/preorderandnotification/models/PreorderOrder.php:1143
      145
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 30 AND `id_shop` = 1 LIMIT 1
      0.146 ms 1 /classes/module/Module.php:2137
      157
      SELECT SQL_NO_CACHE location
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.146 ms 1 /classes/stock/StockAvailable.php:806
      160
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 80 AND `id_shop` = 1 LIMIT 1
      0.146 ms 1 /classes/module/Module.php:2137
      339
      SELECT SQL_NO_CACHE location
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.146 ms 1 /classes/stock/StockAvailable.php:806
      367
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10369 AND id_shop = 1 LIMIT 1
      0.146 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:441
      385
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10311 LIMIT 1
      0.145 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:525
      65
      SELECT SQL_NO_CACHE out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.145 ms 1 /classes/stock/StockAvailable.php:778
      67
      SELECT SQL_NO_CACHE location
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.145 ms 1 /classes/stock/StockAvailable.php:806
      96
      SELECT SQL_NO_CACHE * FROM `ps_image_type`
      0.145 ms 7 /classes/ImageType.php:161
      161
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categoryproducts" LIMIT 1
      0.145 ms 1 /classes/module/Module.php:2664
      191
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_product_group_reduction_cache`
      WHERE `id_product` = 10270 AND `id_group` = 1 LIMIT 1
      0.145 ms 0 /classes/GroupReduction.php:156
      195
      SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 171 LIMIT 1
      0.145 ms 1 /classes/Product.php:5670
      288
      SELECT SQL_NO_CACHE location
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.145 ms 1 /classes/stock/StockAvailable.php:806
      389
      SELECT SQL_NO_CACHE depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.145 ms 1 /classes/stock/StockAvailable.php:753
      70
      SELECT SQL_NO_CACHE id_shop
      FROM `ps_product_shop`
      WHERE `id_product` = 10199
      AND id_shop = 1 LIMIT 1
      0.144 ms 1 /classes/ObjectModel.php:1732
      120
      SELECT SQL_NO_CACHE cl.`link_rewrite`
      FROM `ps_category_lang` cl
      WHERE `id_lang` = 0
      AND cl.id_shop = 1 
      AND cl.`id_category` = 171 LIMIT 1
      0.144 ms 0 /classes/Category.php:1378
      208
      SELECT SQL_NO_CACHE `id_tax_rules_group`
      FROM `ps_product_shop`
      WHERE `id_product` = 10320 AND id_shop=1 LIMIT 1
      0.144 ms 1 /classes/Product.php:6887
      52
      SELECT SQL_NO_CACHE `name`
      FROM `ps_manufacturer`
      WHERE `id_manufacturer` = 3
      AND `active` = 1 LIMIT 1
      0.143 ms 1 /classes/Manufacturer.php:316
      151
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10199 LIMIT 1
      0.143 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:525
      61
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_product_group_reduction_cache`
      WHERE `id_product` = 10199 AND `id_group` = 1 LIMIT 1
      0.142 ms 0 /classes/GroupReduction.php:156
      66
      SELECT SQL_NO_CACHE depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.142 ms 1 /classes/stock/StockAvailable.php:753
      100
      SELECT SQL_NO_CACHE format
      FROM `ps_address_format`
      WHERE `id_country` = 145 LIMIT 1
      0.142 ms 1 /classes/AddressFormat.php:656
      107
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ybc_productimagehover" LIMIT 1
      0.142 ms 1 /classes/module/Module.php:2664
      110
      SELECT SQL_NO_CACHE id_lang FROM ps_lang WHERE is_rtl=0 AND active=1 LIMIT 1
      0.142 ms 1 /modules/ets_megamenu/ets_megamenu.php:1563
      22
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ets_superspeed" LIMIT 1
      0.142 ms 1 /classes/module/Module.php:2664
      173
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_product_group_reduction_cache`
      WHERE `id_product` = 10242 AND `id_group` = 1 LIMIT 1
      0.142 ms 0 /classes/GroupReduction.php:156
      407
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_socialfollow" LIMIT 1
      0.141 ms 1 /classes/module/Module.php:2664
      7
      SELECT SQL_NO_CACHE *
      FROM `ps_shop_group` a
      WHERE (a.`id_shop_group` = 1) LIMIT 1
      0.141 ms 1 /src/Adapter/EntityMapper.php:71
      283
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10302 LIMIT 1
      0.141 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:525
      34
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_edition_basic" LIMIT 1
      0.140 ms 0 /classes/module/Module.php:2664
      135
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
      0.140 ms 1 /classes/module/Module.php:2664
      152
      SELECT SQL_NO_CACHE `name`
      FROM `ps_hook`
      WHERE `id_hook` = 582 LIMIT 1
      0.140 ms 1 /classes/Hook.php:247
      218
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_product_group_reduction_cache`
      WHERE `id_product` = 10215 AND `id_group` = 1 LIMIT 1
      0.140 ms 0 /classes/GroupReduction.php:156
      82
      SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2026-03-16 00:00:00' AND '2026-03-16 23:59:59' LIMIT 1
      0.139 ms 2 /classes/SpecificPrice.php:381
      122
      SELECT SQL_NO_CACHE `name`
      FROM `ps_hook`
      WHERE `id_hook` = 538 LIMIT 1
      0.139 ms 1 /classes/Hook.php:247
      227
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_product_group_reduction_cache`
      WHERE `id_product` = 10369 AND `id_group` = 1 LIMIT 1
      0.138 ms 0 /classes/GroupReduction.php:156
      236
      SELECT SQL_NO_CACHE `id_tax_rules_group`
      FROM `ps_product_shop`
      WHERE `id_product` = 10311 AND id_shop=1 LIMIT 1
      0.138 ms 1 /classes/Product.php:6887
      373
      SELECT SQL_NO_CACHE location
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.138 ms 1 /classes/stock/StockAvailable.php:806
      396
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_contactinfo" LIMIT 1
      0.138 ms 1 /classes/module/Module.php:2664
      48
      SELECT SQL_NO_CACHE *
      FROM `ps_currency_lang`
      WHERE `id_currency` = 1
      0.137 ms 1 /src/Adapter/EntityMapper.php:79
      24
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ybc_blog" LIMIT 1
      0.136 ms 0 /modules/ets_superspeed/classes/ets_superspeed_defines.php:2447
      99
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
      0.136 ms 0 /classes/module/Module.php:2137
      116
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "psgdpr" LIMIT 1
      0.135 ms 1 /classes/module/Module.php:2664
      129
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 26 AND `id_shop` = 1 LIMIT 1
      0.135 ms 1 /classes/module/Module.php:2137
      397
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 14 AND `id_shop` = 1 LIMIT 1
      0.134 ms 1 /classes/module/Module.php:2137
      399
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customeraccountlinks" LIMIT 1
      0.134 ms 1 /classes/module/Module.php:2664
      408
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 32 AND `id_shop` = 1 LIMIT 1
      0.134 ms 1 /classes/module/Module.php:2137
      111
      SELECT SQL_NO_CACHE id_lang FROM ps_lang WHERE is_rtl=1 AND active=1 LIMIT 1
      0.133 ms 1 /modules/ets_megamenu/ets_megamenu.php:1563
      23
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 197 AND `id_shop` = 1 LIMIT 1
      0.132 ms 1 /classes/module/Module.php:2137
      25
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_imageslider" LIMIT 1
      0.132 ms 0 /modules/ets_superspeed/classes/ets_superspeed_defines.php:2447
      26
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "homeslider" LIMIT 1
      0.132 ms 0 /modules/ets_superspeed/classes/ets_superspeed_defines.php:2447
      27
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockbanner" LIMIT 1
      0.132 ms 0 /modules/ets_superspeed/classes/ets_superspeed_defines.php:2447
      105
      SELECT SQL_NO_CACHE id_required_field, object_name, field_name
      FROM ps_required_field
      0.132 ms 1 /classes/ObjectModel.php:1595
      131
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 16 AND `id_shop` = 1 LIMIT 1
      0.131 ms 1 /classes/module/Module.php:2137
      121
      SELECT SQL_NO_CACHE *
      FROM `ps_preorder_dynamic`
      WHERE (id_product =10199) LIMIT 1
      0.131 ms 1 /modules/preorderandnotification/models/PreorderOrder.php:1143
      209
      SELECT SQL_NO_CACHE `reduction`
      FROM `ps_product_group_reduction_cache`
      WHERE `id_product` = 10320 AND `id_group` = 1 LIMIT 1
      0.131 ms 0 /classes/GroupReduction.php:156
      390
      SELECT SQL_NO_CACHE location
      FROM `ps_stock_available`
      WHERE (id_product = 10199) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
      0.130 ms 1 /classes/stock/StockAvailable.php:806
      53
      SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
      0.129 ms 0 /classes/Supplier.php:243
      368
      SELECT SQL_NO_CACHE * FROM `ps_ets_am_loy_reward` WHERE `id_product` = 10369 LIMIT 1
      0.129 ms 1 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php:525
      401
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
      0.129 ms 1 /classes/module/Module.php:2664
      28
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_banner" LIMIT 1
      0.128 ms 1 /modules/ets_superspeed/classes/ets_superspeed_defines.php:2447
      133
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_customersignin" LIMIT 1
      0.127 ms 1 /classes/module/Module.php:2664
      402
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 27 AND `id_shop` = 1 LIMIT 1
      0.127 ms 1 /classes/module/Module.php:2137
      101
      SELECT SQL_NO_CACHE `need_identification_number`
      FROM `ps_country`
      WHERE `id_country` = 145 LIMIT 1
      0.127 ms 1 /classes/Country.php:405
      75
      SELECT SQL_NO_CACHE id_shop
      FROM `ps_category_shop`
      WHERE `id_category` = 171
      AND id_shop = 1 LIMIT 1
      0.125 ms 1 /classes/ObjectModel.php:1732
      400
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 17 AND `id_shop` = 1 LIMIT 1
      0.124 ms 1 /classes/module/Module.php:2137
      404
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 21 AND `id_shop` = 1 LIMIT 1
      0.124 ms 1 /classes/module/Module.php:2137
      136
      SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 31 AND `id_shop` = 1 LIMIT 1
      0.123 ms 1 /classes/module/Module.php:2137
      49
      SELECT SQL_NO_CACHE id_shop
      FROM `ps_currency_shop`
      WHERE `id_currency` = 1
      AND id_shop = 1 LIMIT 1
      0.122 ms 1 /classes/ObjectModel.php:1732
      83
      SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
      FROM `ps_specific_price_priority`
      WHERE `id_product` = 10199
      ORDER BY `id_specific_price_priority` DESC LIMIT 1
      0.122 ms 0 /classes/SpecificPrice.php:259

      Doubles

      18 queries
      SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
      18 queries
      SELECT * FROM `ps_ets_am_loy_reward` WHERE `id_product` = XX LIMIT XX
      11 queries
      SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
      10 queries
      SELECT *
      FROM `ps_product` a
      LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
      WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
      10 queries
      SELECT COUNT(p.id_product)
                  FROM `ps_product` p
                   INNER JOIN ps_product_shop product_shop
              ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX)
                  WHERE p.id_product = XX
                  AND DATEDIFF("XX-XX-XX XX:XX:XX", product_shop.`date_add`) < XX LIMIT XX
      10 queries
      SELECT product_shop.`price`, product_shop.`ecotax`,
      XX as id_product_attribute
      FROM `ps_product` p
      INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
      WHERE (p.`id_product` = XX)
      
      10 queries
                                  SELECT `id_tax_rules_group`
                                  FROM `ps_product_shop`
                                  WHERE `id_product` = XX AND id_shop=XX LIMIT XX
      10 queries
      			SELECT `reduction`
      			FROM `ps_product_group_reduction_cache`
      			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
      10 queries
              SELECT t.`id_lang`, t.`name`
              FROM ps_tag t
              LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
              WHERE pt.`id_product`=XX
      10 queries
      SELECT SUM(quantity)
      FROM `ps_stock_available`
      WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
      10 queries
      SELECT out_of_stock
      FROM `ps_stock_available`
      WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
      10 queries
      SELECT depends_on_stock
      FROM `ps_stock_available`
      WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
      10 queries
      SELECT location
      FROM `ps_stock_available`
      WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
      10 queries
      SELECT image_shop.`id_image`
                          FROM `ps_image` i
                           INNER JOIN ps_image_shop image_shop
              ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
                          WHERE i.`id_product` = XX
                          AND image_shop.`cover` = XX LIMIT XX
      10 queries
      SELECT name FROM ps_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
      10 queries
      SELECT
                  COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity,
                  COALESCE(SUM(first_level_quantity), XX) as quantity
                FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity
                FROM `ps_cart_product` cp
                  WHERE cp.`id_product_attribute` = XX
                  
                  AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
                FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
                  WHERE cp.`id_product_attribute` = XX
                  
                  AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR (
                  pr.`pack_stock_type` = XX
                  AND XX = XX
              ))) as q LIMIT XX
      9 queries
                  SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
                  FROM `ps_image` i
                   INNER JOIN ps_image_shop image_shop
              ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
                  LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
                  WHERE i.`id_product` = XX
                  ORDER BY `position`
      9 queries
      SELECT *
      FROM `ps_product` a
      LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
      WHERE (a.`id_product` = XX) LIMIT XX
      9 queries
      SELECT *
      							FROM `ps_product_lang`
      							WHERE `id_product` = XX AND `id_shop` = XX
      9 queries
                  SELECT wp.`quantity`,w.`id_ets_wishlist`
                      FROM `ps_ets_wishlist_product` wp
                  JOIN `ps_ets_wishlist` w ON (w.`id_ets_wishlist` = wp.`id_ets_wishlist`)
                  WHERE  w.`id_customer` = XX
                  AND wp.`id_product` = XX
                  AND wp.`id_product_attribute` = XX LIMIT XX
      9 queries
      SELECT COUNT(*) FROM `ps_ets_am_user` WHERE `id_customer` = XX AND (`status` = -XX OR `loy` = -XX OR `loy` = -XX) AND id_shop = XX LIMIT XX
      9 queries
      SELECT COUNT(*) FROM `ps_ets_am_user` WHERE id_customer = XX AND (`status` = -XX OR `aff` = -XX OR `aff` = -XX) AND id_shop =  XX LIMIT XX
      9 queries
                      SELECT `id_category` FROM `ps_category_product`
                      WHERE `id_product` = XX
      9 queries
      SELECT * FROM `ps_ets_am_loy_reward` WHERE `id_product` = XX AND id_shop = XX LIMIT XX
      9 queries
      SELECT GROUP_CONCAT(DISTINCT ws.id_customer) AS `new_joined_ids`, ws.`id_product`, ws.`id_customer`, ws.`id_comb`,
                  pa.`id_product_attribute`, sa.`quantity`
                  FROM `ps_product_attribute` pa
                  LEFT JOIN `ps_stock_available` sa
                      ON (pa.id_product_attribute = sa.id_product_attribute)
                  LEFT JOIN `ps_subs` ws
                      ON (pa.id_product_attribute = ws.id_comb)
                  WHERE pa.`id_product` = XX
                  AND sa.quantity <= XX GROUP BY pa.id_product_attribute
      8 queries
      SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
                  FROM `ps_product_attribute` pa
                   INNER JOIN ps_product_attribute_shop product_attribute_shop
              ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
                  JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
                  JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
                  JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
                  JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
                  WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX
                  GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
                  
                  ORDER BY a.`position` ASC;
      8 queries
      SELECT po.*
      FROM `ps_preorder_product` po
      WHERE (po.id_product = XX) LIMIT XX
      4 queries
                      SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop`
                      FROM `ps_module` m
                      LEFT JOIN `ps_module_shop` ms
                      ON m.`id_module` = ms.`id_module`
                      AND ms.`id_shop` = XX
      4 queries
      SELECT `id_lang` FROM `ps_lang`
                          WHERE `locale` = 'es-mx'
                          OR `language_code` = 'es-mx' LIMIT XX
      3 queries
              SELECT pa.id_product_attribute
              FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop
              ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
              WHERE pa.`id_product` = XX
      2 queries
      SELECT *
      FROM `ps_currency` a
      LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX
      LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX
      WHERE (a.`id_currency` = XX) LIMIT XX
      2 queries
      				SELECT tr.*
      				FROM `ps_tax_rule` tr
      				JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
      				WHERE trg.`active` = XX
      				AND tr.`id_country` = XX
      				AND tr.`id_tax_rules_group` = XX
      				AND tr.`id_state` IN (XX, XX)
      				AND ('XX ' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
      					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX ')))
      				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
      2 queries
      			SELECT cl.`link_rewrite`
      			FROM `ps_category_lang` cl
      			WHERE `id_lang` = XX
      			 AND cl.id_shop = XX 
      			AND cl.`id_category` = XX LIMIT XX
      2 queries
      				SELECT tr.*
      				FROM `ps_tax_rule` tr
      				JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
      				WHERE trg.`active` = XX
      				AND tr.`id_country` = XX
      				AND tr.`id_tax_rules_group` = XX
      				AND tr.`id_state` IN (XX, XX)
      				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
      					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
      				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
      2 queries
      			SELECT `need_identification_number`
      			FROM `ps_country`
      			WHERE `id_country` = XX LIMIT XX
      2 queries
                  SELECT *
                  FROM `ps_currency` c
                   INNER JOIN ps_currency_shop currency_shop
              ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX)
                      WHERE c.`deleted` = XX AND c.`active` = XX ORDER BY `iso_code` ASC
      2 queries
      SELECT id_lang FROM ps_lang WHERE is_rtl=XX AND active=XX LIMIT XX
      2 queries
                  SELECT id_manufacturer as value,CONCAT('mm_manufacturer_',id_manufacturer) as id, name as label
                  FROM ps_manufacturer            
                  WHERE active=XX 
                  ORDER BY name asc
              
      2 queries
                  SELECT c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
                  FROM ps_cms c
                  LEFT JOIN ps_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=XX
                  WHERE c.active=XX 
                  ORDER BY cl.meta_title asc
              
      2 queries
      SELECT *
      FROM `ps_preorder_dynamic`
      WHERE (id_product =XX) LIMIT XX
      2 queries
      							SELECT `name`
      							FROM `ps_hook`
      							WHERE `id_hook` = XX LIMIT XX
      2 queries
      SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX
      2 queries
      SELECT w.*, wl.title, wl.subtitle, wl.description 
                      FROM ps_ybc_widget_widget w
                      LEFT JOIN ps_ybc_widget_widget_lang wl ON w.id_widget = wl.id_widget AND wl.id_lang = XX
                      WHERE w.hook = 'ybcCustomXX'  AND enabled=XX 
                      ORDER BY w.sort_order ASC, wl.title ASC
                      
      2 queries
      INSERT IGNORE INTO `ps_ets_superspeed_cache_page_hook` set id_cache_page="XX", hook_name="displayNavXX"

      Tables stress

      55 product
      55 product_shop
      52 stock_available
      30 module
      27 ets_am_loy_reward
      24 cart_product
      23 module_shop
      22 product_lang
      21 product_attribute
      21 image_shop
      19 category_lang
      19 image
      18 ets_am_user
      16 specific_price
      13 product_attribute_shop
      12 category_product
      11 image_lang
      11 pack
      10 product_group_reduction_cache
      10 tag
      10 product_tag
      9 lang
      9 currency
      9 attribute
      9 attribute_lang
      9 product_attribute_combination
      9 ets_wishlist_product
      9 ets_wishlist
      9 subs
      8 hook
      8 attribute_group
      8 preorder_product
      7 currency_shop
      6 manufacturer
      6 category
      5 category_shop
      4 shop_url
      4 shop
      4 lang_shop
      4 country
      4 tax_rule
      4 tax_rules_group
      4 cart_rule
      4 ybc_widget_widget
      4 ybc_widget_widget_lang
      3 hook_module
      3 hook_alias
      3 currency_lang
      3 category_group
      2 shop_group
      2 configuration
      2 country_lang
      2 country_shop
      2 group
      2 group_shop
      2 image_type
      2 cms
      2 cms_lang
      2 preorder_dynamic
      2 cart_rule_lang
      2 ets_superspeed_cache_page
      1 configuration_lang
      1 module_group
      1 meta
      1 meta_lang
      1 group_lang
      1 hook_module_exceptions
      1 supplier
      1 specific_price_priority
      1 attribute_group_lang
      1 attribute_shop
      1 accessory
      1 feature_flag
      1 manufacturer_lang
      1 manufacturer_shop
      1 address_format
      1 state
      1 required_field
      1 connections

      ObjectModel instances

      Name Instances Source
      Product 80 /controllers/front/ProductController.php:146 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10199]
      /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10199]
      /classes/Meta.php:353 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:885 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1500 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:885 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1500 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10199]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1638 (__construct) [id: 10199]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1665 (__construct) [id: 10199]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1700 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1518 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10242]
      /classes/Link.php:113 (__construct) [id: 10302]
      /classes/Link.php:113 (__construct) [id: 10270]
      /classes/Link.php:113 (__construct) [id: 10403]
      /classes/Link.php:113 (__construct) [id: 10320]
      /classes/Link.php:113 (__construct) [id: 10215]
      /classes/Link.php:113 (__construct) [id: 10369]
      /classes/Link.php:113 (__construct) [id: 10311]
      /classes/Link.php:113 (__construct) [id: 10203]
      /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10242]
      /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10302]
      /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10270]
      /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10403]
      /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10320]
      /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10215]
      /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10369]
      /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 10311]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1638 (__construct) [id: 10242]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1665 (__construct) [id: 10242]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1700 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1518 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10242]
      /modules/preorderandnotification/preorderandnotification.php:951 (__construct) [id: 10242]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1638 (__construct) [id: 10302]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1665 (__construct) [id: 10302]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1700 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1518 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10302]
      /modules/preorderandnotification/preorderandnotification.php:951 (__construct) [id: 10302]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1638 (__construct) [id: 10270]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1665 (__construct) [id: 10270]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1700 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1518 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10270]
      /modules/preorderandnotification/preorderandnotification.php:951 (__construct) [id: 10270]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1638 (__construct) [id: 10403]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1665 (__construct) [id: 10403]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1700 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1518 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10403]
      /modules/preorderandnotification/preorderandnotification.php:951 (__construct) [id: 10403]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1638 (__construct) [id: 10320]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1665 (__construct) [id: 10320]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1700 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1518 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10320]
      /modules/preorderandnotification/preorderandnotification.php:951 (__construct) [id: 10320]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1638 (__construct) [id: 10215]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1665 (__construct) [id: 10215]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1700 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1518 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10215]
      /modules/preorderandnotification/preorderandnotification.php:951 (__construct) [id: 10215]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1638 (__construct) [id: 10369]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1665 (__construct) [id: 10369]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1700 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1518 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10369]
      /modules/preorderandnotification/preorderandnotification.php:951 (__construct) [id: 10369]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1638 (__construct) [id: 10311]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1665 (__construct) [id: 10311]
      /modules/ets_affiliatemarketing/ets_affiliatemarketing.php:1700 (__construct) [id: 10199]
      /modules/preorderandnotification/preorderandnotification.php:1518 (__construct) [id: 10199]
      /classes/Link.php:113 (__construct) [id: 10311]
      /modules/preorderandnotification/preorderandnotification.php:951 (__construct) [id: 10311]
      Address 15 /classes/Product.php:741 (__construct) [id: ]
      /classes/Product.php:6906 (initialize) [id: ]
      /classes/Product.php:3804 (__construct) [id: ]
      /controllers/front/ProductController.php:598 (__construct) [id: 0]
      /classes/Product.php:5975 (__construct) [id: ]
      /classes/shop/Shop.php:486 (__construct) [id: ]
      /classes/Product.php:741 (__construct) [id: ]
      /classes/Product.php:741 (__construct) [id: ]
      /classes/Product.php:741 (__construct) [id: ]
      /classes/Product.php:741 (__construct) [id: ]
      /classes/Product.php:741 (__construct) [id: ]
      /classes/Product.php:741 (__construct) [id: ]
      /classes/Product.php:741 (__construct) [id: ]
      /classes/Product.php:741 (__construct) [id: ]
      /classes/Product.php:741 (__construct) [id: ]
      PreorderModel 9 /modules/preorderandnotification/preorderandnotification.php:1516 (__construct) [id: ]
      /modules/preorderandnotification/preorderandnotification.php:1516 (__construct) [id: ]
      /modules/preorderandnotification/preorderandnotification.php:1516 (__construct) [id: ]
      /modules/preorderandnotification/preorderandnotification.php:1516 (__construct) [id: ]
      /modules/preorderandnotification/preorderandnotification.php:1516 (__construct) [id: ]
      /modules/preorderandnotification/preorderandnotification.php:1516 (__construct) [id: ]
      /modules/preorderandnotification/preorderandnotification.php:1516 (__construct) [id: ]
      /modules/preorderandnotification/preorderandnotification.php:1516 (__construct) [id: ]
      /modules/preorderandnotification/preorderandnotification.php:1516 (__construct) [id: ]
      Category 9 /controllers/front/ProductController.php:303 (__construct) [id: 171]
      /controllers/front/ProductController.php:1344 (__construct) [id: 171]
      /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ]
      /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ]
      /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ]
      /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ]
      /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ]
      /modules/ps_categoryproducts/ps_categoryproducts.php:238 (__construct) [id: 171]
      /modules/ps_categoryproducts/ps_categoryproducts.php:266 (__construct) [id: 171]
      Country 5 /config/config.inc.php:146 (__construct) [id: 145]
      /classes/AddressFormat.php:404 (__construct) [id: 145]
      /classes/controller/FrontController.php:1769 (__construct) [id: 145]
      /classes/AddressFormat.php:404 (__construct) [id: 145]
      /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 145]
      State 5 /classes/AddressFormat.php:404 (__construct) [id: 68]
      /classes/controller/FrontController.php:1768 (__construct) [id: 68]
      /classes/AddressFormat.php:404 (__construct) [id: 68]
      /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 68]
      /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 68]
      Currency 4 /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1]
      /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2]
      /classes/Tools.php:691 (getCurrencyInstance) [id: 1]
      /classes/Tools.php:818 (getCurrencyInstance) [id: 0]
      Customer 3 /config/config.inc.php:264 (__construct) [id: ]
      /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:797 (__construct) [id: 0]
      /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php:797 (__construct) [id: 0]
      Cart 3 /classes/controller/FrontController.php:467 (__construct) [id: ]
      /classes/controller/FrontController.php:541 (__construct) [id: ]
      /modules/ets_superspeed/ets_superspeed.php:338 (__construct) [id: ]
      Tax 2 /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 0]
      /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 0]
      AddressFormat 2 /classes/controller/FrontController.php:1763 (generateAddress) [id: ]
      /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
      Language 2 /config/config.inc.php:211 (__construct) [id: 2]
      /classes/Tools.php:561 (__construct) [id: 2]
      Manufacturer 2 /controllers/front/ProductController.php:438 (__construct) [id: 3]
      /classes/Link.php:657 (__construct) [id: 3]
      ConnectionsSource 1 /modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]
      Shop 1 /config/config.inc.php:117 (initialize) [id: 1]
      Risk 1 /classes/controller/FrontController.php:1695 (__construct) [id: ]
      Gender 1 /classes/controller/FrontController.php:1692 (__construct) [id: 0]
      Group 1 /modules/ets_superspeed/classes/cache.php:81 (getCurrent) [id: 1]
      ShopGroup 1 /classes/shop/Shop.php:561 (__construct) [id: 1]
      Ets_superspeed_cache_page 1 /modules/ets_superspeed/classes/cache.php:276 (__construct) [id: ]

      Included Files

      # Filename
      0 /index.php
      1 /config/config.inc.php
      2 /config/defines.inc.php
      3 /config/autoload.php
      4 /vendor/autoload.php
      5 /vendor/composer/autoload_real.php
      6 /vendor/composer/platform_check.php
      7 /vendor/composer/ClassLoader.php
      8 /vendor/composer/include_paths.php
      9 /vendor/composer/autoload_static.php
      10 /vendor/symfony/polyfill-php72/bootstrap.php
      11 /vendor/symfony/polyfill-mbstring/bootstrap.php
      12 /vendor/symfony/polyfill-mbstring/bootstrap80.php
      13 /vendor/symfony/polyfill-intl-normalizer/bootstrap.php
      14 /vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
      15 /vendor/symfony/polyfill-intl-idn/bootstrap.php
      16 /vendor/symfony/deprecation-contracts/function.php
      17 /vendor/ralouphie/getallheaders/src/getallheaders.php
      18 /vendor/symfony/polyfill-ctype/bootstrap.php
      19 /vendor/symfony/polyfill-ctype/bootstrap80.php
      20 /vendor/symfony/polyfill-php80/bootstrap.php
      21 /vendor/guzzlehttp/promises/src/functions_include.php
      22 /vendor/guzzlehttp/promises/src/functions.php
      23 /vendor/guzzlehttp/guzzle/src/functions_include.php
      24 /vendor/guzzlehttp/guzzle/src/functions.php
      25 /vendor/symfony/polyfill-iconv/bootstrap.php
      26 /vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
      27 /vendor/jakeasmith/http_build_url/src/http_build_url.php
      28 /vendor/lcobucci/jwt/compat/class-aliases.php
      29 /vendor/lcobucci/jwt/src/Token.php
      30 /vendor/lcobucci/jwt/src/Signature.php
      31 /vendor/lcobucci/jwt/compat/json-exception-polyfill.php
      32 /vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
      33 /vendor/swiftmailer/swiftmailer/lib/swift_required.php
      34 /vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
      35 /vendor/symfony/polyfill-intl-icu/bootstrap.php
      36 /vendor/symfony/polyfill-php73/bootstrap.php
      37 /vendor/symfony/polyfill-php81/bootstrap.php
      38 /vendor/api-platform/core/src/deprecation.php
      39 /vendor/api-platform/core/src/Api/FilterInterface.php
      40 /vendor/api-platform/core/src/Api/ResourceClassResolverInterface.php
      41 /vendor/api-platform/core/src/deprecated_interfaces.php
      42 /vendor/api-platform/core/src/Metadata/Property/Factory/PropertyNameCollectionFactoryInterface.php
      43 /vendor/api-platform/core/src/Metadata/Resource/Factory/ResourceNameCollectionFactoryInterface.php
      44 /vendor/api-platform/core/src/Metadata/Extractor/ResourceExtractorInterface.php
      45 /vendor/api-platform/core/src/Core/Bridge/Doctrine/Common/Filter/DateFilterInterface.php
      46 /vendor/api-platform/core/src/Core/Bridge/Doctrine/Common/Filter/ExistsFilterInterface.php
      47 /vendor/api-platform/core/src/Core/Bridge/Doctrine/Common/Filter/OrderFilterInterface.php
      48 /vendor/api-platform/core/src/Core/Bridge/Doctrine/Common/Filter/RangeFilterInterface.php
      49 /vendor/api-platform/core/src/Core/Bridge/Doctrine/Common/Filter/SearchFilterInterface.php
      50 /vendor/api-platform/core/src/Core/Bridge/Doctrine/MongoDbOdm/Extension/AggregationCollectionExtensionInterface.php
      51 /vendor/api-platform/core/src/Core/Bridge/Doctrine/MongoDbOdm/Extension/AggregationItemExtensionInterface.php
      52 /vendor/api-platform/core/src/Core/Bridge/Doctrine/MongoDbOdm/Extension/AggregationResultCollectionExtensionInterface.php
      53 /vendor/api-platform/core/src/Core/Bridge/Doctrine/MongoDbOdm/Extension/AggregationResultItemExtensionInterface.php
      54 /vendor/api-platform/core/src/Core/Bridge/Doctrine/MongoDbOdm/Filter/FilterInterface.php
      55 /vendor/api-platform/core/src/Doctrine/Orm/QueryAwareInterface.php
      56 /vendor/api-platform/core/src/Doctrine/Orm/Util/QueryNameGeneratorInterface.php
      57 /vendor/api-platform/core/src/Elasticsearch/Metadata/Document/Factory/DocumentMetadataFactoryInterface.php
      58 /vendor/api-platform/core/src/Symfony/Validator/ValidationGroupsGeneratorInterface.php
      59 /vendor/api-platform/core/src/Symfony/Validator/Exception/ConstraintViolationListAwareExceptionInterface.php
      60 /vendor/api-platform/core/src/Exception/ExceptionInterface.php
      61 /vendor/api-platform/core/src/Core/Bridge/Symfony/Validator/Metadata/Property/Restriction/PropertySchemaRestrictionMetadataInterface.php
      62 /vendor/api-platform/core/src/State/Pagination/PaginatorInterface.php
      63 /vendor/api-platform/core/src/State/Pagination/PartialPaginatorInterface.php
      64 /vendor/api-platform/core/src/Documentation/DocumentationInterface.php
      65 /vendor/api-platform/core/src/JsonLd/AnonymousContextBuilderInterface.php
      66 /vendor/api-platform/core/src/JsonLd/ContextBuilderInterface.php
      67 /vendor/api-platform/core/src/Core/JsonSchema/SchemaFactoryInterface.php
      68 /vendor/api-platform/core/src/JsonSchema/TypeFactoryInterface.php
      69 /vendor/api-platform/core/src/OpenApi/Factory/OpenApiFactoryInterface.php
      70 /vendor/api-platform/core/src/PathResolver/OperationPathResolverInterface.php
      71 /vendor/api-platform/core/src/Symfony/Security/ResourceAccessCheckerInterface.php
      72 /vendor/api-platform/core/src/Serializer/Filter/FilterInterface.php
      73 /vendor/api-platform/core/src/Serializer/SerializerContextBuilderInterface.php
      74 /vendor/api-platform/core/src/Validator/ValidatorInterface.php
      75 /vendor/api-platform/core/src/Api/UrlGeneratorInterface.php
      76 /vendor/api-platform/core/src/GraphQl/ExecutorInterface.php
      77 /vendor/api-platform/core/src/GraphQl/Error/ErrorHandlerInterface.php
      78 /vendor/api-platform/core/src/Core/GraphQl/Resolver/Stage/ValidateStageInterface.php
      79 /vendor/api-platform/core/src/Core/GraphQl/Resolver/Stage/ReadStageInterface.php
      80 /vendor/api-platform/core/src/Core/GraphQl/Resolver/Stage/SecurityPostDenormalizeStageInterface.php
      81 /vendor/api-platform/core/src/Core/GraphQl/Resolver/Stage/SecurityStageInterface.php
      82 /vendor/api-platform/core/src/Core/GraphQl/Resolver/Stage/WriteStageInterface.php
      83 /vendor/api-platform/core/src/Core/GraphQl/Resolver/Stage/SerializeStageInterface.php
      84 /vendor/api-platform/core/src/Core/GraphQl/Resolver/Stage/DeserializeStageInterface.php
      85 /vendor/api-platform/core/src/GraphQl/Resolver/QueryItemResolverInterface.php
      86 /vendor/api-platform/core/src/GraphQl/Resolver/QueryCollectionResolverInterface.php
      87 /vendor/api-platform/core/src/Core/GraphQl/Resolver/Factory/ResolverFactoryInterface.php
      88 /vendor/api-platform/core/src/GraphQl/Resolver/MutationResolverInterface.php
      89 /vendor/api-platform/core/src/Core/GraphQl/Subscription/MercureSubscriptionIriGeneratorInterface.php
      90 /vendor/api-platform/core/src/Core/GraphQl/Subscription/SubscriptionIdentifierGeneratorInterface.php
      91 /vendor/api-platform/core/src/Core/GraphQl/Subscription/SubscriptionManagerInterface.php
      92 /vendor/api-platform/core/src/Core/GraphQl/Serializer/SerializerContextBuilderInterface.php
      93 /vendor/api-platform/core/src/GraphQl/Type/TypesFactoryInterface.php
      94 /vendor/api-platform/core/src/GraphQl/Type/Definition/TypeInterface.php
      95 /vendor/api-platform/core/src/GraphQl/Type/TypesContainerInterface.php
      96 /vendor/psr/container/src/ContainerInterface.php
      97 /vendor/api-platform/core/src/Operation/PathSegmentNameGeneratorInterface.php
      98 /vendor/ircmaxell/password-compat/lib/password.php
      99 /vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
      100 /vendor/prestashop/laminas-code-lts/polyfill/ReflectionEnumPolyfill.php
      101 /src/Core/Version.php
      102 /config/alias.php
      103 /vendor/prestashop/autoload/src/PrestashopAutoload.php
      104 /vendor/prestashop/autoload/src/LegacyClassLoader.php
      105 /vendor/symfony/symfony/src/Symfony/Component/Filesystem/Filesystem.php
      106 /vendor/prestashop/autoload/src/Autoloader.php
      107 /config/bootstrap.php
      108 /src/Core/ContainerBuilder.php
      109 /src/Core/Foundation/IoC/Container.php
      110 /src/Adapter/ServiceLocator.php
      111 /var/cache/prod/appParameters.php
      114 /var/cache/prod/class_index.php
      115 /classes/controller/Controller.php
      117 /classes/ObjectModel.php
      118 /src/Core/Foundation/Database/EntityInterface.php
      120 /classes/db/Db.php
      122 /classes/Hook.php
      124 /classes/module/Module.php
      125 /src/Core/Module/Legacy/ModuleInterface.php
      127 /classes/Tools.php
      128 /classes/Context.php
      129 /classes/shop/Shop.php
      130 /src/Core/Security/PasswordGenerator.php
      131 /classes/db/DbPDO.php
      132 /classes/AddressFormat.php
      133 /classes/Configuration.php
      134 /classes/Validate.php
      135 /classes/cache/Cache.php
      136 /src/Adapter/EntityMapper.php
      137 /classes/db/DbQuery.php
      138 /src/Core/Addon/Theme/ThemeManagerBuilder.php
      139 /vendor/psr/log/Psr/Log/NullLogger.php
      140 /vendor/psr/log/Psr/Log/AbstractLogger.php
      141 /vendor/psr/log/Psr/Log/LoggerInterface.php
      142 /src/Adapter/Configuration.php
      143 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ParameterBag.php
      144 /src/Core/Domain/Configuration/ShopConfigurationInterface.php
      145 /src/Core/ConfigurationInterface.php
      146 /src/Core/Addon/Theme/ThemeRepository.php
      147 /src/Core/Addon/AddonRepositoryInterface.php
      148 /src/Core/Domain/Shop/ValueObject/ShopConstraint.php
      149 /src/Core/Addon/Theme/Theme.php
      150 /src/Core/Addon/AddonInterface.php
      151 /src/Core/Util/ArrayFinder.php
      152 /vendor/symfony/symfony/src/Symfony/Component/PropertyAccess/PropertyAccess.php
      153 /vendor/symfony/symfony/src/Symfony/Component/PropertyAccess/PropertyAccessorBuilder.php
      154 /vendor/symfony/symfony/src/Symfony/Component/PropertyAccess/PropertyAccessor.php
      155 /vendor/symfony/symfony/src/Symfony/Component/PropertyAccess/PropertyAccessorInterface.php
      156 /vendor/symfony/symfony/src/Symfony/Component/PropertyAccess/PropertyPath.php
      157 /vendor/symfony/symfony/src/Symfony/Component/PropertyAccess/PropertyPathInterface.php
      158 /config/defines_uri.inc.php
      159 /classes/Language.php
      160 /src/Core/Language/LanguageInterface.php
      161 /classes/Country.php
      162 /classes/PrestaShopCollection.php
      163 /classes/shop/ShopGroup.php
      164 /classes/Cookie.php
      165 /classes/PhpEncryption.php
      166 /classes/PhpEncryptionEngine.php
      167 /vendor/defuse/php-encryption/src/Key.php
      168 /vendor/defuse/php-encryption/src/Encoding.php
      169 /vendor/defuse/php-encryption/src/Core.php
      170 /vendor/defuse/php-encryption/src/Crypto.php
      171 /vendor/defuse/php-encryption/src/KeyOrPassword.php
      172 /vendor/defuse/php-encryption/src/RuntimeTests.php
      173 /vendor/defuse/php-encryption/src/DerivedKeys.php
      174 /vendor/defuse/php-encryption/src/Exception/WrongKeyOrModifiedCiphertextException.php
      175 /vendor/defuse/php-encryption/src/Exception/CryptoException.php
      176 /src/Core/Session/SessionHandler.php
      177 /src/Core/Session/SessionHandlerInterface.php
      178 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Session.php
      179 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Attribute/AttributeBag.php
      180 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Attribute/AttributeBagInterface.php
      181 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/SessionBagInterface.php
      182 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Flash/FlashBag.php
      183 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Flash/FlashBagInterface.php
      184 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/SessionBagProxy.php
      185 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/SessionInterface.php
      186 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/PhpBridgeSessionStorage.php
      187 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/NativeSessionStorage.php
      188 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/MetadataBag.php
      189 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/StrictSessionHandler.php
      190 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Handler/AbstractSessionHandler.php
      191 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Proxy/SessionHandlerProxy.php
      192 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/Proxy/AbstractProxy.php
      193 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Session/Storage/SessionStorageInterface.php
      194 /config/smarty.config.inc.php
      195 /vendor/smarty/smarty/libs/Smarty.class.php
      196 /vendor/smarty/smarty/libs/functions.php
      197 /vendor/smarty/smarty/libs/Autoloader.php
      198 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_data.php
      199 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php
      200 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
      201 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
      202 /vendor/smarty/smarty/libs/sysplugins/smarty_resource.php
      203 /vendor/smarty/smarty/libs/sysplugins/smarty_variable.php
      204 /vendor/smarty/smarty/libs/sysplugins/smarty_template_source.php
      205 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php
      206 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_resource_file.php
      207 /config/smartyfront.config.inc.php
      208 /classes/Smarty/SmartyResourceModule.php
      209 /vendor/smarty/smarty/libs/sysplugins/smarty_resource_custom.php
      210 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerresource.php
      211 /classes/Smarty/SmartyResourceParent.php
      212 /classes/Smarty/SmartyLazyRegister.php
      213 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_registerplugin.php
      214 /vendor/smarty/smarty/libs/plugins/modifier.truncate.php
      215 /classes/Customer.php
      216 /classes/Group.php
      217 /override/classes/Link.php
      218 /classes/Link.php
      219 /classes/shop/ShopUrl.php
      220 /override/classes/Dispatcher.php
      221 /classes/Dispatcher.php
      222 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/Request.php
      223 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/AcceptHeader.php
      224 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/AcceptHeaderItem.php
      225 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/FileBag.php
      226 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/HeaderBag.php
      227 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/HeaderUtils.php
      228 /vendor/symfony/symfony/src/Symfony/Component/HttpFoundation/ServerBag.php
      229 /src/Adapter/SymfonyContainer.php
      230 /vendor/mobiledetect/mobiledetectlib/Mobile_Detect.php
      231 /config/db_slave_server.inc.php
      232 /src/Adapter/ContainerBuilder.php
      233 /src/Adapter/Environment.php
      234 /src/Core/EnvironmentInterface.php
      235 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCache.php
      236 /vendor/symfony/symfony/src/Symfony/Component/Config/ResourceCheckerConfigCache.php
      237 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheInterface.php
      238 /vendor/symfony/symfony/src/Symfony/Component/Cache/DoctrineProvider.php
      239 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
      240 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
      241 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
      242 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
      243 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiOperationCache.php
      244 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
      245 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiDeleteCache.php
      246 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
      247 /vendor/symfony/symfony/src/Symfony/Component/Cache/PruneableInterface.php
      248 /vendor/symfony/symfony/src/Symfony/Component/Cache/ResettableInterface.php
      249 /vendor/symfony/contracts/Service/ResetInterface.php
      250 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/ArrayAdapter.php
      251 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/ArrayTrait.php
      252 /vendor/psr/log/Psr/Log/LoggerAwareTrait.php
      253 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/AdapterInterface.php
      254 /vendor/symfony/symfony/src/Symfony/Component/Cache/CacheItem.php
      255 /vendor/symfony/contracts/Cache/ItemInterface.php
      256 /vendor/psr/cache/src/CacheItemInterface.php
      257 /vendor/psr/cache/src/CacheItemPoolInterface.php
      258 /vendor/symfony/contracts/Cache/CacheInterface.php
      259 /vendor/psr/log/Psr/Log/LoggerAwareInterface.php
      260 /vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Setup.php
      261 /vendor/doctrine/deprecations/lib/Doctrine/Deprecations/Deprecation.php
      262 /vendor/doctrine/orm/lib/Doctrine/ORM/Configuration.php
      263 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Configuration.php
      264 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Psr6/CacheAdapter.php
      265 /vendor/doctrine/cache/lib/Doctrine/Common/Cache/Psr6/DoctrineProvider.php
      266 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationReader.php
      267 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Reader.php
      268 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/AnnotationRegistry.php
      269 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/DoctrineAnnotations.php
      270 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Annotation.php
      271 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Entity.php
      272 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Embeddable.php
      273 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Embedded.php
      274 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/MappedSuperclass.php
      275 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/InheritanceType.php
      276 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/DiscriminatorColumn.php
      277 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/DiscriminatorMap.php
      278 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Id.php
      279 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/GeneratedValue.php
      280 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Version.php
      281 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinColumn.php
      282 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinColumns.php
      283 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Column.php
      284 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OneToOne.php
      285 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OneToMany.php
      286 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ManyToOne.php
      287 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ManyToMany.php
      288 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Table.php
      289 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/UniqueConstraint.php
      290 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Index.php
      291 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/JoinTable.php
      292 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SequenceGenerator.php
      293 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/CustomIdGenerator.php
      294 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ChangeTrackingPolicy.php
      295 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/OrderBy.php
      296 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedQueries.php
      297 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedQuery.php
      298 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/HasLifecycleCallbacks.php
      299 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PrePersist.php
      300 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostPersist.php
      301 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreUpdate.php
      302 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostUpdate.php
      303 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreRemove.php
      304 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostRemove.php
      305 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PostLoad.php
      306 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/PreFlush.php
      307 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/FieldResult.php
      308 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/ColumnResult.php
      309 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/EntityResult.php
      310 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedNativeQuery.php
      311 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/NamedNativeQueries.php
      312 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SqlResultSetMapping.php
      313 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/SqlResultSetMappings.php
      314 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AssociationOverride.php
      315 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AssociationOverrides.php
      316 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AttributeOverride.php
      317 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/AttributeOverrides.php
      318 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/EntityListeners.php
      319 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Cache.php
      320 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/SimpleAnnotationReader.php
      321 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocParser.php
      322 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/DocLexer.php
      323 /vendor/doctrine/lexer/lib/Doctrine/Common/Lexer/AbstractLexer.php
      324 /vendor/doctrine/annotations/lib/Doctrine/Common/Annotations/Annotation/Target.php
      325 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/AnnotationDriver.php
      326 /vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/CompatibilityAnnotationDriver.php
      327 /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/MappingDriver.php
      328 /vendor/doctrine/persistence/src/Persistence/Mapping/Driver/ColocatedMappingDriver.php
      329 /var/cache/prod/FrontContainer.php
      330 /src/Adapter/Container/LegacyContainer.php
      331 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Container.php
      332 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Argument/RewindableGenerator.php
      333 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/Argument/ServiceLocator.php
      334 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ServiceLocator.php
      335 /vendor/symfony/contracts/Service/ServiceLocatorTrait.php
      336 /vendor/psr/container/src/ContainerExceptionInterface.php
      337 /vendor/psr/container/src/NotFoundExceptionInterface.php
      338 /vendor/symfony/contracts/Service/ServiceProviderInterface.php
      339 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ResettableContainerInterface.php
      340 /vendor/symfony/symfony/src/Symfony/Component/DependencyInjection/ContainerInterface.php
      341 /src/Adapter/Container/LegacyContainerInterface.php
      342 /modules/contactform/vendor/autoload.php
      343 /modules/contactform/vendor/composer/autoload_real.php
      344 /modules/contactform/vendor/composer/autoload_static.php
      345 /modules/dashactivity/vendor/autoload.php
      346 /modules/dashactivity/vendor/composer/autoload_real.php
      347 /modules/dashactivity/vendor/composer/autoload_static.php
      348 /modules/dashproducts/vendor/autoload.php
      349 /modules/dashproducts/vendor/composer/autoload_real.php
      350 /modules/dashproducts/vendor/composer/platform_check.php
      351 /modules/dashproducts/vendor/composer/autoload_static.php
      352 /modules/gsitemap/vendor/autoload.php
      353 /modules/gsitemap/vendor/composer/autoload_real.php
      354 /modules/gsitemap/vendor/composer/platform_check.php
      355 /modules/gsitemap/vendor/composer/autoload_static.php
      356 /modules/pagesnotfound/vendor/autoload.php
      357 /modules/pagesnotfound/vendor/composer/autoload_real.php
      358 /modules/pagesnotfound/vendor/composer/platform_check.php
      359 /modules/pagesnotfound/vendor/composer/autoload_static.php
      360 /modules/ps_banner/vendor/autoload.php
      361 /modules/ps_banner/vendor/composer/autoload_real.php
      362 /modules/ps_banner/vendor/composer/autoload_static.php
      363 /modules/ps_categorytree/vendor/autoload.php
      364 /modules/ps_categorytree/vendor/composer/autoload_real.php
      365 /modules/ps_categorytree/vendor/composer/platform_check.php
      366 /modules/ps_categorytree/vendor/composer/autoload_static.php
      367 /modules/ps_checkpayment/vendor/autoload.php
      368 /modules/ps_checkpayment/vendor/composer/autoload_real.php
      369 /modules/ps_checkpayment/vendor/composer/autoload_static.php
      370 /modules/ps_contactinfo/vendor/autoload.php
      371 /modules/ps_contactinfo/vendor/composer/autoload_real.php
      372 /modules/ps_contactinfo/vendor/composer/autoload_static.php
      373 /modules/ps_crossselling/vendor/autoload.php
      374 /modules/ps_crossselling/vendor/composer/autoload_real.php
      375 /modules/ps_crossselling/vendor/composer/platform_check.php
      376 /modules/ps_crossselling/vendor/composer/autoload_static.php
      377 /modules/ps_customersignin/vendor/autoload.php
      378 /modules/ps_customersignin/vendor/composer/autoload_real.php
      379 /modules/ps_customersignin/vendor/composer/autoload_static.php
      380 /modules/ps_customtext/vendor/autoload.php
      381 /modules/ps_customtext/vendor/composer/autoload_real.php
      382 /modules/ps_customtext/vendor/composer/platform_check.php
      383 /modules/ps_customtext/vendor/composer/autoload_static.php
      384 /modules/ps_dataprivacy/vendor/autoload.php
      385 /modules/ps_dataprivacy/vendor/composer/autoload_real.php
      386 /modules/ps_dataprivacy/vendor/composer/autoload_static.php
      387 /modules/ps_emailsubscription/vendor/autoload.php
      388 /modules/ps_emailsubscription/vendor/composer/autoload_real.php
      389 /modules/ps_emailsubscription/vendor/composer/platform_check.php
      390 /modules/ps_emailsubscription/vendor/composer/autoload_static.php
      391 /modules/ps_facetedsearch/vendor/autoload.php
      392 /modules/ps_facetedsearch/vendor/composer/autoload_real.php
      393 /modules/ps_facetedsearch/vendor/composer/platform_check.php
      394 /modules/ps_facetedsearch/vendor/composer/autoload_static.php
      395 /modules/ps_faviconnotificationbo/vendor/autoload.php
      396 /modules/ps_faviconnotificationbo/vendor/composer/autoload_real.php
      397 /modules/ps_faviconnotificationbo/vendor/composer/platform_check.php
      398 /modules/ps_faviconnotificationbo/vendor/composer/autoload_static.php
      399 /modules/ps_featuredproducts/vendor/autoload.php
      400 /modules/ps_featuredproducts/vendor/composer/autoload_real.php
      401 /modules/ps_featuredproducts/vendor/composer/platform_check.php
      402 /modules/ps_featuredproducts/vendor/composer/autoload_static.php
      403 /modules/ps_linklist/vendor/autoload.php
      404 /modules/ps_linklist/vendor/composer/autoload_real.php
      405 /modules/ps_linklist/vendor/composer/autoload_static.php
      406 /modules/ps_mainmenu/vendor/autoload.php
      407 /modules/ps_mainmenu/vendor/composer/autoload_real.php
      408 /modules/ps_mainmenu/vendor/composer/platform_check.php
      409 /modules/ps_mainmenu/vendor/composer/autoload_static.php
      410 /modules/ps_searchbar/vendor/autoload.php
      411 /modules/ps_searchbar/vendor/composer/autoload_real.php
      412 /modules/ps_searchbar/vendor/composer/autoload_static.php
      413 /modules/ps_sharebuttons/vendor/autoload.php
      414 /modules/ps_sharebuttons/vendor/composer/autoload_real.php
      415 /modules/ps_sharebuttons/vendor/composer/autoload_static.php
      416 /modules/ps_shoppingcart/vendor/autoload.php
      417 /modules/ps_shoppingcart/vendor/composer/autoload_real.php
      418 /modules/ps_shoppingcart/vendor/composer/autoload_static.php
      419 /modules/ps_socialfollow/vendor/autoload.php
      420 /modules/ps_socialfollow/vendor/composer/autoload_real.php
      421 /modules/ps_socialfollow/vendor/composer/platform_check.php
      422 /modules/ps_socialfollow/vendor/composer/autoload_static.php
      423 /modules/ps_themecusto/vendor/autoload.php
      424 /modules/ps_themecusto/vendor/composer/autoload_real.php
      425 /modules/ps_themecusto/vendor/composer/autoload_static.php
      426 /modules/ps_wirepayment/vendor/autoload.php
      427 /modules/ps_wirepayment/vendor/composer/autoload_real.php
      428 /modules/ps_wirepayment/vendor/composer/platform_check.php
      429 /modules/ps_wirepayment/vendor/composer/autoload_static.php
      430 /modules/statsbestcategories/vendor/autoload.php
      431 /modules/statsbestcategories/vendor/composer/autoload_real.php
      432 /modules/statsbestcategories/vendor/composer/platform_check.php
      433 /modules/statsbestcategories/vendor/composer/autoload_static.php
      434 /modules/statsbestcustomers/vendor/autoload.php
      435 /modules/statsbestcustomers/vendor/composer/autoload_real.php
      436 /modules/statsbestcustomers/vendor/composer/platform_check.php
      437 /modules/statsbestcustomers/vendor/composer/autoload_static.php
      438 /modules/statsbestproducts/vendor/autoload.php
      439 /modules/statsbestproducts/vendor/composer/autoload_real.php
      440 /modules/statsbestproducts/vendor/composer/platform_check.php
      441 /modules/statsbestproducts/vendor/composer/autoload_static.php
      442 /modules/statsbestsuppliers/vendor/autoload.php
      443 /modules/statsbestsuppliers/vendor/composer/autoload_real.php
      444 /modules/statsbestsuppliers/vendor/composer/platform_check.php
      445 /modules/statsbestsuppliers/vendor/composer/autoload_static.php
      446 /modules/statsbestvouchers/vendor/autoload.php
      447 /modules/statsbestvouchers/vendor/composer/autoload_real.php
      448 /modules/statsbestvouchers/vendor/composer/platform_check.php
      449 /modules/statsbestvouchers/vendor/composer/autoload_static.php
      450 /modules/statscarrier/vendor/autoload.php
      451 /modules/statscarrier/vendor/composer/autoload_real.php
      452 /modules/statscarrier/vendor/composer/platform_check.php
      453 /modules/statscarrier/vendor/composer/autoload_static.php
      454 /modules/statscatalog/vendor/autoload.php
      455 /modules/statscatalog/vendor/composer/autoload_real.php
      456 /modules/statscatalog/vendor/composer/platform_check.php
      457 /modules/statscatalog/vendor/composer/autoload_static.php
      458 /modules/statscheckup/vendor/autoload.php
      459 /modules/statscheckup/vendor/composer/autoload_real.php
      460 /modules/statscheckup/vendor/composer/platform_check.php
      461 /modules/statscheckup/vendor/composer/autoload_static.php
      462 /modules/statsdata/vendor/autoload.php
      463 /modules/statsdata/vendor/composer/autoload_real.php
      464 /modules/statsdata/vendor/composer/platform_check.php
      465 /modules/statsdata/vendor/composer/autoload_static.php
      466 /modules/statsforecast/vendor/autoload.php
      467 /modules/statsforecast/vendor/composer/autoload_real.php
      468 /modules/statsforecast/vendor/composer/platform_check.php
      469 /modules/statsforecast/vendor/composer/autoload_static.php
      470 /modules/statsnewsletter/vendor/autoload.php
      471 /modules/statsnewsletter/vendor/composer/autoload_real.php
      472 /modules/statsnewsletter/vendor/composer/platform_check.php
      473 /modules/statsnewsletter/vendor/composer/autoload_static.php
      474 /modules/statspersonalinfos/vendor/autoload.php
      475 /modules/statspersonalinfos/vendor/composer/autoload_real.php
      476 /modules/statspersonalinfos/vendor/composer/platform_check.php
      477 /modules/statspersonalinfos/vendor/composer/autoload_static.php
      478 /modules/statsproduct/vendor/autoload.php
      479 /modules/statsproduct/vendor/composer/autoload_real.php
      480 /modules/statsproduct/vendor/composer/platform_check.php
      481 /modules/statsproduct/vendor/composer/autoload_static.php
      482 /modules/statsregistrations/vendor/autoload.php
      483 /modules/statsregistrations/vendor/composer/autoload_real.php
      484 /modules/statsregistrations/vendor/composer/platform_check.php
      485 /modules/statsregistrations/vendor/composer/autoload_static.php
      486 /modules/statssales/vendor/autoload.php
      487 /modules/statssales/vendor/composer/autoload_real.php
      488 /modules/statssales/vendor/composer/platform_check.php
      489 /modules/statssales/vendor/composer/autoload_static.php
      490 /modules/statssearch/vendor/autoload.php
      491 /modules/statssearch/vendor/composer/autoload_real.php
      492 /modules/statssearch/vendor/composer/platform_check.php
      493 /modules/statssearch/vendor/composer/autoload_static.php
      494 /modules/statsstock/vendor/autoload.php
      495 /modules/statsstock/vendor/composer/autoload_real.php
      496 /modules/statsstock/vendor/composer/platform_check.php
      497 /modules/statsstock/vendor/composer/autoload_static.php
      498 /modules/ps_buybuttonlite/vendor/autoload.php
      499 /modules/ps_buybuttonlite/vendor/composer/autoload_real.php
      500 /modules/ps_buybuttonlite/vendor/composer/autoload_static.php
      501 /modules/ps_viewedproduct/vendor/autoload.php
      502 /modules/ps_viewedproduct/vendor/composer/autoload_real.php
      503 /modules/ps_viewedproduct/vendor/composer/platform_check.php
      504 /modules/ps_viewedproduct/vendor/composer/autoload_static.php
      505 /modules/ps_bestsellers/vendor/autoload.php
      506 /modules/ps_bestsellers/vendor/composer/autoload_real.php
      507 /modules/ps_bestsellers/vendor/composer/platform_check.php
      508 /modules/ps_bestsellers/vendor/composer/autoload_static.php
      509 /modules/blockreassurance/vendor/autoload.php
      510 /modules/blockreassurance/vendor/composer/autoload_real.php
      511 /modules/blockreassurance/vendor/composer/autoload_static.php
      512 /modules/ps_categoryproducts/vendor/autoload.php
      513 /modules/ps_categoryproducts/vendor/composer/autoload_real.php
      514 /modules/ps_categoryproducts/vendor/composer/platform_check.php
      515 /modules/ps_categoryproducts/vendor/composer/autoload_static.php
      516 /modules/ps_specials/vendor/autoload.php
      517 /modules/ps_specials/vendor/composer/autoload_real.php
      518 /modules/ps_specials/vendor/composer/platform_check.php
      519 /modules/ps_specials/vendor/composer/autoload_static.php
      520 /modules/statsbestmanufacturers/vendor/autoload.php
      521 /modules/statsbestmanufacturers/vendor/composer/autoload_real.php
      522 /modules/statsbestmanufacturers/vendor/composer/platform_check.php
      523 /modules/statsbestmanufacturers/vendor/composer/autoload_static.php
      524 /modules/eicaptcha/vendor/autoload.php
      525 /modules/eicaptcha/vendor/composer/autoload_real.php
      526 /modules/eicaptcha/vendor/composer/platform_check.php
      527 /modules/eicaptcha/vendor/composer/autoload_static.php
      528 /modules/blockwishlist/vendor/autoload.php
      529 /modules/blockwishlist/vendor/composer/autoload_real.php
      530 /modules/blockwishlist/vendor/composer/autoload_static.php
      531 /modules/mercadopago/vendor/autoload.php
      532 /modules/mercadopago/vendor/composer/autoload_real.php
      533 /modules/mercadopago/vendor/composer/platform_check.php
      534 /modules/mercadopago/vendor/composer/autoload_static.php
      535 /modules/clippay/vendor/autoload.php
      536 /modules/clippay/vendor/composer/autoload_real.php
      537 /modules/clippay/vendor/composer/autoload_static.php
      538 /modules/ps_newproducts/vendor/autoload.php
      539 /modules/ps_newproducts/vendor/composer/autoload_real.php
      540 /modules/ps_newproducts/vendor/composer/platform_check.php
      541 /modules/ps_newproducts/vendor/composer/autoload_static.php
      542 /modules/autoupgrade/vendor/autoload.php
      543 /modules/autoupgrade/vendor/composer/autoload_real.php
      544 /modules/autoupgrade/vendor/composer/autoload_static.php
      545 /modules/autoupgrade/vendor/segmentio/analytics-php/lib/Segment.php
      546 /modules/autoupgrade/vendor/segmentio/analytics-php/lib/Segment/Client.php
      547 /modules/autoupgrade/vendor/segmentio/analytics-php/lib/Segment/Consumer.php
      548 /modules/autoupgrade/vendor/segmentio/analytics-php/lib/Segment/QueueConsumer.php
      549 /modules/autoupgrade/vendor/segmentio/analytics-php/lib/Segment/Consumer/File.php
      550 /modules/autoupgrade/vendor/segmentio/analytics-php/lib/Segment/Consumer/ForkCurl.php
      551 /modules/autoupgrade/vendor/segmentio/analytics-php/lib/Segment/Consumer/LibCurl.php
      552 /modules/autoupgrade/vendor/segmentio/analytics-php/lib/Segment/Consumer/Socket.php
      553 /modules/autoupgrade/vendor/segmentio/analytics-php/lib/Segment/Version.php
      554 /modules/ps_distributionapiclient/vendor/autoload.php
      555 /modules/ps_distributionapiclient/vendor/composer/autoload_real.php
      556 /modules/ps_distributionapiclient/vendor/composer/platform_check.php
      557 /modules/ps_distributionapiclient/vendor/composer/autoload_static.php
      558 /modules/ps_distributionapiclient/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
      559 /modules/ps_distributionapiclient/vendor/symfony/string/Resources/functions.php
      560 /src/Core/Hook/HookModuleFilter.php
      561 /src/Core/Hook/HookModuleFilterInterface.php
      562 /modules/preorderandnotification/preorderandnotification.php
      563 /modules/preorderandnotification/models/PreorderModel.php
      564 /modules/preorderandnotification/models/PreorderProduct.php
      565 /modules/preorderandnotification/models/PreorderOrder.php
      566 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_createdata.php
      567 /vendor/smarty/smarty/libs/sysplugins/smarty_data.php
      568 /classes/Translate.php
      569 /modules/preorderandnotification/translations/mx.php
      570 /modules/ets_superspeed/ets_superspeed.php
      571 /modules/ets_superspeed/classes/cache.php
      572 /modules/ets_superspeed/classes/http_build_url.php
      573 /modules/ets_superspeed/classes/ets_superspeed_defines.php
      574 /modules/ets_superspeed/classes/ets_superspeed_cache_page.php
      575 /modules/ets_superspeed/classes/ets_superspeed_cache_page_error.php
      576 /modules/ets_superspeed/classes/ets_superspeed_cache_page_log.php
      577 /modules/ets_superspeed/classes/ets_superspeed_pagination_class.php
      578 /modules/ets_superspeed/classes/ets_superspeed_compressor_image.php
      579 /modules/ets_superspeed/classes/ets_superspeed_upload_image.php
      580 /modules/ets_superspeed/classes/ets_superspeed_browse_image.php
      581 /modules/ets_superspeed/translations/mx.php
      582 /src/PrestaShopBundle/Translation/TranslatorComponent.php
      583 /vendor/symfony/symfony/src/Symfony/Component/Translation/Translator.php
      584 /vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorInterface.php
      585 /vendor/symfony/contracts/Translation/LocaleAwareInterface.php
      586 /vendor/symfony/contracts/Translation/TranslatorInterface.php
      587 /vendor/symfony/symfony/src/Symfony/Component/Translation/TranslatorBagInterface.php
      588 /src/PrestaShopBundle/Translation/PrestaShopTranslatorTrait.php
      589 /src/PrestaShopBundle/Translation/TranslatorLanguageTrait.php
      590 /src/PrestaShopBundle/Translation/TranslatorInterface.php
      591 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatter.php
      592 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/IntlFormatter.php
      593 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/IntlFormatterInterface.php
      594 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/MessageFormatterInterface.php
      595 /vendor/symfony/symfony/src/Symfony/Component/Translation/Formatter/ChoiceMessageFormatterInterface.php
      596 /vendor/symfony/symfony/src/Symfony/Component/Translation/IdentityTranslator.php
      597 /vendor/symfony/contracts/Translation/TranslatorTrait.php
      598 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactory.php
      599 /vendor/symfony/symfony/src/Symfony/Component/Config/ConfigCacheFactoryInterface.php
      600 /var/cache/prod/translations/catalogue.es-MX.NXhscRe.php
      601 /vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogue.php
      602 /vendor/symfony/symfony/src/Symfony/Component/Translation/MessageCatalogueInterface.php
      603 /vendor/symfony/symfony/src/Symfony/Component/Translation/MetadataAwareInterface.php
      604 /modules/ets_onepagecheckout/ets_onepagecheckout.php
      605 /modules/ets_onepagecheckout/classes/Ets_opc_tools.php
      606 /modules/ets_onepagecheckout/classes/src/autoload.php
      607 /modules/ets_onepagecheckout/classes/Ets_opc_additionalinfo_field.php
      608 /modules/ets_onepagecheckout/classes/Ets_opc_additionalinfo_field_value.php
      609 /modules/ets_onepagecheckout/classes/Ets_opc_db.php
      610 /modules/ets_onepagecheckout/translations/mx.php
      611 /controllers/front/ProductController.php
      612 /classes/controller/ProductPresentingFrontController.php
      613 /override/classes/controller/FrontController.php
      614 /classes/controller/FrontController.php
      615 /src/Adapter/Presenter/Object/ObjectPresenter.php
      616 /src/Adapter/Presenter/PresenterInterface.php
      617 /src/Adapter/Presenter/Cart/CartPresenter.php
      618 /src/Adapter/Image/ImageRetriever.php
      619 /classes/tax/TaxConfiguration.php
      620 /classes/Smarty/TemplateFinder.php
      621 /classes/assets/StylesheetManager.php
      622 /classes/assets/AbstractAssetManager.php
      623 /src/Adapter/Assets/AssetUrlGeneratorTrait.php
      624 /classes/assets/JavascriptManager.php
      625 /classes/assets/CccReducer.php
      626 /src/Core/Localization/Locale/Repository.php
      627 /src/Core/Localization/Locale/RepositoryInterface.php
      628 /src/Core/Localization/CLDR/LocaleRepository.php
      629 /src/Core/Localization/CLDR/LocaleDataSource.php
      630 /src/Core/Localization/CLDR/DataLayer/LocaleCache.php
      631 /src/Core/Data/Layer/AbstractDataLayer.php
      632 /src/Core/Localization/CLDR/LocaleDataLayerInterface.php
      633 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/FilesystemAdapter.php
      634 /vendor/symfony/symfony/src/Symfony/Component/Cache/Adapter/AbstractAdapter.php
      635 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/AbstractAdapterTrait.php
      636 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/AbstractTrait.php
      637 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/ContractsTrait.php
      638 /vendor/symfony/contracts/Cache/CacheTrait.php
      639 /vendor/psr/cache/src/InvalidArgumentException.php
      640 /vendor/psr/cache/src/CacheException.php
      641 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/FilesystemTrait.php
      642 /vendor/symfony/symfony/src/Symfony/Component/Cache/Traits/FilesystemCommonTrait.php
      643 /vendor/symfony/symfony/src/Symfony/Component/Cache/Marshaller/DefaultMarshaller.php
      644 /vendor/symfony/symfony/src/Symfony/Component/Cache/Marshaller/MarshallerInterface.php
      645 /src/Core/Localization/CLDR/DataLayer/LocaleReference.php
      646 /src/Core/Localization/CLDR/Reader.php
      647 /src/Core/Localization/CLDR/ReaderInterface.php
      648 /src/Core/Localization/Currency/Repository.php
      649 /src/Core/Localization/Currency/RepositoryInterface.php
      650 /src/Core/Localization/Currency/CurrencyDataSource.php
      651 /src/Core/Localization/Currency/DataSourceInterface.php
      652 /src/Core/Localization/Currency/DataLayer/CurrencyCache.php
      653 /src/Core/Localization/Currency/CurrencyDataLayerInterface.php
      654 /src/Core/Localization/Currency/DataLayer/CurrencyDatabase.php
      655 /src/Adapter/Currency/CurrencyDataProvider.php
      656 /src/Core/Currency/CurrencyDataProviderInterface.php
      657 /src/Adapter/LegacyContext.php
      658 /src/Adapter/Tools.php
      659 /src/Core/Localization/Currency/DataLayer/CurrencyReference.php
      660 /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php
      661 /vendor/prestashop/decimal/src/Operation/Rounding.php
      662 /src/Core/Localization/Locale.php
      663 /src/Core/Localization/LocaleInterface.php
      664 /src/Core/Localization/Specification/Price.php
      665 /src/Core/Localization/Specification/Number.php
      666 /src/Core/Localization/Specification/NumberInterface.php
      667 /src/Core/Localization/Specification/Factory.php
      668 /src/Core/Localization/CLDR/LocaleData.php
      669 /src/Core/Localization/CLDR/NumberSymbolsData.php
      670 /src/Core/Localization/CLDR/CurrencyData.php
      671 /src/Core/Localization/CLDR/Locale.php
      672 /src/Core/Localization/CLDR/LocaleInterface.php
      673 /src/Core/Localization/Specification/NumberSymbolList.php
      674 /classes/Currency.php
      675 /src/Core/Localization/Currency/LocalizedCurrencyId.php
      676 /classes/webservice/WebserviceRequest.php
      677 /src/Core/Localization/Currency/CurrencyData.php
      678 /src/Core/Localization/Currency/CurrencyCollection.php
      679 /src/Core/Localization/Currency.php
      680 /src/Core/Localization/CurrencyInterface.php
      681 /src/Core/Localization/Specification/NumberCollection.php
      682 /src/Core/Localization/Number/Formatter.php
      683 /override/classes/Cart.php
      684 /classes/Cart.php
      685 /src/Adapter/AddressFactory.php
      686 /classes/CartRule.php
      687 /classes/Product.php
      688 /src/Core/Domain/Product/ValueObject/RedirectType.php
      689 /src/Core/Util/DateTime/DateTime.php
      690 /src/Core/Domain/Product/Stock/ValueObject/OutOfStockType.php
      691 /src/Core/Domain/Product/Pack/ValueObject/PackStockType.php
      692 /src/Core/Domain/Product/ValueObject/ProductType.php
      693 /src/Core/Domain/Product/ValueObject/Reference.php
      694 /src/Core/Domain/Product/ValueObject/Ean13.php
      695 /src/Core/Domain/Product/ValueObject/Isbn.php
      696 /src/Core/Domain/Product/ValueObject/Upc.php
      697 /src/Core/Domain/Product/ProductSettings.php
      698 /modules/ets_affiliatemarketing/ets_affiliatemarketing.php
      699 /modules/ets_affiliatemarketing/classes/EtsAmAdmin.php
      700 /modules/ets_affiliatemarketing/classes/Ets_AM.php
      701 /modules/ets_affiliatemarketing/classes/Ets_Loyalty.php
      702 /modules/ets_affiliatemarketing/classes/Ets_Participation.php
      703 /modules/ets_affiliatemarketing/classes/Ets_Affiliate.php
      704 /modules/ets_affiliatemarketing/classes/Ets_Sponsor.php
      705 /modules/ets_affiliatemarketing/classes/Ets_Reward_Usage.php
      706 /modules/ets_affiliatemarketing/classes/Ets_Invitation.php
      707 /modules/ets_affiliatemarketing/classes/Ets_Banner.php
      708 /modules/ets_affiliatemarketing/classes/Ets_Withdraw.php
      709 /modules/ets_affiliatemarketing/classes/Ets_Withdraw_Field.php
      710 /modules/ets_affiliatemarketing/classes/Ets_PaymentMethod.php
      711 /modules/ets_affiliatemarketing/classes/Ets_Voucher.php
      712 /modules/ets_affiliatemarketing/controllers/front/all.php
      713 /classes/controller/ModuleFrontController.php
      714 /modules/ets_affiliatemarketing/classes/Ets_User.php
      715 /modules/ets_affiliatemarketing/classes/Ets_Reward_Product.php
      716 /modules/ets_affiliatemarketing/classes/Ets_Access_Key.php
      717 /modules/ets_affiliatemarketing/classes/Ets_Product_View.php
      718 /modules/ets_affiliatemarketing/classes/Ets_ImportExport.php
      719 /modules/ets_affiliatemarketing/classes/Ets_Loyalty_Config.php
      720 /modules/ets_affiliatemarketing/classes/Ets_Affiliate_Config.php
      721 /modules/ets_affiliatemarketing/classes/Ets_PaymentMethodField.php
      722 /modules/ets_affiliatemarketing/defines.php
      723 /modules/ets_affiliatemarketing/classes/Ets_aff_email.php
      724 /classes/Mail.php
      725 /modules/ets_affiliatemarketing/classes/Ets_aff_qr_code.php
      726 /classes/PaymentModule.php
      727 /modules/ets_affiliatemarketing/translations/mx.php
      728 /classes/Manufacturer.php
      729 /classes/Supplier.php
      730 /classes/Address.php
      731 /classes/tax/TaxManagerFactory.php
      732 /classes/tax/TaxRulesTaxManager.php
      733 /classes/tax/TaxManagerInterface.php
      734 /src/Core/Domain/Shop/ValueObject/ShopId.php
      735 /src/Core/Domain/Shop/ValueObject/ShopIdInterface.php
      736 /classes/tax/Tax.php
      737 /classes/tax/TaxCalculator.php
      738 /classes/Combination.php
      739 /classes/SpecificPrice.php
      740 /classes/GroupReduction.php
      741 /classes/Tag.php
      742 /classes/stock/StockAvailable.php
      743 /vendor/prestashop/decimal/src/DecimalNumber.php
      744 /vendor/prestashop/decimal/src/Builder.php
      745 /classes/Category.php
      746 /vendor/symfony/symfony/src/Symfony/Component/PropertyAccess/Exception/UnexpectedTypeException.php
      747 /vendor/symfony/symfony/src/Symfony/Component/PropertyAccess/Exception/RuntimeException.php
      748 /vendor/symfony/symfony/src/Symfony/Component/PropertyAccess/Exception/ExceptionInterface.php
      749 /modules/ps_emailsubscription/ps_emailsubscription.php
      750 /src/Core/Module/WidgetInterface.php
      751 /src/PrestaShopBundle/Translation/DomainNormalizer.php
      752 /override/classes/Media.php
      753 /classes/Media.php
      754 /modules/blockreassurance/blockreassurance.php
      755 /modules/ps_socialfollow/ps_socialfollow.php
      756 /modules/ps_emailalerts/ps_emailalerts.php
      757 /modules/ps_emailalerts/MailAlert.php
      758 /classes/Pack.php
      759 /classes/ProductAssembler.php
      760 /src/Core/Product/Search/ProductSearchContext.php
      761 /src/Adapter/Presenter/Product/ProductListingPresenter.php
      762 /src/Adapter/Presenter/Product/ProductPresenter.php
      763 /src/Adapter/Product/PriceFormatter.php
      764 /src/Adapter/Product/ProductColorsRetriever.php
      765 /src/Adapter/HookManager.php
      766 /classes/ProductPresenterFactory.php
      767 /src/Core/Product/ProductPresentationSettings.php
      768 /src/Core/Product/ProductExtraContentFinder.php
      769 /src/PrestaShopBundle/Service/Hook/HookFinder.php
      770 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_method_gettemplatevars.php
      771 /src/Core/Localization/CLDR/ComputingPrecision.php
      772 /src/Core/Localization/CLDR/ComputingPrecisionInterface.php
      773 /override/classes/order/Order.php
      774 /classes/order/Order.php
      775 /classes/Feature.php
      776 /src/Adapter/Presenter/Product/ProductLazyArray.php
      777 /src/Adapter/Presenter/AbstractLazyArray.php
      778 /classes/Image.php
      779 /src/Core/Image/ImageFormatConfiguration.php
      780 /src/Core/Image/ImageFormatConfigurationInterface.php
      781 /classes/FeatureFlag.php
      782 /src/Core/FeatureFlag/FeatureFlagSettings.php
      783 /classes/ImageType.php
      784 /src/Core/Util/Inflector.php
      785 /vendor/doctrine/inflector/lib/Doctrine/Inflector/InflectorFactory.php
      786 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Language.php
      787 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/InflectorFactory.php
      788 /vendor/doctrine/inflector/lib/Doctrine/Inflector/GenericLanguageInflectorFactory.php
      789 /vendor/doctrine/inflector/lib/Doctrine/Inflector/LanguageInflectorFactory.php
      790 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Rules.php
      791 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Ruleset.php
      792 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformations.php
      793 /vendor/doctrine/inflector/lib/Doctrine/Inflector/WordInflector.php
      794 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Inflectible.php
      795 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Transformation.php
      796 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Pattern.php
      797 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Patterns.php
      798 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/English/Uninflected.php
      799 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitutions.php
      800 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Substitution.php
      801 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Rules/Word.php
      802 /vendor/doctrine/inflector/lib/Doctrine/Inflector/Inflector.php
      803 /vendor/doctrine/inflector/lib/Doctrine/Inflector/CachedWordInflector.php
      804 /vendor/doctrine/inflector/lib/Doctrine/Inflector/RulesetInflector.php
      805 /src/Core/Util/String/StringModifier.php
      806 /src/Core/Util/String/StringModifierInterface.php
      807 /src/Adapter/Presenter/Cart/CartLazyArray.php
      808 /classes/Gender.php
      809 /classes/Risk.php
      810 /classes/Meta.php
      811 /classes/State.php
      812 /src/Core/Security/PasswordPolicyConfiguration.php
      813 /src/Core/Configuration/DataConfigurationInterface.php
      814 /src/Core/Security/Hashing.php
      815 /src/Core/Filter/FrontEndObject/MainFilter.php
      816 /src/Core/Filter/FilterInterface.php
      817 /src/Core/Filter/FrontEndObject/CartFilter.php
      818 /src/Core/Filter/HashMapWhitelistFilter.php
      819 /src/Core/Filter/CollectionFilter.php
      820 /src/Core/Filter/FrontEndObject/ProductFilter.php
      821 /src/Core/Filter/FrontEndObject/EmbeddedAttributesFilter.php
      822 /src/Core/Filter/FrontEndObject/CustomerFilter.php
      823 /src/Core/Filter/FrontEndObject/ShopFilter.php
      824 /src/Core/Filter/FrontEndObject/ConfigurationFilter.php
      825 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php
      826 /var/cache/prod/smarty/compile/revostore/3c/24/31/3c2431f86e6b80914b65531dceaf7ab8007ff48a_2.file.javascript.tpl.php
      827 /vendor/smarty/smarty/libs/plugins/modifier.escape.php
      828 /modules/ps_shoppingcart/ps_shoppingcart.php
      829 /modules/ps_searchbar/ps_searchbar.php
      830 /modules/pleasewait/pleasewait.php
      831 /modules/pleasewait/translations/mx.php
      832 /modules/ets_homecategories/ets_homecategories.php
      833 /modules/ets_homecategories/translations/mx.php
      834 /modules/ybc_themeconfig/ybc_themeconfig.php
      835 /modules/ets_multilayerslider/ets_multilayerslider.php
      836 /modules/ets_multilayerslider/classes/MLS_Obj.php
      837 /modules/ets_multilayerslider/classes/MLS_Slide.php
      838 /modules/ets_multilayerslider/classes/MLS_Layer.php
      839 /modules/ets_multilayerslider/classes/MLS_Config.php
      840 /modules/ybc_themeconfig/translations/mx.php
      841 /modules/ybc_widget/ybc_widget.php
      842 /modules/ybc_widget/classes/ybc_widget_widget_class.php
      843 /modules/ybc_widget/translations/mx.php
      844 /modules/ets_megamenu/ets_megamenu.php
      845 /modules/ets_megamenu/classes/MM_Obj.php
      846 /modules/ets_megamenu/classes/MM_Menu.php
      847 /modules/ets_megamenu/classes/MM_Column.php
      848 /modules/ets_megamenu/classes/MM_Block.php
      849 /modules/ets_megamenu/classes/MM_Config.php
      850 /modules/ets_megamenu/classes/MM_Cache.php
      851 /modules/ets_megamenu/translations/mx.php
      852 /modules/eicaptcha/eicaptcha.php
      853 /modules/eicaptcha/translations/mx.php
      854 /modules/eicaptcha/src/Debugger.php
      855 /modules/ets_wishlist_pres17/ets_wishlist_pres17.php
      856 /modules/ets_wishlist_pres17/classes/Ets_wishlist_define.php
      857 /modules/ets_wishlist_pres17/classes/Ets_wl_wishlist.php
      858 /modules/ets_wishlist_pres17/classes/Ets_wl_statistics.php
      859 /modules/ets_wishlist_pres17/classes/Ets_wl_paggination_class.php
      860 /modules/amazzingfilter/amazzingfilter.php
      861 /var/cache/prod/smarty/compile/revostore/49/be/69/49be69c5d41a1b062c6c81976443f4beb84f3c07_2.file.head.tpl.php
      862 /var/cache/prod/smarty/compile/revostore/76/6e/07/766e07b8e9ccaaffd1541e20c70c32931e62463f_2.file.preorder_header.tpl.php
      863 /modules/mercadopago/mercadopago.php
      864 /modules/mercadopago/includes/MPApi.php
      865 /modules/mercadopago/includes/module/settings/CoreSdkSettings.php
      866 /modules/mercadopago/includes/MPLog.php
      867 /modules/mercadopago/includes/MPUseful.php
      868 /modules/mercadopago/includes/MPRestCli.php
      869 /modules/mercadopago/includes/module/preference/StandardPreference.php
      870 /modules/mercadopago/includes/module/preference/AbstractStandardPreference.php
      871 /modules/mercadopago/includes/module/preference/AbstractPreference.php
      872 /modules/mercadopago/includes/module/checkouts/PseCheckout.php
      873 /modules/mercadopago/includes/module/preference/WalletButtonPreference.php
      874 /modules/mercadopago/includes/module/model/MPModule.php
      875 /modules/mercadopago/includes/MPAbstractDB.php
      876 /modules/mercadopago/includes/module/model/MPTransaction.php
      877 /modules/mercadopago/includes/module/model/PSCartRule.php
      878 /modules/mercadopago/includes/module/model/PSCartRuleRule.php
      879 /modules/mercadopago/includes/module/model/PSOrderState.php
      880 /modules/mercadopago/includes/module/model/PSOrderStateLang.php
      881 /modules/mercadopago/includes/module/checkouts/StandardCheckout.php
      882 /modules/mercadopago/includes/module/checkouts/CustomCheckout.php
      883 /modules/mercadopago/includes/module/checkouts/TicketCheckout.php
      884 /modules/mercadopago/includes/module/checkouts/PixCheckout.php
      885 /modules/mercadopago/translations/mx.php
      886 /modules/clippay/clippay.php
      887 /modules/clippay/translations/mx.php
      888 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/6a/2f/18/6a2f189dd7660e24d96b7341ad48122b58b5206b_2.file.product.tpl.php
      889 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_block.php
      890 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php
      891 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/58/06/6e/58066efc1a50179782789d74fb880fd73be0107f_2.file.layout-full-width.tpl.php
      892 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/c4/42/a4/c442a44c71337a6aa79b42d572f05176958e5cc2_2.file.layout-both-columns.tpl.php
      893 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/77/66/7b/77667b32a3fe2859f2f5e306623826ecd742745e_2.file.head.tpl.php
      894 /vendor/smarty/smarty/libs/plugins/modifier.date_format.php
      895 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/1d/22/9e/1d229e8a50327828c8eeb6272d4da66be30febba_2.file.stylesheets.tpl.php
      896 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_foreach.php
      897 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/56/dd/0b/56dd0baeee1b5f3fce49afd2eb9647ee755d1085_2.file.javascript.tpl.php
      898 /vendor/smarty/smarty/libs/plugins/modifier.count.php
      899 /classes/ProductDownload.php
      900 /src/Core/Cart/Calculator.php
      901 /src/Core/Cart/CartRowCollection.php
      902 /src/Core/Cart/Fees.php
      903 /src/Core/Cart/AmountImmutable.php
      904 /src/Core/Cart/CartRuleCollection.php
      905 /src/Core/Cart/CartRuleCalculator.php
      906 /src/Adapter/Product/PriceCalculator.php
      907 /src/Core/Cart/CartRow.php
      908 /vendor/symfony/symfony/src/Symfony/Component/Translation/PluralizationRules.php
      909 /vendor/smarty/smarty/libs/plugins/shared.make_timestamp.php
      910 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/c9/bc/db/c9bcdb86056329e71b62ec38037a52bd2ced5137_2.file.product-activation.tpl.php
      911 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/7b/b0/63/7bb06322e71d5855606eff453bf33dd0769446f0_2.file.header.tpl.php
      912 /modules/ps_languageselector/ps_languageselector.php
      913 /modules/ps_currencyselector/ps_currencyselector.php
      914 /modules/ps_customersignin/ps_customersignin.php
      915 /var/cache/prod/smarty/compile/revostore/d5/f8/f5/d5f8f570180f74d1dbdd1a1d2af0445e90a6650c_2.module.ps_customersigninps_customersignin.tpl.php
      916 /var/cache/prod/smarty/compile/revostore/35/65/5e/35655e6409b6198f29dd6e732ef9598dec599880_2.module.ps_shoppingcartps_shoppingcart.tpl.php
      917 /var/cache/prod/smarty/compile/revostore/11/0e/c7/110ec72aa9921d2c382ad628bdb2f0bc5105a617_2.module.ps_searchbarps_searchbar.tpl.php
      918 /var/cache/prod/smarty/compile/revostore/cf/20/a6/cf20a6c0ff74b65c400f93712f0b667d7f1367ff_2.file.widgets.tpl.php
      919 /var/cache/prod/smarty/compile/revostore/f4/67/50/f467505c0c3d0d5bb4a135d553cda18336994a46_2.file.megamenu.tpl.php
      920 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/10/6b/01/106b017cc2cfa84e34d55851a307d1597045cf31_2.file.notifications.tpl.php
      921 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/bc/23/3b/bc233b1f1f6a4a9ee10e7c4d1cf587177998ae51_2.file.breadcrumb.tpl.php
      922 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/59/20/11/5920116ec8c49e7432bf5f67f955920fcb3a4d45_2.file.product-cover-thumbnails.tpl.php
      923 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/d3/97/df/d397df0d0492a9b0160c6417ca6895404e01778f_2.file.product-prices.tpl.php
      924 /var/cache/prod/smarty/compile/revostore/9f/69/0d/9f690d710125b5743ea373817b7603c75d1e4f15_2.file.price_block.tpl.php
      925 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/e4/60/b3/e460b377032128273cf7ecfeacca271a4d603ca9_2.file.product-variants.tpl.php
      926 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/95/0f/11/950f116f7f8ce31bd4dd2f263da5571cbd2884d4_2.file.product-discounts.tpl.php
      927 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/19/f0/31/19f031e66fa28dd995d19bf078a80d738c2729fe_2.file.product-add-to-cart.tpl.php
      928 /var/cache/prod/smarty/compile/revostore/41/7d/5a/417d5ada2b05604f618696324f02b4c36769d1d1_2.file.list_button_list.tpl.php
      929 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/4d/c1/e2/4dc1e285e3b712e7175dc4d062e9c13247b84a50_2.file.product-additional-info.tpl.php
      930 /modules/ps_sharebuttons/ps_sharebuttons.php
      931 /var/cache/prod/smarty/compile/revostore/ce/90/8e/ce908e3af500ef88d0be39d6badc82307b6995cd_2.module.ps_sharebuttonsviewstemplateshookps_sharebuttons.tpl.php
      932 /var/cache/prod/smarty/compile/revostore/9b/49/74/9b49748e1773d292601222716deea60596c8fb46_2.file.product-additional.tpl.php
      933 /var/cache/prod/smarty/compile/revostore/02/2b/cd/022bcdd07334813bdae3cc6affa4f7c072deb5b4_2.file.preorder_product.tpl.php
      934 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/9f/f8/f1/9ff8f122d14f7116c5dd25900b568b262f80170b_2.file.product-details.tpl.php
      935 /modules/ps_viewedproduct/ps_viewedproduct.php
      936 /modules/ps_categoryproducts/ps_categoryproducts.php
      937 /vendor/smarty/smarty/libs/sysplugins/smarty_template_cached.php
      938 /vendor/smarty/smarty/libs/sysplugins/smarty_cacheresource.php
      939 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_cacheresource_file.php
      940 /src/Adapter/Category/CategoryProductSearchProvider.php
      941 /src/Core/Product/Search/ProductSearchProviderInterface.php
      942 /src/Core/Product/Search/SortOrderFactory.php
      943 /src/Core/Product/Search/ProductSearchQuery.php
      944 /src/Core/Product/Search/SortOrder.php
      945 /src/Core/Product/Search/ProductSearchResult.php
      946 /src/Core/Product/Search/SortOrdersCollection.php
      947 /src/Adapter/Presenter/Product/ProductListingLazyArray.php
      948 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_updatecache.php
      949 /var/cache/prod/smarty/compile/revostore/39/d3/1a/39d31a599d73c039735add7bd5dc7a2a3a72c0ba_2.module.ps_categoryproductsviewstemplateshookps_categoryproducts.tpl.cache.php
      950 /var/cache/prod/smarty/compile/revostore/4f/bd/c7/4fbdc7339a176d9a34209db1db287a136af19ca4_2.file.product.tpl.cache.php
      951 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_capture.php
      952 /var/cache/prod/smarty/compile/revostore/58/d7/dc/58d7dc5add3b41367ca5d1938ffed2cb93d167d1_2.file.product.tpl.php
      953 /src/Adapter/Localization/LegacyTranslator.php
      954 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_codeframe.php
      955 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_writefile.php
      956 /var/cache/prod/smarty/cache/ps_categoryproducts/10199/171/1/1/1/145/revostore/ee/04/57/ee0457378e2bb01f495778b8cc7c6352ad2ef6c7.ps_categoryproductsviewstemplateshookps_categoryproducts.tpl.php
      957 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/a9/d2/27/a9d2278856ba75a2ad2cc60dff0ff15bb912cb2a_2.file.product-images-modal.tpl.php
      958 /var/cache/prod/smarty/compile/revostorelayouts_layout_full_width_tpl/f4/38/7d/f4387ddb912ae2d3f00333064366648e0991c2d5_2.file.footer.tpl.php
      959 /modules/ps_contactinfo/ps_contactinfo.php
      960 /var/cache/prod/smarty/compile/revostore/99/92/f3/9992f3fe04dd41bcec1a2029cf07bead637caf4d_2.module.ps_contactinfops_contactinfo.tpl.php
      961 /modules/ps_customeraccountlinks/ps_customeraccountlinks.php
      962 /var/cache/prod/smarty/cache/ps_customeraccountlinks/1/1/1/145/revostore/b7/b7/2e/b7b72e649dd242d4bf1917e0317bd02f01cfcad4.ps_customeraccountlinksps_customeraccountlinks.tpl.php
      963 /modules/ps_linklist/ps_linklist.php
      964 /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php
      965 /modules/ps_linklist/src/Filter/LinkFilter.php
      966 /modules/ps_linklist/src/Filter/BestSalesRouteFilter.php
      967 /modules/ps_linklist/src/Filter/RouteFilterInterface.php
      968 /modules/ps_linklist/src/LegacyLinkBlockRepository.php
      969 /var/cache/prod/smarty/cache/ps_linklist/displayFooter/1/1/1/145/revostore/b6/5f/3f/b65f3f7826a05afc0c11a845513645a1d05ef92f.ps_linklistviewstemplateshooklinkblock.tpl.php
      970 /var/cache/prod/smarty/compile/revostore/30/7d/c6/307dc6bd4724d29d1572cc301dd7148e962604ef_2.module.ps_emailsubscriptionviewstemplateshookps_emailsubscription.tpl.php
      971 /var/cache/prod/smarty/compile/revostore/18/24/2f/18242f08c3c83a7c623381a713f58be64de777d7_2.file.panel.tpl.php
      972 /var/cache/prod/smarty/cache/ps_socialfollow/1/1/1/145/revostore/bb/d6/e1/bbd6e1847fb5721a91412df3414a8e6f8db19924.ps_socialfollowps_socialfollow.tpl.php
      973 /modules/statsdata/statsdata.php
      974 /classes/Connection.php
      975 /classes/ConnectionsSource.php
      976 /var/cache/prod/smarty/compile/revostore/0d/48/4e/0d484e9043a16fe876ab593ef6aaa2d27bf274ec_2.file.login_popup.tpl.php
      977 /modules/ets_superspeed/classes/ext/minify_html