Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.34 ms
(86.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
  6684
  149261
  150405
  185011
  185208
  185412
  185464
  185595
  185708
  322773
  357753
  357806
  357824
  357839
  357886
  381769
  381984
  382650
  383474
  385538
  386071
  389167
  390224
  390241
  391036
  393848
  400435
  404032
  413195
  419126
  420341
  447842
  450763
  464616
  481087
  489606
  501718
  508745
  509955
  510049
  551430
  554340
  560136
  564462
  569820
  575549
  578493
  583656
  587052
  592054
  592364
  592545
  592815
  598301
  600581
  607286
  610962
  618937
  620105
  623950
  623958
  648491
  651928
  651930
  651941
  652177
  652206
  653245
  653258
  653308
  654385
  661693
  661698
  662038
  663957
  672536
  679702
  685612
  694468
  703506
  712462
  716318
  720791
  724712
  726467
  727717
  728411
  733900
  735684
  738960
  742993
  744468
  745451
  748752
  758812
  759772
  768115
  770007
  770159
  772942
  773071
  773084
  776315
  776798
  776862
  781677
  784298
  792680
  794073
  794719
  796886
  797697
  797705
  799315
  799623
  800324
  802686
  810031
  810789
  811662
]
13.33 ms
(7.38%)
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
  357886
  357806
  400435
  569820
  404032
  489606
  149261
  185208
  381769
  772942
  799623
  575549
  651941
  648491
  672536
  607286
  592545
  776798
  797705
  794073
  802686
  726467
  759772
  738960
  724712
  357753
  185412
  578493
  679702
  560136
  592364
  420341
  150405
  390224
  413195
  651928
  652177
  653308
  583656
  618937
  810789
  796886
  799315
  322773
  185595
  381984
  776862
  784298
  716318
  386071
  6684
  382650
  357824
  654385
  662038
  587052
  800324
  728411
  745451
  735684
  742993
  464616
  620105
  508745
  712462
  185708
  592054
  393848
  727717
  391036
  600581
  185464
  509955
  551430
  554340
  720791
  653245
  653258
  661693
  661698
  694468
  610962
  797697
  776315
  811662
  744468
  773071
  733900
  748752
  390241
  419126
  651930
  663957
  703506
  768115
  792680
  770007
  773084
  781677
  810031
  385538
  510049
  564462
  592815
  623958
  598301
  357839
  450763
  685612
  623950
  794719
  770159
  758812
  481087
  447842
  389167
  383474
  501718
  185011
  652206
]
2.72 ms
(1.51%)
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
  6684
  149261
  150405
  185011
  185208
  185412
  185464
  185595
  185708
  322773
  357753
  357806
  357824
  357839
  357886
  381769
  381984
  382650
  383474
  385538
  386071
  389167
  390224
  390241
  391036
  393848
  400435
  404032
  413195
  419126
  420341
  447842
  450763
  464616
  481087
  489606
  501718
  508745
  509955
  510049
  551430
  554340
  560136
  564462
  569820
  575549
  578493
  583656
  587052
  592054
  592364
  592545
  592815
  598301
  600581
  607286
  610962
  618937
  620105
  623950
  623958
  648491
  651928
  651930
  651941
  652177
  652206
  653245
  653258
  653308
  654385
  661693
  661698
  662038
  663957
  672536
  679702
  685612
  694468
  703506
  712462
  716318
  720791
  724712
  726467
  727717
  728411
  733900
  735684
  738960
  742993
  744468
  745451
  748752
  758812
  759772
  768115
  770007
  770159
  772942
  773071
  773084
  776315
  776798
  776862
  781677
  784298
  792680
  794073
  794719
  796886
  797697
  797705
  799315
  799623
  800324
  802686
  810031
  810789
  811662
]
2.45 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "массаж секс"
]
2.06 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "массаж с сексо"
]
1.85 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.