Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.70 ms
(85.39%)
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
  384568
  387516
  396001
  398414
  399061
  427266
  448499
  452303
  458823
  477573
  477579
  477581
  482180
  484795
  494717
  505106
  522395
  526411
  538564
  541855
  542293
  542309
  542340
  542800
  542860
  543002
  543013
  543077
  543114
  543126
  543161
  543204
  543210
  543231
  543254
  543270
  543283
  543440
  547516
  550257
  550518
  552049
  552607
  554117
  562348
  566575
  567138
  574986
  575035
  577100
  577112
  578130
  580523
  584352
  586512
  586515
  586524
  590750
  591031
  601806
  604163
  619816
  622932
  626382
  628595
  628671
  630570
  630773
  634936
  638159
  638757
  641094
  644910
  647110
  648609
  650727
  660436
  660455
  660811
  660836
  660837
  663830
  667974
  671331
  671371
  680428
  685086
  717617
  720820
  726624
  732140
  733282
  734346
  740863
  742515
  744464
  746645
  750233
  750260
  750620
  752104
  759010
  769862
  769910
  770227
  771142
  789487
  789488
  797109
  797130
  804401
  809338
  811536
  812847
  812859
  813858
  813863
  825366
  825404
  827861
]
16.01 ms
(9.01%)
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
  538564
  398414
  399061
  827861
  550518
  660837
  685086
  630570
  797130
  726624
  742515
  626382
  641094
  671371
  752104
  811536
  638159
  622932
  543077
  750620
  542860
  522395
  477581
  543254
  552607
  574986
  578130
  562348
  566575
  586515
  484795
  384568
  825366
  813858
  542340
  543283
  660455
  717617
  554117
  734346
  797109
  804401
  744464
  809338
  789487
  644910
  452303
  494717
  543013
  601806
  541855
  543204
  547516
  543270
  733282
  542293
  387516
  825404
  448499
  526411
  577112
  543002
  543126
  667974
  720820
  660436
  660811
  628595
  638757
  812847
  759010
  789488
  812859
  543114
  584352
  671331
  590750
  482180
  477579
  746645
  543161
  647110
  750260
  732140
  769910
  396001
  505106
  577100
  619816
  543210
  542309
  542800
  628671
  630773
  771142
  770227
  750233
  427266
  813863
  580523
  543440
  586512
  604163
  575035
  680428
  586524
  550257
  650727
  591031
  634936
  740863
  769862
  477573
  458823
  543231
  567138
  552049
  648609
  660836
  663830
]
2.56 ms
(1.44%)
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
  384568
  387516
  396001
  398414
  399061
  427266
  448499
  452303
  458823
  477573
  477579
  477581
  482180
  484795
  494717
  505106
  522395
  526411
  538564
  541855
  542293
  542309
  542340
  542800
  542860
  543002
  543013
  543077
  543114
  543126
  543161
  543204
  543210
  543231
  543254
  543270
  543283
  543440
  547516
  550257
  550518
  552049
  552607
  554117
  562348
  566575
  567138
  574986
  575035
  577100
  577112
  578130
  580523
  584352
  586512
  586515
  586524
  590750
  591031
  601806
  604163
  619816
  622932
  626382
  628595
  628671
  630570
  630773
  634936
  638159
  638757
  641094
  644910
  647110
  648609
  650727
  660436
  660455
  660811
  660836
  660837
  663830
  667974
  671331
  671371
  680428
  685086
  717617
  720820
  726624
  732140
  733282
  734346
  740863
  742515
  744464
  746645
  750233
  750260
  750620
  752104
  759010
  769862
  769910
  770227
  771142
  789487
  789488
  797109
  797130
  804401
  809338
  811536
  812847
  812859
  813858
  813863
  825366
  825404
  827861
]
2.35 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass arab"
]
1.85 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп араб"
]
1.56 ms
(0.88%)
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.