Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

4.08 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.08 ms
(100.00%)

SELECT
                ib.ec_it_by_productnum,
                ib.ec_it_by_sku,
                ib.ec_it_by_title,
                ib.ec_it_by_uom,
                ib.ec_it_by_itemurl,
                ib.ec_it_by_active,
                ib.ec_it_by_shipups,
                ib.ec_it_by_green,
                ib.ec_it_by_madeinusa,
                ib.ec_it_by_gsa,
                ib.ec_it_by_gsarestricted,
                ib.ec_it_by_pricerestriction,
                ib.ec_it_by_assembly,
                -- Tier 1 (unit) pricing
                ib.ec_it_by_unitprice,
                ib.ec_it_by_unitdelivery,
                ib.ec_it_by_unitpreorder,
                -- Tier 2 (bulk) pricing
                ib.ec_it_by_tier2price,
                ib.ec_it_by_tier2qty,
                ib.ec_it_by_tier2delivery,
                ib.ec_it_by_tier2preorder,
                -- Tier 3 pricing
                ib.ec_it_by_tier3price,
                ib.ec_it_by_tier3qty,
                ib.ec_it_by_tier3delivery,
                ib.ec_it_by_tier3preorder,
                -- Bulk ordering constraints
                ib.ec_it_by_bulkqty,
                ib.ec_it_by_bulkmultiple,
                -- Media
                ib.ec_it_by_thumbfile,
                ib.ec_it_by_thumbsrc,
                -- Brand & category JSON
                ib.ec_it_by_branddata,
                ib.ec_it_by_catdata,
                -- Ratings
                ib.ec_it_by_rating,
                ib.ec_it_by_numratings,
                ib.ec_it_by_numreviews,
                -- Visibility & price restriction from ecdb_items
                it.ec_it_visibility                     AS visibility,
                it.ec_it_pricerestriction               AS it_pricerestriction,
                -- Org-level access: 1 = allowed, 0 = restricted
                cu_prx.cu_prx_it_productnum IS NOT NULL AS has_org_access,
                -- TaxJar tax code
                COALESCE(tc.ca_tx_taxjar_code, '')    AS ca_tx_taxjar_code
            FROM ecdb_item_buyable AS ib
            JOIN ecdb_items AS it
                ON it.ec_it_productnum = ib.ec_it_by_productnum
            LEFT JOIN customer_prx_items AS cu_prx
                ON  cu_prx.cu_prx_it_productnum = ib.ec_it_by_productnum
                AND cu_prx.cu_prx_it_customer   = ?
                AND cu_prx.cu_prx_it_user       = ?
            LEFT JOIN catalog_taxcodes AS tc
                ON tc.ca_tx_id = ib.ec_it_by_taxcode
            WHERE ib.ec_it_by_active = ?
              AND ib.ec_it_by_productnum IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  ib.ec_it_by_productnum,
  ib.ec_it_by_sku,
  ib.ec_it_by_title,
  ib.ec_it_by_uom,
  ib.ec_it_by_itemurl,
  ib.ec_it_by_active,
  ib.ec_it_by_shipups,
  ib.ec_it_by_green,
  ib.ec_it_by_madeinusa,
  ib.ec_it_by_gsa,
  ib.ec_it_by_gsarestricted,
  ib.ec_it_by_pricerestriction,
  ib.ec_it_by_assembly,
  -- Tier 1 (unit) pricing
  ib.ec_it_by_unitprice,
  ib.ec_it_by_unitdelivery,
  ib.ec_it_by_unitpreorder,
  -- Tier 2 (bulk) pricing
  ib.ec_it_by_tier2price,
  ib.ec_it_by_tier2qty,
  ib.ec_it_by_tier2delivery,
  ib.ec_it_by_tier2preorder,
  -- Tier 3 pricing
  ib.ec_it_by_tier3price,
  ib.ec_it_by_tier3qty,
  ib.ec_it_by_tier3delivery,
  ib.ec_it_by_tier3preorder,
  -- Bulk ordering constraints
  ib.ec_it_by_bulkqty,
  ib.ec_it_by_bulkmultiple,
  -- Media
  ib.ec_it_by_thumbfile,
  ib.ec_it_by_thumbsrc,
  -- Brand & category JSON
  ib.ec_it_by_branddata,
  ib.ec_it_by_catdata,
  -- Ratings
  ib.ec_it_by_rating,
  ib.ec_it_by_numratings,
  ib.ec_it_by_numreviews,
  -- Visibility & price restriction from ecdb_items
  it.ec_it_visibility AS visibility,
  it.ec_it_pricerestriction AS it_pricerestriction,
  -- Org-level access: 1 = allowed, 0 = restricted
  cu_prx.cu_prx_it_productnum IS NOT NULL AS has_org_access,
  -- TaxJar tax code
  COALESCE(tc.ca_tx_taxjar_code, '') AS ca_tx_taxjar_code
