Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.11 ms
(82.28%)
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
  391125
  396065
  414432
  421623
  423625
  428052
  428753
  431740
  433980
  436844
  437801
  444188
  447300
  448585
  450450
  451003
  452922
  455670
  458739
  461551
  462038
  462169
  463394
  464915
  468757
  471712
  471933
  473115
  474283
  474575
  475548
  476383
  476536
  478012
  479605
  479662
  483036
  483129
  483995
  486519
  487623
  489021
  490387
  490619
  494864
  498645
  499474
  499502
  501185
  501910
  502709
  502855
  503315
  503822
  505324
  507657
  508687
  510503
  512488
  512604
  516036
  516108
  516377
  516512
  516538
  518091
  521533
  521871
  521903
  521959
  521978
  522282
  522801
  524447
  524514
  524684
  524935
  525453
  526053
  527057
  528781
  528797
  536878
  538212
  541065
  546381
  546652
  547845
  550453
  551639
  552210
  552518
  552948
  558049
  558853
  558950
  558955
  561639
  563750
  569898
  570271
  570382
  571283
  571575
  572062
  572128
  572448
  573812
  574858
  578503
  578865
  579200
  584108
  587005
  598554
  598777
  627135
  655656
  656345
  778610
]
16.21 ms
(11.01%)
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
  512604
  462038
  483129
  473115
  437801
  414432
  464915
  501910
  524447
  524514
  458739
  510503
  516108
  475548
  391125
  498645
  778610
  516538
  552518
  563750
  474575
  578865
  463394
  547845
  541065
  516377
  490619
  448585
  569898
  558853
  538212
  525453
  455670
  598554
  468757
  499502
  656345
  471712
  521533
  573812
  570271
  461551
  476383
  558049
  450450
  452922
  505324
  524935
  552210
  503822
  486519
  550453
  551639
  655656
  462169
  521978
  522282
  489021
  451003
  572062
  572448
  574858
  571575
  521903
  522801
  558950
  487623
  584108
  587005
  431740
  478012
  507657
  428753
  436844
  433980
  528781
  558955
  471933
  526053
  528797
  483995
  579200
  521871
  490387
  474283
  428052
  516036
  502855
  552948
  508687
  494864
  479605
  572128
  521959
  516512
  570382
  546381
  444188
  578503
  524684
  502709
  503315
  527057
  571283
  627135
  423625
  421623
  479662
  476536
  536878
  598777
  396065
  546652
  447300
  483036
  518091
  501185
  512488
  499474
  561639
]
2.47 ms
(1.68%)
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
  391125
  396065
  414432
  421623
  423625
  428052
  428753
  431740
  433980
  436844
  437801
  444188
  447300
  448585
  450450
  451003
  452922
  455670
  458739
  461551
  462038
  462169
  463394
  464915
  468757
  471712
  471933
  473115
  474283
  474575
  475548
  476383
  476536
  478012
  479605
  479662
  483036
  483129
  483995
  486519
  487623
  489021
  490387
  490619
  494864
  498645
  499474
  499502
  501185
  501910
  502709
  502855
  503315
  503822
  505324
  507657
  508687
  510503
  512488
  512604
  516036
  516108
  516377
  516512
  516538
  518091
  521533
  521871
  521903
  521959
  521978
  522282
  522801
  524447
  524514
  524684
  524935
  525453
  526053
  527057
  528781
  528797
  536878
  538212
  541065
  546381
  546652
  547845
  550453
  551639
  552210
  552518
  552948
  558049
  558853
  558950
  558955
  561639
  563750
  569898
  570271
  570382
  571283
  571575
  572062
  572128
  572448
  573812
  574858
  578503
  578865
  579200
  584108
  587005
  598554
  598777
  627135
  655656
  656345
  778610
]
2.18 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русская молодуха в розовой"
]
1.91 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск молодая девушк в розов"
]
1.62 ms
(1.10%)
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.