Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.67 ms
(84.35%)
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
  6806
  100685
  400915
  401209
  408460
  416694
  416820
  418068
  418578
  421366
  425820
  427311
  430374
  430584
  432268
  434376
  434654
  435078
  444544
  444956
  448522
  450579
  451248
  454009
  455079
  460804
  463793
  464188
  464951
  467877
  475649
  499789
  500299
  500332
  503292
  505328
  510898
  512073
  515440
  515994
  521831
  522094
  531201
  533944
  535279
  540269
  545430
  545469
  545605
  555297
  559178
  565501
  566320
  580207
  581236
  581995
  596929
  599990
  600021
  600200
  600252
  601578
  615915
  631593
  631947
  633435
  637001
  639751
  640771
  643516
  647344
  647948
  661455
  662129
  666894
  688581
  705239
  707391
  713163
  713176
  713877
  714067
  715283
  718678
  720029
  720190
  720717
  720756
  724039
  726878
  728152
  728930
  729312
  731813
  736959
  748965
  751610
  755188
  761180
  761530
  761674
  769792
  769865
  780540
  780636
  783962
  784713
  785510
  788954
  791365
  791489
  791623
  801655
  803633
  803676
  818852
  818867
  825818
  825864
]
15.87 ms
(9.19%)
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
  818852
  637001
  600200
  714067
  643516
  801655
  803633
  421366
  825864
  418578
  451248
  434376
  455079
  713176
  535279
  599990
  521831
  791489
  600021
  464951
  500332
  401209
  780540
  761530
  434654
  500299
  565501
  100685
  505328
  408460
  510898
  531201
  647344
  818867
  533944
  430584
  545430
  566320
  559178
  581995
  522094
  450579
  728930
  512073
  783962
  718678
  640771
  581236
  416820
  631947
  454009
  580207
  615915
  515994
  596929
  715283
  729312
  728152
  726878
  720029
  785510
  427311
  724039
  463793
  503292
  444544
  803676
  705239
  791365
  791623
  825818
  780636
  416694
  475649
  467877
  430374
  761674
  707391
  666894
  731813
  448522
  545605
  545469
  600252
  601578
  444956
  464188
  807580
  515440
  540269
  748965
  736959
  6806
  647948
  720756
  688581
  784713
  751610
  769865
  761180
  720190
  418068
  555297
  432268
  713163
  639751
  425820
  755188
  499789
  460804
  633435
  631593
  662129
  720717
  788954
  713877
  661455
  769792
  435078
  400915
]
4.11 ms
(2.38%)
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
  6806
  100685
  400915
  401209
  408460
  416694
  416820
  418068
  418578
  421366
  425820
  427311
  430374
  430584
  432268
  434376
  434654
  435078
  444544
  444956
  448522
  450579
  451248
  454009
  455079
  460804
  463793
  464188
  464951
  467877
  475649
  499789
  500299
  500332
  503292
  505328
  510898
  512073
  515440
  515994
  521831
  522094
  531201
  533944
  535279
  540269
  545430
  545469
  545605
  555297
  559178
  565501
  566320
  580207
  581236
  581995
  596929
  599990
  600021
  600200
  600252
  601578
  615915
  631593
  631947
  633435
  637001
  639751
  640771
  643516
  647344
  647948
  661455
  662129
  666894
  688581
  705239
  707391
  713163
  713176
  713877
  714067
  715283
  718678
  720029
  720190
  720717
  720756
  724039
  726878
  728152
  728930
  729312
  731813
  736959
  748965
  751610
  755188
  761180
  761530
  761674
  769792
  769865
  780540
  780636
  783962
  784713
  785510
  788954
  791365
  791489
  791623
  801655
  803633
  803676
  818852
  818867
  825818
  825864
]
2.01 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal fuck squirt"
]
1.81 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал секс сквирт оргазм"
]
1.50 ms
(0.87%)
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.