Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.49 ms
(80.84%)
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
  173134
  242127
  278764
  382352
  383039
  383652
  388080
  389616
  399563
  408898
  413049
  413163
  432020
  449022
  450313
  458581
  466258
  469343
  492274
  496685
  503377
  507171
  515369
  515546
  524494
  529647
  531185
  538754
  539503
  547142
  549319
  550585
  559654
  559851
  562785
  563103
  568167
  572846
  572858
  587157
  587163
  587215
  591049
  591664
  592605
  593552
  604104
  604806
  604843
  604857
  604909
  604935
  605848
  637687
  637705
  640241
  644126
  644315
  669171
  672506
  684018
  699596
  704907
  707876
  712953
  716140
  716170
  716848
  717789
  721173
  721580
  723545
  725571
  726657
  726757
  728044
  736408
  744380
  748757
  753633
  756230
  757226
  758614
  764044
  770123
  771596
  772009
  773105
  775355
  776786
  779595
  781814
  781953
  783514
  785438
  785877
  786468
  789551
  789685
  790553
  790887
  796245
  796707
  797580
  802467
  804647
  805564
  807333
  808027
  809562
  810337
  810718
  811003
  811250
  813511
  813654
  813807
  814851
  815038
  821770
]
17.14 ms
(11.41%)
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
  382352
  449022
  563103
  568167
  699596
  547142
  604857
  591664
  604843
  604935
  785438
  785877
  797580
  810337
  756230
  770123
  704907
  808027
  811003
  813511
  413049
  388080
  413163
  813654
  813807
  814851
  821770
  492274
  539503
  496685
  524494
  529647
  503377
  550585
  572846
  572858
  669171
  721580
  684018
  712953
  717789
  716140
  716848
  559654
  604806
  644315
  587163
  591049
  644126
  587157
  775355
  783514
  789685
  811250
  781814
  805564
  748757
  758614
  764044
  772009
  796245
  802467
  726757
  744380
  757226
  726657
  753633
  771596
  604104
  637705
  779595
  781953
  789551
  810718
  399563
  278764
  538754
  515369
  804647
  432020
  723545
  531185
  562785
  707876
  716170
  605848
  637687
  725571
  736408
  728044
  796707
  408898
  815038
  450313
  469343
  515546
  549319
  604909
  592605
  466258
  242127
  389616
  458581
  559851
  721173
  672506
  593552
  640241
  587215
  786468
  790553
  807333
  773105
  776786
  790887
  809562
  173134
  507171
  383039
  383652
]
3.24 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
  173134
  242127
  278764
  382352
  383039
  383652
  388080
  389616
  399563
  408898
  413049
  413163
  432020
  449022
  450313
  458581
  466258
  469343
  492274
  496685
  503377
  507171
  515369
  515546
  524494
  529647
  531185
  538754
  539503
  547142
  549319
  550585
  559654
  559851
  562785
  563103
  568167
  572846
  572858
  587157
  587163
  587215
  591049
  591664
  592605
  593552
  604104
  604806
  604843
  604857
  604909
  604935
  605848
  637687
  637705
  640241
  644126
  644315
  669171
  672506
  684018
  699596
  704907
  707876
  712953
  716140
  716170
  716848
  717789
  721173
  721580
  723545
  725571
  726657
  726757
  728044
  736408
  744380
  748757
  753633
  756230
  757226
  758614
  764044
  770123
  771596
  772009
  773105
  775355
  776786
  779595
  781814
  781953
  783514
  785438
  785877
  786468
  789551
  789685
  790553
  790887
  796245
  796707
  797580
  802467
  804647
  805564
  807333
  808027
  809562
  810337
  810718
  811003
  811250
  813511
  813654
  813807
  814851
  815038
  821770
]
2.53 ms
(1.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "busty big milf"
]
2.18 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "busty большие milf"
]
1.88 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "busty большие milf"
]
1.84 ms
(1.22%)
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.