Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.49 ms
(55.97%)
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
  187824
  365995
  383987
  384373
  391208
  404468
  404939
  408601
  423414
  423989
  425709
  439926
  447885
  451813
  452139
  455210
  457332
  466329
  468626
  470624
  484813
  486283
  486799
  491393
  492914
  497583
  504071
  504168
  507607
  508019
  516648
  519608
  522540
  526202
  532511
  535578
  536610
  541780
  541869
  544868
  545909
  547929
  550280
  554351
  556839
  559178
  561401
  562824
  564899
  565903
  566812
  567725
  568306
  575706
  576632
  579812
  586684
  588276
  592559
  599917
  602480
  603648
  604301
  606727
  609807
  617770
  622110
  623120
  629863
  636998
  640691
  651090
  651907
  652879
  653378
  653726
  661354
  682075
  682234
  682273
  683660
  685479
  686863
  690831
  694058
  697266
  699718
  706658
  707706
  718376
  726477
  726478
  726517
  726532
  726544
  726549
  726575
  733886
  733889
  737124
  744972
  746990
  748218
  751026
  770827
  775261
  775276
  775982
  780406
  781459
  785291
  786114
  786463
  787957
  788406
  793704
  796084
  796105
  796109
  806395
]
141.79 ms
(37.53%)
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
  187824
  365995
  383987
  384373
  391208
  404468
  404939
  408601
  423414
  423989
  425709
  439926
  447885
  451813
  452139
  455210
  457332
  466329
  468626
  470624
  484813
  486283
  486799
  491393
  492914
  497583
  504071
  504168
  507607
  508019
  516648
  519608
  522540
  526202
  532511
  535578
  536610
  541780
  541869
  544868
  545909
  547929
  550280
  554351
  556839
  559178
  561401
  562824
  564899
  565903
  566812
  567725
  568306
  575706
  576632
  579812
  586684
  588276
  592559
  599917
  602480
  603648
  604301
  606727
  609807
  617770
  622110
  623120
  629863
  636998
  640691
  651090
  651907
  652879
  653378
  653726
  661354
  682075
  682234
  682273
  683660
  685479
  686863
  690831
  694058
  697266
  699718
  706658
  707706
  718376
  726477
  726478
  726517
  726532
  726544
  726549
  726575
  733886
  733889
  737124
  744972
  746990
  748218
  751026
  770827
  775261
  775276
  775982
  780406
  781459
  785291
  786114
  786463
  787957
  788406
  793704
  796084
  796105
  796109
  806395
]
17.65 ms
(4.67%)
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
  544868
  504071
  545909
  556839
  786463
  391208
  457332
  694058
  599917
  588276
  423989
  522540
  561401
  707706
  793704
  737124
  726477
  470624
  535578
  567725
  575706
  651090
  606727
  383987
  486799
  622110
  423414
  806395
  559178
  439926
  384373
  686863
  746990
  516648
  187824
  466329
  550280
  652879
  661354
  697266
  706658
  718376
  699718
  733889
  751026
  770827
  775982
  365995
  497583
  486283
  404468
  653378
  586684
  603648
  785291
  775261
  425709
  682234
  536610
  507607
  579812
  683660
  566812
  602480
  775276
  744972
  564899
  568306
  541780
  451813
  504168
  532511
  682075
  682273
  562824
  617770
  592559
  796105
  796109
  726532
  781459
  748218
  623120
  629863
  519608
  547929
  609807
  491393
  690831
  651907
  640691
  408601
  604301
  786114
  780406
  508019
  404939
  636998
  733886
  452139
  447885
  484813
  468626
  455210
  492914
  526202
  565903
  541869
  554351
  685479
  787957
  788406
  726517
  726478
  726544
  726575
  726549
  796084
  576632
  653726
]
1.96 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс два"
]
1.90 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сосет член двоим"
]
1.58 ms
(0.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.38%)
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.