Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.79 ms
(84.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
  65228
  343078
  383088
  386989
  387007
  387615
  387919
  388754
  398842
  401584
  433826
  437809
  438017
  447136
  447966
  451608
  453747
  457344
  464419
  474263
  478329
  526031
  535704
  537645
  537756
  537941
  539204
  541543
  546666
  550720
  566290
  566752
  567568
  571961
  572538
  585992
  597507
  599050
  600058
  606788
  608519
  614755
  616772
  624994
  631296
  635662
  640304
  645149
  645593
  646129
  656546
  658015
  658035
  658094
  658215
  678008
  681281
  684254
  684410
  686271
  702959
  705398
  706754
  709393
  710063
  710323
  712071
  715881
  718545
  719486
  724395
  731753
  733276
  734731
  734986
  739041
  742239
  742956
  743118
  748197
  749557
  755659
  756256
  757012
  762844
  763068
  765947
  766519
  767443
  767962
  770505
  778058
  782638
  787605
  789524
  789780
  791182
  791306
  794052
  794178
  795130
  795536
  795614
  796086
  802312
  803497
  803821
  805509
  809957
  810974
  812083
  813329
  814182
  816637
  816744
  817039
  823526
  824268
  826241
  827573
]
13.71 ms
(8.38%)
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
  767443
  757012
  635662
  795130
  803821
  810974
  813329
  65228
  387919
  388754
  386989
  387007
  398842
  684254
  658035
  600058
  794052
  749557
  718545
  387615
  343078
  451608
  457344
  658015
  624994
  739041
  767962
  724395
  803497
  401584
  826241
  710063
  645149
  678008
  686271
  709393
  719486
  567568
  597507
  608519
  599050
  614755
  795614
  782638
  796086
  787605
  766519
  763068
  733276
  734986
  765947
  706754
  809957
  383088
  827573
  447966
  537756
  539204
  572538
  712071
  681281
  645593
  631296
  585992
  770505
  805509
  742239
  742956
  756256
  710323
  795536
  433826
  437809
  816637
  824268
  816744
  474263
  447136
  453747
  464419
  535704
  537645
  537941
  571961
  541543
  546666
  658094
  658215
  684410
  705398
  715881
  646129
  656546
  566752
  606788
  616772
  640304
  794178
  789524
  791182
  791306
  802312
  755659
  762844
  812083
  743118
  748197
  731753
  778058
  789780
  817039
  702959
  734731
  438017
  814182
  823526
  478329
  526031
  550720
  566290
]
3.25 ms
(1.99%)
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
  65228
  343078
  383088
  386989
  387007
  387615
  387919
  388754
  398842
  401584
  433826
  437809
  438017
  447136
  447966
  451608
  453747
  457344
  464419
  474263
  478329
  526031
  535704
  537645
  537756
  537941
  539204
  541543
  546666
  550720
  566290
  566752
  567568
  571961
  572538
  585992
  597507
  599050
  600058
  606788
  608519
  614755
  616772
  624994
  631296
  635662
  640304
  645149
  645593
  646129
  656546
  658015
  658035
  658094
  658215
  678008
  681281
  684254
  684410
  686271
  702959
  705398
  706754
  709393
  710063
  710323
  712071
  715881
  718545
  719486
  724395
  731753
  733276
  734731
  734986
  739041
  742239
  742956
  743118
  748197
  749557
  755659
  756256
  757012
  762844
  763068
  765947
  766519
  767443
  767962
  770505
  778058
  782638
  787605
  789524
  789780
  791182
  791306
  794052
  794178
  795130
  795536
  795614
  796086
  802312
  803497
  803821
  805509
  809957
  810974
  812083
  813329
  814182
  816637
  816744
  817039
  823526
  824268
  826241
  827573
]
2.25 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "love fuck"
]
2.12 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "love секс"
]
1.94 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "love секс"
]

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.