Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.66 ms
(87.06%)
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
  233340
  387377
  394199
  397883
  403924
  407687
  413182
  422181
  424453
  425507
  428500
  429886
  430838
  437218
  439652
  439707
  452146
  453077
  454373
  454548
  456010
  460583
  460906
  461183
  462332
  464138
  465370
  466491
  466864
  466918
  469164
  469881
  470841
  471105
  472415
  474645
  474844
  474862
  475919
  476322
  477071
  478927
  479092
  479512
  480650
  480662
  481466
  482074
  482301
  482339
  482342
  482505
  483327
  484561
  484856
  485226
  485355
  486789
  488907
  490577
  490887
  491111
  493220
  495030
  497233
  499587
  500394
  500415
  502312
  503498
  506535
  510470
  511391
  512607
  513857
  516509
  516891
  518285
  518874
  519082
  519753
  519996
  520641
  520913
  523634
  523884
  526477
  526499
  543317
  544452
  546930
  547492
  547930
  549311
  550456
  555012
  555045
  556004
  557244
  558006
  558011
  558021
  558292
  559166
  560376
  563050
  563066
  563196
  567431
  570052
  570056
  570841
  573538
  577423
  593586
  599509
  620019
  727769
  807326
  812674
]
17.45 ms
(8.45%)
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
  454373
  456010
  466918
  476322
  493220
  497233
  518285
  511391
  516509
  500415
  516891
  482074
  482339
  485226
  558011
  558292
  544452
  547492
  550456
  558006
  549311
  555045
  599509
  812674
  397883
  424453
  469164
  480650
  429886
  437218
  465370
  466864
  482342
  387377
  462332
  481466
  233340
  413182
  479092
  480662
  475919
  500394
  519082
  484856
  491111
  510470
  519996
  526477
  506535
  520641
  520913
  523634
  485355
  488907
  490887
  495030
  512607
  518874
  523884
  403924
  428500
  482505
  452146
  453077
  454548
  474862
  464138
  470841
  474844
  478927
  471105
  474645
  477071
  482301
  484561
  519753
  499587
  526499
  502312
  503498
  513857
  461183
  472415
  483327
  486789
  490577
  555012
  557244
  558021
  560376
  563050
  563066
  570052
  577423
  546930
  556004
  563196
  567431
  543317
  547930
  559166
  570056
  570841
  573538
  593586
  620019
  807326
  727769
  407687
  422181
  430838
  439652
  469881
  479512
  394199
  425507
  439707
  460583
  460906
  466491
]
2.69 ms
(1.30%)
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
  233340
  387377
  394199
  397883
  403924
  407687
  413182
  422181
  424453
  425507
  428500
  429886
  430838
  437218
  439652
  439707
  452146
  453077
  454373
  454548
  456010
  460583
  460906
  461183
  462332
  464138
  465370
  466491
  466864
  466918
  469164
  469881
  470841
  471105
  472415
  474645
  474844
  474862
  475919
  476322
  477071
  478927
  479092
  479512
  480650
  480662
  481466
  482074
  482301
  482339
  482342
  482505
  483327
  484561
  484856
  485226
  485355
  486789
  488907
  490577
  490887
  491111
  493220
  495030
  497233
  499587
  500394
  500415
  502312
  503498
  506535
  510470
  511391
  512607
  513857
  516509
  516891
  518285
  518874
  519082
  519753
  519996
  520641
  520913
  523634
  523884
  526477
  526499
  543317
  544452
  546930
  547492
  547930
  549311
  550456
  555012
  555045
  556004
  557244
  558006
  558011
  558021
  558292
  559166
  560376
  563050
  563066
  563196
  567431
  570052
  570056
  570841
  573538
  577423
  593586
  599509
  620019
  727769
  807326
  812674
]
1.81 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "возраст"
]
1.63 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "возраст"
]
1.57 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.