Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.98 ms
(84.69%)
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
  393508
  395427
  395531
  395699
  398224
  400498
  401957
  407111
  407709
  408437
  413090
  413097
  413164
  415584
  418974
  421822
  421834
  421865
  424125
  425976
  426015
  428532
  428539
  428809
  428852
  433351
  439648
  442418
  443158
  443167
  443180
  443181
  443185
  443675
  443692
  444468
  446277
  446306
  446622
  449232
  450158
  453452
  454257
  454421
  455183
  455989
  457191
  457194
  457686
  460156
  460178
  460191
  461374
  463703
  465366
  466709
  467663
  469466
  471408
  472164
  474792
  475175
  477987
  479177
  480833
  480982
  482239
  486902
  492309
  493198
  509382
  513784
  514122
  515849
  516832
  517011
  521490
  527658
  528390
  528826
  531923
  532062
  532127
  537126
  544103
  548864
  549644
  550223
  550224
  553915
  561463
  563142
  563436
  563445
  565012
  571129
  584765
  586314
  604681
  607030
  663929
  665233
  693629
  706294
  718558
  724156
  726871
  737152
  740183
  748228
  748231
  753722
  756209
  758174
  764698
  774316
  796203
  799357
]
15.50 ms
(8.21%)
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
  444468
  457194
  433351
  475175
  400498
  439648
  421834
  407111
  517011
  563436
  469466
  395531
  407709
  413097
  426015
  413164
  455989
  482239
  467663
  472164
  584765
  401957
  450158
  460191
  471408
  443692
  454257
  460178
  443158
  537126
  492309
  421822
  514122
  393508
  395427
  428539
  428852
  442418
  443181
  443180
  446622
  460156
  461374
  449232
  466709
  513784
  532127
  544103
  553915
  550223
  563142
  563445
  703562
  550224
  604681
  586314
  799357
  726871
  774316
  737152
  796203
  474792
  477987
  415584
  479177
  424125
  493198
  521490
  425976
  486902
  457686
  756209
  480982
  413090
  509382
  748228
  706294
  408437
  748231
  398224
  395699
  428809
  443675
  443185
  453452
  463703
  465366
  446277
  446306
  532062
  516832
  528390
  531923
  548864
  549644
  565012
  663929
  665233
  693629
  718558
  571129
  607030
  779905
  740183
  758174
  724156
  753722
  764698
  457191
  418974
  455183
  480833
  515849
  527658
  528826
  443167
  421865
  454421
  561463
  428532
]
5.94 ms
(3.14%)
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
  393508
  395427
  395531
  395699
  398224
  400498
  401957
  407111
  407709
  408437
  413090
  413097
  413164
  415584
  418974
  421822
  421834
  421865
  424125
  425976
  426015
  428532
  428539
  428809
  428852
  433351
  439648
  442418
  443158
  443167
  443180
  443181
  443185
  443675
  443692
  444468
  446277
  446306
  446622
  449232
  450158
  453452
  454257
  454421
  455183
  455989
  457191
  457194
  457686
  460156
  460178
  460191
  461374
  463703
  465366
  466709
  467663
  469466
  471408
  472164
  474792
  475175
  477987
  479177
  480833
  480982
  482239
  486902
  492309
  493198
  509382
  513784
  514122
  515849
  516832
  517011
  521490
  527658
  528390
  528826
  531923
  532062
  532127
  537126
  544103
  548864
  549644
  550223
  550224
  553915
  561463
  563142
  563436
  563445
  565012
  571129
  584765
  586314
  604681
  607030
  663929
  665233
  693629
  706294
  718558
  724156
  726871
  737152
  740183
  748228
  748231
  753722
  756209
  758174
  764698
  774316
  796203
  799357
]
1.97 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "son blowjob"
]
1.93 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "son минет оральн секс"
]
1.80 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "son минет оральн секс"
]

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.