Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
195.89 ms
(87.75%)
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
  7161
  91344
  95673
  118284
  118479
  154826
  229105
  233025
  293499
  381964
  382165
  382430
  383924
  384108
  385225
  386345
  387218
  387937
  392100
  393326
  396071
  398741
  401479
  401532
  406817
  408692
  414292
  414337
  415292
  417348
  424581
  425707
  428568
  432683
  441095
  442117
  443087
  443097
  445397
  445470
  445745
  447920
  448873
  449070
  451266
  451609
  451758
  452746
  453585
  453788
  453822
  454270
  460533
  461924
  466991
  467155
  470412
  471312
  475502
  475504
  477052
  478442
  478512
  485338
  488713
  493477
  494999
  495737
  501611
  506149
  506268
  507661
  507696
  507772
  508935
  510812
  515969
  520713
  524791
  534567
  534627
  544819
  555023
  556872
  556906
  557336
  559194
  559910
  565256
  565539
  566786
  580773
  583943
  592259
  593292
  622329
  628087
  628384
  632046
  632588
  634561
  639379
  646884
  666535
  666550
  666875
  666878
  688105
  694178
  720306
  725382
  726292
  736022
  743893
  760381
  760392
  789223
  790392
  790876
  827737
]
17.06 ms
(7.64%)
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
  392100
  385225
  382430
  406817
  293499
  485338
  453822
  466991
  556906
  453585
  415292
  449070
  424581
  506268
  566786
  398741
  95673
  414292
  401479
  694178
  386345
  381964
  583943
  442117
  443097
  451758
  495737
  559910
  556872
  445397
  471312
  460533
  488713
  593292
  534567
  666550
  445745
  501611
  118479
  118284
  393326
  827737
  233025
  417348
  557336
  384108
  408692
  646884
  632588
  632046
  467155
  387218
  428568
  441095
  478512
  524791
  510812
  639379
  451609
  506149
  494999
  622329
  396071
  520713
  666535
  666875
  666878
  628384
  493477
  387937
  425707
  507696
  544819
  790392
  7161
  91344
  432683
  452746
  559194
  443087
  507661
  592259
  461924
  451266
  454270
  565256
  580773
  628087
  229105
  382165
  453788
  790876
  447920
  534627
  634561
  414337
  448873
  470412
  565539
  555023
  515969
  154826
  401532
  477052
  475502
  478442
  507772
  508935
  475504
  688105
  720306
  726292
  736022
  760381
  789223
  760392
  743893
  725382
  383924
  445470
]
3.17 ms
(1.42%)
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
  7161
  91344
  95673
  118284
  118479
  154826
  229105
  233025
  293499
  381964
  382165
  382430
  383924
  384108
  385225
  386345
  387218
  387937
  392100
  393326
  396071
  398741
  401479
  401532
  406817
  408692
  414292
  414337
  415292
  417348
  424581
  425707
  428568
  432683
  441095
  442117
  443087
  443097
  445397
  445470
  445745
  447920
  448873
  449070
  451266
  451609
  451758
  452746
  453585
  453788
  453822
  454270
  460533
  461924
  466991
  467155
  470412
  471312
  475502
  475504
  477052
  478442
  478512
  485338
  488713
  493477
  494999
  495737
  501611
  506149
  506268
  507661
  507696
  507772
  508935
  510812
  515969
  520713
  524791
  534567
  534627
  544819
  555023
  556872
  556906
  557336
  559194
  559910
  565256
  565539
  566786
  580773
  583943
  592259
  593292
  622329
  628087
  628384
  632046
  632588
  634561
  639379
  646884
  666535
  666550
  666875
  666878
  688105
  694178
  720306
  725382
  726292
  736022
  743893
  760381
  760392
  789223
  790392
  790876
  827737
]
2.05 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "фистинг мужика порно"
]
1.82 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг мужчин порн"
]
1.65 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.72%)
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.