Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.32 ms
(32.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм mom"
]
211.95 ms
(32.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
209.88 ms
(31.99%)
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
  107495
  382918
  392750
  395988
  413106
  419777
  430264
  430833
  448374
  450654
  454220
  457471
  460976
  469366
  483189
  487030
  487895
  491829
  493201
  502488
  505891
  508522
  512475
  513118
  513119
  521200
  529899
  531412
  531414
  531521
  533192
  533256
  533261
  533983
  534018
  534304
  535076
  537549
  539497
  540370
  541626
  545342
  550010
  556042
  559726
  560319
  561121
  565484
  569539
  570857
  572605
  576657
  577358
  583655
  586554
  586866
  596286
  598864
  602563
  606633
  607102
  611730
  622690
  623656
  623945
  624195
  627726
  632008
  632650
  633333
  641938
  645813
  647984
  650450
  668512
  681052
  681074
  688666
  694532
  697169
  706250
  714225
  723077
  723643
  723735
  737473
  739863
  741893
  744184
  744494
  751515
  754081
  761805
  765846
  777537
  780086
  780659
  782193
  782220
  787896
  788130
  789699
  799161
  802126
  805318
  805459
  806239
  806383
  806742
  806861
  808257
  810447
  811746
  812305
  812934
  813455
  815838
  817023
  825830
  825831
]
15.02 ms
(2.29%)
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
  723077
  668512
  681074
  561121
  607102
  611730
  623656
  641938
  805318
  812934
  782193
  632650
  633333
  706250
  788130
  806383
  806861
  521200
  541626
  586554
  535076
  688666
  419777
  483189
  508522
  430833
  107495
  392750
  395988
  815838
  825830
  723643
  450654
  469366
  448374
  537549
  512475
  533192
  533261
  487895
  545342
  560319
  570857
  576657
  645813
  694532
  714225
  556042
  586866
  622690
  623945
  777537
  811746
  723735
  754081
  761805
  808257
  741893
  739863
  744494
  765846
  751515
  780659
  789699
  806239
  806742
  812305
  457471
  430264
  624195
  505891
  382918
  413106
  817023
  825831
  487030
  454220
  460976
  491829
  493201
  513118
  529899
  531414
  533256
  533983
  539497
  540370
  502488
  531521
  534304
  513119
  531412
  534018
  572605
  577358
  583655
  559726
  565484
  550010
  681052
  697169
  647984
  650450
  569539
  598864
  606633
  627726
  632008
  596286
  602563
  782220
  802126
  780086
  787896
  799161
  805459
  810447
  813455
  737473
  744184
]
2.79 ms
(0.42%)
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
  107495
  382918
  392750
  395988
  413106
  419777
  430264
  430833
  448374
  450654
  454220
  457471
  460976
  469366
  483189
  487030
  487895
  491829
  493201
  502488
  505891
  508522
  512475
  513118
  513119
  521200
  529899
  531412
  531414
  531521
  533192
  533256
  533261
  533983
  534018
  534304
  535076
  537549
  539497
  540370
  541626
  545342
  550010
  556042
  559726
  560319
  561121
  565484
  569539
  570857
  572605
  576657
  577358
  583655
  586554
  586866
  596286
  598864
  602563
  606633
  607102
  611730
  622690
  623656
  623945
  624195
  627726
  632008
  632650
  633333
  641938
  645813
  647984
  650450
  668512
  681052
  681074
  688666
  694532
  697169
  706250
  714225
  723077
  723643
  723735
  737473
  739863
  741893
  744184
  744494
  751515
  754081
  761805
  765846
  777537
  780086
  780659
  782193
  782220
  787896
  788130
  789699
  799161
  802126
  805318
  805459
  806239
  806383
  806742
  806861
  808257
  810447
  811746
  812305
  812934
  813455
  815838
  817023
  825830
  825831
]
2.10 ms
(0.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бдсм mom"
]
2.03 ms
(0.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bdsm mom"
]

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.