Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.86 ms
(84.24%)
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
  34645
  81775
  146547
  389864
  389897
  395662
  397714
  399295
  399388
  399739
  399837
  401084
  401614
  401637
  402931
  403628
  405564
  409804
  411494
  412207
  413257
  413294
  413485
  416437
  419598
  420044
  420047
  420094
  422429
  425249
  426463
  431205
  432189
  433996
  434024
  437556
  440617
  445020
  450216
  454660
  457378
  457509
  460211
  461625
  462056
  463667
  464939
  465081
  466661
  469202
  472349
  472727
  473959
  474500
  488793
  489308
  491706
  504743
  505031
  505186
  506359
  511759
  513311
  513788
  514383
  515790
  516919
  518021
  518942
  523434
  525739
  526217
  533138
  533467
  535570
  537045
  546572
  569582
  579246
  579247
  586803
  593227
  598115
  598235
  620324
  620566
  628720
  630581
  638550
  652231
  654572
  661329
  670748
  673017
  676342
  679396
  690429
  693236
  695851
  698575
  702268
  713430
  722853
  723629
  736979
  738877
  741338
  744725
  752161
  752943
  756671
  758691
  765055
  781630
  788908
  789926
  790669
  806961
  810048
  811626
]
16.51 ms
(9.67%)
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
  445020
  472727
  533467
  676342
  679396
  546572
  620566
  586803
  402931
  403628
  395662
  469202
  397714
  426463
  461625
  413294
  440617
  454660
  489308
  505186
  513788
  504743
  518942
  399739
  465081
  420047
  525739
  412207
  628720
  389897
  401637
  432189
  433996
  670748
  695851
  593227
  810048
  756671
  457509
  466661
  472349
  462056
  425249
  515790
  523434
  652231
  654572
  661329
  690429
  579247
  620324
  781630
  790669
  741338
  744725
  738877
  34645
  399837
  420044
  535570
  537045
  693236
  698575
  713430
  811626
  789926
  702268
  722853
  409804
  81775
  146547
  474500
  401084
  413257
  450216
  405564
  488793
  473959
  413485
  457378
  464939
  411494
  422429
  463667
  460211
  506359
  526217
  399388
  420094
  516919
  518021
  533138
  491706
  514383
  505031
  511759
  673017
  752943
  399295
  416437
  434024
  723629
  513311
  569582
  579246
  630581
  598115
  598235
  638550
  806961
  758691
  765055
  752161
  736979
  788908
  401614
  419598
  431205
  437556
  389864
]
2.69 ms
(1.58%)
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
  34645
  81775
  146547
  389864
  389897
  395662
  397714
  399295
  399388
  399739
  399837
  401084
  401614
  401637
  402931
  403628
  405564
  409804
  411494
  412207
  413257
  413294
  413485
  416437
  419598
  420044
  420047
  420094
  422429
  425249
  426463
  431205
  432189
  433996
  434024
  437556
  440617
  445020
  450216
  454660
  457378
  457509
  460211
  461625
  462056
  463667
  464939
  465081
  466661
  469202
  472349
  472727
  473959
  474500
  488793
  489308
  491706
  504743
  505031
  505186
  506359
  511759
  513311
  513788
  514383
  515790
  516919
  518021
  518942
  523434
  525739
  526217
  533138
  533467
  535570
  537045
  546572
  569582
  579246
  579247
  586803
  593227
  598115
  598235
  620324
  620566
  628720
  630581
  638550
  652231
  654572
  661329
  670748
  673017
  676342
  679396
  690429
  693236
  695851
  698575
  702268
  713430
  722853
  723629
  736979
  738877
  741338
  744725
  752161
  752943
  756671
  758691
  765055
  781630
  788908
  789926
  790669
  806961
  810048
  811626
]
2.21 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful big"
]
1.97 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая большие"
]
1.87 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.97%)
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.