Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.93 ms
(83.22%)
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
  233135
  390653
  393865
  398909
  403900
  404313
  405485
  405507
  407154
  409105
  409109
  412394
  416408
  418195
  420584
  421861
  424850
  427536
  428472
  428846
  437582
  438208
  438219
  446286
  450779
  450786
  450803
  451086
  453453
  456736
  460179
  460188
  463630
  465834
  466435
  477114
  478835
  480553
  481874
  482248
  482629
  484768
  486252
  498501
  507834
  513113
  514297
  516209
  520021
  520683
  521176
  522168
  522614
  524271
  524867
  527151
  531523
  531528
  531917
  531935
  536347
  537815
  556511
  556607
  556653
  556659
  561589
  565004
  565623
  569394
  569940
  573758
  579227
  581878
  583934
  586682
  589616
  591048
  596573
  608049
  609966
  610114
  622710
  624286
  625435
  662140
  665940
  670748
  673654
  684030
  692365
  695186
  704987
  711671
  717677
  717948
  721060
  721748
  721822
  724706
  726621
  726891
  740156
  742839
  743396
  753722
  757114
  758564
  761370
  767528
  772526
  782626
  784936
  786462
  789698
  801223
  804071
  816994
  818488
  818775
]
14.06 ms
(8.24%)
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
  416408
  531917
  405485
  405507
  446286
  527151
  596573
  486252
  390653
  556607
  684030
  782626
  460188
  412394
  418195
  421861
  438208
  409109
  536347
  537815
  531523
  531528
  498501
  524867
  531935
  565623
  804071
  403900
  438219
  404313
  409105
  460179
  398909
  427536
  450803
  451086
  428472
  465834
  507834
  520021
  484768
  516209
  522168
  818488
  565004
  561589
  581878
  665940
  670748
  692365
  695186
  704987
  721822
  556659
  579227
  610114
  786462
  724706
  726891
  758564
  711671
  721060
  424850
  818775
  569940
  583934
  482629
  784936
  450786
  480553
  456736
  573758
  622710
  420584
  463630
  393865
  466435
  478835
  481874
  453453
  477114
  407154
  482248
  514297
  513113
  521176
  556653
  569394
  556511
  662140
  673654
  717677
  717948
  624286
  591048
  625435
  589616
  586682
  789698
  801223
  742839
  740156
  726621
  743396
  753722
  757114
  608049
  609966
  721748
  428846
  233135
  437582
  450779
  522614
  524271
  816994
  767528
  761370
  772526
  520683
]
5.15 ms
(3.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom член"
]
3.89 ms
(2.28%)
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
  233135
  390653
  393865
  398909
  403900
  404313
  405485
  405507
  407154
  409105
  409109
  412394
  416408
  418195
  420584
  421861
  424850
  427536
  428472
  428846
  437582
  438208
  438219
  446286
  450779
  450786
  450803
  451086
  453453
  456736
  460179
  460188
  463630
  465834
  466435
  477114
  478835
  480553
  481874
  482248
  482629
  484768
  486252
  498501
  507834
  513113
  514297
  516209
  520021
  520683
  521176
  522168
  522614
  524271
  524867
  527151
  531523
  531528
  531917
  531935
  536347
  537815
  556511
  556607
  556653
  556659
  561589
  565004
  565623
  569394
  569940
  573758
  579227
  581878
  583934
  586682
  589616
  591048
  596573
  608049
  609966
  610114
  622710
  624286
  625435
  662140
  665940
  670748
  673654
  684030
  692365
  695186
  704987
  711671
  717677
  717948
  721060
  721748
  721822
  724706
  726621
  726891
  740156
  742839
  743396
  753722
  757114
  758564
  761370
  767528
  772526
  782626
  784936
  786462
  789698
  801223
  804071
  816994
  818488
  818775
]
2.00 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom dick"
]
1.78 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom член"
]

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.