Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.33 ms
(79.90%)
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
  5852
  7108
  13282
  27757
  31028
  33711
  36844
  38028
  46409
  157318
  174791
  191082
  309480
  327981
  381874
  382072
  382650
  383031
  383412
  383540
  383582
  383926
  384519
  384551
  386728
  387447
  387766
  387925
  389967
  390320
  390669
  391006
  391322
  391448
  397466
  398000
  399647
  399688
  401379
  403999
  405538
  406045
  407277
  412789
  413495
  414005
  415094
  416129
  416165
  416963
  417967
  420249
  426553
  443403
  445935
  447882
  448043
  453305
  456924
  461734
  461735
  461741
  461754
  466912
  472279
  472874
  472877
  476058
  483577
  484792
  484803
  486318
  487500
  490579
  496039
  500310
  500665
  508423
  518964
  518980
  520732
  533591
  533941
  533962
  542296
  542620
  551052
  554088
  556130
  562821
  568213
  579319
  588562
  596977
  629117
  630030
  646022
  651075
  651097
  663994
  665293
  676805
  703157
  708822
  711005
  724553
  724561
  737320
  738778
  739029
  746315
  758169
  792805
  803313
  804667
  808792
  810244
  810267
  821518
]
23.17 ms
(14.10%)
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
  588562
  758169
  739029
  309480
  533962
  381874
  191082
  420249
  448043
  456924
  461741
  461754
  386728
  31028
  387925
  663879
  406045
  443403
  447882
  646022
  413495
  484792
  416165
  414005
  821518
  36844
  500310
  711005
  738778
  384519
  157318
  13282
  391322
  518964
  808792
  397466
  426553
  390320
  500665
  487500
  389967
  412789
  533941
  533591
  554088
  651075
  792805
  810244
  746315
  663994
  391006
  398000
  383031
  383412
  476058
  407277
  399688
  382650
  5852
  399647
  415094
  472877
  542296
  651097
  703157
  382072
  174791
  27757
  33711
  7108
  390669
  556130
  629117
  708822
  417967
  461734
  391448
  520732
  384551
  486318
  508423
  387447
  484803
  401379
  453305
  518980
  416963
  405538
  466912
  38028
  496039
  461735
  562821
  551052
  630030
  803313
  472279
  665293
  804667
  724553
  724561
  416129
  403999
  387766
  383926
  327981
  483577
  542620
  579319
  568213
  737320
  472874
  383582
  676805
  596977
  810267
  46409
  490579
  383540
  445935
]
2.63 ms
(1.60%)
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
  5852
  7108
  13282
  27757
  31028
  33711
  36844
  38028
  46409
  157318
  174791
  191082
  309480
  327981
  381874
  382072
  382650
  383031
  383412
  383540
  383582
  383926
  384519
  384551
  386728
  387447
  387766
  387925
  389967
  390320
  390669
  391006
  391322
  391448
  397466
  398000
  399647
  399688
  401379
  403999
  405538
  406045
  407277
  412789
  413495
  414005
  415094
  416129
  416165
  416963
  417967
  420249
  426553
  443403
  445935
  447882
  448043
  453305
  456924
  461734
  461735
  461741
  461754
  466912
  472279
  472874
  472877
  476058
  483577
  484792
  484803
  486318
  487500
  490579
  496039
  500310
  500665
  508423
  518964
  518980
  520732
  533591
  533941
  533962
  542296
  542620
  551052
  554088
  556130
  562821
  568213
  579319
  588562
  596977
  629117
  630030
  646022
  651075
  651097
  663994
  665293
  676805
  703157
  708822
  711005
  724553
  724561
  737320
  738778
  739029
  746315
  758169
  792805
  803313
  804667
  808792
  810244
  810267
  821518
]
1.99 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ebony big"
]
1.86 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чернокожая большие"
]
1.56 ms
(0.95%)
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.