Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.12 ms
(52.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
163.35 ms
(41.12%)
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
  418669
  419128
  419131
  421043
  421841
  421845
  421880
  421889
  421902
  421918
  422152
  422196
  423499
  423886
  423929
  424121
  425353
  426864
  430446
  432650
  433359
  433372
  433375
  436719
  439687
  439763
  441383
  442991
  447094
  447828
  448955
  454084
  455318
  457437
  457449
  457463
  457980
  461038
  461843
  461848
  464921
  466840
  467121
  472788
  473511
  474463
  478333
  481161
  483632
  483646
  484052
  486834
  493158
  498321
  515611
  516226
  517023
  517405
  526525
  527663
  538010
  538011
  544120
  549825
  549844
  559687
  561386
  564306
  565341
  566065
  569034
  569232
  569526
  569546
  569919
  572697
  579369
  582404
  591356
  603773
  604197
  604304
  611950
  625686
  635834
  637917
  639152
  666650
  668985
  718996
  730599
  736784
  740617
  756463
  757331
  766896
  772051
  779584
  784750
  784804
  786007
  786523
  787131
  787154
  787313
  790504
  796184
  797447
  797949
  798509
  801409
  801742
  809413
  812831
  815063
  815108
  816968
  820574
  821036
]
17.17 ms
(4.32%)
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
  544120
  566065
  559687
  637917
  604197
  604304
  448955
  421918
  424121
  421845
  461843
  538011
  538010
  779584
  442991
  436719
  432650
  457463
  484052
  467121
  582404
  591356
  757331
  756463
  635834
  718996
  472788
  474463
  426864
  478333
  498321
  740617
  572697
  787154
  815063
  815108
  473511
  486834
  447094
  457980
  569919
  797447
  801409
  784804
  766896
  423929
  422152
  421889
  422196
  465885
  433372
  515611
  516226
  461848
  421043
  517405
  603773
  798509
  668985
  820574
  816968
  821036
  786007
  796184
  812831
  787313
  772051
  639152
  790504
  517023
  569034
  549825
  569526
  730599
  439687
  454084
  421841
  457449
  457437
  526525
  493158
  666650
  625686
  423499
  527663
  549844
  561386
  564306
  569546
  786523
  611950
  423886
  418669
  421902
  466840
  419131
  439763
  455318
  483632
  483646
  801742
  736784
  433375
  461038
  481161
  579369
  569232
  565341
  797949
  809413
  784750
  787131
  425353
  441383
  447828
  421880
  433359
  419128
  430446
  464921
]
2.67 ms
(0.67%)
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
  418669
  419128
  419131
  421043
  421841
  421845
  421880
  421889
  421902
  421918
  422152
  422196
  423499
  423886
  423929
  424121
  425353
  426864
  430446
  432650
  433359
  433372
  433375
  436719
  439687
  439763
  441383
  442991
  447094
  447828
  448955
  454084
  455318
  457437
  457449
  457463
  457980
  461038
  461843
  461848
  464921
  466840
  467121
  472788
  473511
  474463
  478333
  481161
  483632
  483646
  484052
  486834
  493158
  498321
  515611
  516226
  517023
  517405
  526525
  527663
  538010
  538011
  544120
  549825
  549844
  559687
  561386
  564306
  565341
  566065
  569034
  569232
  569526
  569546
  569919
  572697
  579369
  582404
  591356
  603773
  604197
  604304
  611950
  625686
  635834
  637917
  639152
  666650
  668985
  718996
  730599
  736784
  740617
  756463
  757331
  766896
  772051
  779584
  784750
  784804
  786007
  786523
  787131
  787154
  787313
  790504
  796184
  797447
  797949
  798509
  801409
  801742
  809413
  812831
  815063
  815108
  816968
  820574
  821036
]
2.52 ms
(0.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов анал mom"
]
2.40 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov anal mom"
]
1.98 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов анал mom"
]

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.