Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.46 ms
(80.49%)
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
  188066
  382519
  385491
  390794
  391027
  417854
  422403
  424468
  425749
  427536
  428265
  429439
  430430
  434040
  435020
  436693
  442021
  442952
  443818
  446729
  447628
  448985
  451815
  452628
  452782
  454053
  454398
  455776
  457311
  457660
  459685
  460722
  462475
  463225
  463726
  464443
  464556
  465030
  470299
  475948
  476332
  477968
  479473
  480576
  482680
  484485
  488549
  489301
  490394
  499749
  502048
  503089
  505968
  505987
  506012
  507176
  508819
  510467
  513334
  516207
  517369
  518062
  518388
  518865
  519935
  519969
  522230
  522830
  525144
  528099
  528235
  529446
  531067
  534190
  540647
  540657
  543907
  545319
  545916
  551162
  552326
  557922
  561281
  562938
  563196
  563906
  564855
  566001
  573757
  574655
  576348
  576644
  577177
  579867
  580651
  581748
  599727
  600737
  601355
  611264
  614443
  618813
  623392
  637399
  668949
  676209
  681443
  682259
  682296
  682300
  683008
  690693
  722705
  726523
  726561
  726598
  761118
  780805
  791425
  803719
]
21.78 ms
(13.24%)
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
  417854
  434040
  457311
  505968
  576348
  618813
  611264
  545319
  505987
  681443
  429439
  690693
  722705
  780805
  457660
  564855
  382519
  424468
  455776
  506012
  551162
  528099
  447628
  463726
  682300
  522830
  499749
  573757
  576644
  761118
  460722
  459685
  430430
  442952
  525144
  531067
  623392
  803719
  726598
  462475
  448985
  464556
  581748
  574655
  422403
  518865
  516207
  599727
  540657
  436693
  510467
  534190
  545916
  543907
  446729
  577177
  637399
  188066
  425749
  475948
  482680
  502048
  507176
  580651
  508819
  682259
  683008
  454398
  443818
  518062
  566001
  452782
  600737
  470299
  503089
  428265
  454053
  517369
  557922
  682296
  791425
  465030
  477968
  563196
  442021
  668949
  601355
  480576
  390794
  435020
  518388
  513334
  464443
  540647
  561281
  726523
  726561
  552326
  563906
  579867
  385491
  614443
  484485
  451815
  529446
  676209
  562938
  519935
  490394
  528235
  488549
  519969
  479473
  427536
  452628
  489301
  463225
  476332
  522230
  391027
]
2.61 ms
(1.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "спящую в рот ебут"
]
2.57 ms
(1.56%)
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
  188066
  382519
  385491
  390794
  391027
  417854
  422403
  424468
  425749
  427536
  428265
  429439
  430430
  434040
  435020
  436693
  442021
  442952
  443818
  446729
  447628
  448985
  451815
  452628
  452782
  454053
  454398
  455776
  457311
  457660
  459685
  460722
  462475
  463225
  463726
  464443
  464556
  465030
  470299
  475948
  476332
  477968
  479473
  480576
  482680
  484485
  488549
  489301
  490394
  499749
  502048
  503089
  505968
  505987
  506012
  507176
  508819
  510467
  513334
  516207
  517369
  518062
  518388
  518865
  519935
  519969
  522230
  522830
  525144
  528099
  528235
  529446
  531067
  534190
  540647
  540657
  543907
  545319
  545916
  551162
  552326
  557922
  561281
  562938
  563196
  563906
  564855
  566001
  573757
  574655
  576348
  576644
  577177
  579867
  580651
  581748
  599727
  600737
  601355
  611264
  614443
  618813
  623392
  637399
  668949
  676209
  681443
  682259
  682296
  682300
  683008
  690693
  722705
  726523
  726561
  726598
  761118
  780805
  791425
  803719
]
1.90 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.03%)
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.