Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
339.09 ms
(92.22%)
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
  410734
  417109
  417121
  418707
  419264
  419272
  420860
  421695
  424628
  425272
  429247
  430142
  434008
  434425
  437118
  437966
  437983
  438629
  441677
  442564
  446612
  447609
  450853
  450958
  451437
  453226
  455516
  464262
  465770
  467121
  471990
  475579
  476441
  480114
  480867
  482494
  485994
  490529
  495356
  496504
  503166
  503315
  508828
  509872
  514400
  516888
  519562
  519794
  520484
  520829
  521404
  521442
  524255
  524916
  529349
  532248
  532252
  539396
  547579
  552354
  554001
  555785
  557670
  557900
  558373
  565005
  568419
  569318
  570990
  579174
  581465
  584291
  588221
  593974
  594257
  595530
  612447
  664702
  684383
  684830
  691856
  695178
  711700
  719600
  721560
  723277
  723585
  725714
  727143
  737441
  741185
  756973
  757446
  764666
  767252
  770644
  771366
  777631
  779938
  784042
  784814
  784976
  788361
  789463
  791301
  792661
  796442
  796981
  798401
  799955
  800350
  802841
  804891
  806626
  807345
  809354
  809603
  809842
  809847
  813065
]
17.16 ms
(4.67%)
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
  594257
  784976
  789463
  806626
  807345
  777631
  798401
  809354
  809847
  813065
  727143
  741185
  770644
  792661
  796442
  800350
  802841
  725714
  771366
  737441
  767252
  779938
  784042
  784814
  796981
  799955
  804891
  809603
  809842
  438629
  447609
  453226
  475579
  480867
  419264
  421695
  434008
  434425
  442564
  424628
  437983
  450958
  480114
  417109
  450853
  509872
  496504
  508828
  521404
  485994
  664702
  593974
  791301
  757446
  764666
  410734
  554001
  464262
  446612
  519794
  524916
  514400
  503315
  529349
  539396
  691856
  588221
  595530
  756973
  788361
  532252
  695178
  612447
  418707
  419272
  420860
  425272
  437118
  437966
  430142
  441677
  417121
  429247
  723585
  482494
  451437
  476441
  490529
  465770
  471990
  455516
  467121
  520484
  520829
  495356
  503166
  516888
  519562
  521442
  524255
  532248
  557900
  568419
  570990
  581465
  547579
  557670
  569318
  579174
  552354
  555785
  558373
  584291
  719600
  684830
  684383
  711700
  721560
  723277
  565005
]
3.57 ms
(0.97%)
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
  410734
  417109
  417121
  418707
  419264
  419272
  420860
  421695
  424628
  425272
  429247
  430142
  434008
  434425
  437118
  437966
  437983
  438629
  441677
  442564
  446612
  447609
  450853
  450958
  451437
  453226
  455516
  464262
  465770
  467121
  471990
  475579
  476441
  480114
  480867
  482494
  485994
  490529
  495356
  496504
  503166
  503315
  508828
  509872
  514400
  516888
  519562
  519794
  520484
  520829
  521404
  521442
  524255
  524916
  529349
  532248
  532252
  539396
  547579
  552354
  554001
  555785
  557670
  557900
  558373
  565005
  568419
  569318
  570990
  579174
  581465
  584291
  588221
  593974
  594257
  595530
  612447
  664702
  684383
  684830
  691856
  695178
  711700
  719600
  721560
  723277
  723585
  725714
  727143
  737441
  741185
  756973
  757446
  764666
  767252
  770644
  771366
  777631
  779938
  784042
  784814
  784976
  788361
  789463
  791301
  792661
  796442
  796981
  798401
  799955
  800350
  802841
  804891
  806626
  807345
  809354
  809603
  809842
  809847
  813065
]
2.10 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tight pov"
]
2.02 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "tight пов"
]
1.97 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "tight пов"
]
1.79 ms
(0.49%)
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.