Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.23 ms
(84.38%)
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
  249873
  392064
  392805
  396626
  406472
  419568
  420491
  421260
  422460
  429027
  429121
  429141
  429146
  429291
  429431
  434650
  436642
  436862
  438536
  446350
  447632
  451683
  453633
  457407
  459913
  461676
  463202
  463735
  466848
  466881
  466882
  467013
  468769
  469944
  476990
  478059
  479564
  483883
  492147
  492348
  499307
  501372
  502916
  512643
  528988
  539064
  552151
  552292
  552633
  552696
  553094
  555631
  558231
  558360
  559474
  560967
  561069
  561917
  563299
  564781
  565177
  565190
  565831
  566301
  569875
  570248
  570276
  570301
  570338
  570526
  570528
  570530
  570647
  570656
  571191
  571555
  571780
  571893
  572116
  572137
  572151
  572364
  573051
  573430
  573648
  573667
  573685
  573702
  573720
  573866
  574532
  575796
  576333
  577382
  579375
  580735
  588615
  596997
  597535
  602413
  602662
  603430
  603459
  614043
  617201
  633027
  652129
  702630
  712459
  745649
  749440
  756074
  762843
  763842
  781633
  790511
  808314
  810265
  811528
  814997
]
19.83 ms
(10.38%)
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
  756074
  745649
  749440
  762843
  763842
  702630
  712459
  781633
  811528
  434650
  451683
  249873
  419568
  392064
  406472
  512643
  528988
  392805
  396626
  420491
  421260
  429027
  429146
  429431
  436642
  438536
  429141
  422460
  429121
  436862
  429291
  814997
  461676
  469944
  478059
  492348
  447632
  466848
  466881
  467013
  468769
  476990
  479564
  446350
  453633
  457407
  459913
  463735
  466882
  483883
  492147
  501372
  539064
  502916
  499307
  463202
  553094
  564781
  565831
  569875
  570526
  572151
  573430
  573667
  573702
  573720
  573866
  575796
  552292
  559474
  565177
  570248
  570338
  570528
  570530
  570647
  570656
  576333
  577382
  579375
  552151
  552696
  558360
  561069
  561917
  563299
  565190
  570276
  570301
  571780
  571893
  572364
  652129
  552633
  555631
  558231
  560967
  566301
  571191
  571555
  572116
  572137
  573051
  573648
  573685
  574532
  580735
  602662
  588615
  602413
  603459
  617201
  633027
  596997
  597535
  603430
  614043
  808314
  810265
  790511
]
2.89 ms
(1.51%)
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
  249873
  392064
  392805
  396626
  406472
  419568
  420491
  421260
  422460
  429027
  429121
  429141
  429146
  429291
  429431
  434650
  436642
  436862
  438536
  446350
  447632
  451683
  453633
  457407
  459913
  461676
  463202
  463735
  466848
  466881
  466882
  467013
  468769
  469944
  476990
  478059
  479564
  483883
  492147
  492348
  499307
  501372
  502916
  512643
  528988
  539064
  552151
  552292
  552633
  552696
  553094
  555631
  558231
  558360
  559474
  560967
  561069
  561917
  563299
  564781
  565177
  565190
  565831
  566301
  569875
  570248
  570276
  570301
  570338
  570526
  570528
  570530
  570647
  570656
  571191
  571555
  571780
  571893
  572116
  572137
  572151
  572364
  573051
  573430
  573648
  573667
  573685
  573702
  573720
  573866
  574532
  575796
  576333
  577382
  579375
  580735
  588615
  596997
  597535
  602413
  602662
  603430
  603459
  614043
  617201
  633027
  652129
  702630
  712459
  745649
  749440
  756074
  762843
  763842
  781633
  790511
  808314
  810265
  811528
  814997
]
2.05 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 19 мастурбац лет"
]
1.99 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18-летние мастурбация"
]
1.61 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 19 мастурбац лет"
]

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.