Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.24 ms
(85.63%)
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
  123955
  385067
  403252
  426124
  512186
  527506
  529606
  530422
  534975
  542158
  544327
  546262
  547208
  547276
  548444
  548459
  552557
  552922
  555883
  556197
  558713
  559849
  559983
  562125
  565707
  568296
  569709
  572045
  572356
  575935
  577041
  577238
  579057
  579712
  580395
  583699
  586269
  588823
  589155
  589868
  593110
  595464
  596290
  598413
  599399
  600228
  604134
  607381
  608628
  621085
  622451
  625347
  630504
  646191
  646493
  646789
  647228
  651278
  652221
  656909
  660308
  661063
  661519
  661526
  661788
  662945
  663218
  668893
  670463
  671097
  671769
  672029
  675884
  676503
  676996
  680788
  680971
  683269
  708543
  708562
  713157
  720133
  780889
  781024
  781754
  782095
  783835
  785100
  786926
  787644
  789486
  794686
  796791
  800973
  812414
  814059
  814196
  817031
  818126
  819089
  819123
  819216
  820169
  821025
  821131
  821547
  823056
  823353
  824231
  825033
  825921
  826564
  827228
  827332
  827716
  828068
  828390
  828587
  828738
]
12.73 ms
(7.61%)
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
  812414
  426124
  385067
  123955
  403252
  819216
  820169
  824231
  826564
  817031
  818126
  821547
  827228
  827332
  827716
  814196
  819123
  821025
  823056
  823353
  814059
  819089
  821131
  825033
  828738
  828068
  828390
  825921
  828587
  512186
  529606
  534975
  527506
  530422
  544327
  547276
  569709
  575935
  580395
  542158
  546262
  556197
  559849
  559983
  565707
  577041
  579712
  548444
  548459
  552922
  555883
  568296
  572045
  572356
  652221
  660308
  661063
  661526
  663218
  668893
  672029
  675884
  676503
  676996
  680788
  708562
  646191
  646789
  647228
  656909
  661519
  662945
  670463
  713157
  720133
  646493
  651278
  661788
  671097
  671769
  680971
  683269
  708543
  547208
  552557
  558713
  562125
  577238
  579057
  583699
  598413
  604134
  608628
  625347
  607381
  621085
  630504
  586269
  588823
  589155
  589868
  593110
  596290
  597175
  599399
  595464
  600228
  622451
  781754
  785100
  786926
  787644
  794686
  796791
  800973
  780889
  781024
  782095
  783835
  789486
]
2.98 ms
(1.78%)
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
  123955
  385067
  403252
  426124
  512186
  527506
  529606
  530422
  534975
  542158
  544327
  546262
  547208
  547276
  548444
  548459
  552557
  552922
  555883
  556197
  558713
  559849
  559983
  562125
  565707
  568296
  569709
  572045
  572356
  575935
  577041
  577238
  579057
  579712
  580395
  583699
  586269
  588823
  589155
  589868
  593110
  595464
  596290
  598413
  599399
  600228
  604134
  607381
  608628
  621085
  622451
  625347
  630504
  646191
  646493
  646789
  647228
  651278
  652221
  656909
  660308
  661063
  661519
  661526
  661788
  662945
  663218
  668893
  670463
  671097
  671769
  672029
  675884
  676503
  676996
  680788
  680971
  683269
  708543
  708562
  713157
  720133
  780889
  781024
  781754
  782095
  783835
  785100
  786926
  787644
  789486
  794686
  796791
  800973
  812414
  814059
  814196
  817031
  818126
  819089
  819123
  819216
  820169
  821025
  821131
  821547
  823056
  823353
  824231
  825033
  825921
  826564
  827228
  827332
  827716
  828068
  828390
  828587
  828738
]
2.14 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые мастурбац"
]
2.10 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые мастурбац"
]
2.03 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny masturbation"
]

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.