Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.26 ms
(81.50%)
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
  390205
  398182
  422746
  423123
  428530
  436178
  436230
  438001
  439518
  440625
  443219
  443311
  443982
  446659
  448820
  449425
  453203
  453253
  453337
  456964
  458234
  460281
  461100
  462844
  465745
  468016
  468065
  469764
  472775
  473241
  476909
  480702
  482388
  490896
  495163
  495218
  496086
  500531
  502315
  504411
  507296
  510004
  510582
  510767
  514104
  516598
  518270
  522669
  522771
  525241
  528778
  529143
  539354
  539742
  545539
  546669
  547742
  547949
  550336
  552029
  552643
  552974
  553100
  556101
  556626
  559569
  560450
  561087
  562001
  563362
  565940
  565983
  567363
  568055
  568450
  569289
  570159
  576418
  579780
  580280
  582137
  582926
  583039
  583566
  583819
  584991
  585671
  585701
  588250
  594073
  597068
  597070
  598029
  601836
  601982
  602981
  603732
  608336
  613880
  615621
  616711
  616971
  618789
  620215
  620754
  622839
  622987
  632576
  634484
  636801
  638115
  650788
  651954
  653560
  657361
  659035
  662997
  678791
  679567
  741247
]
20.68 ms
(12.28%)
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
  465745
  562001
  583566
  582926
  632576
  741247
  462844
  468016
  525241
  545539
  601836
  603732
  453253
  618789
  585671
  622839
  583819
  585701
  552974
  495163
  565940
  522771
  565983
  552643
  576418
  469764
  613880
  456964
  547949
  569289
  553100
  556626
  579780
  443311
  390205
  473241
  650788
  529143
  550336
  436230
  510004
  580280
  594073
  597070
  495218
  616711
  588250
  616971
  468065
  504411
  448820
  516598
  528778
  507296
  423123
  428530
  461100
  552029
  657361
  620215
  679567
  651954
  659035
  502315
  496086
  458234
  472775
  480702
  443982
  602981
  653560
  398182
  522669
  567363
  570159
  490896
  518270
  584991
  583039
  546669
  482388
  476909
  439518
  539354
  440625
  560450
  662997
  597068
  510582
  622987
  601982
  636801
  615621
  556101
  568055
  443219
  460281
  563362
  638115
  598029
  453203
  547742
  449425
  453337
  634484
  510767
  422746
  446659
  582137
  608336
  620754
  436178
  568450
  438001
  500531
  514104
  539742
  561087
  559569
  678791
]
2.86 ms
(1.70%)
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
  390205
  398182
  422746
  423123
  428530
  436178
  436230
  438001
  439518
  440625
  443219
  443311
  443982
  446659
  448820
  449425
  453203
  453253
  453337
  456964
  458234
  460281
  461100
  462844
  465745
  468016
  468065
  469764
  472775
  473241
  476909
  480702
  482388
  490896
  495163
  495218
  496086
  500531
  502315
  504411
  507296
  510004
  510582
  510767
  514104
  516598
  518270
  522669
  522771
  525241
  528778
  529143
  539354
  539742
  545539
  546669
  547742
  547949
  550336
  552029
  552643
  552974
  553100
  556101
  556626
  559569
  560450
  561087
  562001
  563362
  565940
  565983
  567363
  568055
  568450
  569289
  570159
  576418
  579780
  580280
  582137
  582926
  583039
  583566
  583819
  584991
  585671
  585701
  588250
  594073
  597068
  597070
  598029
  601836
  601982
  602981
  603732
  608336
  613880
  615621
  616711
  616971
  618789
  620215
  620754
  622839
  622987
  632576
  634484
  636801
  638115
  650788
  651954
  653560
  657361
  659035
  662997
  678791
  679567
  741247
]
1.98 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ден в вагин"
]
1.98 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "был день в пизде"
]
1.85 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ден в вагин"
]
1.81 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.