Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.11 ms
(84.99%)
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
  188117
  188669
  389218
  389653
  389840
  398787
  398965
  411036
  411189
  411747
  430301
  433781
  443628
  445047
  445104
  445221
  451248
  453382
  454640
  455460
  455685
  457428
  458047
  462707
  464539
  465552
  466007
  467118
  481927
  482094
  484316
  487945
  492204
  497862
  503508
  503966
  507266
  507267
  508721
  509262
  513131
  517686
  517703
  517722
  521378
  521657
  528500
  530110
  530836
  531724
  532701
  540588
  548323
  549844
  554466
  555397
  561021
  569102
  575031
  577106
  585733
  594131
  601649
  602321
  615390
  617116
  620342
  650614
  662884
  663857
  665311
  666115
  670367
  670473
  686315
  692816
  700825
  705677
  715802
  725207
  725218
  727010
  728478
  733287
  733520
  733555
  735976
  736194
  741785
  744227
  744988
  746177
  748587
  755989
  756530
  757069
  757504
  758923
  759356
  761815
  766300
  769337
  770136
  771576
  774609
  781785
  781895
  781994
  782026
  789697
  794179
  795998
  798608
  803472
  805638
  806556
  809195
  811393
  814190
  818335
]
15.46 ms
(8.81%)
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
  755989
  758923
  725207
  744227
  757504
  766300
  602321
  715802
  781994
  487945
  507266
  445104
  818335
  503508
  517703
  531724
  569102
  577106
  555397
  666115
  686315
  692816
  705677
  662884
  665311
  806556
  733520
  756530
  771576
  803472
  464539
  433781
  497862
  411747
  561021
  805638
  508721
  484316
  455685
  458047
  507267
  670367
  554466
  798608
  770136
  744988
  789697
  455460
  462707
  389840
  443628
  521657
  481927
  540588
  517686
  528500
  670473
  700825
  620342
  615390
  601649
  774609
  782026
  781895
  809195
  736194
  795998
  725218
  733287
  733555
  727010
  746177
  748587
  741785
  759356
  728478
  735976
  761815
  794179
  398965
  466007
  411189
  389218
  575031
  769337
  188117
  389653
  430301
  457428
  465552
  482094
  454640
  467118
  530110
  530836
  451248
  513131
  509262
  549844
  411036
  445047
  532701
  517722
  650614
  617116
  188669
  398787
  445221
  814190
  453382
  492204
  503966
  521378
  548323
  663857
  594131
  585733
  781785
  811393
  757069
]
3.13 ms
(1.79%)
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
  188117
  188669
  389218
  389653
  389840
  398787
  398965
  411036
  411189
  411747
  430301
  433781
  443628
  445047
  445104
  445221
  451248
  453382
  454640
  455460
  455685
  457428
  458047
  462707
  464539
  465552
  466007
  467118
  481927
  482094
  484316
  487945
  492204
  497862
  503508
  503966
  507266
  507267
  508721
  509262
  513131
  517686
  517703
  517722
  521378
  521657
  528500
  530110
  530836
  531724
  532701
  540588
  548323
  549844
  554466
  555397
  561021
  569102
  575031
  577106
  585733
  594131
  601649
  602321
  615390
  617116
  620342
  650614
  662884
  663857
  665311
  666115
  670367
  670473
  686315
  692816
  700825
  705677
  715802
  725207
  725218
  727010
  728478
  733287
  733520
  733555
  735976
  736194
  741785
  744227
  744988
  746177
  748587
  755989
  756530
  757069
  757504
  758923
  759356
  761815
  766300
  769337
  770136
  771576
  774609
  781785
  781895
  781994
  782026
  789697
  794179
  795998
  798608
  803472
  805638
  806556
  809195
  811393
  814190
  818335
]
2.13 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fat mother"
]
2.12 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fat мам женщин"
]
1.48 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fat мам женщин"
]

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.