Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.69 ms
(83.55%)
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
  181804
  382020
  382413
  382450
  382812
  384880
  388819
  390734
  391576
  393770
  395620
  396395
  396740
  398209
  400166
  401602
  403006
  406086
  406179
  409100
  413280
  416178
  417979
  422299
  423884
  424255
  424946
  426796
  427100
  427174
  427467
  428051
  428450
  429541
  432886
  434849
  439326
  443472
  445440
  446026
  446560
  447077
  448553
  449484
  453322
  461944
  462392
  462699
  462708
  463545
  464699
  465441
  471969
  472683
  474613
  478510
  478990
  480680
  481083
  481354
  481484
  483952
  486105
  486277
  486705
  489098
  490129
  490592
  495040
  495194
  496454
  497210
  503887
  507241
  509079
  509430
  510051
  512189
  513537
  513971
  515767
  518291
  520123
  521194
  521342
  522905
  523138
  523862
  524124
  524723
  525587
  525693
  525884
  527180
  528144
  528161
  529376
  533461
  541767
  548789
  555056
  556004
  556850
  558261
  558465
  560385
  572260
  574595
  578010
  584705
  588318
  590721
  594088
  598050
  600458
  602562
  605117
  613275
  619884
  625001
]
16.07 ms
(10.60%)
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
  510051
  625001
  427174
  396740
  594088
  572260
  462392
  474613
  598050
  448553
  462699
  480680
  541767
  521342
  525587
  388819
  481484
  496454
  574595
  478990
  181804
  427100
  490592
  384880
  428051
  453322
  495194
  382450
  413280
  426796
  393770
  416178
  462708
  524124
  486705
  513537
  495040
  528144
  588318
  445440
  584705
  391576
  401602
  403006
  406086
  409100
  422299
  423884
  471969
  509079
  528161
  578010
  396395
  398209
  429541
  449484
  434849
  461944
  486105
  497210
  529376
  522905
  382020
  513971
  472683
  548789
  555056
  556004
  556850
  390734
  481083
  465441
  503887
  524723
  382812
  417979
  446560
  483952
  428450
  424255
  478510
  486277
  512189
  558261
  558465
  382413
  509430
  515767
  520123
  490129
  590721
  602562
  406179
  527180
  464699
  463545
  521194
  424946
  427467
  432886
  443472
  489098
  518291
  523138
  525884
  600458
  400166
  439326
  613275
  447077
  446026
  605117
  395620
  560385
  481354
  533461
  507241
  523862
  525693
  619884
]
2.22 ms
(1.47%)
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
  181804
  382020
  382413
  382450
  382812
  384880
  388819
  390734
  391576
  393770
  395620
  396395
  396740
  398209
  400166
  401602
  403006
  406086
  406179
  409100
  413280
  416178
  417979
  422299
  423884
  424255
  424946
  426796
  427100
  427174
  427467
  428051
  428450
  429541
  432886
  434849
  439326
  443472
  445440
  446026
  446560
  447077
  448553
  449484
  453322
  461944
  462392
  462699
  462708
  463545
  464699
  465441
  471969
  472683
  474613
  478510
  478990
  480680
  481083
  481354
  481484
  483952
  486105
  486277
  486705
  489098
  490129
  490592
  495040
  495194
  496454
  497210
  503887
  507241
  509079
  509430
  510051
  512189
  513537
  513971
  515767
  518291
  520123
  521194
  521342
  522905
  523138
  523862
  524124
  524723
  525587
  525693
  525884
  527180
  528144
  528161
  529376
  533461
  541767
  548789
  555056
  556004
  556850
  558261
  558465
  560385
  572260
  574595
  578010
  584705
  588318
  590721
  594088
  598050
  600458
  602562
  605117
  613275
  619884
  625001
]
1.88 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ласкают киску"
]
1.68 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ласка вагин"
]
1.47 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.