Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.93 ms
(57.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин сперм в рот"
]
129.37 ms
(35.55%)
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
  80699
  130016
  190891
  375930
  385198
  385491
  388411
  390139
  391208
  393102
  394453
  396946
  400653
  401013
  404021
  405827
  407024
  407491
  411842
  412989
  418080
  426783
  428468
  428781
  430534
  438324
  439465
  443677
  443738
  445089
  445297
  446766
  447527
  450647
  459595
  462347
  465473
  466840
  469726
  470167
  478183
  478362
  480282
  484285
  486290
  486477
  486684
  497284
  497391
  499341
  499427
  500037
  501482
  504668
  509271
  513361
  518126
  522653
  523835
  525200
  526724
  527845
  530185
  535806
  539561
  544943
  547743
  552828
  555066
  555089
  555936
  558778
  561033
  565015
  566760
  567360
  569655
  573327
  573757
  576644
  583941
  588984
  597546
  597843
  598839
  604129
  610148
  613543
  614858
  623396
  624148
  625860
  630328
  636208
  641874
  666892
  715001
  717794
  717949
  720122
  734461
  738314
  742544
  749009
  758572
  762994
  766041
  769443
  769668
  779534
  780427
  781078
  788883
  795978
  795988
  796155
  802012
  807305
  807846
  809787
]
15.90 ms
(4.37%)
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
  469726
  504668
  779534
  385198
  499341
  518126
  80699
  411842
  478183
  624148
  583941
  405827
  480282
  525200
  588984
  625860
  499427
  613543
  445297
  565015
  401013
  795988
  445089
  539561
  666892
  614858
  742544
  558778
  497284
  597843
  466840
  478362
  573757
  576644
  391208
  486290
  604129
  641874
  486684
  547743
  717949
  762994
  769443
  567360
  561033
  597546
  407491
  500037
  535806
  400653
  443677
  513361
  418080
  749009
  470167
  428468
  447527
  393102
  443738
  530185
  734461
  552828
  497391
  190891
  636208
  780427
  526724
  555089
  527845
  807846
  428781
  623396
  396946
  426783
  501482
  720122
  796155
  438324
  388411
  544943
  758572
  807305
  738314
  802012
  390139
  769668
  717794
  569655
  610148
  394453
  450647
  412989
  430534
  385491
  573327
  715001
  795978
  788883
  809787
  439465
  459595
  598839
  407024
  375930
  509271
  130016
  465473
  484285
  522653
  555936
  630328
  566760
  404021
  446766
  462347
  555066
  486477
  523835
  766041
  781078
]
2.63 ms
(0.72%)
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
  80699
  130016
  190891
  375930
  385198
  385491
  388411
  390139
  391208
  393102
  394453
  396946
  400653
  401013
  404021
  405827
  407024
  407491
  411842
  412989
  418080
  426783
  428468
  428781
  430534
  438324
  439465
  443677
  443738
  445089
  445297
  446766
  447527
  450647
  459595
  462347
  465473
  466840
  469726
  470167
  478183
  478362
  480282
  484285
  486290
  486477
  486684
  497284
  497391
  499341
  499427
  500037
  501482
  504668
  509271
  513361
  518126
  522653
  523835
  525200
  526724
  527845
  530185
  535806
  539561
  544943
  547743
  552828
  555066
  555089
  555936
  558778
  561033
  565015
  566760
  567360
  569655
  573327
  573757
  576644
  583941
  588984
  597546
  597843
  598839
  604129
  610148
  613543
  614858
  623396
  624148
  625860
  630328
  636208
  641874
  666892
  715001
  717794
  717949
  720122
  734461
  738314
  742544
  749009
  758572
  762994
  766041
  769443
  769668
  779534
  780427
  781078
  788883
  795978
  795988
  796155
  802012
  807305
  807846
  809787
]
2.06 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамка кончил в рот"
]
1.63 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.35 ms
(0.37%)
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.