Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.52 ms
(83.25%)
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
  146800
  148814
  401813
  411009
  414240
  416025
  420835
  420866
  421856
  426043
  426486
  431385
  434307
  440642
  444086
  446860
  448328
  458109
  468678
  473437
  475762
  507171
  511857
  512495
  513172
  520138
  524512
  586375
  586891
  587295
  588525
  588852
  589229
  590061
  598284
  599709
  600613
  607997
  609976
  610249
  622318
  622658
  623509
  630478
  640948
  642219
  643423
  656938
  679563
  687399
  689323
  701291
  702695
  713240
  716140
  724929
  726454
  727685
  738451
  739150
  741256
  741526
  742346
  744205
  744697
  746187
  747376
  751281
  752750
  754516
  755343
  756843
  758286
  758812
  762149
  769000
  770062
  770379
  770438
  770860
  773182
  774881
  778331
  780380
  785707
  786390
  788215
  788319
  793017
  793266
  798674
  799699
  801892
  802367
  803110
  806919
  807111
  807160
  809032
  809077
  809080
  809086
  812543
  812920
  813188
  813800
  815174
  815949
  815965
  816126
  817146
  817334
  817782
  822638
  824438
  824724
  826102
  826223
  827506
]
14.83 ms
(10.42%)
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
  656938
  679563
  687399
  689323
  630478
  586891
  598284
  610249
  586375
  587295
  600613
  590061
  607997
  609976
  622318
  643423
  778331
  793266
  798674
  807160
  809077
  809086
  774881
  780380
  785707
  786390
  809032
  809080
  724929
  727685
  747376
  793017
  799699
  801892
  802367
  812920
  726454
  738451
  739150
  741256
  746187
  769000
  770379
  742346
  754516
  770860
  744205
  751281
  756843
  758286
  758812
  762149
  770438
  773182
  622658
  623509
  642219
  701291
  702695
  776045
  788215
  788319
  807111
  812543
  813188
  146800
  148814
  431385
  416025
  426043
  421856
  434307
  468678
  511857
  512495
  520138
  524512
  414240
  426486
  458109
  513172
  713240
  716140
  588852
  599709
  589229
  770062
  755343
  741526
  444086
  448328
  507171
  806919
  803110
  744697
  752750
  640948
  588525
  401813
  420866
  411009
  420835
  440642
  815174
  817334
  824438
  826102
  817782
  822638
  824724
  827506
  813800
  815949
  815965
  816126
  817146
  826223
  475762
  446860
  473437
]
2.26 ms
(1.58%)
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
  146800
  148814
  401813
  411009
  414240
  416025
  420835
  420866
  421856
  426043
  426486
  431385
  434307
  440642
  444086
  446860
  448328
  458109
  468678
  473437
  475762
  507171
  511857
  512495
  513172
  520138
  524512
  586375
  586891
  587295
  588525
  588852
  589229
  590061
  598284
  599709
  600613
  607997
  609976
  610249
  622318
  622658
  623509
  630478
  640948
  642219
  643423
  656938
  679563
  687399
  689323
  701291
  702695
  713240
  716140
  724929
  726454
  727685
  738451
  739150
  741256
  741526
  742346
  744205
  744697
  746187
  747376
  751281
  752750
  754516
  755343
  756843
  758286
  758812
  762149
  769000
  770062
  770379
  770438
  770860
  773182
  774881
  778331
  780380
  785707
  786390
  788215
  788319
  793017
  793266
  798674
  799699
  801892
  802367
  803110
  806919
  807111
  807160
  809032
  809077
  809080
  809086
  812543
  812920
  813188
  813800
  815174
  815949
  815965
  816126
  817146
  817334
  817782
  822638
  824438
  824724
  826102
  826223
  827506
]
2.15 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation oil"
]
1.62 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац масл"
]
1.61 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.