Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.36 ms
(56.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старый молодые домашн любительск"
]
137.66 ms
(37.29%)
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
  235834
  400609
  400723
  417461
  424023
  443370
  453624
  462500
  463771
  466187
  467767
  469844
  470734
  474842
  477409
  483258
  504764
  507772
  509077
  511889
  514787
  523680
  530578
  541250
  545538
  552534
  568440
  583210
  584666
  586789
  595654
  604425
  606258
  609712
  615112
  617603
  618528
  624508
  626330
  627171
  633665
  644708
  675424
  680682
  684096
  686082
  693341
  701508
  702320
  704722
  707881
  710001
  716124
  719124
  722080
  726703
  731432
  732775
  735524
  736866
  736980
  737910
  738257
  738623
  738970
  740084
  740489
  741114
  741998
  743009
  744711
  745386
  747954
  748392
  753548
  753677
  753993
  754967
  758723
  759634
  761592
  761862
  762559
  765763
  765907
  766687
  770444
  771874
  774927
  775284
  775630
  776138
  784925
  786715
  787950
  789870
  789877
  790101
  793436
  797165
  798171
  800275
  800305
  800377
  801305
  803144
  803244
  803261
  804959
  805727
  807333
  807663
  809707
  810533
  811866
  816764
  817482
  821870
  825694
  827328
]
16.16 ms
(4.38%)
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
  604425
  626330
  615112
  633665
  644708
  776138
  793436
  810533
  774927
  789877
  726703
  736980
  737910
  738257
  740084
  784925
  731432
  754967
  759634
  738623
  738970
  735524
  745386
  765763
  771874
  741114
  753993
  765907
  618528
  627171
  716124
  722080
  798171
  804959
  805727
  462500
  400723
  400609
  469844
  470734
  541250
  719124
  701508
  684096
  686082
  586789
  811866
  680682
  758723
  417461
  704722
  545538
  741998
  761592
  807333
  809707
  797165
  748392
  530578
  443370
  817482
  821870
  825694
  827328
  816764
  463771
  474842
  467767
  507772
  509077
  514787
  523680
  568440
  583210
  584666
  552534
  693341
  707881
  675424
  710001
  617603
  606258
  609712
  624508
  595654
  775630
  789870
  786715
  790101
  801305
  803144
  803261
  770444
  787950
  800305
  800377
  736866
  740489
  732775
  743009
  753548
  761862
  762559
  753677
  744711
  747954
  702320
  775284
  800275
  803244
  807663
  424023
  466187
  477409
  235834
  453624
  483258
  766687
  504764
  511889
]
2.48 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
  235834
  400609
  400723
  417461
  424023
  443370
  453624
  462500
  463771
  466187
  467767
  469844
  470734
  474842
  477409
  483258
  504764
  507772
  509077
  511889
  514787
  523680
  530578
  541250
  545538
  552534
  568440
  583210
  584666
  586789
  595654
  604425
  606258
  609712
  615112
  617603
  618528
  624508
  626330
  627171
  633665
  644708
  675424
  680682
  684096
  686082
  693341
  701508
  702320
  704722
  707881
  710001
  716124
  719124
  722080
  726703
  731432
  732775
  735524
  736866
  736980
  737910
  738257
  738623
  738970
  740084
  740489
  741114
  741998
  743009
  744711
  745386
  747954
  748392
  753548
  753677
  753993
  754967
  758723
  759634
  761592
  761862
  762559
  765763
  765907
  766687
  770444
  771874
  774927
  775284
  775630
  776138
  784925
  786715
  787950
  789870
  789877
  790101
  793436
  797165
  798171
  800275
  800305
  800377
  801305
  803144
  803244
  803261
  804959
  805727
  807333
  807663
  809707
  810533
  811866
  816764
  817482
  821870
  825694
  827328
]
2.23 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "стариками молодые дом…"
]
1.85 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "старый молодые домашн любительск"
]
1.46 ms
(0.40%)
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.