Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.94 ms
(85.83%)
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
  170215
  233292
  368335
  384234
  385376
  387422
  395554
  400209
  400243
  403312
  405261
  405490
  405501
  407644
  408213
  413794
  414008
  414784
  416970
  420134
  422171
  425976
  428202
  429552
  430834
  431022
  443727
  445060
  445065
  446443
  447862
  448055
  450847
  457446
  462453
  463172
  464339
  464388
  465840
  466149
  466176
  469072
  470302
  471403
  494269
  504091
  506052
  515931
  517267
  531072
  532135
  533469
  534221
  535018
  536313
  543579
  549968
  550378
  556661
  563099
  563182
  563432
  563433
  565146
  579397
  582586
  591289
  599716
  599726
  612872
  620200
  629762
  630475
  644682
  650779
  663865
  664793
  667621
  684222
  684815
  688668
  699611
  702144
  702455
  702904
  709331
  724656
  725350
  725561
  727637
  733819
  736398
  737093
  742248
  744194
  744915
  748342
  755810
  774384
  782249
  782272
  782276
  788284
  788468
  789976
  790878
  792287
  798679
  799050
  800541
  801868
  802430
  804583
  805362
  805685
  806099
  813252
  818929
  827857
  827887
]
14.60 ms
(8.53%)
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
  827857
  827887
  533469
  536313
  532135
  534221
  550378
  563182
  579397
  582586
  650779
  684815
  702904
  664793
  667621
  688668
  702144
  663865
  684222
  702455
  563433
  565146
  612872
  620200
  644682
  599716
  782249
  802430
  782272
  792287
  800541
  801868
  805362
  725350
  727637
  737093
  744194
  782276
  788468
  789976
  724656
  733819
  736398
  742248
  744915
  774384
  748342
  755810
  709331
  799050
  804583
  805685
  387422
  368335
  233292
  395554
  448055
  400209
  471403
  450847
  517267
  556661
  599726
  422171
  457446
  430834
  469072
  431022
  504091
  494269
  531072
  405490
  425976
  818929
  447862
  464339
  515931
  549968
  699611
  629762
  806099
  813252
  725561
  790878
  543579
  506052
  630475
  591289
  466176
  470302
  465840
  535018
  428202
  384234
  385376
  170215
  400243
  405501
  414008
  414784
  420134
  445065
  413794
  416970
  445060
  464388
  563099
  563432
  798679
  788284
  403312
  405261
  407644
  408213
  429552
  443727
  446443
  462453
  463172
  466149
]
2.54 ms
(1.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
  170215
  233292
  368335
  384234
  385376
  387422
  395554
  400209
  400243
  403312
  405261
  405490
  405501
  407644
  408213
  413794
  414008
  414784
  416970
  420134
  422171
  425976
  428202
  429552
  430834
  431022
  443727
  445060
  445065
  446443
  447862
  448055
  450847
  457446
  462453
  463172
  464339
  464388
  465840
  466149
  466176
  469072
  470302
  471403
  494269
  504091
  506052
  515931
  517267
  531072
  532135
  533469
  534221
  535018
  536313
  543579
  549968
  550378
  556661
  563099
  563182
  563432
  563433
  565146
  579397
  582586
  591289
  599716
  599726
  612872
  620200
  629762
  630475
  644682
  650779
  663865
  664793
  667621
  684222
  684815
  688668
  699611
  702144
  702455
  702904
  709331
  724656
  725350
  725561
  727637
  733819
  736398
  737093
  742248
  744194
  744915
  748342
  755810
  774384
  782249
  782272
  782276
  788284
  788468
  789976
  790878
  792287
  798679
  799050
  800541
  801868
  802430
  804583
  805362
  805685
  806099
  813252
  818929
  827857
  827887
]
2.18 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young boy mom"
]
1.64 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young парен mom"
]
1.47 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young парен mom"
]

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.