Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.76 ms
(83.97%)
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
  21575
  21576
  96452
  381848
  385273
  385854
  396449
  397396
  416111
  418792
  433064
  433419
  433455
  433867
  435089
  435400
  437368
  438532
  439343
  441519
  446902
  447304
  448369
  452751
  452791
  464563
  466325
  473225
  475563
  479174
  481008
  483443
  486827
  489876
  490741
  505457
  508184
  516304
  524102
  527792
  528639
  533736
  537404
  538217
  552207
  552227
  561621
  561675
  566392
  568938
  571647
  571900
  571929
  573852
  574837
  575751
  575812
  576414
  576915
  580886
  590023
  591180
  594305
  594490
  597546
  597601
  597962
  598495
  598538
  598552
  598736
  598814
  600144
  602714
  603003
  605367
  605874
  628197
  629013
  643602
  652853
  654120
  656470
  657938
  659315
  662448
  673554
  674177
  675806
  687362
  690066
  700031
  701051
  707180
  712859
  719480
  740056
  740594
  742226
  745082
  745100
  748539
  760401
  761737
  765896
  767236
  767611
  775831
  781006
  781621
  782519
  785780
  787552
  789182
  793948
  806857
  807244
  808186
  811275
  819857
]
17.19 ms
(9.97%)
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
  656470
  657938
  719480
  552207
  552227
  629013
  591180
  597962
  590023
  785780
  787552
  806857
  760401
  808186
  811275
  767611
  740056
  745082
  643602
  700031
  782519
  789182
  793948
  396449
  381848
  433867
  385273
  464563
  438532
  479174
  594490
  439343
  441519
  466325
  561621
  576414
  561675
  574837
  575751
  605367
  96452
  437368
  448369
  475563
  418792
  452791
  433064
  483443
  489876
  516304
  486827
  505457
  662448
  775831
  446902
  527792
  490741
  528639
  819857
  508184
  533736
  537404
  568938
  571647
  571929
  573852
  580886
  571900
  575812
  652853
  654120
  674177
  687362
  707180
  659315
  673554
  675806
  690066
  712859
  566392
  576915
  594305
  598736
  603003
  597546
  598538
  602714
  605874
  598552
  598814
  597601
  598495
  600144
  628197
  781006
  748539
  761737
  767236
  745100
  742226
  740594
  765896
  701051
  781621
  807244
  397396
  21575
  416111
  433419
  435089
  435400
  447304
  452751
  473225
  21576
  385854
  481008
  433455
  524102
  538217
]
3.47 ms
(2.01%)
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
  21575
  21576
  96452
  381848
  385273
  385854
  396449
  397396
  416111
  418792
  433064
  433419
  433455
  433867
  435089
  435400
  437368
  438532
  439343
  441519
  446902
  447304
  448369
  452751
  452791
  464563
  466325
  473225
  475563
  479174
  481008
  483443
  486827
  489876
  490741
  505457
  508184
  516304
  524102
  527792
  528639
  533736
  537404
  538217
  552207
  552227
  561621
  561675
  566392
  568938
  571647
  571900
  571929
  573852
  574837
  575751
  575812
  576414
  576915
  580886
  590023
  591180
  594305
  594490
  597546
  597601
  597962
  598495
  598538
  598552
  598736
  598814
  600144
  602714
  603003
  605367
  605874
  628197
  629013
  643602
  652853
  654120
  656470
  657938
  659315
  662448
  673554
  674177
  675806
  687362
  690066
  700031
  701051
  707180
  712859
  719480
  740056
  740594
  742226
  745082
  745100
  748539
  760401
  761737
  765896
  767236
  767611
  775831
  781006
  781621
  782519
  785780
  787552
  789182
  793948
  806857
  807244
  808186
  811275
  819857
]
1.86 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian teen riding"
]
1.76 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск teen riding"
]
1.53 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск teen riding"
]

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.