Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.75 ms
(57.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
123.94 ms
(34.87%)
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
  383961
  406377
  411814
  411838
  415148
  422525
  422529
  422566
  422572
  422625
  422631
  422894
  422896
  423007
  423026
  428577
  429116
  430239
  432122
  443301
  443467
  445269
  446793
  449135
  451531
  451890
  452068
  452221
  452434
  452441
  455908
  457164
  458302
  458992
  459202
  461747
  463846
  463862
  463920
  463963
  464256
  465351
  465819
  466177
  467142
  467166
  467380
  468473
  468597
  468638
  468647
  468703
  469550
  471777
  472431
  473094
  474656
  475451
  475799
  475828
  475981
  477074
  478052
  478933
  480293
  480295
  480415
  483734
  485355
  486424
  486426
  490139
  491518
  491566
  492111
  495214
  495267
  496724
  497517
  499774
  503418
  504376
  505106
  507005
  507649
  513289
  513704
  517778
  518032
  518771
  519002
  519249
  520421
  521128
  522628
  522844
  523389
  523705
  525100
  525681
  525956
  526841
  528761
  530532
  530632
  532644
  533522
  537893
  541324
  554428
  562068
  585143
  585210
  593975
  603493
  604160
  625003
  645004
  653547
  723580
]
18.84 ms
(5.30%)
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
  422529
  463920
  465819
  466177
  477074
  383961
  467380
  429116
  458302
  459202
  465351
  480415
  430239
  446793
  468473
  468597
  468638
  471777
  520421
  522844
  491566
  513704
  518032
  518771
  521128
  523705
  491518
  495214
  497517
  519002
  525956
  485355
  486424
  496724
  507649
  526841
  603493
  532644
  519249
  428577
  486426
  653547
  604160
  585210
  593975
  523389
  504376
  499774
  562068
  625003
  475828
  492111
  406377
  422631
  423007
  422625
  422894
  422896
  415148
  422566
  432122
  422525
  422572
  443301
  445269
  411814
  411838
  423026
  443467
  585143
  723580
  645004
  452221
  458992
  463846
  463862
  463963
  467166
  475451
  475981
  478933
  449135
  451531
  452068
  452434
  455908
  468647
  469550
  475799
  480293
  451890
  452441
  457164
  461747
  467142
  468703
  473094
  474656
  478052
  490139
  525681
  528761
  522628
  530632
  537893
  495267
  513289
  517778
  530532
  503418
  505106
  507005
  525100
  533522
  464256
  472431
  480295
  483734
  541324
  554428
]
2.49 ms
(0.70%)
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
  383961
  406377
  411814
  411838
  415148
  422525
  422529
  422566
  422572
  422625
  422631
  422894
  422896
  423007
  423026
  428577
  429116
  430239
  432122
  443301
  443467
  445269
  446793
  449135
  451531
  451890
  452068
  452221
  452434
  452441
  455908
  457164
  458302
  458992
  459202
  461747
  463846
  463862
  463920
  463963
  464256
  465351
  465819
  466177
  467142
  467166
  467380
  468473
  468597
  468638
  468647
  468703
  469550
  471777
  472431
  473094
  474656
  475451
  475799
  475828
  475981
  477074
  478052
  478933
  480293
  480295
  480415
  483734
  485355
  486424
  486426
  490139
  491518
  491566
  492111
  495214
  495267
  496724
  497517
  499774
  503418
  504376
  505106
  507005
  507649
  513289
  513704
  517778
  518032
  518771
  519002
  519249
  520421
  521128
  522628
  522844
  523389
  523705
  525100
  525681
  525956
  526841
  528761
  530532
  530632
  532644
  533522
  537893
  541324
  554428
  562068
  585143
  585210
  593975
  603493
  604160
  625003
  645004
  653547
  723580
]
2.04 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кастинг мужчины"
]
1.87 ms
(0.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг мужчин"
]
1.49 ms
(0.42%)
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.