Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.61 ms
(83.57%)
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
  100976
  145624
  153311
  213330
  383090
  383480
  383694
  386250
  386685
  387625
  387732
  388176
  388543
  388767
  389283
  391001
  408766
  411818
  412018
  413223
  415612
  416402
  426446
  429298
  433581
  437322
  439441
  440526
  448166
  451465
  456062
  456879
  460630
  480613
  483421
  489539
  492418
  508706
  527790
  529692
  529857
  531924
  537558
  544353
  547787
  548327
  554978
  556009
  557062
  557237
  558724
  564371
  584996
  612344
  613107
  618010
  632453
  632989
  698476
  705382
  714228
  715904
  720901
  724475
  726370
  729226
  732725
  733452
  738208
  738276
  738847
  741146
  741624
  744205
  746436
  753710
  755326
  756875
  759682
  759709
  760898
  768052
  768862
  771224
  772678
  785118
  789006
  793535
  796541
  796888
  803820
  804622
  808585
  810315
  815884
  817745
  817825
  818502
  819676
  819816
  820380
  823690
  823738
  824277
  824278
  824533
  824952
  825212
  826160
  826206
  826493
  828146
  828158
  828360
  828487
  828601
  828715
  828746
  828762
]
15.06 ms
(9.71%)
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
  738847
  759709
  771224
  741624
  755326
  759682
  760898
  768052
  726370
  732725
  733452
  738208
  738276
  741146
  744205
  746436
  753710
  768862
  772678
  612344
  618010
  632989
  698476
  705382
  715904
  720901
  785118
  796541
  796888
  803820
  810315
  412018
  413223
  388767
  213330
  100976
  544353
  387625
  391001
  411818
  386685
  426446
  439441
  456879
  448166
  529692
  460630
  547787
  804622
  808585
  724475
  756875
  729226
  408766
  433581
  437322
  388543
  440526
  451465
  456062
  508706
  527790
  564371
  714228
  632453
  613107
  793535
  824278
  825212
  824952
  537558
  556009
  823690
  828601
  389283
  824277
  824808
  828158
  828762
  828746
  828360
  828487
  828715
  789006
  386250
  383090
  383480
  383694
  153311
  145624
  387732
  388176
  415612
  416402
  429298
  826206
  584996
  826493
  819676
  819816
  823738
  826160
  817745
  820380
  824533
  815884
  817825
  818502
  828146
  480613
  489539
  529857
  531924
  483421
  492418
  548327
  554978
  557062
  557237
  558724
]
2.78 ms
(1.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные milf"
]
2.55 ms
(1.64%)
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
  100976
  145624
  153311
  213330
  383090
  383480
  383694
  386250
  386685
  387625
  387732
  388176
  388543
  388767
  389283
  391001
  408766
  411818
  412018
  413223
  415612
  416402
  426446
  429298
  433581
  437322
  439441
  440526
  448166
  451465
  456062
  456879
  460630
  480613
  483421
  489539
  492418
  508706
  527790
  529692
  529857
  531924
  537558
  544353
  547787
  548327
  554978
  556009
  557062
  557237
  558724
  564371
  584996
  612344
  613107
  618010
  632453
  632989
  698476
  705382
  714228
  715904
  720901
  724475
  726370
  729226
  732725
  733452
  738208
  738276
  738847
  741146
  741624
  744205
  746436
  753710
  755326
  756875
  759682
  759709
  760898
  768052
  768862
  771224
  772678
  785118
  789006
  793535
  796541
  796888
  803820
  804622
  808585
  810315
  815884
  817745
  817825
  818502
  819676
  819816
  820380
  823690
  823738
  824277
  824278
  824533
  824952
  825212
  826160
  826206
  826493
  828146
  828158
  828360
  828487
  828601
  828715
  828746
  828762
]
2.04 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "натуральная натуральные milf"
]
1.70 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural milf"
]
1.36 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.