Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.51 ms
(79.84%)
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
  73727
  156525
  185011
  185247
  185249
  204992
  323129
  357806
  382059
  382696
  389304
  389356
  390304
  390535
  390731
  390908
  395920
  396013
  399352
  401479
  406203
  406416
  406445
  407357
  413943
  415691
  415934
  418481
  424571
  434440
  445233
  447842
  448349
  449006
  454066
  459126
  463867
  463882
  464616
  469672
  489110
  489410
  497635
  499815
  501805
  506960
  507171
  507175
  511176
  518032
  518948
  525533
  531471
  538352
  538365
  551289
  551321
  551384
  551422
  554340
  557337
  558617
  563796
  569820
  569824
  572010
  572012
  572016
  573400
  575730
  576039
  583656
  595865
  600613
  603583
  626877
  644564
  647643
  651883
  651932
  651936
  653247
  653308
  654331
  661879
  663533
  671703
  672457
  672518
  677158
  689308
  689846
  694468
  694610
  696102
  709583
  721200
  722810
  722896
  724937
  733900
  735417
  738907
  738960
  740485
  742993
  744475
  744478
  747345
  748663
  762873
  768115
  773068
  774090
  807806
  817478
  817734
  818390
  818784
]
21.06 ms
(13.73%)
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
  323129
  557337
  389356
  415934
  185247
  406416
  709583
  677158
  762873
  382059
  558617
  382696
  722810
  724937
  511176
  454066
  415691
  538365
  661879
  694610
  595865
  626877
  773068
  418481
  651936
  204992
  395920
  572016
  572010
  489110
  6684
  817478
  654331
  390908
  390731
  448349
  647643
  506960
  554340
  694468
  733900
  742993
  807806
  573400
  603583
  501805
  569820
  424571
  518948
  390535
  463882
  507175
  818784
  721200
  463867
  156525
  663533
  390304
  551384
  525533
  735417
  738960
  744478
  413943
  447842
  531471
  774090
  551289
  551422
  818390
  489410
  434440
  671703
  672518
  738907
  740485
  722896
  569824
  459126
  497635
  696102
  401479
  406203
  576039
  551321
  563796
  518032
  572012
  747345
  407357
  406445
  651932
  357806
  185011
  538352
  768115
  748663
  185249
  499815
  817734
  672457
  600613
  73727
  507171
  744475
  399352
  469672
  575730
  653247
  445233
  396013
  651883
  389304
  689846
  653308
  583656
  464616
  449006
  689308
  644564
]
3.08 ms
(2.01%)
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
  73727
  156525
  185011
  185247
  185249
  204992
  323129
  357806
  382059
  382696
  389304
  389356
  390304
  390535
  390731
  390908
  395920
  396013
  399352
  401479
  406203
  406416
  406445
  407357
  413943
  415691
  415934
  418481
  424571
  434440
  445233
  447842
  448349
  449006
  454066
  459126
  463867
  463882
  464616
  469672
  489110
  489410
  497635
  499815
  501805
  506960
  507171
  507175
  511176
  518032
  518948
  525533
  531471
  538352
  538365
  551289
  551321
  551384
  551422
  554340
  557337
  558617
  563796
  569820
  569824
  572010
  572012
  572016
  573400
  575730
  576039
  583656
  595865
  600613
  603583
  626877
  644564
  647643
  651883
  651932
  651936
  653247
  653308
  654331
  661879
  663533
  671703
  672457
  672518
  677158
  689308
  689846
  694468
  694610
  696102
  709583
  721200
  722810
  722896
  724937
  733900
  735417
  738907
  738960
  740485
  742993
  744475
  744478
  747345
  748663
  762873
  768115
  773068
  774090
  807806
  817478
  817734
  818390
  818784
]
1.94 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl 18 massage"
]
1.71 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк 18 массаж"
]
1.62 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк 18 массаж"
]

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.