Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.36 ms
(82.37%)
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
  423552
  433352
  443129
  452840
  459028
  481655
  482891
  487976
  490300
  492410
  510586
  516990
  517186
  521387
  523060
  527437
  527474
  528730
  534488
  540004
  544471
  545677
  546099
  546546
  547721
  548055
  559148
  560316
  560745
  560897
  562437
  563736
  568799
  568826
  568932
  571096
  573861
  574151
  577614
  578331
  579684
  584718
  587332
  592052
  592186
  592218
  593105
  594635
  595573
  596919
  598525
  600682
  609072
  617961
  619512
  627349
  627789
  628748
  628901
  639222
  651758
  652380
  658224
  665588
  672588
  673448
  678615
  678732
  687368
  688997
  694929
  695169
  695473
  696333
  696345
  696576
  699910
  700006
  712073
  712276
  715012
  716374
  721124
  722262
  733869
  735144
  736693
  740092
  740093
  747969
  751337
  757196
  758732
  760558
  767056
  768675
  770386
  770514
  771870
  777924
  784796
  788879
  794702
  795363
  795431
  797668
  797817
  799095
  799289
  801003
  801619
  806693
  807332
  807419
  809712
  809779
  811668
  812038
  813260
  813482
]
15.68 ms
(10.22%)
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
  812038
  443129
  459028
  423552
  433352
  510586
  544471
  658224
  672588
  788879
  807332
  794702
  492410
  452840
  481655
  482891
  487976
  490300
  540004
  521387
  534488
  517186
  528730
  516990
  523060
  527437
  527474
  545677
  560316
  574151
  577614
  578331
  563736
  568799
  568932
  560745
  560897
  562437
  571096
  573861
  665588
  678615
  688997
  695169
  699910
  721124
  678732
  687368
  694929
  695473
  696345
  696576
  712073
  651758
  652380
  673448
  696333
  700006
  712276
  715012
  716374
  546099
  546546
  547721
  548055
  559148
  568826
  579684
  584718
  592218
  594635
  598525
  639222
  592052
  593105
  609072
  617961
  592186
  595573
  596919
  600682
  628748
  628901
  587332
  777924
  795431
  797668
  799095
  799289
  801003
  809779
  784796
  795363
  807419
  809712
  740092
  740093
  757196
  797817
  801619
  806693
  811668
  813260
  813482
  736693
  758732
  767056
  768675
  751337
  771870
  733869
  735144
  747969
  760558
  770386
  770514
  619512
  627349
  627789
  722262
]
3.27 ms
(2.13%)
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
  423552
  433352
  443129
  452840
  459028
  481655
  482891
  487976
  490300
  492410
  510586
  516990
  517186
  521387
  523060
  527437
  527474
  528730
  534488
  540004
  544471
  545677
  546099
  546546
  547721
  548055
  559148
  560316
  560745
  560897
  562437
  563736
  568799
  568826
  568932
  571096
  573861
  574151
  577614
  578331
  579684
  584718
  587332
  592052
  592186
  592218
  593105
  594635
  595573
  596919
  598525
  600682
  609072
  617961
  619512
  627349
  627789
  628748
  628901
  639222
  651758
  652380
  658224
  665588
  672588
  673448
  678615
  678732
  687368
  688997
  694929
  695169
  695473
  696333
  696345
  696576
  699910
  700006
  712073
  712276
  715012
  716374
  721124
  722262
  733869
  735144
  736693
  740092
  740093
  747969
  751337
  757196
  758732
  760558
  767056
  768675
  770386
  770514
  771870
  777924
  784796
  788879
  794702
  795363
  795431
  797668
  797817
  799095
  799289
  801003
  801619
  806693
  807332
  807419
  809712
  809779
  811668
  812038
  813260
  813482
]
2.30 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "узкая молодые"
]
2.06 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "узкая молодые"
]
1.97 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.16%)
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.