Query Metrics

8 Database Queries
8 Different statements
316.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
214.14 ms
(67.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby moms"
]
73.36 ms
(23.18%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  33309
  187956
  390045
  395571
  396774
  398224
  398236
  398244
  398522
  401062
  405850
  407708
  407765
  407768
  407769
  407816
  409156
  416121
  424432
  425865
  428103
  433684
  442973
  443744
  450825
  454188
  460735
  460919
  462155
  466014
  467048
  468953
  468955
  474813
  475294
  482304
  483366
  489950
  490707
  495243
  496279
  497516
  517687
  523565
  563903
  590418
  591314
  634484
  746686
  748206
  748234
  748236
  782020
]
12.55 ms
(3.96%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  468953
  442973
  523565
  187956
  398522
  396774
  490707
  496279
  433684
  425865
  401062
  407708
  398236
  398244
  409156
  495243
  563903
  748206
  748234
  782020
  398224
  407765
  407768
  450825
  460919
  474813
  33309
  390045
  443744
  497516
  746686
  748236
  416121
  405850
  407769
  517687
  590418
  462155
  424432
  407816
  483366
  460735
  468955
  482304
  467048
  466014
  454188
  395571
  634484
  428103
  489950
  591314
  475294
]
7.97 ms
(2.52%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "chubby moms"
  "chubby moms"
  "chubby moms"
  20
]
3.06 ms
(0.97%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  33309
  187956
  390045
  395571
  396774
  398224
  398236
  398244
  398522
  401062
  405850
  407708
  407765
  407768
  407769
  407816
  409156
  416121
  424432
  425865
  428103
  433684
  442973
  443744
  450825
  454188
  460735
  460919
  462155
  466014
  467048
  468953
  468955
  474813
  475294
  482304
  483366
  489950
  490707
  495243
  496279
  497516
  517687
  523565
  563903
  590418
  591314
  634484
  746686
  748206
  748234
  748236
  782020
]
1.97 ms
(0.62%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby moms"
]
1.69 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby moms"
]

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.