Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.04 ms
(85.38%)
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
  145336
  382934
  390928
  415869
  416161
  454140
  468601
  471004
  480494
  498454
  499568
  508353
  520813
  521485
  529922
  530710
  532879
  536111
  541915
  546243
  553220
  553221
  555748
  561776
  562553
  564486
  571120
  572722
  576869
  577033
  577952
  589572
  589652
  591869
  595524
  597905
  598347
  601555
  604807
  613943
  614484
  620880
  622680
  627671
  628563
  629432
  629545
  629723
  630036
  631880
  640306
  640878
  641043
  642953
  644216
  646277
  647030
  649008
  650232
  650607
  650895
  666058
  683046
  691362
  700033
  700947
  702318
  704063
  704701
  707394
  707481
  710360
  711975
  712146
  713453
  719451
  723242
  732936
  736028
  736339
  740169
  740450
  743254
  743994
  744003
  744208
  744751
  746191
  748289
  748519
  748650
  751340
  752938
  754938
  756562
  757267
  759155
  759811
  766285
  770704
  777790
  777840
  777855
  778768
  781424
  787268
  788125
  791854
  792796
  796433
  797035
  799044
  802320
  803404
  804482
  809679
  810802
  810964
  812234
  812235
]
11.03 ms
(7.72%)
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
  561776
  562553
  646277
  546243
  553220
  571120
  572722
  577033
  577952
  597905
  598347
  629545
  640878
  777855
  788125
  744751
  748289
  802320
  809679
  732936
  748519
  754938
  757267
  743254
  751340
  629432
  791854
  390928
  536111
  529922
  532879
  541915
  553221
  650232
  666058
  691362
  700947
  702318
  707481
  713453
  649008
  700033
  711975
  647030
  719451
  576869
  589572
  629723
  644216
  589652
  591869
  604807
  627671
  613943
  778768
  804482
  797035
  766285
  781424
  796433
  812235
  740450
  743994
  759811
  736028
  746191
  748650
  736339
  740169
  744003
  752938
  756562
  704701
  712146
  723242
  812234
  499568
  454140
  416161
  468601
  480494
  498454
  520813
  521485
  601555
  555748
  650607
  631880
  595524
  630036
  650895
  704063
  614484
  620880
  622680
  810964
  707394
  564486
  508353
  382934
  145336
  415869
  471004
  530710
  683046
  710360
  628563
  640306
  641043
  642953
  777790
  799044
  810802
  777840
  803404
  744208
  770704
  787268
  792796
  759155
]
2.90 ms
(2.03%)
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
  145336
  382934
  390928
  415869
  416161
  454140
  468601
  471004
  480494
  498454
  499568
  508353
  520813
  521485
  529922
  530710
  532879
  536111
  541915
  546243
  553220
  553221
  555748
  561776
  562553
  564486
  571120
  572722
  576869
  577033
  577952
  589572
  589652
  591869
  595524
  597905
  598347
  601555
  604807
  613943
  614484
  620880
  622680
  627671
  628563
  629432
  629545
  629723
  630036
  631880
  640306
  640878
  641043
  642953
  644216
  646277
  647030
  649008
  650232
  650607
  650895
  666058
  683046
  691362
  700033
  700947
  702318
  704063
  704701
  707394
  707481
  710360
  711975
  712146
  713453
  719451
  723242
  732936
  736028
  736339
  740169
  740450
  743254
  743994
  744003
  744208
  744751
  746191
  748289
  748519
  748650
  751340
  752938
  754938
  756562
  757267
  759155
  759811
  766285
  770704
  777790
  777840
  777855
  778768
  781424
  787268
  788125
  791854
  792796
  796433
  797035
  799044
  802320
  803404
  804482
  809679
  810802
  810964
  812234
  812235
]
1.95 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие вагин соло"
]
1.74 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big vagina solo"
]
1.65 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.