Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.15 ms
(84.21%)
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
  30841
  31028
  185456
  388709
  406128
  417171
  420520
  422418
  425141
  426218
  426889
  447976
  448652
  455021
  461208
  469720
  480268
  482662
  483465
  491136
  494866
  496444
  497836
  505618
  505706
  506711
  507133
  511349
  514852
  515025
  515823
  516044
  518629
  522291
  525209
  525744
  526193
  527122
  527735
  528493
  528679
  528893
  529189
  529906
  531718
  533824
  535855
  537780
  538990
  539360
  540403
  541422
  541910
  542058
  543577
  544339
  550911
  552716
  554701
  554717
  556616
  558448
  559509
  560316
  560896
  560927
  561438
  564621
  565443
  566184
  567055
  569466
  574072
  576800
  576917
  579426
  582822
  584310
  586170
  588242
  588973
  593561
  596243
  596766
  601177
  605658
  606989
  608058
  610132
  618276
  625326
  636413
  637241
  639637
  645297
  647147
  647813
  649470
  652494
  658469
  668703
  668780
  672356
  675171
  680604
  684398
  687814
  691178
  708901
  713167
  727634
  728839
  750706
  770486
  770755
  778480
  789802
  799085
  805075
  810916
]
12.95 ms
(8.72%)
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
  527735
  529906
  531718
  541910
  691178
  647147
  675171
  713167
  588242
  778480
  805075
  770755
  728839
  770486
  608058
  799085
  448652
  505706
  559509
  708901
  645297
  652494
  636413
  601177
  388709
  525209
  514852
  533824
  496444
  647813
  668780
  593561
  469720
  494866
  526193
  560316
  566184
  584310
  668703
  649470
  560927
  625326
  610132
  639637
  420520
  426889
  515823
  483465
  447976
  455021
  518629
  525744
  527122
  505618
  539360
  561438
  579426
  558448
  556616
  554717
  582822
  596766
  586170
  596243
  422418
  497836
  541422
  406128
  540403
  516044
  538990
  528679
  564621
  542058
  554701
  576800
  680604
  684398
  588973
  810916
  727634
  750706
  789802
  606989
  461208
  31028
  30841
  426218
  529189
  491136
  550911
  560896
  544339
  672356
  605658
  637241
  185456
  618276
  425141
  417171
  480268
  482662
  507133
  511349
  515025
  522291
  528893
  537780
  506711
  535855
  528493
  552716
  574072
  543577
  565443
  567055
  569466
  687814
  658469
  576917
]
2.71 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
  30841
  31028
  185456
  388709
  406128
  417171
  420520
  422418
  425141
  426218
  426889
  447976
  448652
  455021
  461208
  469720
  480268
  482662
  483465
  491136
  494866
  496444
  497836
  505618
  505706
  506711
  507133
  511349
  514852
  515025
  515823
  516044
  518629
  522291
  525209
  525744
  526193
  527122
  527735
  528493
  528679
  528893
  529189
  529906
  531718
  533824
  535855
  537780
  538990
  539360
  540403
  541422
  541910
  542058
  543577
  544339
  550911
  552716
  554701
  554717
  556616
  558448
  559509
  560316
  560896
  560927
  561438
  564621
  565443
  566184
  567055
  569466
  574072
  576800
  576917
  579426
  582822
  584310
  586170
  588242
  588973
  593561
  596243
  596766
  601177
  605658
  606989
  608058
  610132
  618276
  625326
  636413
  637241
  639637
  645297
  647147
  647813
  649470
  652494
  658469
  668703
  668780
  672356
  675171
  680604
  684398
  687814
  691178
  708901
  713167
  727634
  728839
  750706
  770486
  770755
  778480
  789802
  799085
  805075
  810916
]
2.12 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "виды вагин"
]
2.00 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вид вагин"
]
1.99 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.14%)
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.