Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
219.15 ms
(89.94%)
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
  109313
  184985
  203528
  357886
  390386
  399568
  404395
  407809
  415541
  424232
  427219
  429069
  429276
  429479
  442550
  444331
  446232
  446566
  450336
  451780
  452302
  454378
  457898
  458331
  459261
  463368
  466698
  467668
  468009
  471956
  474336
  474597
  475378
  475394
  476112
  476234
  476480
  476527
  478510
  489318
  492101
  493156
  500669
  506813
  510253
  516059
  518201
  519878
  520929
  522387
  522426
  522499
  523560
  524574
  525615
  526192
  531656
  533061
  537970
  549230
  551368
  556707
  557302
  557426
  560791
  561712
  565866
  565931
  571813
  571838
  579215
  579842
  580631
  581714
  583069
  585799
  585945
  587212
  591259
  591667
  596518
  602651
  610931
  613845
  614142
  617828
  619396
  620234
  621647
  623874
  628199
  644192
  649516
  699583
  714552
  720719
  729618
  742848
  745053
  749398
  751575
  757406
  760507
  775733
  775976
  778614
  779346
  784932
  787131
  795304
  795398
  797264
  800662
  801610
  802278
  802724
  810616
  814736
  816975
  826130
]
14.42 ms
(5.92%)
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
  585799
  587212
  596518
  602651
  614142
  644192
  591667
  802724
  775733
  779346
  800662
  802278
  745053
  757406
  749398
  760507
  620234
  795304
  797264
  109313
  457898
  427219
  442550
  203528
  390386
  415541
  429276
  444331
  826130
  459261
  525615
  526192
  476234
  549230
  556707
  557426
  571838
  551368
  699583
  720719
  649516
  561712
  571813
  579215
  579842
  613845
  778614
  795398
  751575
  742848
  617828
  714552
  357886
  466698
  474597
  467668
  474336
  424232
  492101
  493156
  522499
  489318
  506813
  520929
  184985
  429479
  407809
  814736
  816975
  581714
  471956
  476112
  446232
  454378
  476527
  478510
  533061
  523560
  583069
  565866
  560791
  580631
  628199
  623874
  591259
  610931
  810616
  729618
  775976
  404395
  458331
  476480
  399568
  518201
  510253
  519878
  450336
  451780
  463368
  475394
  522426
  516059
  537970
  522387
  531656
  468009
  557302
  565931
  621647
  585945
  619396
  784932
  787131
  801610
  446566
  452302
  429069
  475378
  524574
  500669
]
3.09 ms
(1.27%)
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
  109313
  184985
  203528
  357886
  390386
  399568
  404395
  407809
  415541
  424232
  427219
  429069
  429276
  429479
  442550
  444331
  446232
  446566
  450336
  451780
  452302
  454378
  457898
  458331
  459261
  463368
  466698
  467668
  468009
  471956
  474336
  474597
  475378
  475394
  476112
  476234
  476480
  476527
  478510
  489318
  492101
  493156
  500669
  506813
  510253
  516059
  518201
  519878
  520929
  522387
  522426
  522499
  523560
  524574
  525615
  526192
  531656
  533061
  537970
  549230
  551368
  556707
  557302
  557426
  560791
  561712
  565866
  565931
  571813
  571838
  579215
  579842
  580631
  581714
  583069
  585799
  585945
  587212
  591259
  591667
  596518
  602651
  610931
  613845
  614142
  617828
  619396
  620234
  621647
  623874
  628199
  644192
  649516
  699583
  714552
  720719
  729618
  742848
  745053
  749398
  751575
  757406
  760507
  775733
  775976
  778614
  779346
  784932
  787131
  795304
  795398
  797264
  800662
  801610
  802278
  802724
  810616
  814736
  816975
  826130
]
1.93 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "horny hard"
]
1.76 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "horny hard"
]
1.67 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "horny hard"
]

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.