Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.18 ms
(83.81%)
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
  382610
  385225
  392822
  395699
  395755
  395759
  400506
  400991
  403052
  414038
  416606
  424447
  426547
  427435
  432707
  439526
  439652
  443305
  444121
  444869
  446630
  451526
  453529
  453559
  453603
  455197
  455808
  456799
  457000
  457654
  461394
  462085
  464327
  464534
  466130
  467162
  471861
  473322
  474033
  474415
  476985
  477955
  482322
  496863
  498300
  507381
  510553
  511993
  516154
  516434
  517233
  517369
  523572
  546017
  547607
  550336
  550609
  550639
  550718
  555868
  557558
  558021
  558055
  558320
  560569
  561744
  563058
  563074
  563852
  564799
  577811
  580747
  582815
  586185
  594623
  600035
  604709
  605856
  606697
  609052
  609652
  617350
  617363
  622839
  623499
  623814
  624508
  629111
  631980
  642832
  655697
  657402
  682463
  688592
  691186
  705667
  709524
  715402
  716392
  721109
  721717
  722277
  726712
  738771
  739557
  742209
  747652
  757317
  760576
  783562
  796555
  798686
  800260
  800261
  800937
  803293
  804763
  807927
  808917
  820893
]
17.77 ms
(10.26%)
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
  605856
  623814
  642832
  800260
  457654
  400506
  416606
  456799
  516154
  523572
  546017
  558021
  577811
  722277
  558055
  594623
  623499
  726712
  721109
  439652
  477955
  461394
  466130
  424447
  439526
  444121
  451526
  482322
  511993
  496863
  682463
  688592
  604709
  783562
  798686
  757317
  747652
  760576
  804763
  474033
  395755
  403052
  385225
  550718
  560569
  609652
  464327
  547607
  444869
  457000
  563852
  655697
  657402
  622839
  600035
  550609
  395699
  395759
  392822
  382610
  820893
  453559
  473322
  446630
  550639
  558320
  563058
  564799
  715402
  716392
  617363
  586185
  624508
  631980
  609052
  800261
  796555
  800937
  738771
  742209
  629111
  705667
  808917
  443305
  453603
  516434
  455197
  557558
  427435
  471861
  580747
  550336
  467162
  453529
  517233
  517369
  555868
  606697
  400991
  426547
  414038
  617350
  474415
  476985
  498300
  507381
  510553
  561744
  563074
  582815
  709524
  691186
  721717
  807927
  803293
  739557
  432707
  464534
  455808
  462085
]
2.49 ms
(1.44%)
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
  382610
  385225
  392822
  395699
  395755
  395759
  400506
  400991
  403052
  414038
  416606
  424447
  426547
  427435
  432707
  439526
  439652
  443305
  444121
  444869
  446630
  451526
  453529
  453559
  453603
  455197
  455808
  456799
  457000
  457654
  461394
  462085
  464327
  464534
  466130
  467162
  471861
  473322
  474033
  474415
  476985
  477955
  482322
  496863
  498300
  507381
  510553
  511993
  516154
  516434
  517233
  517369
  523572
  546017
  547607
  550336
  550609
  550639
  550718
  555868
  557558
  558021
  558055
  558320
  560569
  561744
  563058
  563074
  563852
  564799
  577811
  580747
  582815
  586185
  594623
  600035
  604709
  605856
  606697
  609052
  609652
  617350
  617363
  622839
  623499
  623814
  624508
  629111
  631980
  642832
  655697
  657402
  682463
  688592
  691186
  705667
  709524
  715402
  716392
  721109
  721717
  722277
  726712
  738771
  739557
  742209
  747652
  757317
  760576
  783562
  796555
  798686
  800260
  800261
  800937
  803293
  804763
  807927
  808917
  820893
]
2.08 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife old man"
]
1.97 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен old мужчин"
]
1.93 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен old мужчин"
]

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.