Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.44 ms
(83.14%)
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
  61726
  96393
  154133
  159305
  187789
  188266
  188507
  188669
  381830
  386189
  387856
  388132
  388363
  388719
  388722
  388732
  388757
  388785
  390447
  390567
  391156
  391576
  396711
  405859
  406062
  411745
  411809
  411820
  411967
  413460
  420914
  424248
  426503
  447808
  450117
  453471
  460040
  460186
  466801
  466973
  466986
  468075
  469575
  471995
  474104
  474629
  476239
  476262
  476343
  476344
  479765
  479769
  485755
  487347
  487352
  487360
  487937
  488377
  496547
  506066
  515693
  516107
  516140
  523563
  525479
  540509
  546933
  547029
  559344
  563164
  566814
  582799
  604514
  618052
  624472
  630828
  644881
  662898
  678767
  678805
  681643
  698733
  710505
  713193
  720289
  724252
  725177
  726965
  728385
  728445
  729286
  730315
  733265
  735442
  738296
  738305
  740647
  744987
  744990
  748253
  748256
  766660
  770115
  770149
  770187
  776339
  780724
  781447
  794641
  799358
  803019
  811013
  814621
  817963
  823944
  824936
  824938
  825038
  827278
  827973
]
13.95 ms
(10.13%)
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
  799358
  61726
  388757
  559344
  794641
  188266
  450117
  604514
  506066
  390567
  776339
  728445
  391576
  485755
  466986
  411809
  624472
  730315
  496547
  187789
  738305
  825038
  630828
  396711
  770187
  644881
  827278
  381830
  827973
  540509
  713193
  386189
  388719
  388722
  479765
  733265
  479769
  388732
  460040
  406062
  466801
  811013
  728385
  387856
  388785
  780724
  516107
  725177
  738296
  487352
  681643
  388132
  469575
  678767
  474104
  188507
  420914
  411967
  424248
  487347
  582799
  740647
  770149
  426503
  471995
  516140
  476343
  388363
  814621
  817963
  824936
  662898
  698733
  735442
  413460
  391156
  824938
  678805
  154133
  411820
  487937
  488377
  523563
  618052
  744987
  710505
  803019
  744990
  726965
  729286
  487360
  525479
  188669
  405859
  411745
  476262
  724252
  748256
  453471
  159305
  547029
  770115
  823944
  566814
  460186
  476239
  474629
  447808
  563164
  781447
  96393
  390447
  466973
  546933
  720289
  748253
  476344
  468075
  766660
  515693
]
2.44 ms
(1.77%)
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
  61726
  96393
  154133
  159305
  187789
  188266
  188507
  188669
  381830
  386189
  387856
  388132
  388363
  388719
  388722
  388732
  388757
  388785
  390447
  390567
  391156
  391576
  396711
  405859
  406062
  411745
  411809
  411820
  411967
  413460
  420914
  424248
  426503
  447808
  450117
  453471
  460040
  460186
  466801
  466973
  466986
  468075
  469575
  471995
  474104
  474629
  476239
  476262
  476343
  476344
  479765
  479769
  485755
  487347
  487352
  487360
  487937
  488377
  496547
  506066
  515693
  516107
  516140
  523563
  525479
  540509
  546933
  547029
  559344
  563164
  566814
  582799
  604514
  618052
  624472
  630828
  644881
  662898
  678767
  678805
  681643
  698733
  710505
  713193
  720289
  724252
  725177
  726965
  728385
  728445
  729286
  730315
  733265
  735442
  738296
  738305
  740647
  744987
  744990
  748253
  748256
  766660
  770115
  770149
  770187
  776339
  780724
  781447
  794641
  799358
  803019
  811013
  814621
  817963
  823944
  824936
  824938
  825038
  827278
  827973
]
1.86 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal mature granny"
]
1.63 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал mature granny"
]
1.58 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал mature granny"
]

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.