Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.68 ms
(58.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double teen анал"
]
125.95 ms
(34.72%)
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
  96231
  96269
  96524
  390437
  395646
  398317
  402546
  404800
  404804
  407290
  409615
  410934
  410940
  413376
  413398
  414048
  414259
  420559
  426390
  429805
  431805
  434443
  440698
  447470
  448100
  448560
  449404
  449450
  460889
  462742
  470541
  472431
  473387
  481145
  482194
  495397
  498963
  499111
  510394
  513696
  526162
  530497
  532916
  533003
  533743
  533949
  535466
  535747
  536785
  537206
  537776
  537887
  547242
  550198
  558124
  565245
  565249
  583699
  589071
  590741
  591804
  598057
  613516
  615459
  627409
  629243
  632593
  632658
  633807
  636293
  637432
  640777
  644310
  648836
  648862
  650794
  651620
  672999
  676097
  679770
  679775
  684048
  686658
  696950
  700282
  702164
  704256
  706652
  715790
  719001
  721846
  723560
  727833
  730329
  731198
  732053
  733106
  748950
  749990
  751435
  761231
  764295
  770396
  770405
  775744
  775893
  777012
  782556
  787500
  792583
  801931
  801942
  808116
  809439
  809928
  811425
  814888
  817328
  823721
  827523
]
17.76 ms
(4.90%)
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
  526162
  589071
  395646
  409615
  429805
  704256
  823721
  727833
  749990
  96524
  449450
  537887
  770396
  533949
  537206
  565249
  702164
  598057
  410940
  447470
  510394
  700282
  499111
  629243
  583699
  764295
  731198
  547242
  676097
  410934
  420559
  390437
  448560
  449404
  537776
  498963
  535466
  513696
  472431
  706652
  719001
  650794
  679770
  651620
  637432
  632658
  640777
  770405
  748950
  751435
  633807
  413376
  96231
  426390
  723560
  827523
  460889
  533003
  532916
  686658
  672999
  615459
  590741
  801931
  811425
  775744
  777012
  801942
  809439
  732053
  782556
  808116
  809928
  733106
  627409
  644310
  696950
  715790
  775893
  787500
  792583
  404804
  407290
  398317
  448100
  636293
  434443
  565245
  632593
  817328
  550198
  648836
  591804
  473387
  721846
  730329
  495397
  402546
  404800
  440698
  414048
  814888
  470541
  481145
  530497
  535747
  533743
  536785
  462742
  684048
  648862
  679775
  558124
  613516
  761231
  413398
  414259
  431805
  96269
  482194
]
2.79 ms
(0.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
  96231
  96269
  96524
  390437
  395646
  398317
  402546
  404800
  404804
  407290
  409615
  410934
  410940
  413376
  413398
  414048
  414259
  420559
  426390
  429805
  431805
  434443
  440698
  447470
  448100
  448560
  449404
  449450
  460889
  462742
  470541
  472431
  473387
  481145
  482194
  495397
  498963
  499111
  510394
  513696
  526162
  530497
  532916
  533003
  533743
  533949
  535466
  535747
  536785
  537206
  537776
  537887
  547242
  550198
  558124
  565245
  565249
  583699
  589071
  590741
  591804
  598057
  613516
  615459
  627409
  629243
  632593
  632658
  633807
  636293
  637432
  640777
  644310
  648836
  648862
  650794
  651620
  672999
  676097
  679770
  679775
  684048
  686658
  696950
  700282
  702164
  704256
  706652
  715790
  719001
  721846
  723560
  727833
  730329
  731198
  732053
  733106
  748950
  749990
  751435
  761231
  764295
  770396
  770405
  775744
  775893
  777012
  782556
  787500
  792583
  801931
  801942
  808116
  809439
  809928
  811425
  814888
  817328
  823721
  827523
]
2.12 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double teen anal"
]
1.89 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double teen анал"
]
1.60 ms
(0.44%)
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.