Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.51 ms
(83.15%)
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
  27900
  97480
  384112
  384578
  384974
  386467
  386649
  388425
  416134
  433463
  446329
  469068
  470325
  475097
  489539
  490162
  495138
  512031
  516005
  517483
  517671
  523365
  523621
  530749
  531917
  532295
  532845
  533143
  533152
  533816
  533884
  534014
  535739
  536539
  538539
  539456
  541360
  542980
  543529
  545923
  546135
  547048
  547944
  548399
  549938
  550578
  550583
  553413
  554844
  555007
  556549
  561571
  565128
  566670
  568005
  568209
  571733
  575285
  575933
  576613
  580862
  590306
  593232
  593820
  595841
  604864
  605073
  605591
  609349
  613791
  615990
  626226
  630248
  630585
  633696
  637524
  643081
  644710
  646041
  646166
  646336
  652818
  654180
  660975
  707361
  708166
  729424
  731262
  731915
  732693
  733477
  736002
  736188
  738220
  738223
  739690
  746784
  746984
  749419
  752191
  755054
  756148
  756344
  758168
  759041
  761455
  770989
  772581
  774736
  774748
  806972
  810618
  811308
  812527
  816859
  817121
  817123
  817635
  818594
  824832
]
15.02 ms
(9.95%)
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
  811308
  731262
  733477
  736002
  752191
  770989
  756344
  746984
  746784
  774748
  615990
  532295
  646166
  565128
  575933
  817123
  534014
  568005
  660975
  646041
  756148
  542980
  386649
  97480
  817635
  541360
  554844
  545923
  707361
  708166
  633696
  637524
  736188
  749419
  772581
  774736
  27900
  384112
  384974
  388425
  824832
  532845
  517671
  538539
  548399
  654180
  566670
  571733
  644710
  755054
  812527
  738220
  739690
  806972
  386467
  433463
  533152
  575285
  550583
  630248
  759041
  732693
  489539
  561571
  652818
  593820
  604864
  626226
  595841
  729424
  731915
  738223
  758168
  446329
  475097
  490162
  523621
  810618
  531917
  535739
  523365
  533143
  469068
  576613
  553413
  549938
  593232
  630585
  605073
  495138
  605591
  539456
  568209
  516005
  533884
  547944
  550578
  543529
  646336
  613791
  517483
  556549
  609349
  816859
  817121
  536539
  547048
  643081
  555007
  590306
  470325
  512031
  761455
  384578
  416134
  818594
  530749
  533816
  546135
  580862
]
2.75 ms
(1.82%)
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
  27900
  97480
  384112
  384578
  384974
  386467
  386649
  388425
  416134
  433463
  446329
  469068
  470325
  475097
  489539
  490162
  495138
  512031
  516005
  517483
  517671
  523365
  523621
  530749
  531917
  532295
  532845
  533143
  533152
  533816
  533884
  534014
  535739
  536539
  538539
  539456
  541360
  542980
  543529
  545923
  546135
  547048
  547944
  548399
  549938
  550578
  550583
  553413
  554844
  555007
  556549
  561571
  565128
  566670
  568005
  568209
  571733
  575285
  575933
  576613
  580862
  590306
  593232
  593820
  595841
  604864
  605073
  605591
  609349
  613791
  615990
  626226
  630248
  630585
  633696
  637524
  643081
  644710
  646041
  646166
  646336
  652818
  654180
  660975
  707361
  708166
  729424
  731262
  731915
  732693
  733477
  736002
  736188
  738220
  738223
  739690
  746784
  746984
  749419
  752191
  755054
  756148
  756344
  758168
  759041
  761455
  770989
  772581
  774736
  774748
  806972
  810618
  811308
  812527
  816859
  817121
  817123
  817635
  818594
  824832
]
2.07 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "эротика большие сиськи"
]
2.04 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "эротик большие сиськ"
]
1.63 ms
(1.08%)
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.