Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.82 ms
(86.80%)
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
  73724
  386285
  395892
  400440
  400454
  401260
  410173
  429342
  442781
  455226
  463168
  463170
  466851
  470840
  472766
  485902
  488004
  508076
  515217
  515219
  515245
  524012
  527513
  537568
  537755
  543870
  544358
  545734
  547276
  547282
  549940
  550620
  562928
  566009
  574201
  574286
  581628
  592837
  600165
  611309
  631220
  649996
  655101
  655314
  656046
  656739
  657034
  658292
  658413
  659608
  665502
  670081
  670175
  671882
  681808
  682022
  683515
  683538
  683825
  685992
  686040
  686652
  689370
  689757
  693852
  694600
  695758
  696277
  700546
  702360
  712794
  712925
  713262
  715560
  718194
  720628
  722654
  722889
  722916
  723406
  724710
  728350
  734508
  737482
  739168
  744254
  745764
  748128
  748553
  759563
  759585
  759656
  759662
  761005
  766028
  766796
  774178
  779832
  788595
  788670
  789210
  789304
  794610
  795286
  800560
  803083
  814065
  815878
  817629
  817677
  817678
  818316
  818639
  818656
  820732
  823152
  823365
  823688
  825184
  827660
]
14.32 ms
(7.45%)
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
  748128
  759563
  724710
  761005
  774178
  713262
  722889
  722916
  788595
  386285
  442781
  463170
  472766
  400440
  401260
  455226
  466851
  395892
  400454
  429342
  463168
  470840
  508076
  485902
  515219
  527513
  488004
  515217
  524012
  73724
  410173
  823152
  817677
  823688
  825184
  814065
  815878
  817629
  817678
  818316
  818639
  818656
  820732
  823365
  827660
  537755
  537568
  515245
  547276
  550620
  581628
  543870
  562928
  544358
  545734
  547282
  549940
  574286
  655314
  665502
  671882
  683515
  683538
  693852
  695758
  696277
  700546
  702360
  712925
  715560
  657034
  659608
  682022
  683825
  685992
  686040
  686652
  689757
  712794
  718194
  720628
  722654
  723406
  649996
  655101
  656046
  656739
  658292
  658413
  670081
  670175
  681808
  689370
  694600
  566009
  574201
  600165
  611309
  592837
  631220
  788670
  789210
  789304
  800560
  779832
  795286
  734508
  737482
  744254
  745764
  759585
  794610
  803083
  739168
  748553
  759656
  759662
  766028
  766796
  728350
]
2.83 ms
(1.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.79 ms
(1.45%)
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
  73724
  386285
  395892
  400440
  400454
  401260
  410173
  429342
  442781
  455226
  463168
  463170
  466851
  470840
  472766
  485902
  488004
  508076
  515217
  515219
  515245
  524012
  527513
  537568
  537755
  543870
  544358
  545734
  547276
  547282
  549940
  550620
  562928
  566009
  574201
  574286
  581628
  592837
  600165
  611309
  631220
  649996
  655101
  655314
  656046
  656739
  657034
  658292
  658413
  659608
  665502
  670081
  670175
  671882
  681808
  682022
  683515
  683538
  683825
  685992
  686040
  686652
  689370
  689757
  693852
  694600
  695758
  696277
  700546
  702360
  712794
  712925
  713262
  715560
  718194
  720628
  722654
  722889
  722916
  723406
  724710
  728350
  734508
  737482
  739168
  744254
  745764
  748128
  748553
  759563
  759585
  759656
  759662
  761005
  766028
  766796
  774178
  779832
  788595
  788670
  789210
  789304
  794610
  795286
  800560
  803083
  814065
  815878
  817629
  817677
  817678
  818316
  818639
  818656
  820732
  823152
  823365
  823688
  825184
  827660
]
2.18 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young young"
]
1.81 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young young"
]
1.45 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young young"
]

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.