Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
413.69 ms
(57.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "toilet ass fuck"
]
282.43 ms
(39.36%)
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
  24255
  131602
  189380
  226412
  385671
  386532
  388118
  398523
  400507
  411335
  426395
  457205
  461362
  467847
  473484
  524187
  544826
  555217
  560070
  576540
  586618
  592080
  596191
  604208
  605923
  620607
  638871
  641627
  647530
  649937
  650634
  652878
  652881
  655295
  656660
  663303
  663960
  665289
  665489
  665880
  667682
  672844
  679399
  680279
  689566
  700815
  700818
  707088
  712236
  714958
  716707
  717076
  723887
  724009
  724086
  724320
  726289
  731590
  740289
  742814
  744094
  745954
  746059
  755608
  756673
  759522
  760690
  762167
  765313
  767081
  769580
  775720
  780614
  781907
  781967
  782696
  784300
  784810
  785479
  789363
  789414
  789814
  791886
  791932
  792123
  792440
  795364
  796656
  796730
  799075
  801345
  801576
  807318
  811014
  812267
  814772
  814804
  815363
  815497
  815844
  815989
  816185
  818308
  818971
  818993
  819423
  819505
  820228
  820733
  821023
  821593
  821718
  823451
  823599
  823773
  824171
  824215
  824319
  825196
  827202
]
13.52 ms
(1.88%)
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
  818308
  824319
  461362
  576540
  652878
  652881
  665289
  665880
  700815
  717076
  665489
  667682
  555217
  605923
  604208
  791932
  807318
  811014
  780614
  789814
  726289
  789363
  762167
  756673
  769580
  781967
  801345
  467847
  398523
  680279
  801576
  524187
  815363
  544826
  656660
  755608
  765313
  784810
  814804
  707088
  411335
  679399
  789414
  426395
  716707
  386532
  824215
  457205
  689566
  586618
  799075
  796656
  731590
  791886
  473484
  655295
  649937
  663303
  560070
  592080
  775720
  723887
  785479
  796730
  724086
  745954
  792123
  24255
  792440
  744094
  781907
  400507
  596191
  742814
  385671
  131602
  816185
  820733
  821593
  824171
  647530
  700818
  663960
  672844
  641627
  620607
  638871
  782696
  784300
  759522
  724009
  740289
  746059
  767081
  760690
  712236
  795364
  812267
  388118
  650634
  714958
  724320
  226412
  189380
  815844
  815989
  818971
  818993
  819423
  820228
  823599
  814772
  827202
  815497
  819505
  821718
  823773
  821023
  823451
  825196
]
2.52 ms
(0.35%)
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
  24255
  131602
  189380
  226412
  385671
  386532
  388118
  398523
  400507
  411335
  426395
  457205
  461362
  467847
  473484
  524187
  544826
  555217
  560070
  576540
  586618
  592080
  596191
  604208
  605923
  620607
  638871
  641627
  647530
  649937
  650634
  652878
  652881
  655295
  656660
  663303
  663960
  665289
  665489
  665880
  667682
  672844
  679399
  680279
  689566
  700815
  700818
  707088
  712236
  714958
  716707
  717076
  723887
  724009
  724086
  724320
  726289
  731590
  740289
  742814
  744094
  745954
  746059
  755608
  756673
  759522
  760690
  762167
  765313
  767081
  769580
  775720
  780614
  781907
  781967
  782696
  784300
  784810
  785479
  789363
  789414
  789814
  791886
  791932
  792123
  792440
  795364
  796656
  796730
  799075
  801345
  801576
  807318
  811014
  812267
  814772
  814804
  815363
  815497
  815844
  815989
  816185
  818308
  818971
  818993
  819423
  819505
  820228
  820733
  821023
  821593
  821718
  823451
  823599
  823773
  824171
  824215
  824319
  825196
  827202
]
2.02 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "туалет жоп секс"
]
1.76 ms
(0.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "туалет жоп секс"
]
1.62 ms
(0.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.