Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
195.99 ms
(88.47%)
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
  381876
  381902
  383098
  384063
  386384
  389044
  392989
  398444
  419896
  422475
  423961
  427143
  428567
  436827
  441962
  442957
  448412
  449194
  449332
  451028
  451881
  456395
  456426
  457593
  457806
  460251
  461969
  464208
  467787
  473128
  475206
  475653
  476992
  477848
  482053
  482588
  482603
  482608
  484451
  487621
  489847
  494541
  499752
  504118
  510841
  511383
  517129
  519546
  534462
  563625
  564235
  584100
  603994
  612465
  617377
  672891
  675167
  680583
  695707
  722198
  726156
  727459
  727549
  727556
  728176
  729230
  732224
  734351
  734359
  734415
  742927
  744166
  744169
  747822
  748469
  755596
  761247
  768646
  780379
  782765
  785700
  792204
  792325
  793247
  793321
  795013
  796308
  796473
  796875
  811749
  813171
  814295
  814399
  818564
  819143
  819745
  820051
  820750
  824601
  824905
  824956
  825200
  826169
  826229
  826318
  826384
  826410
  826491
  826693
  826695
  826726
  826881
  826956
  826976
  827083
  827087
  827300
  827374
  827401
  827576
]
14.82 ms
(6.69%)
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
  796875
  727459
  747822
  727549
  813171
  386384
  482053
  381876
  517129
  484451
  489847
  519546
  826693
  826726
  826976
  827401
  826881
  726156
  732224
  748469
  744169
  825200
  473128
  475653
  827083
  827300
  824956
  826169
  782765
  734351
  734359
  383098
  381902
  398444
  427143
  422475
  814295
  449194
  456395
  448412
  510841
  511383
  672891
  695707
  563625
  811749
  742927
  727556
  436827
  457593
  441962
  457806
  464208
  467787
  494541
  487621
  504118
  814399
  826229
  826491
  827087
  819745
  824601
  826384
  675167
  793247
  796473
  796308
  795013
  475206
  617377
  755596
  729230
  768646
  384063
  826318
  389044
  482608
  451881
  482588
  499752
  534462
  460251
  584100
  612465
  761247
  423961
  476992
  818564
  826695
  826410
  827374
  824905
  680583
  564235
  780379
  785700
  744166
  792325
  820051
  820750
  793321
  603994
  456426
  826956
  827576
  819143
  722198
  734415
  728176
  792204
  392989
  419896
  442957
  428567
  449332
  477848
  451028
  461969
  482603
]
2.41 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фейсситтинг жен"
]
2.35 ms
(1.06%)
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
  381876
  381902
  383098
  384063
  386384
  389044
  392989
  398444
  419896
  422475
  423961
  427143
  428567
  436827
  441962
  442957
  448412
  449194
  449332
  451028
  451881
  456395
  456426
  457593
  457806
  460251
  461969
  464208
  467787
  473128
  475206
  475653
  476992
  477848
  482053
  482588
  482603
  482608
  484451
  487621
  489847
  494541
  499752
  504118
  510841
  511383
  517129
  519546
  534462
  563625
  564235
  584100
  603994
  612465
  617377
  672891
  675167
  680583
  695707
  722198
  726156
  727459
  727549
  727556
  728176
  729230
  732224
  734351
  734359
  734415
  742927
  744166
  744169
  747822
  748469
  755596
  761247
  768646
  780379
  782765
  785700
  792204
  792325
  793247
  793321
  795013
  796308
  796473
  796875
  811749
  813171
  814295
  814399
  818564
  819143
  819745
  820051
  820750
  824601
  824905
  824956
  825200
  826169
  826229
  826318
  826384
  826410
  826491
  826693
  826695
  826726
  826881
  826956
  826976
  827083
  827087
  827300
  827374
  827401
  827576
]
2.23 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "facesitting wife"
]
1.88 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фейсситтинг жен"
]
1.86 ms
(0.84%)
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.