Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.50 ms
(88.85%)
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
  400015
  414643
  424191
  425299
  449335
  460114
  466686
  468999
  505186
  514394
  514978
  515045
  522931
  530892
  531499
  536886
  538535
  543132
  548489
  556948
  557465
  560163
  565232
  566063
  568410
  577318
  577463
  577976
  586966
  589077
  591721
  592874
  606055
  608558
  609966
  610615
  613273
  630106
  630286
  632766
  633848
  636333
  649702
  654180
  666655
  666660
  675584
  675826
  686091
  693248
  744089
  748160
  763804
  763957
  764843
  765853
  770653
  770792
  772963
  774494
  774994
  777210
  777675
  778471
  779566
  779596
  779843
  780214
  783164
  783992
  784087
  785987
  786467
  786816
  789855
  790510
  791124
  791516
  793166
  793295
  793999
  794068
  797675
  798616
  799976
  800291
  807279
  807298
  808815
  809760
  810780
  810882
  811204
  811395
  811500
  813509
  815062
  817952
  817969
  817993
  819955
  820444
  820466
  820870
  820944
  820965
  821181
  821673
  822120
  822193
  822249
  822439
  822547
  822913
  823145
  823290
  823414
  823516
  827877
  827914
]
12.74 ms
(6.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
  530892
  531499
  556948
  566063
  568410
  649702
  548489
  608558
  632766
  633848
  610615
  630106
  636333
  778471
  779566
  774994
  793295
  748160
  784087
  791516
  811500
  765853
  770653
  609966
  797675
  798616
  810780
  425299
  449335
  468999
  414643
  424191
  514394
  515045
  505186
  522931
  514978
  817969
  817993
  821673
  822193
  817952
  820965
  822120
  822547
  823290
  819955
  820466
  820870
  823516
  820444
  820944
  821181
  822249
  822439
  822913
  823145
  823414
  827877
  827914
  538535
  460114
  543132
  666660
  675584
  693248
  654180
  666655
  686091
  560163
  565232
  577463
  606055
  630286
  774494
  777210
  777675
  785987
  791124
  793166
  799976
  807279
  779843
  807298
  813509
  770792
  783164
  786816
  789855
  793999
  810882
  811395
  763957
  764843
  772963
  744089
  763804
  779596
  780214
  786467
  790510
  794068
  800291
  808815
  809760
  811204
  400015
  557465
  592874
  586966
  613273
  783992
  815062
  536886
  466686
  577318
  577976
  675826
  589077
  591721
]
3.02 ms
(1.51%)
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
  400015
  414643
  424191
  425299
  449335
  460114
  466686
  468999
  505186
  514394
  514978
  515045
  522931
  530892
  531499
  536886
  538535
  543132
  548489
  556948
  557465
  560163
  565232
  566063
  568410
  577318
  577463
  577976
  586966
  589077
  591721
  592874
  606055
  608558
  609966
  610615
  613273
  630106
  630286
  632766
  633848
  636333
  649702
  654180
  666655
  666660
  675584
  675826
  686091
  693248
  744089
  748160
  763804
  763957
  764843
  765853
  770653
  770792
  772963
  774494
  774994
  777210
  777675
  778471
  779566
  779596
  779843
  780214
  783164
  783992
  784087
  785987
  786467
  786816
  789855
  790510
  791124
  791516
  793166
  793295
  793999
  794068
  797675
  798616
  799976
  800291
  807279
  807298
  808815
  809760
  810780
  810882
  811204
  811395
  811500
  813509
  815062
  817952
  817969
  817993
  819955
  820444
  820466
  820870
  820944
  820965
  821181
  821673
  822120
  822193
  822249
  822439
  822547
  822913
  823145
  823290
  823414
  823516
  827877
  827914
]
2.01 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov beauty girl"
]
1.80 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов beauty девушк"
]
1.44 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов beauty девушк"
]

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.