Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.42 ms
(88.06%)
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
  398164
  398613
  400000
  402337
  404318
  412362
  421043
  429449
  437314
  452057
  455281
  456475
  458440
  462510
  463710
  469507
  475263
  477883
  479348
  487431
  489148
  493455
  494323
  498927
  510657
  510673
  513677
  514748
  517010
  517240
  517874
  519929
  519936
  520485
  521027
  530347
  532079
  534040
  534155
  540724
  541882
  541913
  542939
  543330
  543825
  544234
  547518
  549368
  549382
  551203
  557231
  557343
  559020
  560574
  561086
  563219
  563882
  565314
  565454
  566710
  568539
  569967
  570171
  570175
  570410
  570657
  571666
  572602
  573757
  574840
  576644
  578067
  580269
  581292
  582135
  584797
  586980
  590426
  603014
  639443
  644664
  651893
  651957
  652898
  652939
  652966
  677061
  684159
  688335
  688642
  698045
  698282
  700454
  704579
  715836
  717696
  721068
  722882
  723926
  728172
  741467
  756877
  766413
  767996
  769456
  773432
  775455
  776716
  780963
  784005
  789659
  789740
  791189
  800959
  802849
  808060
  815437
  816973
  818338
  824316
]
13.46 ms
(6.64%)
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
  570410
  541882
  544234
  570175
  580269
  651957
  652939
  652966
  688335
  721068
  651893
  677061
  700454
  722882
  652898
  717696
  563882
  568539
  570657
  571666
  572602
  574840
  590426
  603014
  780963
  789659
  775455
  802849
  723926
  756877
  766413
  789740
  728172
  741467
  767996
  773432
  769456
  639443
  644664
  698045
  698282
  704579
  776716
  784005
  791189
  800959
  402337
  456475
  398613
  479348
  458440
  462510
  540724
  494323
  510673
  487431
  493455
  455281
  520485
  532079
  469507
  684159
  688642
  715836
  561086
  578067
  581292
  586980
  808060
  437314
  475263
  412362
  452057
  421043
  514748
  519929
  513677
  517240
  517874
  517010
  519936
  521027
  569967
  429449
  404318
  398164
  400000
  815437
  816973
  818338
  824316
  463710
  477883
  489148
  498927
  510657
  530347
  534155
  534040
  541913
  543330
  543825
  547518
  549368
  549382
  551203
  557231
  557343
  559020
  560574
  563219
  565314
  565454
  566710
  570171
  573757
  576644
  582135
  584797
  542939
]
3.09 ms
(1.53%)
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
  398164
  398613
  400000
  402337
  404318
  412362
  421043
  429449
  437314
  452057
  455281
  456475
  458440
  462510
  463710
  469507
  475263
  477883
  479348
  487431
  489148
  493455
  494323
  498927
  510657
  510673
  513677
  514748
  517010
  517240
  517874
  519929
  519936
  520485
  521027
  530347
  532079
  534040
  534155
  540724
  541882
  541913
  542939
  543330
  543825
  544234
  547518
  549368
  549382
  551203
  557231
  557343
  559020
  560574
  561086
  563219
  563882
  565314
  565454
  566710
  568539
  569967
  570171
  570175
  570410
  570657
  571666
  572602
  573757
  574840
  576644
  578067
  580269
  581292
  582135
  584797
  586980
  590426
  603014
  639443
  644664
  651893
  651957
  652898
  652939
  652966
  677061
  684159
  688335
  688642
  698045
  698282
  700454
  704579
  715836
  717696
  721068
  722882
  723926
  728172
  741467
  756877
  766413
  767996
  769456
  773432
  775455
  776716
  780963
  784005
  789659
  789740
  791189
  800959
  802849
  808060
  815437
  816973
  818338
  824316
]
2.28 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.10 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sleeping beauty"
]
1.67 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "спящ beauty"
]
1.59 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спящ beauty"
]

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.