Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
235.11 ms
(56.62%)
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
  477190
  528267
  486881
  499266
  496627
  516422
  524642
  487436
  514444
  825712
  518461
  532706
  537847
  524175
  494972
  548798
  552561
  723141
  752483
  731490
  392461
  396441
  552563
  717943
  426326
  497374
  485598
  393987
  522055
  392049
  551003
  670059
  670375
  786092
  796792
  618243
  540343
  437994
  538919
  584966
  547077
  720826
  545043
  736384
  761707
  768228
  737300
  740246
  725635
  738896
  769702
  724834
  739720
  753710
  516641
  534783
  498821
  466873
  482132
  469705
  514608
  525296
  511894
  525990
  561798
  488261
  526317
  534700
  535604
  535928
  531342
  528744
  572686
  719555
  535251
  511441
  489286
  732608
  538030
  539661
  695465
  588843
  738857
  499937
  496485
  541826
  539356
  542573
  561265
  556080
  801062
  493004
  526863
  531946
  539658
  533208
  536113
  531674
  533317
  542570
  542647
  553868
  456536
  458667
  522239
  524901
  538054
  479200
  483445
  554979
  501735
  487269
  511912
  486361
  465015
  528481
  528498
  513806
  711027
  479746
]
170.60 ms
(41.08%)
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
  392049
  392461
  393987
  396441
  426326
  437994
  456536
  458667
  465015
  466873
  469705
  477190
  479200
  479746
  482132
  483445
  485598
  486361
  486881
  487269
  487436
  488261
  489286
  493004
  494972
  496485
  496627
  497374
  498821
  499266
  499937
  501735
  511441
  511894
  511912
  513806
  514444
  514608
  516422
  516641
  518461
  522055
  522239
  524175
  524642
  524901
  525296
  525990
  526317
  526863
  528267
  528481
  528498
  528744
  531342
  531674
  531946
  532706
  533208
  533317
  534700
  534783
  535251
  535604
  536113
  537847
  538030
  538054
  538919
  539356
  539658
  539661
  540343
  541826
  542570
  542573
  542647
  545043
  547077
  548798
  551003
  552561
  552563
  553868
  554979
  556080
  561265
  561798
  572686
  584966
  588843
  618243
  670059
  670375
  695465
  711027
  717943
  719555
  720826
  723141
  724834
  725635
  731490
  732608
  736384
  737300
  738857
  738896
  739720
  740246
  752483
  753710
  761707
  768228
  769702
  786092
  796792
  801062
  825712
]
3.12 ms
(0.75%)
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
  392049
  392461
  393987
  396441
  426326
  437994
  456536
  458667
  465015
  466873
  469705
  477190
  479200
  479746
  482132
  483445
  485598
  486361
  486881
  487269
  487436
  488261
  489286
  493004
  494972
  496485
  496627
  497374
  498821
  499266
  499937
  501735
  511441
  511894
  511912
  513806
  514444
  514608
  516422
  516641
  518461
  522055
  522239
  524175
  524642
  524901
  525296
  525990
  526317
  526863
  528267
  528481
  528498
  528744
  531342
  531674
  531946
  532706
  533208
  533317
  534700
  534783
  535251
  535604
  536113
  537847
  538030
  538054
  538919
  539356
  539658
  539661
  540343
  541826
  542570
  542573
  542647
  545043
  547077
  548798
  551003
  552561
  552563
  553868
  554979
  556080
  561265
  561798
  572686
  584966
  588843
  618243
  670059
  670375
  695465
  711027
  717943
  719555
  720826
  723141
  724834
  725635
  731490
  732608
  736384
  737300
  738857
  738896
  739720
  740246
  752483
  753710
  761707
  768228
  769702
  786092
  796792
  801062
  825712
]
1.81 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск большой большие член"
]
1.72 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade big dick"
]
1.48 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск большой большие член"
]
1.41 ms
(0.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.