Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.82 ms
(82.77%)
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
  28242
  233135
  365992
  366478
  391563
  401594
  401858
  402226
  404121
  404257
  409728
  411368
  420513
  423520
  426336
  427091
  428929
  432304
  432794
  444841
  445720
  447538
  447555
  455322
  460351
  466417
  467306
  470978
  473091
  473240
  474272
  479694
  480004
  480306
  482031
  482075
  482221
  482403
  485575
  489118
  489573
  489609
  491185
  491326
  491457
  491938
  492841
  492994
  493271
  496453
  496725
  503636
  505031
  506287
  507665
  508546
  508873
  508876
  509083
  509663
  513313
  513472
  513710
  516740
  523970
  525942
  527167
  527629
  534040
  538207
  539126
  552430
  555834
  558205
  560630
  561632
  561829
  565953
  581967
  586601
  586603
  595401
  595497
  595515
  596459
  596600
  596630
  596649
  597048
  597066
  598508
  598544
  598773
  600159
  603103
  626880
  637002
  652869
  652927
  675798
  683242
  701486
  712380
  720850
  722814
  742224
  742846
  747709
  750753
  754584
  761147
  766248
  782602
  786372
  788905
  790531
  790925
  799714
  812346
  827221
]
18.24 ms
(11.54%)
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
  460351
  466417
  420513
  508873
  509083
  527167
  558205
  505031
  595515
  401858
  28242
  799714
  766248
  428929
  404257
  411368
  473240
  482221
  538207
  552430
  626880
  786372
  742846
  561829
  586601
  423520
  503636
  506287
  491457
  508546
  827221
  683242
  652927
  790531
  747709
  754584
  401594
  365992
  482403
  597048
  586603
  467306
  479694
  455322
  474272
  480004
  473091
  447555
  485575
  513472
  492994
  496453
  489573
  509663
  523970
  534040
  600159
  742224
  427091
  233135
  409728
  491185
  366478
  581967
  565953
  596649
  597066
  596630
  426336
  480306
  447538
  527629
  491326
  491938
  513313
  750753
  712380
  720850
  598508
  790925
  761147
  722814
  516740
  561632
  560630
  782602
  788905
  444841
  482075
  470978
  508876
  489118
  489609
  493271
  496725
  525942
  539126
  603103
  432794
  701486
  652869
  513710
  555834
  596459
  596600
  482031
  492841
  507665
  404121
  432304
  402226
  595401
  637002
  675798
  595497
  598544
  391563
  812346
  598773
  445720
]
2.67 ms
(1.69%)
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
  28242
  233135
  365992
  366478
  391563
  401594
  401858
  402226
  404121
  404257
  409728
  411368
  420513
  423520
  426336
  427091
  428929
  432304
  432794
  444841
  445720
  447538
  447555
  455322
  460351
  466417
  467306
  470978
  473091
  473240
  474272
  479694
  480004
  480306
  482031
  482075
  482221
  482403
  485575
  489118
  489573
  489609
  491185
  491326
  491457
  491938
  492841
  492994
  493271
  496453
  496725
  503636
  505031
  506287
  507665
  508546
  508873
  508876
  509083
  509663
  513313
  513472
  513710
  516740
  523970
  525942
  527167
  527629
  534040
  538207
  539126
  552430
  555834
  558205
  560630
  561632
  561829
  565953
  581967
  586601
  586603
  595401
  595497
  595515
  596459
  596600
  596630
  596649
  597048
  597066
  598508
  598544
  598773
  600159
  603103
  626880
  637002
  652869
  652927
  675798
  683242
  701486
  712380
  720850
  722814
  742224
  742846
  747709
  750753
  754584
  761147
  766248
  782602
  786372
  788905
  790531
  790925
  799714
  812346
  827221
]
1.76 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русский анал с красоткой"
]
1.66 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск анал красивая"
]
1.43 ms
(0.90%)
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.