GET http://api.taafiya.com/market/product/tafiya-rfjcwi/lists

Query Metrics

18 Database Queries
3 Different statements
18.46 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.19 ms
SELECT COUNT(*) AS total FROM (SELECT p.*, pc.designation AS category FROM product p INNER JOIN product_category pc ON pc.id = p.category_id INNER JOIN company c ON c.id = p.company_id WHERE c.slug = ?) t
Parameters:
[
  "tafiya-rfjcwi"
]
2 1.26 ms
SELECT p.*, pc.designation AS category FROM product p INNER JOIN product_category pc ON pc.id = p.category_id INNER JOIN company c ON c.id = p.company_id WHERE c.slug = ?
Parameters:
[
  "tafiya-rfjcwi"
]
3 1.32 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"\x13ð⢋®\x11ïµ6Ùây‘\x16Â"
]
4 0.55 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"\x16š¯@:Ê\x11ïŸ+•¢Ð‘ˆ³"
]
5 0.36 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"4Mñô?v\x11ï€D}nQ>îZ"
]
6 0.52 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"4äeVŒ\x08\x11ïŸlg¨/„\x1Dˆ"
]
7 0.46 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"OC\t¾4£\x11ïµÖQÅùGCÅ"
]
8 0.50 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"\x08–Œ\x08\x11ï³V×"²\x7FÔá"
]
9 0.75 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"dÔ.\x12ŒO\x11ï•@Í\x11S}Qd"
]
10 0.59 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"g)%‗î\x07\x11´àjì╣┤uêo"
]
11 1.12 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"‹«¤FCc\x11ï…d§ÉØ0ô%"
]
12 0.50 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"Øa9║î\x08\x11´ôûwö¸aá\x15"
]
13 0.48 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"£íJ.6\x10\x11ï‘Þ™÷dà¥ø"
]
14 0.93 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"»\x0FÉ\x066\x10\x11´öùG¶Þ┤PÌ"
]
15 1.22 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"Ì\x16ÐôŒ\x07\x11ï²p«M]]]\t"
]
16 3.58 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"Ñé{|Cc\x11ï­85<\x0F\x10¦Ð"
]
17 0.75 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"é¶ýŒŒ\x07\x11ï„Ï™kvµu¬"
]
18 0.36 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"ü'ä”?s\x11ï¨m…ìXÕÞÞ"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.