Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.76 ms
(52.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
163.01 ms
(41.07%)
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
  188462
  396711
  400851
  406018
  406688
  407759
  411430
  411718
  462328
  463156
  466190
  466319
  467427
  467488
  467537
  467541
  469283
  470148
  474485
  474824
  475884
  475919
  476272
  476346
  479031
  479034
  479044
  479048
  479061
  479091
  479129
  479136
  480921
  481929
  484426
  484443
  484560
  484725
  485755
  490195
  490406
  490917
  490918
  502001
  510889
  511541
  511594
  514688
  515917
  518846
  520864
  520920
  523847
  525847
  526711
  554508
  555075
  567344
  582335
  589662
  589752
  591064
  591877
  591910
  592914
  593842
  614514
  620226
  629412
  629847
  664831
  665199
  665315
  665487
  666361
  667833
  667847
  678975
  696311
  710445
  712215
  720121
  724233
  725135
  725197
  725334
  725537
  726544
  726549
  726838
  727970
  728170
  728445
  728449
  729819
  732373
  732805
  735460
  736399
  736408
  741452
  743803
  745397
  746636
  748130
  748206
  748228
  748232
  748234
  748238
  750785
  756233
  756683
  759704
  761436
  770127
  772459
  789526
  808649
  811491
]
18.01 ms
(4.54%)
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
  567344
  582335
  592914
  589662
  591910
  589752
  614514
  591877
  593842
  725135
  725197
  728445
  746636
  748130
  748206
  748234
  748238
  789526
  811491
  726838
  736399
  748228
  772459
  726544
  729819
  745397
  725537
  726549
  732373
  748232
  770127
  724233
  743803
  629847
  710445
  712215
  720121
  400851
  463156
  479034
  188462
  462328
  467541
  474824
  479136
  466319
  469283
  470148
  474485
  476346
  479129
  480921
  411430
  466190
  467427
  476272
  479044
  479048
  479061
  479091
  481929
  407759
  467488
  467537
  475884
  475919
  479031
  502001
  514688
  523847
  485755
  490406
  520920
  526711
  484560
  490918
  511594
  515917
  525847
  484426
  484443
  484725
  490195
  490917
  510889
  511541
  518846
  520864
  396711
  406688
  554508
  664831
  665199
  665315
  665487
  666361
  667847
  667833
  678975
  696311
  555075
  591064
  620226
  629412
  725334
  736408
  756233
  728449
  741452
  756683
  759704
  727970
  735460
  750785
  761436
  728170
  732805
  808649
  406018
  411718
]
2.80 ms
(0.70%)
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
  188462
  396711
  400851
  406018
  406688
  407759
  411430
  411718
  462328
  463156
  466190
  466319
  467427
  467488
  467537
  467541
  469283
  470148
  474485
  474824
  475884
  475919
  476272
  476346
  479031
  479034
  479044
  479048
  479061
  479091
  479129
  479136
  480921
  481929
  484426
  484443
  484560
  484725
  485755
  490195
  490406
  490917
  490918
  502001
  510889
  511541
  511594
  514688
  515917
  518846
  520864
  520920
  523847
  525847
  526711
  554508
  555075
  567344
  582335
  589662
  589752
  591064
  591877
  591910
  592914
  593842
  614514
  620226
  629412
  629847
  664831
  665199
  665315
  665487
  666361
  667833
  667847
  678975
  696311
  710445
  712215
  720121
  724233
  725135
  725197
  725334
  725537
  726544
  726549
  726838
  727970
  728170
  728445
  728449
  729819
  732373
  732805
  735460
  736399
  736408
  741452
  743803
  745397
  746636
  748130
  748206
  748228
  748232
  748234
  748238
  750785
  756233
  756683
  759704
  761436
  770127
  772459
  789526
  808649
  811491
]
2.07 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature cock"
]
1.77 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature cock"
]
1.51 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature cock"
]

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.