Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.30 ms
(85.96%)
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
  193342
  395654
  395839
  396214
  397406
  416195
  417486
  417952
  420201
  420384
  423428
  423505
  424449
  432777
  434491
  435400
  435406
  435454
  441111
  441476
  441566
  441838
  443224
  444828
  444829
  446079
  447086
  448374
  451670
  452818
  453788
  456214
  457804
  458086
  459520
  464302
  465277
  468704
  470087
  470173
  470181
  470320
  470973
  471685
  477073
  477553
  479530
  481812
  482804
  484438
  484476
  488909
  494698
  495067
  496733
  496758
  504672
  508679
  508832
  508876
  509063
  509064
  510368
  511090
  511269
  512922
  513114
  513366
  513690
  518005
  518919
  525418
  528853
  533544
  536667
  537927
  541618
  542895
  543869
  545204
  545471
  546202
  546780
  547428
  548253
  548300
  550560
  552131
  560286
  565252
  574222
  584234
  588786
  600104
  604207
  604329
  604408
  614566
  626539
  634563
  636285
  643233
  661933
  662009
  694479
  695620
  720739
  725619
  726292
  729919
  729957
  731960
  739868
  743380
  746722
  751503
  799362
  814640
  817156
  827876
]
17.30 ms
(9.05%)
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
  470320
  423505
  457804
  471685
  484476
  694479
  695620
  614566
  543869
  604207
  432777
  560286
  441111
  417952
  420384
  444828
  458086
  465277
  477553
  513366
  528853
  495067
  508679
  537927
  552131
  547428
  662009
  720739
  545471
  550560
  636285
  604329
  726292
  746722
  743380
  751503
  725619
  799362
  470173
  481812
  395654
  441476
  435454
  509064
  512922
  513114
  518005
  397406
  446079
  453788
  510368
  731960
  396214
  416195
  479530
  509063
  827876
  814640
  451670
  533544
  542895
  661933
  600104
  729957
  739868
  604408
  470973
  508832
  546780
  634563
  729919
  434491
  420201
  444829
  423428
  488909
  470087
  525418
  536667
  518919
  511269
  477073
  565252
  548253
  548300
  588786
  424449
  470181
  435406
  484438
  496733
  496758
  193342
  395839
  441838
  441566
  417486
  452818
  464302
  482804
  494698
  468704
  545204
  584234
  574222
  546202
  626539
  643233
  456214
  435400
  459520
  508876
  513690
  447086
  443224
  817156
  448374
  504672
  511090
  541618
]
2.57 ms
(1.34%)
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
  193342
  395654
  395839
  396214
  397406
  416195
  417486
  417952
  420201
  420384
  423428
  423505
  424449
  432777
  434491
  435400
  435406
  435454
  441111
  441476
  441566
  441838
  443224
  444828
  444829
  446079
  447086
  448374
  451670
  452818
  453788
  456214
  457804
  458086
  459520
  464302
  465277
  468704
  470087
  470173
  470181
  470320
  470973
  471685
  477073
  477553
  479530
  481812
  482804
  484438
  484476
  488909
  494698
  495067
  496733
  496758
  504672
  508679
  508832
  508876
  509063
  509064
  510368
  511090
  511269
  512922
  513114
  513366
  513690
  518005
  518919
  525418
  528853
  533544
  536667
  537927
  541618
  542895
  543869
  545204
  545471
  546202
  546780
  547428
  548253
  548300
  550560
  552131
  560286
  565252
  574222
  584234
  588786
  600104
  604207
  604329
  604408
  614566
  626539
  634563
  636285
  643233
  661933
  662009
  694479
  695620
  720739
  725619
  726292
  729919
  729957
  731960
  739868
  743380
  746722
  751503
  799362
  814640
  817156
  827876
]
2.17 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "domination anal"
]
1.74 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "domination анал"
]
1.40 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "domination анал"
]

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.