Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
234.79 ms
(90.15%)
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
  384390
  391951
  397104
  397396
  397457
  397523
  408532
  427358
  429960
  432803
  441420
  441425
  441430
  441495
  441503
  441511
  442121
  448636
  455897
  457380
  459635
  460773
  475472
  484318
  489271
  493573
  493775
  495364
  498872
  509163
  509600
  511357
  511481
  512506
  515003
  520790
  529082
  531557
  534801
  537504
  537974
  542348
  543648
  560643
  561703
  571421
  580210
  580423
  581064
  583151
  585296
  586589
  592399
  593372
  602580
  602862
  603824
  607928
  618021
  626842
  640390
  640792
  651097
  652353
  657160
  667033
  680266
  693369
  695892
  703457
  703713
  720284
  720828
  722222
  722583
  722640
  724052
  727575
  729082
  731224
  742861
  750494
  752613
  755846
  757394
  759961
  761496
  765493
  765514
  766677
  767046
  769883
  770295
  773387
  777742
  779010
  780361
  782441
  787506
  792938
  793896
  794368
  794772
  794823
  794847
  795300
  795461
  795687
  796153
  796165
  796180
  800404
  801737
  802053
  803722
  805502
  810186
  812069
  814457
  817171
]
15.91 ms
(6.11%)
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
  770295
  794847
  441425
  537974
  795300
  731224
  795461
  429960
  652353
  626842
  750494
  727575
  640390
  794772
  537504
  542348
  583151
  391951
  794368
  796153
  408532
  442121
  695892
  722583
  602580
  602862
  779010
  769883
  571421
  384390
  817171
  493775
  667033
  680266
  720284
  657160
  703457
  801737
  724052
  773387
  427358
  795687
  812069
  397457
  593372
  814457
  498872
  693369
  640792
  780361
  793896
  782441
  755846
  800404
  766677
  729082
  767046
  802053
  460773
  531557
  796180
  794823
  792938
  448636
  560643
  561703
  580423
  607928
  592399
  511357
  484318
  515003
  581064
  703713
  586589
  618021
  777742
  742861
  441420
  441503
  509163
  651097
  810186
  722222
  585296
  803722
  765514
  759961
  722640
  397523
  493573
  580210
  720828
  796165
  805502
  757394
  752613
  787506
  512506
  765493
  761496
  441430
  495364
  397104
  455897
  459635
  509600
  511481
  603824
  432803
  397396
  489271
  543648
  441495
  441511
  457380
  475472
  520790
  534801
  529082
]
3.47 ms
(1.33%)
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
  384390
  391951
  397104
  397396
  397457
  397523
  408532
  427358
  429960
  432803
  441420
  441425
  441430
  441495
  441503
  441511
  442121
  448636
  455897
  457380
  459635
  460773
  475472
  484318
  489271
  493573
  493775
  495364
  498872
  509163
  509600
  511357
  511481
  512506
  515003
  520790
  529082
  531557
  534801
  537504
  537974
  542348
  543648
  560643
  561703
  571421
  580210
  580423
  581064
  583151
  585296
  586589
  592399
  593372
  602580
  602862
  603824
  607928
  618021
  626842
  640390
  640792
  651097
  652353
  657160
  667033
  680266
  693369
  695892
  703457
  703713
  720284
  720828
  722222
  722583
  722640
  724052
  727575
  729082
  731224
  742861
  750494
  752613
  755846
  757394
  759961
  761496
  765493
  765514
  766677
  767046
  769883
  770295
  773387
  777742
  779010
  780361
  782441
  787506
  792938
  793896
  794368
  794772
  794823
  794847
  795300
  795461
  795687
  796153
  796165
  796180
  800404
  801737
  802053
  803722
  805502
  810186
  812069
  814457
  817171
]
1.78 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "крича вперв анал крича вперв"
]
1.70 ms
(0.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "крича вперв анал крича вперв"
]
1.34 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "painful anal crying"
]

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.