Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.39 ms
(85.83%)
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
  7178
  13118
  13229
  172068
  232973
  276696
  379559
  393102
  397863
  398811
  401383
  401666
  403321
  404664
  406734
  408969
  409316
  410683
  411326
  411408
  411468
  413183
  415988
  421740
  426434
  428846
  434425
  439643
  440851
  443738
  448363
  448802
  457463
  460673
  466196
  468043
  468167
  469447
  470148
  475319
  477128
  479856
  480212
  481328
  481937
  482339
  482527
  486192
  493149
  495990
  498081
  498614
  500806
  508684
  509267
  511375
  512513
  513114
  514833
  520904
  521121
  521137
  522510
  522614
  523838
  526456
  536433
  537267
  547492
  557512
  557814
  561042
  562967
  564655
  570783
  571806
  580712
  582335
  586583
  590373
  592548
  592857
  596488
  619096
  621536
  634849
  639788
  709654
  718496
  719929
  726612
  727789
  733371
  740826
  746621
  758509
  761323
  761600
  777727
  777734
  782593
  782626
  787155
  788610
  788946
  788980
  789537
  790874
  792936
  795750
  795988
  797728
  798453
  801173
  802151
  803306
  807352
  807353
  807452
  811923
]
10.90 ms
(7.58%)
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
  557814
  562967
  580712
  592857
  634849
  787155
  795988
  802151
  807352
  807353
  777727
  788980
  733371
  758509
  761323
  761600
  798453
  726612
  727789
  740826
  709654
  719929
  777734
  788946
  792936
  795750
  379559
  409316
  410683
  428846
  481328
  7178
  401666
  413183
  434425
  440851
  475319
  13118
  477128
  415988
  421740
  466196
  500806
  522614
  536433
  508684
  513114
  522510
  486192
  526456
  514833
  520904
  398811
  621536
  789537
  807452
  797728
  746621
  811923
  232973
  13229
  460673
  482527
  571806
  397863
  426434
  439643
  411468
  401383
  404664
  408969
  457463
  468043
  512513
  480212
  482339
  564655
  547492
  718496
  557512
  582335
  586583
  619096
  596488
  639788
  590373
  592548
  782593
  782626
  803306
  788610
  790874
  801173
  172068
  393102
  403321
  481937
  468167
  469447
  479856
  406734
  411408
  470148
  411326
  443738
  509267
  537267
  493149
  521121
  521137
  495990
  523838
  498081
  498614
  511375
  276696
  448802
  448363
  561042
  570783
]
2.35 ms
(1.64%)
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
  7178
  13118
  13229
  172068
  232973
  276696
  379559
  393102
  397863
  398811
  401383
  401666
  403321
  404664
  406734
  408969
  409316
  410683
  411326
  411408
  411468
  413183
  415988
  421740
  426434
  428846
  434425
  439643
  440851
  443738
  448363
  448802
  457463
  460673
  466196
  468043
  468167
  469447
  470148
  475319
  477128
  479856
  480212
  481328
  481937
  482339
  482527
  486192
  493149
  495990
  498081
  498614
  500806
  508684
  509267
  511375
  512513
  513114
  514833
  520904
  521121
  521137
  522510
  522614
  523838
  526456
  536433
  537267
  547492
  557512
  557814
  561042
  562967
  564655
  570783
  571806
  580712
  582335
  586583
  590373
  592548
  592857
  596488
  619096
  621536
  634849
  639788
  709654
  718496
  719929
  726612
  727789
  733371
  740826
  746621
  758509
  761323
  761600
  777727
  777734
  782593
  782626
  787155
  788610
  788946
  788980
  789537
  790874
  792936
  795750
  795988
  797728
  798453
  801173
  802151
  803306
  807352
  807353
  807452
  811923
]
2.11 ms
(1.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелые тетки бесплатн…"
]
1.65 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин мам женщин бесплатн"
]
1.39 ms
(0.97%)
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.