Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
408.07 ms
(93.53%)
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
  386524
  386593
  391455
  397208
  400461
  403050
  403053
  416606
  418649
  418738
  418998
  419351
  421072
  422929
  432685
  437089
  444121
  452493
  453782
  456215
  457663
  458025
  458242
  458397
  461105
  461125
  462253
  462517
  462523
  462583
  463129
  463166
  464286
  464307
  464513
  465237
  465786
  466966
  470633
  470745
  472845
  475168
  481308
  485085
  491750
  495830
  503870
  503922
  507362
  515744
  519322
  520170
  520982
  521995
  522057
  523977
  525374
  526139
  528769
  530576
  540098
  542779
  543795
  544206
  545530
  545739
  546053
  548684
  556072
  557608
  560452
  563278
  567393
  569453
  570291
  576027
  588274
  588331
  591088
  595945
  600481
  601569
  603951
  605329
  605851
  606102
  606173
  607772
  608425
  608765
  611299
  613973
  617660
  623499
  647693
  693457
  694029
  694116
  696218
  718889
  722277
  722672
  723927
  727747
  733068
  733138
  747355
  747655
  747687
  748662
  748686
  755255
  757906
  763522
  790391
  801272
  804373
  808192
  823300
  827977
]
17.68 ms
(4.05%)
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
  461125
  470745
  491750
  567393
  545739
  563278
  560452
  722277
  548684
  588274
  606173
  611299
  595945
  605851
  608765
  747687
  464513
  432685
  457663
  458397
  464307
  528769
  485085
  647693
  617660
  696218
  545530
  722672
  605329
  403050
  462583
  418998
  386593
  827977
  755255
  747355
  515744
  520170
  418738
  458025
  569453
  419351
  463166
  386524
  418649
  416606
  464286
  453782
  456215
  458242
  520982
  463129
  694029
  546053
  557608
  606102
  623499
  608425
  723927
  733138
  748686
  763522
  481308
  461105
  466966
  470633
  519322
  526139
  503922
  397208
  462253
  525374
  475168
  542779
  556072
  607772
  613973
  733068
  748662
  808192
  543795
  591088
  444121
  437089
  422929
  570291
  727747
  421072
  472845
  540098
  544206
  600481
  804373
  757906
  462517
  465237
  462523
  465786
  503870
  495830
  823300
  718889
  694116
  693457
  801272
  790391
  403053
  507362
  588331
  747655
  523977
  601569
  452493
  521995
  603951
  522057
  391455
  400461
  530576
  576027
]
3.26 ms
(0.75%)
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
  386524
  386593
  391455
  397208
  400461
  403050
  403053
  416606
  418649
  418738
  418998
  419351
  421072
  422929
  432685
  437089
  444121
  452493
  453782
  456215
  457663
  458025
  458242
  458397
  461105
  461125
  462253
  462517
  462523
  462583
  463129
  463166
  464286
  464307
  464513
  465237
  465786
  466966
  470633
  470745
  472845
  475168
  481308
  485085
  491750
  495830
  503870
  503922
  507362
  515744
  519322
  520170
  520982
  521995
  522057
  523977
  525374
  526139
  528769
  530576
  540098
  542779
  543795
  544206
  545530
  545739
  546053
  548684
  556072
  557608
  560452
  563278
  567393
  569453
  570291
  576027
  588274
  588331
  591088
  595945
  600481
  601569
  603951
  605329
  605851
  606102
  606173
  607772
  608425
  608765
  611299
  613973
  617660
  623499
  647693
  693457
  694029
  694116
  696218
  718889
  722277
  722672
  723927
  727747
  733068
  733138
  747355
  747655
  747687
  748662
  748686
  755255
  757906
  763522
  790391
  801272
  804373
  808192
  823300
  827977
]
2.21 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young girl amateur"
]
1.94 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young девушк любительск"
]
1.71 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young девушк любительск"
]

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.