Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.90 ms
(83.99%)
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
  159305
  188266
  386987
  387149
  390447
  395465
  398561
  408978
  413004
  424248
  425149
  426550
  428051
  439758
  442634
  448696
  450181
  452254
  452856
  453135
  456036
  458449
  459643
  460338
  460438
  460533
  460762
  462085
  462095
  462105
  462183
  464534
  464965
  465317
  465385
  466147
  466341
  466790
  467055
  469614
  470762
  472555
  472700
  475897
  476164
  476341
  477718
  478339
  478790
  479084
  479128
  482951
  484375
  485751
  485764
  485937
  485939
  485942
  485950
  487364
  490394
  495238
  498290
  498457
  499712
  514902
  515086
  516653
  518844
  518862
  519386
  520094
  520660
  527947
  529380
  534579
  536481
  537824
  538064
  538530
  538912
  539593
  543924
  545964
  545968
  547536
  549223
  549776
  551886
  552062
  552063
  554839
  558173
  561439
  575677
  582799
  590289
  592883
  593070
  594933
  597867
  610002
  615907
  618052
  618776
  622503
  628693
  629837
  644175
  668701
  710505
  735906
  739557
  742385
  744359
  776212
  784475
  790986
  808166
  808168
]
14.95 ms
(9.81%)
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
  395465
  466790
  776212
  710505
  485950
  593070
  618052
  582799
  622503
  452856
  450181
  552062
  561439
  398561
  469614
  482951
  519386
  478339
  466147
  529380
  462183
  558173
  744359
  735906
  442634
  428051
  538912
  462095
  425149
  460533
  552063
  575677
  479084
  808168
  742385
  520094
  188266
  424248
  539593
  538064
  516653
  499712
  485751
  520660
  413004
  628693
  594933
  629837
  465385
  476164
  458449
  668701
  808166
  466341
  485942
  456036
  459643
  462105
  498290
  390447
  472700
  545964
  547536
  549223
  479128
  485764
  387149
  490394
  498457
  537824
  460762
  472555
  460438
  408978
  478790
  534579
  549776
  554839
  452254
  476341
  159305
  739557
  644175
  551886
  610002
  464534
  453135
  477718
  485939
  485937
  790986
  592883
  464965
  545968
  527947
  518862
  386987
  487364
  518844
  439758
  426550
  618776
  615907
  475897
  462085
  467055
  484375
  536481
  597867
  495238
  470762
  514902
  515086
  590289
  460338
  448696
  465317
  543924
  784475
  538530
]
2.78 ms
(1.83%)
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
  159305
  188266
  386987
  387149
  390447
  395465
  398561
  408978
  413004
  424248
  425149
  426550
  428051
  439758
  442634
  448696
  450181
  452254
  452856
  453135
  456036
  458449
  459643
  460338
  460438
  460533
  460762
  462085
  462095
  462105
  462183
  464534
  464965
  465317
  465385
  466147
  466341
  466790
  467055
  469614
  470762
  472555
  472700
  475897
  476164
  476341
  477718
  478339
  478790
  479084
  479128
  482951
  484375
  485751
  485764
  485937
  485939
  485942
  485950
  487364
  490394
  495238
  498290
  498457
  499712
  514902
  515086
  516653
  518844
  518862
  519386
  520094
  520660
  527947
  529380
  534579
  536481
  537824
  538064
  538530
  538912
  539593
  543924
  545964
  545968
  547536
  549223
  549776
  551886
  552062
  552063
  554839
  558173
  561439
  575677
  582799
  590289
  592883
  593070
  594933
  597867
  610002
  615907
  618052
  618776
  622503
  628693
  629837
  644175
  668701
  710505
  735906
  739557
  742385
  744359
  776212
  784475
  790986
  808166
  808168
]
1.77 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ÐüðÁð║Ðü Ðü ð▒ð░ð▒ð║ð░ð╝ð© ð┤ð¥ð╝ð░Ðêð¢ðÔǪ"
]
1.76 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс бабушк домашн любительск"
]
1.70 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс бабушк домашн любительск"
]
1.43 ms
(0.94%)
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.