Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.63 ms
(85.23%)
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
  108555
  387477
  393222
  396362
  401193
  418565
  420825
  448702
  473692
  485156
  490325
  495334
  508625
  510606
  511615
  522467
  525293
  525857
  538658
  539858
  540874
  541815
  541947
  542968
  546698
  547253
  553422
  554941
  556579
  558895
  559988
  560265
  567642
  569267
  572279
  576774
  577717
  580493
  587340
  591089
  593825
  595379
  596314
  596358
  597978
  598028
  599276
  603567
  603617
  608560
  608780
  609633
  609643
  609679
  610968
  612578
  615506
  616491
  617859
  622160
  624649
  625639
  625646
  632921
  634011
  634033
  635029
  641787
  641796
  642093
  643777
  645665
  647074
  648099
  661044
  661509
  663780
  666484
  666680
  667382
  668942
  671447
  672259
  673213
  674938
  678304
  678879
  679230
  679296
  679305
  681710
  682406
  683407
  686323
  686589
  689085
  689830
  696817
  702960
  703016
  703026
  703247
  703280
  703314
  703325
  705102
  706531
  708141
  711867
  720061
  725627
  739106
  750407
  753959
  754172
  798730
  807319
  812621
  825748
]
18.08 ms
(9.30%)
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
  667382
  641787
  706531
  608560
  420825
  540874
  490325
  525857
  495334
  510606
  525293
  522467
  539858
  542968
  560265
  567642
  580493
  546698
  556579
  576774
  645665
  647074
  648099
  666680
  671447
  673213
  674938
  678304
  678879
  679230
  679305
  682406
  683407
  696817
  702960
  703026
  703247
  705102
  720061
  663780
  672259
  679296
  681710
  686589
  689085
  689830
  703016
  703280
  703314
  703325
  661044
  661509
  666484
  668942
  686323
  547253
  553422
  558895
  569267
  572279
  596314
  597978
  598028
  599276
  608780
  609633
  615506
  622160
  625646
  634011
  634033
  641796
  587340
  595379
  643777
  596358
  603617
  617859
  635029
  591089
  593825
  603567
  609643
  610968
  616491
  625639
  642091
  642093
  753959
  754172
  739106
  750407
  725627
  609679
  612578
  624649
  632921
  708141
  711867
  508625
  387477
  396362
  798730
  812621
  807319
  401193
  108555
  393222
  418565
  825748
  485156
  473692
  448702
  511615
  538658
  541815
  577717
  541947
  554941
  559988
]
3.22 ms
(1.66%)
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
  108555
  387477
  393222
  396362
  401193
  418565
  420825
  448702
  473692
  485156
  490325
  495334
  508625
  510606
  511615
  522467
  525293
  525857
  538658
  539858
  540874
  541815
  541947
  542968
  546698
  547253
  553422
  554941
  556579
  558895
  559988
  560265
  567642
  569267
  572279
  576774
  577717
  580493
  587340
  591089
  593825
  595379
  596314
  596358
  597978
  598028
  599276
  603567
  603617
  608560
  608780
  609633
  609643
  609679
  610968
  612578
  615506
  616491
  617859
  622160
  624649
  625639
  625646
  632921
  634011
  634033
  635029
  641787
  641796
  642093
  643777
  645665
  647074
  648099
  661044
  661509
  663780
  666484
  666680
  667382
  668942
  671447
  672259
  673213
  674938
  678304
  678879
  679230
  679296
  679305
  681710
  682406
  683407
  686323
  686589
  689085
  689830
  696817
  702960
  703016
  703026
  703247
  703280
  703314
  703325
  705102
  706531
  708141
  711867
  720061
  725627
  739106
  750407
  753959
  754172
  798730
  807319
  812621
  825748
]
1.97 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "студентки частное"
]
1.93 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "студентк любительск"
]
1.82 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "студентк любительск"
]
1.67 ms
(0.86%)
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.