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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 27.96 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 3.75 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 2.68 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"\x13ð⢋®\x11ïµ6Ùây‘\x16Â"
]
4 1.23 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"\x16š¯@:Ê\x11ïŸ+•¢Ð‘ˆ³"
]
5 1.87 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"4Mñô?v\x11ï€D}nQ>îZ"
]
6 1.51 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"4äeVŒ\x08\x11ïŸlg¨/„\x1Dˆ"
]
7 0.77 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"OC\t¾4£\x11ïµÖQÅùGCÅ"
]
8 1.95 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.80 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"g)%‗î\x07\x11´àjì╣┤uêo"
]
11 0.61 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"‹«¤FCc\x11ï…d§ÉØ0ô%"
]
12 1.57 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"Øa9║î\x08\x11´ôûwö¸aá\x15"
]
13 3.41 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"£íJ.6\x10\x11ï‘Þ™÷dà¥ø"
]
14 1.71 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"»\x0FÉ\x066\x10\x11´öùG¶Þ┤PÌ"
]
15 1.32 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"Ì\x16ÐôŒ\x07\x11ï²p«M]]]\t"
]
16 1.61 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"Ñé{|Cc\x11ï­85<\x0F\x10¦Ð"
]
17 0.92 ms
SELECT pi.path FROM product_image pi WHERE pi.product_id = ?
Parameters:
[
  b"é¶ýŒŒ\x07\x11ï„Ï™kvµu¬"
]
18 1.18 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.