Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.37 ms
(88.84%)
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
  24243
  33562
  149612
  386190
  387672
  443553
  443583
  460724
  484466
  495682
  510045
  516611
  535819
  536547
  540603
  547025
  551022
  557144
  558187
  564893
  566070
  567805
  599774
  602196
  607616
  619482
  622370
  624463
  625878
  626379
  629362
  647645
  653004
  663497
  663857
  664969
  666556
  673984
  681597
  684018
  684065
  695980
  697249
  705385
  707935
  707962
  710887
  714148
  715279
  716112
  716308
  717092
  719913
  719939
  721603
  729091
  731068
  732106
  734126
  734180
  738168
  738324
  738576
  746318
  761245
  763030
  766101
  767140
  770119
  771345
  771363
  775755
  776630
  779327
  781783
  781929
  783776
  786448
  789204
  794615
  794930
  795488
  796251
  796424
  796549
  797624
  799631
  807339
  808038
  808642
  809273
  809288
  810063
  814022
  814109
  814979
  815398
  816769
  817406
  817488
  817691
  817962
  818454
  818506
  818836
  819262
  819545
  819609
  820055
  820203
  820727
  821079
  821606
  823289
  823415
  823693
  824148
  825829
  826306
  827033
]
11.82 ms
(6.28%)
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
  729091
  705385
  734180
  386190
  716112
  149612
  821606
  814109
  820055
  818506
  664969
  599774
  721603
  796549
  809273
  810063
  495682
  818454
  684065
  719913
  763030
  738168
  767140
  717092
  776630
  734126
  771363
  775755
  816769
  817962
  823693
  815398
  460724
  551022
  622370
  624463
  808642
  808038
  789204
  770119
  732106
  761245
  714148
  796251
  809288
  24243
  629362
  567805
  516611
  558187
  766101
  794930
  818836
  817406
  817488
  817691
  823289
  719939
  779327
  795488
  796424
  799631
  771345
  781929
  783776
  794615
  814022
  387672
  825829
  820203
  819545
  731068
  797624
  540603
  443583
  710887
  666556
  626379
  738324
  547025
  443553
  819609
  663857
  33562
  484466
  557144
  707935
  602196
  625878
  807339
  786448
  746318
  738576
  510045
  681597
  619482
  781783
  819262
  826306
  814979
  823415
  827033
  824148
  820727
  821079
  536547
  535819
  564893
  566070
  695980
  697249
  715279
  647645
  653004
  684018
  716308
  663497
  673984
  707962
  607616
]
2.11 ms
(1.12%)
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
  24243
  33562
  149612
  386190
  387672
  443553
  443583
  460724
  484466
  495682
  510045
  516611
  535819
  536547
  540603
  547025
  551022
  557144
  558187
  564893
  566070
  567805
  599774
  602196
  607616
  619482
  622370
  624463
  625878
  626379
  629362
  647645
  653004
  663497
  663857
  664969
  666556
  673984
  681597
  684018
  684065
  695980
  697249
  705385
  707935
  707962
  710887
  714148
  715279
  716112
  716308
  717092
  719913
  719939
  721603
  729091
  731068
  732106
  734126
  734180
  738168
  738324
  738576
  746318
  761245
  763030
  766101
  767140
  770119
  771345
  771363
  775755
  776630
  779327
  781783
  781929
  783776
  786448
  789204
  794615
  794930
  795488
  796251
  796424
  796549
  797624
  799631
  807339
  808038
  808642
  809273
  809288
  810063
  814022
  814109
  814979
  815398
  816769
  817406
  817488
  817691
  817962
  818454
  818506
  818836
  819262
  819545
  819609
  820055
  820203
  820727
  821079
  821606
  823289
  823415
  823693
  824148
  825829
  826306
  827033
]
1.88 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "saggy tits blowjob"
]
1.77 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "saggy сиськ минет оральн секс"
]
1.75 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "saggy сиськ минет оральн секс"
]

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.