Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.40 ms
(88.12%)
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
  382946
  386959
  390840
  405431
  424177
  427219
  434672
  436149
  436174
  438979
  443059
  445028
  447762
  451678
  451694
  457537
  458322
  460932
  466486
  468864
  472010
  472805
  475234
  475608
  476037
  476754
  478852
  484248
  484311
  488793
  494494
  517098
  520036
  525435
  525703
  538331
  543749
  554963
  556504
  560761
  562744
  563160
  570413
  590491
  591204
  598985
  601058
  601410
  605027
  605828
  613190
  613248
  614542
  614587
  614631
  616136
  617596
  617614
  633120
  637589
  653265
  661928
  666449
  671563
  681526
  683089
  693245
  693302
  696902
  704068
  708130
  720434
  721042
  739113
  739401
  751939
  755015
  756275
  760410
  762238
  766188
  768989
  771959
  775567
  776807
  777567
  777684
  778028
  778676
  778745
  779362
  779435
  779863
  781045
  781275
  782321
  782514
  783469
  784596
  786107
  786350
  787308
  787460
  787824
  788391
  789235
  789926
  789936
  790938
  791173
  792427
  797516
  799015
  799260
  799528
  799772
  799872
  807348
  808574
  825580
]
15.53 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
  525435
  472805
  386959
  447762
  434672
  424177
  458322
  468864
  484311
  538331
  661928
  671563
  616136
  605027
  605828
  617596
  777567
  779435
  783469
  790938
  778745
  779362
  779863
  781045
  781275
  787308
  788391
  760410
  782321
  786350
  789926
  799260
  799528
  751939
  762238
  766188
  778028
  782514
  786107
  789235
  789936
  791173
  799015
  799872
  488793
  666449
  451694
  560761
  570413
  466486
  476754
  445028
  475608
  476037
  554963
  382946
  438979
  443059
  478852
  451678
  472010
  517098
  484248
  601410
  390840
  543749
  556504
  563160
  653265
  683089
  693245
  696902
  693302
  720434
  721042
  617614
  590491
  633120
  613190
  591204
  613248
  792427
  739113
  739401
  768989
  778676
  799772
  457537
  776807
  525703
  436174
  405431
  460932
  475234
  520036
  494494
  637589
  436149
  427219
  825580
  704068
  681526
  708130
  562744
  614542
  614587
  614631
  598985
  601058
  775567
  777684
  784596
  797516
  807348
  771959
  787460
  787824
  808574
  755015
  756275
]
4.34 ms
(1.87%)
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
  382946
  386959
  390840
  405431
  424177
  427219
  434672
  436149
  436174
  438979
  443059
  445028
  447762
  451678
  451694
  457537
  458322
  460932
  466486
  468864
  472010
  472805
  475234
  475608
  476037
  476754
  478852
  484248
  484311
  488793
  494494
  517098
  520036
  525435
  525703
  538331
  543749
  554963
  556504
  560761
  562744
  563160
  570413
  590491
  591204
  598985
  601058
  601410
  605027
  605828
  613190
  613248
  614542
  614587
  614631
  616136
  617596
  617614
  633120
  637589
  653265
  661928
  666449
  671563
  681526
  683089
  693245
  693302
  696902
  704068
  708130
  720434
  721042
  739113
  739401
  751939
  755015
  756275
  760410
  762238
  766188
  768989
  771959
  775567
  776807
  777567
  777684
  778028
  778676
  778745
  779362
  779435
  779863
  781045
  781275
  782321
  782514
  783469
  784596
  786107
  786350
  787308
  787460
  787824
  788391
  789235
  789926
  789936
  790938
  791173
  792427
  797516
  799015
  799260
  799528
  799772
  799872
  807348
  808574
  825580
]
2.23 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian big tits"
]
2.02 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск большие сиськ"
]
1.54 ms
(0.66%)
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.