Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.57 ms
(83.72%)
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
  43250
  97047
  97107
  326081
  388091
  389315
  396753
  397057
  403966
  409452
  413446
  420562
  423609
  432745
  454984
  471992
  477553
  489280
  500971
  508564
  517840
  527386
  534064
  537198
  538255
  545418
  545488
  549092
  559178
  564392
  564528
  566789
  575566
  583472
  586294
  586886
  587761
  589042
  602966
  604222
  604553
  605334
  607248
  621029
  626021
  627412
  628602
  632674
  633895
  637128
  637129
  639184
  644330
  644952
  649148
  652831
  656924
  662022
  662389
  670096
  670719
  675809
  679445
  685013
  685819
  686511
  689442
  689949
  691409
  692324
  692438
  695278
  695280
  695878
  699201
  703070
  703098
  705794
  705906
  709684
  710056
  712887
  714556
  717897
  718983
  719335
  720481
  720673
  721412
  721417
  727807
  732954
  733246
  733857
  739993
  743497
  748539
  748816
  749269
  750359
  758599
  759910
  761582
  766830
  767287
  768347
  770413
  775776
  775899
  775934
  784391
  785503
  788580
  791127
  791844
  792246
  799944
  817423
  825442
  827829
]
17.41 ms
(10.52%)
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
  686511
  705794
  712887
  628602
  627412
  775899
  792246
  732954
  758599
  759910
  768347
  791127
  799944
  749269
  703070
  709684
  396753
  775776
  559178
  538255
  662389
  637128
  750359
  471992
  534064
  717897
  691409
  500971
  545488
  586886
  602966
  97107
  43250
  817423
  827829
  685819
  607248
  739993
  743497
  639184
  718983
  720673
  420562
  326081
  397057
  403966
  97047
  413446
  423609
  432745
  644952
  477553
  527386
  508564
  564392
  575566
  583472
  564528
  714556
  652831
  699201
  656924
  689442
  695878
  719335
  720481
  586294
  637129
  604222
  632674
  605334
  775934
  788580
  727807
  748539
  748816
  767287
  784391
  785503
  791844
  733246
  733857
  766830
  761582
  770413
  604553
  644330
  705906
  545418
  537198
  566789
  454984
  489280
  389315
  388091
  409452
  825442
  517840
  549092
  670719
  692324
  692438
  695280
  703098
  649148
  670096
  675809
  685013
  662022
  679445
  689949
  695278
  710056
  721412
  721417
  587761
  626021
  589042
  621029
  633895
]
2.76 ms
(1.67%)
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
  43250
  97047
  97107
  326081
  388091
  389315
  396753
  397057
  403966
  409452
  413446
  420562
  423609
  432745
  454984
  471992
  477553
  489280
  500971
  508564
  517840
  527386
  534064
  537198
  538255
  545418
  545488
  549092
  559178
  564392
  564528
  566789
  575566
  583472
  586294
  586886
  587761
  589042
  602966
  604222
  604553
  605334
  607248
  621029
  626021
  627412
  628602
  632674
  633895
  637128
  637129
  639184
  644330
  644952
  649148
  652831
  656924
  662022
  662389
  670096
  670719
  675809
  679445
  685013
  685819
  686511
  689442
  689949
  691409
  692324
  692438
  695278
  695280
  695878
  699201
  703070
  703098
  705794
  705906
  709684
  710056
  712887
  714556
  717897
  718983
  719335
  720481
  720673
  721412
  721417
  727807
  732954
  733246
  733857
  739993
  743497
  748539
  748816
  749269
  750359
  758599
  759910
  761582
  766830
  767287
  768347
  770413
  775776
  775899
  775934
  784391
  785503
  788580
  791127
  791844
  792246
  799944
  817423
  825442
  827829
]
2.12 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double anal teens"
]
1.61 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double анал teens"
]
1.53 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double анал teens"
]
1.52 ms
(0.92%)
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.