Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.94 ms
(86.47%)
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
  393248
  396021
  424072
  437767
  453747
  489916
  506963
  508394
  513323
  531396
  533829
  539226
  560259
  564533
  584961
  600328
  610052
  614035
  617213
  617807
  620255
  620662
  621086
  625026
  632128
  633577
  639571
  641569
  645761
  646077
  646244
  648612
  650100
  650344
  652979
  655214
  655241
  657228
  666398
  668662
  669967
  672968
  675193
  683052
  685433
  692517
  695690
  699602
  701282
  710837
  712213
  715774
  716719
  717432
  719731
  719797
  719799
  722701
  723566
  726082
  726143
  727785
  727792
  727969
  729657
  734708
  740603
  740791
  740893
  740997
  741035
  742239
  744656
  747674
  751728
  753966
  756661
  758237
  758528
  762041
  762436
  763460
  763537
  768727
  769423
  772404
  773084
  773463
  777851
  777861
  778757
  779507
  781624
  783744
  788334
  789436
  791233
  792335
  793765
  793774
  794957
  795074
  798629
  799324
  799898
  800199
  801524
  801921
  802852
  802880
  803277
  804526
  805527
  809329
  810624
  811653
  811735
  812053
  813953
  814521
]
10.87 ms
(6.92%)
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
  424072
  396021
  506963
  533829
  675193
  685433
  648612
  672968
  683052
  701282
  710837
  719799
  560259
  639571
  779507
  801921
  783744
  794957
  740893
  753966
  795074
  802880
  803277
  809329
  811735
  747674
  762041
  729657
  727969
  740603
  758237
  621086
  712213
  715774
  793774
  437767
  393248
  813953
  489916
  531396
  692517
  695690
  717432
  650100
  650344
  666398
  722701
  668662
  719797
  610052
  793765
  798629
  804526
  778757
  802852
  768727
  772404
  788334
  799324
  811653
  762436
  751728
  763460
  741035
  763537
  726082
  734708
  740791
  769423
  773084
  617807
  632128
  719731
  777851
  777861
  792335
  799898
  800199
  810624
  814521
  508394
  513323
  564533
  646244
  669967
  614035
  620255
  600328
  617213
  791233
  801524
  758528
  805527
  742239
  773463
  727792
  726143
  727785
  740997
  744656
  756661
  625026
  699602
  716719
  781624
  789436
  812053
  723566
  453747
  539226
  645761
  657228
  655214
  646077
  652979
  655241
  584961
  641569
  620662
  633577
]
3.12 ms
(1.98%)
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
  393248
  396021
  424072
  437767
  453747
  489916
  506963
  508394
  513323
  531396
  533829
  539226
  560259
  564533
  584961
  600328
  610052
  614035
  617213
  617807
  620255
  620662
  621086
  625026
  632128
  633577
  639571
  641569
  645761
  646077
  646244
  648612
  650100
  650344
  652979
  655214
  655241
  657228
  666398
  668662
  669967
  672968
  675193
  683052
  685433
  692517
  695690
  699602
  701282
  710837
  712213
  715774
  716719
  717432
  719731
  719797
  719799
  722701
  723566
  726082
  726143
  727785
  727792
  727969
  729657
  734708
  740603
  740791
  740893
  740997
  741035
  742239
  744656
  747674
  751728
  753966
  756661
  758237
  758528
  762041
  762436
  763460
  763537
  768727
  769423
  772404
  773084
  773463
  777851
  777861
  778757
  779507
  781624
  783744
  788334
  789436
  791233
  792335
  793765
  793774
  794957
  795074
  798629
  799324
  799898
  800199
  801524
  801921
  802852
  802880
  803277
  804526
  805527
  809329
  810624
  811653
  811735
  812053
  813953
  814521
]
2.13 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "глубокий секс"
]
1.90 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "глубок секс"
]
1.72 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 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.