Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.32 ms
(80.92%)
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
  58584
  378046
  396349
  399411
  400854
  400989
  400991
  401052
  401406
  415779
  416606
  417338
  421492
  421859
  426726
  427260
  432552
  432699
  437172
  439622
  439733
  440896
  443080
  443357
  443762
  444121
  448696
  449289
  454244
  454456
  455459
  455507
  455520
  455677
  456811
  457020
  458707
  458827
  460918
  462083
  462557
  464240
  466085
  466100
  467410
  467497
  470091
  470280
  470561
  470654
  472297
  474251
  475821
  475892
  475927
  479078
  479079
  479121
  479752
  481313
  482510
  483371
  484451
  484625
  484652
  485002
  485081
  485482
  485931
  490840
  492751
  495195
  496871
  499183
  502715
  503972
  504161
  504281
  504825
  505919
  506438
  509193
  509495
  513103
  514368
  516635
  517075
  517125
  518872
  519424
  519480
  519597
  519771
  520229
  522210
  523124
  523625
  523829
  526230
  538007
  544052
  546464
  547936
  552286
  552855
  555269
  558710
  562008
  563010
  564804
  569652
  575233
  584180
  588745
  614020
  624550
  626066
  644098
  645270
  771673
]
23.29 ms
(12.88%)
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
  569652
  499183
  645270
  443080
  490840
  644098
  518872
  401406
  514368
  475821
  470561
  519597
  421492
  449289
  526230
  432552
  474251
  443762
  509495
  558710
  588745
  415779
  458827
  444121
  400854
  457020
  417338
  475892
  517075
  513103
  555269
  462557
  546464
  399411
  401052
  416606
  458707
  467410
  472297
  562008
  552855
  626066
  614020
  771673
  400989
  455459
  470091
  479079
  470280
  479078
  479121
  484451
  538007
  439733
  509193
  432699
  485482
  396349
  462083
  455677
  455520
  519424
  547936
  552286
  563010
  437172
  464240
  460918
  466100
  467497
  519480
  484625
  502715
  503972
  496871
  523625
  485081
  506438
  492751
  564804
  504281
  443357
  522210
  505919
  516635
  544052
  483371
  485002
  504161
  454244
  455507
  519771
  584180
  58584
  448696
  495195
  427260
  482510
  520229
  523124
  479752
  421859
  517125
  439622
  523829
  624550
  475927
  575233
  454456
  400991
  456811
  481313
  504825
  378046
  426726
  440896
  466085
  470654
  484652
  485931
]
4.13 ms
(2.29%)
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
  58584
  378046
  396349
  399411
  400854
  400989
  400991
  401052
  401406
  415779
  416606
  417338
  421492
  421859
  426726
  427260
  432552
  432699
  437172
  439622
  439733
  440896
  443080
  443357
  443762
  444121
  448696
  449289
  454244
  454456
  455459
  455507
  455520
  455677
  456811
  457020
  458707
  458827
  460918
  462083
  462557
  464240
  466085
  466100
  467410
  467497
  470091
  470280
  470561
  470654
  472297
  474251
  475821
  475892
  475927
  479078
  479079
  479121
  479752
  481313
  482510
  483371
  484451
  484625
  484652
  485002
  485081
  485482
  485931
  490840
  492751
  495195
  496871
  499183
  502715
  503972
  504161
  504281
  504825
  505919
  506438
  509193
  509495
  513103
  514368
  516635
  517075
  517125
  518872
  519424
  519480
  519597
  519771
  520229
  522210
  523124
  523625
  523829
  526230
  538007
  544052
  546464
  547936
  552286
  552855
  555269
  558710
  562008
  563010
  564804
  569652
  575233
  584180
  588745
  614020
  624550
  626066
  644098
  645270
  771673
]
1.95 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашка с гостем и мужем"
]
1.86 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск гост жен"
]
1.41 ms
(0.78%)
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.