Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.24 ms
(86.39%)
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
  381887
  418564
  418575
  427486
  435146
  438714
  444641
  444674
  449690
  453200
  453846
  453865
  454193
  454533
  454537
  456627
  456672
  456744
  459267
  470805
  472008
  473304
  475814
  476599
  477927
  478614
  479393
  479415
  482929
  485069
  485404
  485594
  494677
  501923
  504212
  506021
  506397
  506744
  511186
  513171
  513451
  515668
  516743
  521330
  527773
  533208
  541000
  542776
  543561
  545226
  546561
  548752
  553135
  553144
  554372
  558658
  563036
  566488
  568040
  601445
  609686
  614047
  630704
  661501
  667246
  670825
  690946
  703281
  714421
  718897
  721962
  724058
  726172
  726899
  728511
  729272
  730827
  730971
  732942
  733060
  733458
  734171
  735333
  736889
  740102
  740520
  743884
  743911
  744762
  750515
  758128
  759138
  759552
  766289
  766527
  767973
  775147
  775609
  779908
  788678
  788977
  789470
  794666
  795175
  795378
  796043
  799748
  800998
  802901
  803999
  805111
  812121
  814730
  818891
  823365
  824260
  824593
  826990
  827096
  827241
]
10.81 ms
(7.52%)
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
  714421
  788678
  796043
  802901
  812121
  728511
  750515
  726899
  759552
  456627
  477927
  418564
  435146
  454533
  456744
  475814
  453200
  456672
  459267
  470805
  511186
  513171
  558658
  548752
  554372
  563036
  566488
  427486
  438714
  453846
  454193
  444674
  453865
  479415
  418575
  449690
  454537
  473304
  476599
  479393
  472008
  516743
  506397
  515668
  482929
  485404
  506744
  521330
  527773
  533208
  568040
  542776
  553144
  541000
  543561
  546561
  670825
  545226
  803999
  767973
  690946
  661501
  494677
  506021
  614047
  501923
  485594
  805111
  759138
  733458
  513451
  504212
  736889
  703281
  630704
  381887
  444641
  818891
  824260
  826990
  827096
  827241
  814730
  823365
  824593
  478614
  485069
  718897
  721962
  667246
  553135
  609686
  601445
  775147
  775609
  779908
  789470
  799748
  795175
  795378
  800998
  729272
  730827
  740520
  743884
  743911
  766289
  766527
  788977
  794666
  724058
  726172
  730971
  732942
  733060
  734171
  735333
  740102
  744762
  758128
]
2.23 ms
(1.55%)
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
  381887
  418564
  418575
  427486
  435146
  438714
  444641
  444674
  449690
  453200
  453846
  453865
  454193
  454533
  454537
  456627
  456672
  456744
  459267
  470805
  472008
  473304
  475814
  476599
  477927
  478614
  479393
  479415
  482929
  485069
  485404
  485594
  494677
  501923
  504212
  506021
  506397
  506744
  511186
  513171
  513451
  515668
  516743
  521330
  527773
  533208
  541000
  542776
  543561
  545226
  546561
  548752
  553135
  553144
  554372
  558658
  563036
  566488
  568040
  601445
  609686
  614047
  630704
  661501
  667246
  670825
  690946
  703281
  714421
  718897
  721962
  724058
  726172
  726899
  728511
  729272
  730827
  730971
  732942
  733060
  733458
  734171
  735333
  736889
  740102
  740520
  743884
  743911
  744762
  750515
  758128
  759138
  759552
  766289
  766527
  767973
  775147
  775609
  779908
  788678
  788977
  789470
  794666
  795175
  795378
  796043
  799748
  800998
  802901
  803999
  805111
  812121
  814730
  818891
  823365
  824260
  824593
  826990
  827096
  827241
]
1.90 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "скрытое домашнее порн…"
]
1.57 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт домашн любительск порн"
]
1.52 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.