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

Response
200 OK
IP
216.73.217.126
Profiled on
Token
05436c

Query Metrics

1 Database Queries
1 Different statements
1.70 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.70 ms 
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: 
[
  0
  0
  "y"
  60563
  9397365
  9053430
  9168477
  9594789
  9510025
  9219692
  8750960
  7602105
  9173196
  9172933
  9173287
  9173113
  9173006
  9174236
  9066986
  9173139
  9174244
  7601834
  9172982
  9823691
  9172958
  9172990
  7473531
]
View formatted query    View runnable query    Explain query    View query backtrace

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.