Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.51 ms
(86.11%)
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
  9896
  32585
  72499
  80285
  117596
  118202
  148793
  181060
  188122
  190929
  208504
  212132
  228393
  249443
  256949
  382199
  382649
  385508
  386043
  388915
  392645
  394029
  396288
  396790
  397601
  398451
  399252
  401519
  401527
  401713
  402582
  407782
  411397
  411837
  413270
  415036
  415354
  415871
  417293
  417419
  419102
  422506
  424434
  426057
  433697
  434582
  437709
  441560
  443046
  443924
  444221
  444366
  446154
  446375
  450764
  451242
  451515
  452879
  454300
  454651
  456743
  457956
  458604
  459043
  459153
  459593
  459746
  459772
  460171
  461063
  466155
  466318
  466497
  467861
  469916
  471529
  473336
  474047
  474967
  475818
  475845
  476377
  477477
  477740
  479391
  484400
  485831
  490257
  490811
  491686
  492816
  493148
  493462
  500813
  501757
  504020
  506039
  506072
  508407
  508777
  509329
  509614
  516912
  521120
  528673
  546921
  557380
  563202
  566918
  573673
  575637
  575805
  599202
  604500
  605711
  613355
  660956
  714655
  744361
  811130
]
14.92 ms
(8.16%)
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
  459153
  80285
  118202
  394029
  397601
  398451
  401519
  477477
  490811
  811130
  9896
  457956
  475818
  415354
  433697
  446154
  249443
  466318
  411837
  415036
  458604
  744361
  424434
  422506
  493462
  402582
  474047
  476377
  228393
  72499
  32585
  475845
  446375
  575637
  563202
  714655
  599202
  419102
  459746
  460171
  451515
  466497
  411397
  444366
  392645
  188122
  452879
  454651
  485831
  490257
  417419
  382199
  469916
  426057
  466155
  399252
  459593
  474967
  501757
  508777
  508407
  401527
  401713
  566918
  212132
  444221
  417293
  256949
  437709
  454300
  473336
  660956
  573673
  459043
  500813
  443924
  443046
  415871
  450764
  504020
  613355
  386043
  459772
  471529
  479391
  148793
  396288
  493148
  208504
  117596
  467861
  605711
  388915
  434582
  451242
  506072
  461063
  546921
  575805
  557380
  604500
  407782
  477740
  441560
  506039
  509329
  509614
  516912
  484400
  491686
  492816
  521120
  528673
  382649
  385508
  181060
  190929
  413270
  456743
  396790
]
2.78 ms
(1.52%)
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
  9896
  32585
  72499
  80285
  117596
  118202
  148793
  181060
  188122
  190929
  208504
  212132
  228393
  249443
  256949
  382199
  382649
  385508
  386043
  388915
  392645
  394029
  396288
  396790
  397601
  398451
  399252
  401519
  401527
  401713
  402582
  407782
  411397
  411837
  413270
  415036
  415354
  415871
  417293
  417419
  419102
  422506
  424434
  426057
  433697
  434582
  437709
  441560
  443046
  443924
  444221
  444366
  446154
  446375
  450764
  451242
  451515
  452879
  454300
  454651
  456743
  457956
  458604
  459043
  459153
  459593
  459746
  459772
  460171
  461063
  466155
  466318
  466497
  467861
  469916
  471529
  473336
  474047
  474967
  475818
  475845
  476377
  477477
  477740
  479391
  484400
  485831
  490257
  490811
  491686
  492816
  493148
  493462
  500813
  501757
  504020
  506039
  506072
  508407
  508777
  509329
  509614
  516912
  521120
  528673
  546921
  557380
  563202
  566918
  573673
  575637
  575805
  599202
  604500
  605711
  613355
  660956
  714655
  744361
  811130
]
2.01 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.01 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "занимаются сексом в о%…"
]
1.98 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "занима секс в"
]
1.71 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.