Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.16 ms
(49.80%)
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
  339415
  459965
  479460
  480187
  480889
  481644
  483903
  486139
  494901
  497850
  499088
  502207
  502376
  504727
  504785
  505788
  505899
  506036
  509874
  511191
  513410
  516800
  517373
  517990
  518027
  518643
  519069
  520513
  521232
  521691
  522751
  525151
  525852
  527276
  529514
  530178
  532247
  533274
  535840
  537219
  538155
  538478
  539155
  539186
  539530
  545137
  546099
  551863
  552486
  552682
  553817
  555487
  556506
  558087
  558215
  559994
  561838
  562970
  565523
  566242
  566915
  569648
  571265
  572266
  572714
  575725
  575871
  577474
  577608
  577625
  578340
  578528
  578800
  579443
  580423
  581868
  582826
  583000
  583242
  585442
  585521
  586250
  586695
  587063
  587342
  588666
  589392
  589722
  589735
  590824
  592416
  594448
  594846
  595543
  596710
  598186
  599400
  601463
  604362
  604646
  605656
  606901
  607180
  607928
  609419
  617855
  618188
  618771
  620371
  622840
  628901
  631370
  647105
  648021
  651138
  655456
  655466
  656242
  656522
  728203
]
187.81 ms
(44.71%)
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
  339415
  459965
  479460
  480187
  480889
  481644
  483903
  486139
  494901
  497850
  499088
  502207
  502376
  504727
  504785
  505788
  505899
  506036
  509874
  511191
  513410
  516800
  517373
  517990
  518027
  518643
  519069
  520513
  521232
  521691
  522751
  525151
  525852
  527276
  529514
  530178
  532247
  533274
  535840
  537219
  538155
  538478
  539155
  539186
  539530
  545137
  546099
  551863
  552486
  552682
  553817
  555487
  556506
  558087
  558215
  559994
  561838
  562970
  565523
  566242
  566915
  569648
  571265
  572266
  572714
  575725
  575871
  577474
  577608
  577625
  578340
  578528
  578800
  579443
  580423
  581868
  582826
  583000
  583242
  585442
  585521
  586250
  586695
  587063
  587342
  588666
  589392
  589722
  589735
  590824
  592416
  594448
  594846
  595543
  596710
  598186
  599400
  601463
  604362
  604646
  605656
  606901
  607180
  607928
  609419
  617855
  618188
  618771
  620371
  622840
  628901
  631370
  647105
  648021
  651138
  655456
  655466
  656242
  656522
  728203
]
14.91 ms
(3.55%)
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
  558215
  565523
  609419
  586695
  504785
  575871
  655456
  594846
  518643
  527276
  538478
  517373
  518027
  577474
  598186
  599400
  502376
  513410
  728203
  339415
  479460
  480889
  481644
  486139
  509874
  516800
  529514
  538155
  504727
  522751
  525151
  533274
  537219
  539186
  499088
  519069
  520513
  502207
  539155
  555487
  569648
  577625
  583242
  552486
  553817
  556506
  561838
  572714
  581868
  582826
  558087
  559994
  562970
  566915
  579443
  583000
  647105
  656242
  648021
  656522
  651138
  655466
  545137
  546099
  551863
  552682
  566242
  578800
  580423
  586250
  605656
  606901
  607180
  607928
  588666
  594448
  604646
  618771
  620371
  587063
  587342
  589392
  589735
  590824
  601463
  628901
  585442
  585521
  589722
  592416
  595543
  596710
  617855
  618188
  622840
  631370
  604362
  459965
  483903
  511191
  532247
  535840
  497850
  505788
  505899
  506036
  521691
  494901
  525852
  530178
  539530
  517990
  521232
  480187
  571265
  572266
  575725
  577608
  578340
  578528
]
2.24 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на лиц мужчин"
]
2.16 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на лицо мужчине"
]
1.94 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.