Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.61 ms
(88.03%)
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
  4048
  6745
  7169
  7456
  28568
  40051
  79520
  191412
  237986
  314021
  318795
  382385
  384497
  384780
  387977
  388374
  392772
  395523
  401802
  407018
  409936
  410807
  464803
  470592
  539402
  539501
  544684
  548269
  577079
  581285
  584177
  601647
  609831
  630403
  648210
  674744
  687211
  689929
  692049
  693295
  693535
  694147
  700661
  701125
  701281
  702620
  710928
  713657
  714908
  716615
  720637
  721892
  722191
  723261
  735443
  736522
  737598
  737968
  741898
  743362
  748353
  750743
  755396
  759577
  762800
  765562
  773342
  775462
  782976
  784069
  784213
  788193
  789671
  789727
  789751
  790002
  795046
  795141
  795299
  797356
  797789
  798935
  799010
  799147
  801044
  801778
  802514
  802698
  805135
  808122
  808209
  810045
  811474
  811853
  811989
  812098
  813575
  813663
  813819
  814583
  814588
  815455
  816991
  817357
  817455
  817523
  817724
  818222
  818414
  821238
  821521
  822045
  822585
  825862
  828194
  828509
]
9.16 ms
(5.62%)
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
  648210
  687211
  714908
  737598
  630403
  40051
  702620
  817724
  674744
  782976
  798935
  750743
  384497
  384780
  813575
  548269
  720637
  723261
  808209
  710928
  721892
  801778
  743362
  795299
  765562
  817523
  825862
  759577
  808122
  539402
  7169
  388374
  382385
  814588
  822795
  828194
  700661
  713657
  784213
  812098
  735443
  409936
  410807
  79520
  814583
  817455
  818414
  539501
  748353
  789751
  790002
  797789
  755396
  773342
  775462
  789671
  789727
  314021
  762800
  6745
  7456
  813819
  577079
  584177
  788193
  810045
  779805
  387977
  401802
  828717
  694147
  470592
  407018
  191412
  4048
  741898
  701125
  318795
  737968
  821238
  692049
  802514
  811474
  701281
  601647
  716615
  817357
  828509
  544684
  693295
  784069
  811853
  464803
  689929
  609831
  797356
  801044
  795046
  395523
  818222
  581285
  722191
  799147
  802698
  805135
  799010
  822585
  816991
  821521
  822045
  693535
  795141
  811989
  736522
  28568
  237986
  392772
  824705
  813663
  815455
]
3.13 ms
(1.92%)
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
  4048
  6745
  7169
  7456
  28568
  40051
  79520
  191412
  237986
  314021
  318795
  382385
  384497
  384780
  387977
  388374
  392772
  395523
  401802
  407018
  409936
  410807
  464803
  470592
  539402
  539501
  544684
  548269
  577079
  581285
  584177
  601647
  609831
  630403
  648210
  674744
  687211
  689929
  692049
  693295
  693535
  694147
  700661
  701125
  701281
  702620
  710928
  713657
  714908
  716615
  720637
  721892
  722191
  723261
  735443
  736522
  737598
  737968
  741898
  743362
  748353
  750743
  755396
  759577
  762800
  765562
  773342
  775462
  782976
  784069
  784213
  788193
  789671
  789727
  789751
  790002
  795046
  795141
  795299
  797356
  797789
  798935
  799010
  799147
  801044
  801778
  802514
  802698
  805135
  808122
  808209
  810045
  811474
  811853
  811989
  812098
  813575
  813663
  813819
  814583
  814588
  815455
  816991
  817357
  817455
  817523
  817724
  818222
  818414
  821238
  821521
  822045
  822585
  825862
  828194
  828509
]
2.17 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс мам женщин"
]
1.86 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс с мамашой"
]
1.74 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.90%)
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.