Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.51 ms
(53.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс красивая русск"
]
150.37 ms
(38.59%)
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
  16691
  382827
  384546
  389593
  391491
  398711
  402693
  402877
  404211
  405242
  417949
  417950
  417957
  418459
  418885
  423520
  425725
  433910
  435414
  435806
  444581
  444605
  447224
  447496
  447532
  449825
  455093
  457798
  458744
  461476
  461984
  462039
  462040
  462240
  462515
  462539
  462797
  463180
  464909
  466034
  466435
  469332
  469725
  470004
  470509
  476532
  481158
  481281
  481321
  482221
  482258
  486193
  489371
  491090
  491192
  491379
  496910
  497270
  498101
  501658
  502047
  503636
  505220
  505364
  507968
  508120
  516108
  524576
  540918
  546001
  547753
  552624
  552856
  557041
  560530
  561912
  562236
  563102
  565430
  566759
  567219
  567254
  567538
  573955
  575808
  586733
  587191
  590223
  595402
  597553
  597995
  599567
  605824
  629013
  652978
  654464
  660910
  670815
  676517
  679351
  688544
  703577
  721849
  722764
  722853
  728287
  733787
  751228
  762219
  762258
  775063
  777961
  778363
  779328
  783206
  785889
  789926
  790268
  804871
  825752
]
20.82 ms
(5.34%)
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
  777961
  384546
  783206
  563102
  469332
  463180
  433910
  461984
  449825
  491379
  524576
  491192
  462539
  605824
  417949
  721849
  688544
  481281
  567219
  762258
  762219
  728287
  464909
  508120
  552856
  547753
  590223
  629013
  455093
  462040
  466435
  404211
  482258
  660910
  785889
  733787
  751228
  402693
  469725
  595402
  466034
  507968
  679351
  722764
  444605
  505220
  567538
  573955
  561912
  557041
  417957
  435806
  505364
  389593
  587191
  16691
  405242
  546001
  789926
  804871
  722853
  540918
  418459
  457798
  778363
  779328
  444581
  825752
  498101
  790268
  458744
  461476
  481158
  382827
  447224
  486193
  447532
  597553
  566759
  423520
  503636
  476532
  482221
  502047
  703577
  565430
  567254
  586733
  398711
  402877
  435414
  470004
  575808
  501658
  496910
  391491
  652978
  462240
  670815
  562236
  462039
  560530
  447496
  462797
  481321
  516108
  418885
  599567
  491090
  417950
  654464
  497270
  425725
  470509
  775063
  597995
  489371
  462515
  676517
  552624
]
3.47 ms
(0.89%)
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
  16691
  382827
  384546
  389593
  391491
  398711
  402693
  402877
  404211
  405242
  417949
  417950
  417957
  418459
  418885
  423520
  425725
  433910
  435414
  435806
  444581
  444605
  447224
  447496
  447532
  449825
  455093
  457798
  458744
  461476
  461984
  462039
  462040
  462240
  462515
  462539
  462797
  463180
  464909
  466034
  466435
  469332
  469725
  470004
  470509
  476532
  481158
  481281
  481321
  482221
  482258
  486193
  489371
  491090
  491192
  491379
  496910
  497270
  498101
  501658
  502047
  503636
  505220
  505364
  507968
  508120
  516108
  524576
  540918
  546001
  547753
  552624
  552856
  557041
  560530
  561912
  562236
  563102
  565430
  566759
  567219
  567254
  567538
  573955
  575808
  586733
  587191
  590223
  595402
  597553
  597995
  599567
  605824
  629013
  652978
  654464
  660910
  670815
  676517
  679351
  688544
  703577
  721849
  722764
  722853
  728287
  733787
  751228
  762219
  762258
  775063
  777961
  778363
  779328
  783206
  785889
  789926
  790268
  804871
  825752
]
2.15 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет красотки русски…"
]
1.66 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.42%)
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.