Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.43 ms
(53.46%)
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
  391762
  398009
  400620
  420405
  421762
  449222
  449800
  458127
  465486
  489258
  493402
  500067
  509163
  516488
  536145
  538619
  540805
  541559
  546893
  562984
  567655
  574157
  575627
  588531
  596533
  599464
  607253
  616509
  616569
  624592
  639681
  644276
  650728
  651977
  656631
  662889
  675494
  675613
  677191
  687463
  689040
  696104
  696113
  698735
  699519
  699543
  700689
  704138
  704840
  706895
  714383
  714953
  715407
  719113
  726313
  728373
  734268
  734620
  735900
  736727
  738514
  738911
  740166
  741318
  746536
  747982
  750129
  751213
  755172
  756972
  757914
  759008
  759874
  760278
  761546
  763832
  763922
  769201
  771894
  773682
  776216
  777109
  778079
  778604
  779889
  781136
  783379
  785684
  786089
  786101
  787040
  787280
  787282
  787769
  788918
  790298
  791247
  791411
  794109
  794439
  794715
  794724
  795236
  795669
  796022
  796051
  796117
  796199
  797174
  797473
  801051
  802520
  808774
  808856
  809985
  810114
  813537
  824972
]
164.04 ms
(41.67%)
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
  391762
  398009
  400620
  420405
  421762
  449222
  449800
  458127
  465486
  489258
  493402
  500067
  509163
  516488
  536145
  538619
  540805
  541559
  546893
  562984
  567655
  574157
  575627
  588531
  596533
  599464
  607253
  616509
  616569
  624592
  639681
  644276
  650728
  651977
  656631
  662889
  675494
  675613
  677191
  687463
  689040
  696104
  696113
  698735
  699519
  699543
  700689
  704138
  704840
  706895
  714383
  714953
  715407
  719113
  726313
  728373
  734268
  734620
  735900
  736727
  738514
  738911
  740166
  741318
  746536
  747982
  750129
  751213
  755172
  756972
  757914
  759008
  759874
  760278
  761546
  763832
  763922
  769201
  771894
  773682
  776216
  777109
  778079
  778604
  779889
  781136
  783379
  785684
  786089
  786101
  787040
  787280
  787282
  787769
  788918
  790298
  791247
  791411
  794109
  794439
  794715
  794724
  795236
  795669
  796022
  796051
  796117
  796199
  797174
  797473
  801051
  802520
  808774
  808856
  809985
  810114
  813537
  824972
]
12.16 ms
(3.09%)
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
  795236
  808856
  726313
  746536
  771894
  735900
  747982
  755172
  763832
  773682
  777182
  787769
  489258
  493402
  400620
  420405
  449800
  536145
  567655
  575627
  574157
  541559
  651977
  677191
  715407
  689040
  696113
  704138
  714383
  719113
  675613
  704840
  596533
  639681
  599464
  624592
  776216
  777109
  778604
  785684
  790298
  794715
  802520
  778079
  779889
  786089
  794109
  796051
  786101
  791411
  797473
  809985
  810114
  734268
  756972
  728373
  738911
  750129
  759008
  769201
  741318
  761546
  700689
  787040
  794724
  796117
  398009
  540805
  465486
  449222
  500067
  516488
  644276
  391762
  421762
  824972
  458127
  509163
  538619
  546893
  562984
  656631
  699519
  650728
  687463
  696104
  698735
  662889
  675494
  699543
  706895
  714953
  607253
  616509
  588531
  616569
  781136
  787280
  791247
  796022
  797174
  788918
  794439
  796199
  801051
  808774
  813537
  734988
  760278
  783379
  787282
  795669
  734620
  738514
  736727
  757914
  763922
  751213
  759874
  740166
]
1.99 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum in creampie"
]
1.87 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum creampie"
]
1.74 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum creampie"
]

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.