Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.71 ms
(36.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy face"
]
213.93 ms
(36.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy face"
]
142.47 ms
(24.05%)
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
  354333
  384065
  385547
  389236
  390857
  398444
  418254
  426467
  426793
  441798
  457806
  482615
  487621
  516981
  521693
  540183
  548301
  577558
  595964
  610797
  629971
  639986
  670816
  679499
  680611
  688880
  689187
  700900
  703721
  709383
  713964
  715741
  722118
  726325
  726723
  727505
  727549
  727550
  728176
  728178
  728196
  728203
  729230
  729278
  734344
  734358
  734366
  736755
  740487
  742830
  742838
  743965
  744154
  744158
  744782
  747489
  747566
  747822
  748536
  750377
  752896
  752942
  757262
  761279
  761288
  767479
  767515
  768896
  774156
  775596
  775601
  777133
  780310
  780372
  780377
  782764
  782774
  788217
  788596
  792197
  792204
  793763
  794459
  794462
  794464
  794481
  795016
  795035
  795104
  795885
  800056
  800082
  800137
  800182
  800252
  801167
  801608
  801616
  802336
  803256
  804413
  812316
  812424
  812429
  813161
  813172
  813313
  819143
  819748
  820198
  823255
  824954
  824957
  825159
  825947
  826489
  826595
  826619
  826880
  827286
]
12.61 ms
(2.13%)
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
  734344
  819143
  802336
  728176
  734366
  780372
  792204
  354333
  390857
  824954
  826619
  820198
  819748
  540183
  715741
  722118
  639986
  775596
  782764
  727550
  747489
  750377
  728178
  729278
  736755
  729230
  742830
  795885
  813313
  680611
  777133
  794481
  795104
  803256
  744158
  782774
  792197
  426793
  426467
  767515
  788596
  728203
  774156
  747822
  727549
  768896
  780310
  801608
  804413
  823255
  824957
  826489
  826595
  825159
  825947
  827286
  516981
  521693
  577558
  709383
  689187
  610797
  595964
  780377
  793763
  800082
  800182
  795035
  800056
  761288
  752896
  742838
  748536
  757262
  761279
  794464
  384065
  389236
  812429
  398444
  679499
  788217
  801167
  813161
  767479
  728196
  747566
  813172
  441798
  418254
  457806
  487621
  385547
  826880
  482615
  548301
  703721
  713964
  670816
  688880
  700900
  629971
  794462
  800252
  801616
  812424
  775601
  800137
  743965
  794459
  795016
  812316
  734358
  726325
  740487
  752942
  726723
  727505
  744154
  744782
]
3.17 ms
(0.54%)
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
  354333
  384065
  385547
  389236
  390857
  398444
  418254
  426467
  426793
  441798
  457806
  482615
  487621
  516981
  521693
  540183
  548301
  577558
  595964
  610797
  629971
  639986
  670816
  679499
  680611
  688880
  689187
  700900
  703721
  709383
  713964
  715741
  722118
  726325
  726723
  727505
  727549
  727550
  728176
  728178
  728196
  728203
  729230
  729278
  734344
  734358
  734366
  736755
  740487
  742830
  742838
  743965
  744154
  744158
  744782
  747489
  747566
  747822
  748536
  750377
  752896
  752942
  757262
  761279
  761288
  767479
  767515
  768896
  774156
  775596
  775601
  777133
  780310
  780372
  780377
  782764
  782774
  788217
  788596
  792197
  792204
  793763
  794459
  794462
  794464
  794481
  795016
  795035
  795104
  795885
  800056
  800082
  800137
  800182
  800252
  801167
  801608
  801616
  802336
  803256
  804413
  812316
  812424
  812429
  813161
  813172
  813313
  819143
  819748
  820198
  823255
  824954
  824957
  825159
  825947
  826489
  826595
  826619
  826880
  827286
]
2.03 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy in face"
]
1.57 ms
(0.26%)
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.