Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.15 ms
(85.68%)
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
  384570
  396204
  396786
  398425
  401089
  402716
  408824
  413577
  414256
  417421
  417592
  420494
  420507
  424089
  429575
  429877
  443119
  445545
  448641
  455456
  464250
  481251
  546476
  547570
  548773
  550306
  551283
  552077
  552124
  552148
  552565
  552668
  552684
  554085
  558504
  558858
  560626
  562047
  562119
  562286
  562294
  562395
  566220
  569850
  569991
  570013
  570021
  570038
  570193
  570199
  570274
  570531
  570606
  570670
  571769
  571865
  571906
  572154
  572165
  573022
  573100
  573341
  573770
  573790
  573840
  573908
  574611
  576076
  576369
  577834
  579202
  581185
  585910
  586546
  586663
  586803
  586932
  590609
  590615
  591041
  591309
  593137
  594048
  594225
  594826
  596618
  596619
  597136
  597504
  598021
  598058
  598526
  598528
  598535
  598674
  598700
  598816
  598923
  599107
  599454
  600472
  600894
  601534
  601880
  605050
  606392
  607125
  652923
  659042
  714491
  714498
  714526
  718696
  728730
  730715
  732423
  770814
  792767
  795690
  805346
]
18.12 ms
(9.35%)
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
  659042
  714491
  652923
  714498
  718696
  546476
  547570
  548773
  550306
  551283
  552077
  552124
  552148
  552565
  552668
  552684
  554085
  558504
  558858
  560626
  562047
  562119
  562286
  562294
  562395
  566220
  569850
  569991
  570013
  570021
  570038
  570193
  570199
  570274
  570531
  570606
  570670
  571769
  571865
  571906
  572154
  572165
  573022
  573100
  573341
  573770
  573790
  573840
  573908
  574611
  576076
  576369
  577834
  579202
  581185
  593137
  594826
  597136
  598058
  598674
  598700
  598923
  600472
  601880
  605050
  607125
  585910
  590615
  591041
  596618
  596619
  598535
  598816
  599454
  600894
  606392
  586803
  590609
  591309
  594048
  594225
  598021
  598526
  598528
  599107
  586546
  586663
  586932
  597504
  795690
  805346
  730715
  770814
  728730
  732423
  601534
  714526
  792767
  398425
  402716
  408824
  413577
  417592
  420494
  420507
  443119
  445545
  448641
  396204
  384570
  401089
  414256
  417421
  424089
  429575
  429877
  455456
  464250
  481251
  396786
]
2.97 ms
(1.53%)
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
  384570
  396204
  396786
  398425
  401089
  402716
  408824
  413577
  414256
  417421
  417592
  420494
  420507
  424089
  429575
  429877
  443119
  445545
  448641
  455456
  464250
  481251
  546476
  547570
  548773
  550306
  551283
  552077
  552124
  552148
  552565
  552668
  552684
  554085
  558504
  558858
  560626
  562047
  562119
  562286
  562294
  562395
  566220
  569850
  569991
  570013
  570021
  570038
  570193
  570199
  570274
  570531
  570606
  570670
  571769
  571865
  571906
  572154
  572165
  573022
  573100
  573341
  573770
  573790
  573840
  573908
  574611
  576076
  576369
  577834
  579202
  581185
  585910
  586546
  586663
  586803
  586932
  590609
  590615
  591041
  591309
  593137
  594048
  594225
  594826
  596618
  596619
  597136
  597504
  598021
  598058
  598526
  598528
  598535
  598674
  598700
  598816
  598923
  599107
  599454
  600472
  600894
  601534
  601880
  605050
  606392
  607125
  652923
  659042
  714491
  714498
  714526
  718696
  728730
  730715
  732423
  770814
  792767
  795690
  805346
]
1.84 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худая жоп"
]
1.75 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худая попу"
]
1.73 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.35 ms
(0.70%)
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.