Query Metrics

7 Database Queries
7 Different statements
169.64 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
141.28 ms
(83.28%)
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
  27777
  38313
  190903
  372346
  382378
  382484
  382884
  382979
  393735
  396734
  397158
  399022
  402254
  403049
  411913
  430081
  461961
  470800
  472235
  476409
  479710
  488306
  488311
  491023
  504456
  512046
  515110
  515111
  517073
  520268
  520774
  523802
  523822
  538868
  548573
  550443
  550662
  556408
  567145
  568575
  568579
  570076
  571201
  586629
  589579
  594964
  596915
  600121
  605610
  606491
  607167
  607203
  617435
  621664
  624464
  637061
  646783
  649084
  663393
  663932
  665287
  667472
  667490
  668453
  675537
  676445
  676528
  677011
  678802
  681187
  684582
  696273
  696966
  696977
  696978
  700660
  701299
  708802
  712804
  712830
  712896
  716043
  722652
  722665
  722672
  732135
  732422
  732457
  734611
  735516
  735587
  735839
  743034
  743118
  743126
  743132
  744278
  744315
  745818
  747355
  759569
  759609
  759645
  759647
  759649
  766020
  767959
  776878
  778549
  778602
  783885
  788471
  788749
  789228
  789806
  800249
  812132
  812137
  819963
  827117
]
18.32 ms
(10.80%)
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
  396734
  38313
  430081
  461961
  517073
  570076
  520774
  567145
  470800
  675537
  586629
  382979
  523802
  550443
  568575
  568579
  596915
  716043
  382378
  402254
  668453
  607167
  399022
  827117
  488311
  678802
  722652
  677011
  776878
  800249
  744315
  735587
  747355
  778602
  403049
  550662
  393735
  27777
  649084
  712804
  667472
  637061
  789228
  743118
  382884
  819963
  515110
  515111
  663932
  667490
  701299
  676445
  696978
  712830
  624464
  605610
  589579
  743034
  789806
  766020
  732422
  732457
  735516
  743126
  812132
  523822
  491023
  488306
  556408
  676528
  663393
  696273
  646783
  684582
  600121
  783885
  788471
  788749
  759647
  744278
  759649
  696966
  700660
  708802
  479710
  722665
  606491
  548573
  722672
  696977
  778549
  190903
  372346
  382484
  512046
  538868
  607203
  735839
  759645
  767959
  571201
  594964
  397158
  411913
  665287
  681187
  712896
  732135
  734611
  745818
  743132
  759569
  759609
  617435
  812137
  520268
  476409
  504456
  472235
  621664
]
2.65 ms
(1.56%)
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
  27777
  38313
  190903
  372346
  382378
  382484
  382884
  382979
  393735
  396734
  397158
  399022
  402254
  403049
  411913
  430081
  461961
  470800
  472235
  476409
  479710
  488306
  488311
  491023
  504456
  512046
  515110
  515111
  517073
  520268
  520774
  523802
  523822
  538868
  548573
  550443
  550662
  556408
  567145
  568575
  568579
  570076
  571201
  586629
  589579
  594964
  596915
  600121
  605610
  606491
  607167
  607203
  617435
  621664
  624464
  637061
  646783
  649084
  663393
  663932
  665287
  667472
  667490
  668453
  675537
  676445
  676528
  677011
  678802
  681187
  684582
  696273
  696966
  696977
  696978
  700660
  701299
  708802
  712804
  712830
  712896
  716043
  722652
  722665
  722672
  732135
  732422
  732457
  734611
  735516
  735587
  735839
  743034
  743118
  743126
  743132
  744278
  744315
  745818
  747355
  759569
  759609
  759645
  759647
  759649
  766020
  767959
  776878
  778549
  778602
  783885
  788471
  788749
  789228
  789806
  800249
  812132
  812137
  819963
  827117
]
2.11 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "деды ебут дедов"
]
1.87 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старый секс старый"
]
1.59 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "старый секс старый"
]

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.