Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.96 ms
(85.28%)
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
  176298
  389264
  389448
  390835
  395585
  404292
  409705
  413000
  414026
  417978
  418970
  425629
  430175
  433594
  440971
  441250
  442997
  444722
  445015
  445086
  446137
  450770
  452048
  453171
  454709
  464542
  466020
  466446
  467670
  469153
  470596
  470936
  472299
  474081
  484519
  484969
  486234
  488378
  489235
  491966
  493052
  496114
  499889
  501497
  505836
  506737
  517923
  518927
  519278
  519588
  519721
  520826
  524496
  530269
  531943
  534286
  534377
  536584
  538165
  540801
  546101
  546940
  549129
  551081
  551577
  552043
  554889
  556014
  556205
  557185
  560510
  562007
  562894
  570395
  571764
  571807
  583517
  593153
  596953
  602665
  606223
  606958
  609697
  610035
  614847
  618187
  622291
  623716
  627181
  636405
  650630
  653232
  670513
  673575
  702375
  717063
  721771
  730030
  733387
  734779
  740166
  740756
  743738
  743792
  750445
  769464
  771700
  779996
  784168
  788978
  789946
  789998
  791873
  793873
  794508
  795387
  796859
  802187
  827952
]
13.68 ms
(8.78%)
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
  610035
  470596
  530269
  551081
  556014
  524496
  552043
  750445
  519721
  450770
  557185
  491966
  518927
  404292
  413000
  417978
  445015
  430175
  520826
  389448
  472299
  390835
  827952
  474081
  493052
  538165
  496114
  546101
  549129
  571807
  650630
  653232
  673575
  571764
  593153
  596953
  636405
  796859
  802187
  734779
  769464
  743738
  627181
  717063
  784168
  789946
  795387
  395585
  488378
  445086
  414026
  418970
  453171
  484969
  534286
  570395
  560510
  554889
  556205
  670513
  606223
  609697
  614847
  602665
  789998
  788978
  743792
  779996
  409705
  425629
  176298
  466446
  486234
  506737
  536584
  562894
  519588
  484519
  606958
  452048
  464542
  519278
  517923
  531943
  534377
  562007
  454709
  440971
  501497
  551577
  623716
  470936
  546940
  442997
  466020
  389264
  505836
  540801
  499889
  441250
  827917
  446137
  467670
  469153
  489235
  583517
  622291
  794508
  791873
  733387
  793873
  730030
  740166
  740756
  771700
  618187
  702375
  721771
  433594
  444722
]
2.80 ms
(1.80%)
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
  176298
  389264
  389448
  390835
  395585
  404292
  409705
  413000
  414026
  417978
  418970
  425629
  430175
  433594
  440971
  441250
  442997
  444722
  445015
  445086
  446137
  450770
  452048
  453171
  454709
  464542
  466020
  466446
  467670
  469153
  470596
  470936
  472299
  474081
  484519
  484969
  486234
  488378
  489235
  491966
  493052
  496114
  499889
  501497
  505836
  506737
  517923
  518927
  519278
  519588
  519721
  520826
  524496
  530269
  531943
  534286
  534377
  536584
  538165
  540801
  546101
  546940
  549129
  551081
  551577
  552043
  554889
  556014
  556205
  557185
  560510
  562007
  562894
  570395
  571764
  571807
  583517
  593153
  596953
  602665
  606223
  606958
  609697
  610035
  614847
  618187
  622291
  623716
  627181
  636405
  650630
  653232
  670513
  673575
  702375
  717063
  721771
  730030
  733387
  734779
  740166
  740756
  743738
  743792
  750445
  769464
  771700
  779996
  784168
  788978
  789946
  789998
  791873
  793873
  794508
  795387
  796859
  802187
  827952
]
1.80 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "лето с тётей"
]
1.74 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лет мам женщин"
]
1.59 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лет мам женщин"
]
1.33 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.