Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.64 ms
(86.95%)
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
  15162
  382078
  388696
  393145
  393233
  395937
  395946
  396724
  399378
  412852
  414050
  414132
  415618
  416527
  416531
  416690
  416746
  422676
  425913
  428171
  428786
  431439
  431911
  445413
  447534
  454081
  456555
  470278
  473127
  473213
  474596
  475335
  477760
  480206
  483543
  497693
  500336
  505143
  505800
  507956
  511864
  512152
  523190
  527915
  530805
  531913
  533982
  535651
  536783
  541421
  541845
  544838
  545453
  546202
  548153
  550922
  554137
  559951
  584112
  595145
  604553
  609889
  618364
  628111
  633458
  637654
  639279
  642162
  643233
  651957
  658816
  662026
  662046
  674936
  674966
  678052
  680100
  693291
  711615
  722527
  722638
  725038
  726292
  737552
  738435
  740934
  741252
  744047
  745092
  747155
  747597
  752105
  752610
  752623
  752630
  752711
  757905
  758189
  758196
  761572
  761632
  762222
  770210
  770265
  770797
  771355
  778042
  782839
  788852
  792715
  792726
  792799
  800538
  801275
  801311
  804306
  806324
  806541
  825876
]
16.54 ms
(7.79%)
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
  628111
  782849
  726292
  740934
  752610
  761572
  792799
  806541
  741252
  737552
  770210
  771355
  758189
  604553
  639279
  395946
  428171
  473127
  505800
  507956
  415618
  530805
  678052
  544838
  483543
  747597
  523190
  454081
  559951
  806324
  470278
  533982
  414132
  642162
  633458
  393145
  395937
  382078
  399378
  412852
  431439
  428786
  477760
  473213
  531913
  505143
  497693
  475335
  550922
  674936
  711615
  722527
  546202
  643233
  618364
  595145
  800538
  725038
  762222
  752105
  758196
  804306
  15162
  388696
  393233
  414050
  456555
  425913
  431911
  422676
  512152
  527915
  416527
  416531
  416690
  825876
  535651
  541845
  545453
  541421
  651957
  693291
  722638
  658816
  662026
  637654
  778042
  782839
  801311
  744047
  745092
  770797
  792726
  738435
  752711
  761632
  747155
  752623
  752630
  609889
  792715
  396724
  674966
  536783
  680100
  416746
  511864
  500336
  474596
  480206
  554137
  548153
  662046
  584112
  770265
  788852
  801275
  757905
  445413
  447534
]
4.33 ms
(2.04%)
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
  15162
  382078
  388696
  393145
  393233
  395937
  395946
  396724
  399378
  412852
  414050
  414132
  415618
  416527
  416531
  416690
  416746
  422676
  425913
  428171
  428786
  431439
  431911
  445413
  447534
  454081
  456555
  470278
  473127
  473213
  474596
  475335
  477760
  480206
  483543
  497693
  500336
  505143
  505800
  507956
  511864
  512152
  523190
  527915
  530805
  531913
  533982
  535651
  536783
  541421
  541845
  544838
  545453
  546202
  548153
  550922
  554137
  559951
  584112
  595145
  604553
  609889
  618364
  628111
  633458
  637654
  639279
  642162
  643233
  651957
  658816
  662026
  662046
  674936
  674966
  678052
  680100
  693291
  711615
  722527
  722638
  725038
  726292
  737552
  738435
  740934
  741252
  744047
  745092
  747155
  747597
  752105
  752610
  752623
  752630
  752711
  757905
  758189
  758196
  761572
  761632
  762222
  770210
  770265
  770797
  771355
  778042
  782839
  788852
  792715
  792726
  792799
  800538
  801275
  801311
  804306
  806324
  806541
  825876
]
2.08 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge anal teen"
]
1.67 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные анал teen"
]
1.55 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные анал teen"
]

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.