Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.87 ms
(82.59%)
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
  447903
  459002
  466557
  467839
  468893
  475931
  480079
  486162
  488154
  495361
  497834
  498405
  500633
  502887
  503353
  504825
  509005
  513837
  514661
  518223
  518577
  518875
  518877
  519845
  521103
  521828
  522918
  522987
  523564
  523734
  524037
  526733
  528960
  529565
  530473
  534594
  534630
  535979
  538478
  538913
  542294
  542520
  543494
  549170
  551131
  556922
  558956
  558990
  559566
  560168
  563042
  563534
  565739
  567758
  569025
  569085
  569087
  569131
  569526
  572970
  573740
  573911
  574414
  575708
  577535
  577778
  580254
  581698
  583644
  583979
  584528
  584716
  585003
  586426
  588154
  588276
  588300
  589074
  589087
  589425
  590501
  590813
  594151
  594406
  597430
  598919
  599040
  605486
  605703
  605826
  606564
  607369
  609540
  609723
  609926
  612933
  613007
  614495
  616760
  617139
  617857
  618534
  619782
  620072
  620162
  620266
  620943
  621140
  621305
  621566
  624320
  626127
  628681
  629688
  643668
  670329
  672804
  673667
  676209
  688991
]
15.79 ms
(10.97%)
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
  629688
  643668
  586426
  609723
  588300
  624320
  628681
  607369
  612933
  447903
  459002
  468893
  498405
  522918
  528960
  534630
  500633
  519845
  523564
  535979
  509005
  522987
  560168
  575708
  551131
  569025
  563534
  565739
  569085
  584528
  673667
  676209
  688991
  556922
  574414
  583644
  583979
  589087
  605486
  619782
  626127
  589425
  599040
  606564
  620072
  620162
  588154
  597430
  620943
  605826
  614495
  488154
  538913
  572970
  617857
  594151
  577778
  518577
  534594
  558956
  573911
  590501
  588276
  466557
  616760
  521103
  495361
  523734
  617139
  480079
  529565
  521828
  503353
  486162
  542294
  577535
  569131
  558990
  569526
  670329
  584716
  605703
  609540
  589074
  621140
  621566
  621305
  609926
  620266
  585003
  467839
  497834
  518223
  518877
  513837
  514661
  518875
  504825
  524037
  526733
  502887
  530473
  538478
  475931
  542520
  559566
  563042
  567758
  543494
  581698
  672804
  549170
  569087
  573740
  580254
  594406
  598919
  613007
  618534
  590813
]
3.11 ms
(2.16%)
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
  447903
  459002
  466557
  467839
  468893
  475931
  480079
  486162
  488154
  495361
  497834
  498405
  500633
  502887
  503353
  504825
  509005
  513837
  514661
  518223
  518577
  518875
  518877
  519845
  521103
  521828
  522918
  522987
  523564
  523734
  524037
  526733
  528960
  529565
  530473
  534594
  534630
  535979
  538478
  538913
  542294
  542520
  543494
  549170
  551131
  556922
  558956
  558990
  559566
  560168
  563042
  563534
  565739
  567758
  569025
  569085
  569087
  569131
  569526
  572970
  573740
  573911
  574414
  575708
  577535
  577778
  580254
  581698
  583644
  583979
  584528
  584716
  585003
  586426
  588154
  588276
  588300
  589074
  589087
  589425
  590501
  590813
  594151
  594406
  597430
  598919
  599040
  605486
  605703
  605826
  606564
  607369
  609540
  609723
  609926
  612933
  613007
  614495
  616760
  617139
  617857
  618534
  619782
  620072
  620162
  620266
  620943
  621140
  621305
  621566
  624320
  626127
  628681
  629688
  643668
  670329
  672804
  673667
  676209
  688991
]
1.62 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "заглотила сперму"
]
1.57 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "заглот сперм"
]
1.51 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "заглот сперм"
]
1.45 ms
(1.01%)
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.