Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.72 ms
(84.55%)
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
  389462
  389966
  411325
  418126
  422171
  424129
  424194
  424216
  429736
  429889
  429902
  434286
  434358
  434371
  440995
  444536
  446786
  448558
  452977
  464978
  465970
  467402
  467518
  467551
  468142
  468255
  470100
  470985
  471605
  472418
  473237
  475185
  477147
  479351
  481335
  481830
  481961
  482383
  484731
  491913
  492695
  495562
  498279
  499391
  503473
  507643
  508565
  510855
  510880
  511376
  511528
  511534
  511830
  511831
  515913
  515916
  519299
  520343
  521798
  523737
  523740
  523875
  526727
  527424
  532954
  540727
  541841
  544163
  544510
  546766
  548392
  555091
  555126
  555127
  555136
  555140
  560825
  564894
  565308
  566664
  570099
  572022
  591069
  591206
  592970
  596796
  599234
  601792
  618908
  620268
  649516
  694115
  705630
  714335
  714562
  718784
  725475
  731121
  740919
  741685
  741712
  742279
  742286
  742318
  742348
  742356
  742415
  742416
  746144
  757099
  758244
  761039
  761756
  767111
  777241
  777750
  782789
  785972
  800733
]
17.05 ms
(9.50%)
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
  767111
  741685
  757099
  705630
  800733
  572022
  515916
  532954
  389966
  467551
  470985
  482383
  566664
  560825
  555140
  570099
  620268
  591069
  467402
  467518
  471605
  515913
  523740
  503473
  510855
  523875
  511376
  472418
  424129
  429902
  465970
  473237
  491913
  742279
  411325
  477147
  468142
  555127
  565308
  601792
  429889
  464978
  513476
  527424
  546766
  422171
  470100
  481335
  544163
  718784
  591206
  592970
  596796
  777750
  777241
  782789
  742286
  725475
  742348
  742416
  746144
  758244
  742318
  742356
  731121
  740919
  742415
  714562
  468255
  424216
  479351
  434358
  481830
  481961
  492695
  508565
  521798
  498279
  507643
  511528
  511534
  555136
  555126
  761039
  510880
  523737
  520343
  526727
  389462
  475185
  429736
  424194
  434286
  446786
  418126
  434371
  519299
  499391
  484731
  541841
  444536
  452977
  511831
  448558
  495562
  511830
  440995
  540727
  544510
  564894
  548392
  555091
  714335
  649516
  694115
  599234
  618908
  785972
  761756
  741712
]
4.21 ms
(2.35%)
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
  389462
  389966
  411325
  418126
  422171
  424129
  424194
  424216
  429736
  429889
  429902
  434286
  434358
  434371
  440995
  444536
  446786
  448558
  452977
  464978
  465970
  467402
  467518
  467551
  468142
  468255
  470100
  470985
  471605
  472418
  473237
  475185
  477147
  479351
  481335
  481830
  481961
  482383
  484731
  491913
  492695
  495562
  498279
  499391
  503473
  507643
  508565
  510855
  510880
  511376
  511528
  511534
  511830
  511831
  515913
  515916
  519299
  520343
  521798
  523737
  523740
  523875
  526727
  527424
  532954
  540727
  541841
  544163
  544510
  546766
  548392
  555091
  555126
  555127
  555136
  555140
  560825
  564894
  565308
  566664
  570099
  572022
  591069
  591206
  592970
  596796
  599234
  601792
  618908
  620268
  649516
  694115
  705630
  714335
  714562
  718784
  725475
  731121
  740919
  741685
  741712
  742279
  742286
  742318
  742348
  742356
  742415
  742416
  746144
  757099
  758244
  761039
  761756
  767111
  777241
  777750
  782789
  785972
  800733
]
1.82 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian mature dildo"
]
1.58 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск mature дилд"
]
1.49 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск mature дилд"
]

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.