Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.90 ms
(83.27%)
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
  7196
  95837
  96231
  96269
  387544
  387550
  388803
  395702
  398317
  400940
  402546
  404800
  404804
  404952
  407290
  407357
  410930
  413398
  414048
  414259
  420216
  424362
  426390
  431805
  440698
  447144
  448552
  451565
  452608
  460889
  462742
  467558
  470541
  473387
  473782
  475806
  478548
  481145
  481149
  482194
  488805
  497590
  498520
  503673
  509805
  509875
  510392
  522133
  530249
  530497
  530623
  532916
  532981
  533003
  533016
  533371
  533743
  535582
  535597
  535747
  536215
  536292
  536546
  536616
  536686
  536785
  537201
  537909
  537931
  537986
  545407
  558124
  565250
  590741
  591804
  597237
  613516
  615459
  617408
  627409
  632687
  634158
  641986
  644310
  647928
  648862
  651144
  653447
  672999
  677671
  677986
  679775
  686658
  687262
  696950
  715670
  715790
  721445
  723560
  732053
  733106
  733888
  742135
  761231
  775744
  775893
  777012
  782556
  787500
  788268
  792583
  796736
  801931
  801942
  808116
  809439
  809928
  811425
  814888
  827523
]
20.43 ms
(11.05%)
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
  591804
  473387
  96231
  426390
  723560
  827523
  460889
  533003
  532916
  686658
  672999
  721445
  615459
  590741
  801931
  811425
  775744
  777012
  801942
  809439
  732053
  742135
  782556
  808116
  809928
  733106
  627409
  644310
  696950
  715790
  775893
  787500
  792583
  404804
  407290
  475806
  398317
  448552
  95837
  402546
  404800
  440698
  414048
  814888
  470541
  481145
  530497
  535747
  533016
  533743
  536785
  462742
  648862
  679775
  558124
  613516
  761231
  413398
  414259
  431805
  96269
  482194
  395702
  451565
  478548
  497590
  481149
  536686
  796736
  387550
  404952
  447144
  473782
  535582
  536546
  537931
  537201
  537909
  537986
  509875
  530623
  532981
  536292
  545407
  651144
  677671
  715670
  647928
  687262
  597237
  617408
  733888
  632687
  788268
  410930
  420216
  424362
  467558
  7196
  407357
  488805
  498520
  510392
  530249
  522133
  509805
  634158
  503673
  452608
  533371
  536215
  535597
  536616
  565250
  653447
  677986
  641986
  400940
  388803
  387544
]
2.72 ms
(1.47%)
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
  7196
  95837
  96231
  96269
  387544
  387550
  388803
  395702
  398317
  400940
  402546
  404800
  404804
  404952
  407290
  407357
  410930
  413398
  414048
  414259
  420216
  424362
  426390
  431805
  440698
  447144
  448552
  451565
  452608
  460889
  462742
  467558
  470541
  473387
  473782
  475806
  478548
  481145
  481149
  482194
  488805
  497590
  498520
  503673
  509805
  509875
  510392
  522133
  530249
  530497
  530623
  532916
  532981
  533003
  533016
  533371
  533743
  535582
  535597
  535747
  536215
  536292
  536546
  536616
  536686
  536785
  537201
  537909
  537931
  537986
  545407
  558124
  565250
  590741
  591804
  597237
  613516
  615459
  617408
  627409
  632687
  634158
  641986
  644310
  647928
  648862
  651144
  653447
  672999
  677671
  677986
  679775
  686658
  687262
  696950
  715670
  715790
  721445
  723560
  732053
  733106
  733888
  742135
  761231
  775744
  775893
  777012
  782556
  787500
  788268
  792583
  796736
  801931
  801942
  808116
  809439
  809928
  811425
  814888
  827523
]
2.28 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double anal teens"
]
1.92 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double анал teens"
]
1.86 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double анал teens"
]
1.72 ms
(0.93%)
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.