FROM
  ecdb_item_buyable AS ib
  JOIN ecdb_items AS it ON it.ec_it_productnum = ib.ec_it_by_productnum
  LEFT JOIN customer_prx_items AS cu_prx ON cu_prx.cu_prx_it_productnum = ib.ec_it_by_productnum
  AND cu_prx.cu_prx_it_customer = ?
  AND cu_prx.cu_prx_it_user = ?
  LEFT JOIN catalog_taxcodes AS tc ON tc.ca_tx_id = ib.ec_it_by_taxcode
WHERE
  ib.ec_it_by_active = ?
  AND ib.ec_it_by_productnum IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT
                ib.ec_it_by_productnum,
                ib.ec_it_by_sku,
                ib.ec_it_by_title,
                ib.ec_it_by_uom,
                ib.ec_it_by_itemurl,
                ib.ec_it_by_active,
                ib.ec_it_by_shipups,
                ib.ec_it_by_green,
                ib.ec_it_by_madeinusa,
                ib.ec_it_by_gsa,
                ib.ec_it_by_gsarestricted,
                ib.ec_it_by_pricerestriction,
                ib.ec_it_by_assembly,
                -- Tier 1 (unit) pricing
                ib.ec_it_by_unitprice,
                ib.ec_it_by_unitdelivery,
                ib.ec_it_by_unitpreorder,
                -- Tier 2 (bulk) pricing
                ib.ec_it_by_tier2price,
                ib.ec_it_by_tier2qty,
                ib.ec_it_by_tier2delivery,
                ib.ec_it_by_tier2preorder,
                -- Tier 3 pricing
                ib.ec_it_by_tier3price,
                ib.ec_it_by_tier3qty,
                ib.ec_it_by_tier3delivery,
                ib.ec_it_by_tier3preorder,
                -- Bulk ordering constraints
                ib.ec_it_by_bulkqty,
                ib.ec_it_by_bulkmultiple,
                -- Media
                ib.ec_it_by_thumbfile,
                ib.ec_it_by_thumbsrc,
                -- Brand & category JSON
                ib.ec_it_by_branddata,
                ib.ec_it_by_catdata,
                -- Ratings
                ib.ec_it_by_rating,
                ib.ec_it_by_numratings,
                ib.ec_it_by_numreviews,
                -- Visibility & price restriction from ecdb_items
                it.ec_it_visibility                     AS visibility,
                it.ec_it_pricerestriction               AS it_pricerestriction,
                -- Org-level access: 1 = allowed, 0 = restricted
                cu_prx.cu_prx_it_productnum IS NOT NULL AS has_org_access,
                -- TaxJar tax code
                COALESCE(tc.ca_tx_taxjar_code, '')    AS ca_tx_taxjar_code
            FROM ecdb_item_buyable AS ib
            JOIN ecdb_items AS it
                ON it.ec_it_productnum = ib.ec_it_by_productnum
            LEFT JOIN customer_prx_items AS cu_prx
                ON  cu_prx.cu_prx_it_productnum = ib.ec_it_by_productnum
                AND cu_prx.cu_prx_it_customer   = 0
                AND cu_prx.cu_prx_it_user       = 0
            LEFT JOIN catalog_taxcodes AS tc
                ON tc.ca_tx_id = ib.ec_it_by_taxcode
            WHERE ib.ec_it_by_active = 'y'
              AND ib.ec_it_by_productnum IN (7596893, 9170739, 7497613, 9581760, 9173733, 9232208, 71120, 9173147, 9581752, 9173394, 9170713, 8776957, 9052267, 5430533, 7511017, 7008428, 9052259, 7777055, 8357337, 7426711, 9170721, 9173717, 8357329, 9173741);

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\OtsSearchBundle\Catalog\ProductHydrationService->fetchBaseData (line 98)
3	App\OtsSearchBundle\Catalog\ProductHydrationService->hydrateByIds (line 60)
4	App\Controller\SearchController->index (line 89)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://docker1-www.ontimesupplies.com/search?page=3&query=Cosco

Configuration Settings

Theme

Page Width