Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
419.52 ms
(59.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian teen fuck"
]
255.76 ms
(36.56%)
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
  373852
  382381
  385710
  388512
  395249
  395597
  395664
  401344
  402266
  405990
  406134
  414048
  416138
  418009
  418332
  418706
  420192
  420613
  420621
  422511
  422513
  422543
  422550
  422561
  422572
  422591
  422592
  422649
  422657
  422661
  422671
  422879
  422901
  422908
  422923
  422926
  422953
  422958
  422985
  423007
  423025
  423263
  423266
  429385
  433152
  435727
  445252
  453019
  456622
  456642
  456700
  459232
  460710
  475799
  477216
  478025
  478452
  482621
  488379
  491354
  497444
  502466
  508962
  511249
  511260
  511264
  512189
  512224
  537201
  542542
  542553
  543501
  543823
  543919
  545508
  551973
  559093
  560216
  562872
  564066
  564778
  565344
  571824
  583397
  584550
  585390
  585761
  585967
  586623
  586886
  590935
  592380
  600460
  600560
  601200
  602581
  604319
  605380
  619451
  622521
  636288
  637168
  647619
  651561
  651620
  658163
  659269
  699820
  701744
  713550
  722519
  741109
  744090
  744704
  748686
  758728
  761005
  800415
  816079
  823245
]
17.14 ms
(2.45%)
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
  491354
  475799
  542542
  542553
  823245
  602581
  405990
  560216
  559093
  422901
  422511
  478025
  395597
  604319
  423007
  422649
  423025
  600460
  637168
  601200
  423263
  453019
  422543
  478452
  744090
  422561
  422879
  422572
  508962
  562872
  651620
  761005
  422923
  543501
  592380
  800415
  422657
  512224
  511260
  565344
  622521
  418706
  395249
  701744
  418332
  511264
  571824
  583397
  585967
  402266
  488379
  543919
  418009
  395664
  586623
  420192
  422926
  600560
  422671
  433152
  414048
  482621
  545508
  564066
  748686
  477216
  422958
  422592
  619451
  586886
  722519
  502466
  658163
  713550
  585761
  445252
  564778
  382381
  512189
  511249
  435727
  816079
  758728
  699820
  388512
  422513
  385710
  459232
  543823
  460710
  584550
  741109
  373852
  605380
  422591
  420613
  659269
  590935
  429385
  401344
  422550
  422908
  537201
  636288
  456642
  416138
  422953
  456700
  551973
  456622
  420621
  647619
  651561
  744704
  422985
  423266
  406134
  422661
  497444
  585390
]
3.36 ms
(0.48%)
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
  373852
  382381
  385710
  388512
  395249
  395597
  395664
  401344
  402266
  405990
  406134
  414048
  416138
  418009
  418332
  418706
  420192
  420613
  420621
  422511
  422513
  422543
  422550
  422561
  422572
  422591
  422592
  422649
  422657
  422661
  422671
  422879
  422901
  422908
  422923
  422926
  422953
  422958
  422985
  423007
  423025
  423263
  423266
  429385
  433152
  435727
  445252
  453019
  456622
  456642
  456700
  459232
  460710
  475799
  477216
  478025
  478452
  482621
  488379
  491354
  497444
  502466
  508962
  511249
  511260
  511264
  512189
  512224
  537201
  542542
  542553
  543501
  543823
  543919
  545508
  551973
  559093
  560216
  562872
  564066
  564778
  565344
  571824
  583397
  584550
  585390
  585761
  585967
  586623
  586886
  590935
  592380
  600460
  600560
  601200
  602581
  604319
  605380
  619451
  622521
  636288
  637168
  647619
  651561
  651620
  658163
  659269
  699820
  701744
  713550
  722519
  741109
  744090
  744704
  748686
  758728
  761005
  800415
  816079
  823245
]
1.37 ms
(0.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк teen секс"
]
1.11 ms
(0.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "азиатк teen секс"
]

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.