Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.90 ms
(83.23%)
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
  96205
  187759
  188282
  188398
  358596
  382295
  388322
  388778
  389098
  391237
  391655
  391930
  392054
  393097
  393135
  397629
  397850
  402409
  403317
  407799
  408240
  413223
  415780
  423493
  426003
  440403
  440947
  443326
  443903
  445292
  445744
  449082
  452302
  457991
  460672
  460704
  463856
  465811
  465962
  466173
  466227
  466844
  467930
  468362
  468484
  469582
  470948
  474463
  477070
  478460
  482074
  483149
  490782
  492292
  493752
  506067
  506076
  511826
  518563
  520681
  521166
  522484
  526228
  536419
  536473
  539372
  555263
  555290
  555779
  558523
  560999
  561002
  561042
  562961
  573753
  577385
  579371
  582404
  592428
  598128
  605476
  610052
  610473
  616594
  620113
  634849
  648199
  692049
  714620
  718041
  727741
  731259
  731482
  736522
  740882
  742722
  745517
  753552
  756878
  757277
  757388
  759921
  759950
  761469
  761600
  766669
  777728
  777734
  795141
  795988
  797218
  799357
  802138
  802229
  805736
  807394
  817347
  821521
  822278
  822585
]
16.38 ms
(10.33%)
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
  797218
  756878
  415780
  577385
  445292
  468484
  493752
  466844
  469582
  465811
  573753
  452302
  506076
  188282
  610052
  187759
  397629
  188398
  391930
  477070
  616594
  740882
  440947
  467930
  407799
  506067
  560999
  799357
  757277
  520681
  402409
  474463
  605476
  807394
  759921
  727741
  718041
  463856
  802138
  759950
  761469
  490782
  443903
  466227
  470948
  620113
  731259
  753552
  457991
  389098
  466173
  413223
  536473
  445744
  483149
  460704
  403317
  440403
  391237
  465962
  478460
  382295
  408240
  392054
  443326
  393097
  555263
  582404
  393135
  539372
  822278
  822585
  817347
  821521
  555779
  692049
  555290
  592428
  610473
  795141
  731482
  736522
  468362
  482074
  518563
  521166
  449082
  745517
  742722
  492292
  558523
  391655
  397850
  96205
  511826
  522484
  579371
  648199
  766669
  388778
  805736
  423493
  460672
  802229
  777728
  757388
  426003
  388322
  536419
  561002
  714620
  634849
  795988
  761600
  777734
  561042
  358596
  598128
  526228
  562961
]
3.00 ms
(1.89%)
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
  96205
  187759
  188282
  188398
  358596
  382295
  388322
  388778
  389098
  391237
  391655
  391930
  392054
  393097
  393135
  397629
  397850
  402409
  403317
  407799
  408240
  413223
  415780
  423493
  426003
  440403
  440947
  443326
  443903
  445292
  445744
  449082
  452302
  457991
  460672
  460704
  463856
  465811
  465962
  466173
  466227
  466844
  467930
  468362
  468484
  469582
  470948
  474463
  477070
  478460
  482074
  483149
  490782
  492292
  493752
  506067
  506076
  511826
  518563
  520681
  521166
  522484
  526228
  536419
  536473
  539372
  555263
  555290
  555779
  558523
  560999
  561002
  561042
  562961
  573753
  577385
  579371
  582404
  592428
  598128
  605476
  610052
  610473
  616594
  620113
  634849
  648199
  692049
  714620
  718041
  727741
  731259
  731482
  736522
  740882
  742722
  745517
  753552
  756878
  757277
  757388
  759921
  759950
  761469
  761600
  766669
  777728
  777734
  795141
  795988
  797218
  799357
  802138
  802229
  805736
  807394
  817347
  821521
  822278
  822585
]
2.09 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелые мамки в сперме%…"
]
1.86 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин мам женщин сперм"
]
1.53 ms
(0.96%)
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.