Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.19 ms
(85.42%)
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
  382604
  384795
  386535
  411802
  411818
  411975
  414659
  420478
  421169
  428115
  430310
  431120
  438570
  443427
  444386
  444652
  445639
  453122
  453439
  453577
  453804
  454097
  454328
  454591
  454882
  464945
  465660
  468638
  469195
  472697
  474752
  475286
  477120
  480390
  480829
  482671
  483497
  486929
  489270
  489288
  492385
  492398
  495725
  499144
  504564
  506664
  509487
  512735
  514710
  517814
  530372
  531188
  531296
  532752
  535467
  536632
  540508
  542212
  543487
  543867
  544848
  545217
  550379
  576637
  577696
  583985
  588262
  591357
  593750
  598098
  598438
  599872
  600269
  601008
  601593
  601714
  603773
  604905
  605066
  605118
  606192
  606560
  606635
  607371
  608035
  621067
  621434
  630857
  634121
  634209
  634849
  634873
  636053
  643263
  644941
  644960
  647665
  648819
  649560
  651082
  668537
  691598
  693532
  696192
  702619
  705404
  705677
  710500
  712010
  714730
  716175
  718558
  726662
  726864
  727597
  729565
  741541
  750461
  775911
  776600
]
15.89 ms
(9.48%)
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
  550379
  705677
  634121
  621067
  411802
  474752
  420478
  506664
  599872
  702619
  710500
  504564
  606560
  741541
  531296
  530372
  648819
  634849
  535467
  532752
  543487
  544848
  651082
  712010
  601714
  588262
  606635
  634209
  593750
  454882
  514710
  499144
  517814
  509487
  649560
  598438
  606192
  634873
  603773
  729565
  726662
  472697
  428115
  444386
  644960
  453122
  453804
  454097
  480390
  489288
  536632
  576637
  705404
  604905
  601008
  607371
  714730
  483497
  438570
  480829
  492385
  716175
  696192
  718558
  776600
  727597
  421169
  492398
  386535
  453577
  489270
  445639
  605066
  384795
  431120
  443427
  430310
  482671
  464945
  726864
  598098
  465660
  454328
  454591
  453439
  475286
  382604
  444652
  644941
  647665
  636053
  750461
  495725
  468638
  531188
  583985
  600269
  608035
  775911
  411975
  414659
  540508
  545217
  542212
  543867
  691598
  693532
  591357
  630857
  605118
  601593
  411818
  486929
  512735
  577696
  668537
  643263
  621434
  469195
  477120
]
2.24 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
  382604
  384795
  386535
  411802
  411818
  411975
  414659
  420478
  421169
  428115
  430310
  431120
  438570
  443427
  444386
  444652
  445639
  453122
  453439
  453577
  453804
  454097
  454328
  454591
  454882
  464945
  465660
  468638
  469195
  472697
  474752
  475286
  477120
  480390
  480829
  482671
  483497
  486929
  489270
  489288
  492385
  492398
  495725
  499144
  504564
  506664
  509487
  512735
  514710
  517814
  530372
  531188
  531296
  532752
  535467
  536632
  540508
  542212
  543487
  543867
  544848
  545217
  550379
  576637
  577696
  583985
  588262
  591357
  593750
  598098
  598438
  599872
  600269
  601008
  601593
  601714
  603773
  604905
  605066
  605118
  606192
  606560
  606635
  607371
  608035
  621067
  621434
  630857
  634121
  634209
  634849
  634873
  636053
  643263
  644941
  644960
  647665
  648819
  649560
  651082
  668537
  691598
  693532
  696192
  702619
  705404
  705677
  710500
  712010
  714730
  716175
  718558
  726662
  726864
  727597
  729565
  741541
  750461
  775911
  776600
]
2.12 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кастинг отсос"
]
1.52 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг минет оральн секс"
]
1.22 ms
(0.73%)
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.