Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
236.84 ms
(50.87%)
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
  478660
  465981
  801901
  403052
  679091
  513311
  489584
  462295
  453355
  457554
  460299
  573794
  559251
  475342
  455212
  471481
  494349
  489650
  721336
  666513
  391206
  395876
  518716
  564786
  686089
  789419
  456642
  461478
  398171
  462029
  458238
  543841
  445035
  466666
  521964
  561829
  686868
  462521
  569567
  445909
  463737
  490786
  722154
  596438
  778923
  727294
  612482
  442521
  478497
  490736
  525917
  699459
  526917
  565367
  417880
  498924
  585436
  594868
  475010
  438373
  466594
  477449
  496047
  510851
  560911
  399194
  567666
  549479
  472801
  461575
  510796
  4429
  570447
  401454
  407222
  499157
  489148
  548761
  146855
  626209
  406017
  753678
  586817
  431490
  508739
  598994
  506463
  557185
  790498
  803854
  388290
  460649
  576082
  560145
  597048
  438398
  442979
  471474
  463945
  488995
  469655
  522559
  460872
  565920
  542072
  449499
  411635
  460852
  463530
  464893
  494413
  571067
  575777
  588962
  414023
  434277
  456949
  471129
  455425
  420440
]
218.67 ms
(46.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
  4429
  146855
  388290
  391206
  395876
  398171
  399194
  401454
  403052
  406017
  407222
  411635
  414023
  417880
  420440
  431490
  434277
  438373
  438398
  442521
  442979
  445035
  445909
  449499
  453355
  455212
  455425
  456642
  456949
  457554
  458238
  460299
  460649
  460852
  460872
  461478
  461575
  462029
  462295
  462521
  463530
  463737
  463945
  464893
  465981
  466594
  466666
  469655
  471129
  471474
  471481
  472801
  475010
  475342
  477449
  478497
  478660
  488995
  489148
  489584
  489650
  490736
  490786
  494349
  494413
  496047
  498924
  499157
  506463
  508739
  510796
  510851
  513311
  518716
  521964
  522559
  525917
  526917
  542072
  543841
  548761
  549479
  557185
  559251
  560145
  560911
  561829
  564786
  565367
  565920
  567666
  569567
  570447
  571067
  573794
  575777
  576082
  585436
  586817
  588962
  594868
  596438
  597048
  598994
  612482
  626209
  666513
  679091
  686089
  686868
  699459
  721336
  722154
  727294
  753678
  778923
  789419
  790498
  801901
  803854
]
3.05 ms
(0.66%)
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
  4429
  146855
  388290
  391206
  395876
  398171
  399194
  401454
  403052
  406017
  407222
  411635
  414023
  417880
  420440
  431490
  434277
  438373
  438398
  442521
  442979
  445035
  445909
  449499
  453355
  455212
  455425
  456642
  456949
  457554
  458238
  460299
  460649
  460852
  460872
  461478
  461575
  462029
  462295
  462521
  463530
  463737
  463945
  464893
  465981
  466594
  466666
  469655
  471129
  471474
  471481
  472801
  475010
  475342
  477449
  478497
  478660
  488995
  489148
  489584
  489650
  490736
  490786
  494349
  494413
  496047
  498924
  499157
  506463
  508739
  510796
  510851
  513311
  518716
  521964
  522559
  525917
  526917
  542072
  543841
  548761
  549479
  557185
  559251
  560145
  560911
  561829
  564786
  565367
  565920
  567666
  569567
  570447
  571067
  573794
  575777
  576082
  585436
  586817
  588962
  594868
  596438
  597048
  598994
  612482
  626209
  666513
  679091
  686089
  686868
  699459
  721336
  722154
  727294
  753678
  778923
  789419
  790498
  801901
  803854
]
2.10 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful girl blowjob"
]
1.73 ms
(0.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая девушк минет оральн секс"
]
1.68 ms
(0.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.33%)
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.