Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.36 ms
(87.44%)
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
  51911
  188561
  248347
  398073
  398543
  399079
  400480
  412779
  412830
  415753
  415988
  416568
  416715
  421838
  428305
  429879
  432939
  435512
  435671
  439071
  439135
  439274
  448012
  452814
  452829
  455902
  461612
  465497
  468255
  468269
  471664
  475319
  475947
  477417
  477435
  478998
  483738
  483762
  493271
  502462
  505328
  510544
  512072
  513663
  520908
  521145
  523355
  523751
  523896
  525466
  525603
  528315
  529661
  531588
  531638
  531767
  531838
  536377
  541392
  542710
  542762
  547502
  554215
  565721
  567678
  576527
  576932
  577520
  583355
  583798
  585450
  585827
  588387
  589519
  592330
  595145
  601789
  604803
  618808
  619612
  624302
  634068
  637503
  660382
  664181
  664236
  670357
  670366
  680815
  685506
  700471
  710405
  711480
  724961
  731511
  740908
  742279
  742358
  742455
  744050
  748309
  752613
  756786
  757492
  759793
  776484
  777005
  778230
  780247
  782351
  784744
  785851
  786859
  792726
  793053
  805046
  806938
  808725
  809351
  824868
]
13.05 ms
(7.30%)
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
  793053
  778230
  740908
  792726
  724961
  744050
  756786
  752613
  759793
  637503
  777005
  784744
  785851
  525466
  824868
  531588
  531638
  554215
  583798
  670357
  618808
  592330
  782351
  757492
  399079
  415753
  455902
  483738
  483762
  576932
  589519
  619612
  416568
  421838
  439274
  398543
  513663
  588387
  731511
  710405
  808725
  398073
  624302
  523355
  435671
  432939
  528315
  536377
  523896
  531838
  541392
  565721
  547502
  664236
  711480
  700471
  576527
  634068
  595145
  776484
  806938
  742358
  51911
  468255
  475947
  248347
  412779
  412830
  471664
  429879
  475319
  428305
  461612
  415988
  493271
  510544
  520908
  502462
  505328
  523751
  786859
  780247
  542762
  664181
  585827
  478998
  685506
  439135
  521145
  542710
  601789
  742279
  531767
  809351
  748309
  742455
  805046
  188561
  416715
  577520
  604803
  529661
  585450
  448012
  567678
  670366
  400480
  435512
  439071
  465497
  468269
  452814
  452829
  477417
  512072
  525603
  477435
  583355
  680815
  660382
]
2.85 ms
(1.59%)
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
  51911
  188561
  248347
  398073
  398543
  399079
  400480
  412779
  412830
  415753
  415988
  416568
  416715
  421838
  428305
  429879
  432939
  435512
  435671
  439071
  439135
  439274
  448012
  452814
  452829
  455902
  461612
  465497
  468255
  468269
  471664
  475319
  475947
  477417
  477435
  478998
  483738
  483762
  493271
  502462
  505328
  510544
  512072
  513663
  520908
  521145
  523355
  523751
  523896
  525466
  525603
  528315
  529661
  531588
  531638
  531767
  531838
  536377
  541392
  542710
  542762
  547502
  554215
  565721
  567678
  576527
  576932
  577520
  583355
  583798
  585450
  585827
  588387
  589519
  592330
  595145
  601789
  604803
  618808
  619612
  624302
  634068
  637503
  660382
  664181
  664236
  670357
  670366
  680815
  685506
  700471
  710405
  711480
  724961
  731511
  740908
  742279
  742358
  742455
  744050
  748309
  752613
  756786
  757492
  759793
  776484
  777005
  778230
  780247
  782351
  784744
  785851
  786859
  792726
  793053
  805046
  806938
  808725
  809351
  824868
]
1.96 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass solo anal"
]
1.54 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп соло анал"
]
1.54 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп соло анал"
]
1.52 ms
(0.85%)
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.