Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.64 ms
(84.16%)
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
  326944
  386266
  396305
  438040
  443459
  455626
  459404
  460410
  465405
  489260
  499964
  499995
  506246
  508730
  509170
  518004
  519173
  521789
  523154
  534329
  544262
  555562
  556648
  560793
  567081
  578240
  579861
  582394
  605675
  610050
  618629
  631207
  639120
  699304
  712787
  714969
  718830
  721996
  722151
  724688
  724698
  726313
  726908
  728834
  729253
  730998
  733386
  734129
  734135
  734509
  735009
  735897
  739176
  741390
  742565
  746219
  749592
  751498
  756354
  761480
  768151
  768464
  772525
  777564
  778634
  785161
  785633
  787430
  788653
  791548
  793756
  793793
  794057
  794553
  794710
  794959
  795771
  796001
  796241
  796679
  797208
  800056
  800140
  800353
  800840
  801480
  803062
  803475
  803699
  806508
  808316
  816808
  817447
  821533
  822767
  823546
  823703
  823841
  823981
  824036
  824045
  824046
  824267
  824544
  824966
  825381
  825455
  826163
  826166
  826204
  826633
  827209
  827999
  828006
  828121
  828351
  828753
  828842
  828868
]
16.96 ms
(9.94%)
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
  800140
  800840
  739176
  749592
  772525
  794057
  795771
  800056
  724688
  768464
  726908
  735009
  824267
  826633
  821533
  817447
  828351
  544262
  788653
  796241
  523154
  824045
  826166
  826163
  825381
  827209
  824046
  824544
  826204
  825455
  828006
  828868
  828024
  521789
  555562
  556648
  699304
  718830
  714969
  785633
  793756
  793793
  794553
  803475
  803699
  806508
  734129
  734135
  742565
  746219
  791548
  794710
  796001
  796679
  797208
  808316
  730998
  741390
  726313
  733386
  735897
  728834
  729253
  756354
  768151
  721996
  722151
  777564
  787430
  801480
  443459
  455626
  534329
  489260
  582394
  567081
  578240
  560793
  579861
  712787
  605675
  785161
  734509
  724698
  751498
  631207
  778634
  396305
  459404
  438040
  465405
  460410
  499964
  499995
  508730
  519173
  506246
  518004
  386266
  326944
  816808
  823703
  822767
  824966
  823546
  823841
  823981
  824036
  827999
  828753
  828121
  828842
  509170
  618629
  639120
  610050
  803062
  761480
  794959
  800353
]
3.13 ms
(1.83%)
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
  326944
  386266
  396305
  438040
  443459
  455626
  459404
  460410
  465405
  489260
  499964
  499995
  506246
  508730
  509170
  518004
  519173
  521789
  523154
  534329
  544262
  555562
  556648
  560793
  567081
  578240
  579861
  582394
  605675
  610050
  618629
  631207
  639120
  699304
  712787
  714969
  718830
  721996
  722151
  724688
  724698
  726313
  726908
  728834
  729253
  730998
  733386
  734129
  734135
  734509
  735009
  735897
  739176
  741390
  742565
  746219
  749592
  751498
  756354
  761480
  768151
  768464
  772525
  777564
  778634
  785161
  785633
  787430
  788653
  791548
  793756
  793793
  794057
  794553
  794710
  794959
  795771
  796001
  796241
  796679
  797208
  800056
  800140
  800353
  800840
  801480
  803062
  803475
  803699
  806508
  808316
  816808
  817447
  821533
  822767
  823546
  823703
  823841
  823981
  824036
  824045
  824046
  824267
  824544
  824966
  825381
  825455
  826163
  826166
  826204
  826633
  827209
  827999
  828006
  828121
  828351
  828753
  828842
  828868
]
1.99 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum milf"
]
1.81 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum milf"
]
1.44 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum milf"
]

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.