Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
246.84 ms
(90.42%)
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
  404468
  405074
  424895
  430762
  454778
  470625
  470644
  475046
  479709
  479835
  488217
  496928
  499536
  502112
  506565
  513880
  517641
  520208
  520925
  522399
  522576
  533961
  533969
  535013
  536987
  539841
  542562
  550024
  551580
  552794
  558434
  558446
  560435
  561918
  568313
  574755
  574764
  574975
  577134
  577210
  578132
  578717
  582806
  583655
  584166
  585307
  585329
  587554
  587594
  591108
  592015
  592299
  595986
  596463
  599226
  599525
  599863
  603608
  604468
  604681
  604704
  605144
  605456
  605565
  606725
  612242
  612263
  615433
  628644
  632502
  633973
  636574
  654600
  660452
  661955
  663501
  666044
  666695
  668559
  683973
  684029
  688083
  718885
  720127
  720241
  720659
  725825
  726635
  728440
  728956
  731723
  732823
  734387
  742685
  744597
  745015
  748326
  751026
  769502
  769531
  770124
  773946
  773963
  781671
  789115
  789973
  790860
  795593
  797126
  797133
  802161
  803076
  807544
  810798
  811079
  811872
  812305
  813031
  813427
  819571
]
15.93 ms
(5.83%)
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
  550024
  551580
  574975
  663501
  552794
  604681
  636574
  599226
  596463
  612242
  612263
  605144
  628644
  790860
  731723
  769531
  725825
  745015
  604468
  781671
  430762
  405074
  475046
  578717
  810798
  807544
  812305
  520925
  599863
  536987
  583655
  688083
  584166
  587554
  604704
  606725
  615433
  789973
  803076
  728956
  726635
  732823
  734387
  742685
  789115
  535013
  479709
  520208
  479835
  542562
  819571
  585329
  599525
  802161
  744597
  496928
  605456
  488217
  470625
  539841
  558446
  568313
  661955
  603608
  770124
  797126
  454778
  513880
  522576
  577210
  666695
  720659
  720127
  591108
  585307
  795593
  813031
  813427
  751026
  773946
  748326
  718885
  720241
  797133
  811872
  470644
  499536
  517641
  577134
  666044
  660452
  592015
  605565
  811079
  404468
  533969
  506565
  574764
  654600
  582806
  595986
  773963
  728440
  769502
  632502
  424895
  668559
  522399
  533961
  502112
  558434
  560435
  561918
  683973
  684029
  574755
  578132
  633973
  592299
  587594
]
2.98 ms
(1.09%)
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
  404468
  405074
  424895
  430762
  454778
  470625
  470644
  475046
  479709
  479835
  488217
  496928
  499536
  502112
  506565
  513880
  517641
  520208
  520925
  522399
  522576
  533961
  533969
  535013
  536987
  539841
  542562
  550024
  551580
  552794
  558434
  558446
  560435
  561918
  568313
  574755
  574764
  574975
  577134
  577210
  578132
  578717
  582806
  583655
  584166
  585307
  585329
  587554
  587594
  591108
  592015
  592299
  595986
  596463
  599226
  599525
  599863
  603608
  604468
  604681
  604704
  605144
  605456
  605565
  606725
  612242
  612263
  615433
  628644
  632502
  633973
  636574
  654600
  660452
  661955
  663501
  666044
  666695
  668559
  683973
  684029
  688083
  718885
  720127
  720241
  720659
  725825
  726635
  728440
  728956
  731723
  732823
  734387
  742685
  744597
  745015
  748326
  751026
  769502
  769531
  770124
  773946
  773963
  781671
  789115
  789973
  790860
  795593
  797126
  797133
  802161
  803076
  807544
  810798
  811079
  811872
  812305
  813031
  813427
  819571
]
2.07 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf секс куколд"
]
1.91 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf sex cuckold"
]
1.72 ms
(0.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf секс куколд"
]

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.