Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.11 ms
(85.67%)
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
  384593
  399017
  399332
  408326
  417821
  418803
  419764
  429338
  442832
  445057
  446518
  447645
  447659
  448709
  451708
  453352
  457145
  459378
  463141
  464280
  464320
  467200
  468579
  468588
  468773
  470514
  472830
  473073
  473955
  477678
  477732
  477906
  484878
  486275
  486704
  487123
  489551
  491458
  491475
  496272
  506328
  507362
  511724
  517044
  522919
  524664
  525686
  527495
  538216
  547518
  548536
  549090
  549332
  553128
  554425
  554639
  557983
  558026
  558308
  559024
  560183
  561660
  562128
  562148
  562198
  563278
  564136
  565420
  565956
  566272
  570481
  574959
  575425
  576279
  577328
  577377
  577399
  578070
  578178
  578492
  578851
  579321
  581649
  583671
  584706
  593122
  596635
  598490
  598703
  599418
  599501
  600084
  600246
  601065
  603931
  604425
  608765
  609886
  610201
  612099
  621120
  623120
  637436
  657363
  659501
  671670
  682912
  683955
  688049
  692050
  693182
  696976
  712025
  715860
  720491
  729065
  743086
  746155
  775797
  822360
]
15.20 ms
(8.91%)
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
  683955
  558026
  576279
  583671
  429338
  442832
  446518
  451708
  459378
  457145
  468579
  473073
  507362
  557983
  577377
  419764
  477906
  468588
  473955
  464320
  464280
  468773
  470514
  522919
  524664
  486275
  486704
  491475
  506328
  511724
  517044
  484878
  525686
  527495
  538216
  418803
  408326
  577399
  563278
  657363
  579321
  609886
  489551
  554639
  549090
  575425
  549332
  558308
  560183
  577328
  578178
  562198
  574959
  578070
  581649
  659501
  692050
  682912
  548536
  559024
  562148
  565420
  565956
  570481
  578492
  578851
  584706
  593122
  598490
  600246
  603931
  599418
  637436
  596635
  599501
  598703
  601065
  621120
  746155
  623120
  566272
  554425
  564136
  600084
  612099
  399017
  417821
  561660
  688049
  671670
  729065
  743086
  696976
  712025
  715860
  608765
  562128
  775797
  453352
  491458
  384593
  399332
  445057
  822360
  447645
  448709
  472830
  477678
  447659
  496272
  487123
  547518
  693182
  553128
  604425
  610201
  720491
  463141
  467200
  477732
]
2.30 ms
(1.35%)
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
  384593
  399017
  399332
  408326
  417821
  418803
  419764
  429338
  442832
  445057
  446518
  447645
  447659
  448709
  451708
  453352
  457145
  459378
  463141
  464280
  464320
  467200
  468579
  468588
  468773
  470514
  472830
  473073
  473955
  477678
  477732
  477906
  484878
  486275
  486704
  487123
  489551
  491458
  491475
  496272
  506328
  507362
  511724
  517044
  522919
  524664
  525686
  527495
  538216
  547518
  548536
  549090
  549332
  553128
  554425
  554639
  557983
  558026
  558308
  559024
  560183
  561660
  562128
  562148
  562198
  563278
  564136
  565420
  565956
  566272
  570481
  574959
  575425
  576279
  577328
  577377
  577399
  578070
  578178
  578492
  578851
  579321
  581649
  583671
  584706
  593122
  596635
  598490
  598703
  599418
  599501
  600084
  600246
  601065
  603931
  604425
  608765
  609886
  610201
  612099
  621120
  623120
  637436
  657363
  659501
  671670
  682912
  683955
  688049
  692050
  693182
  696976
  712025
  715860
  720491
  729065
  743086
  746155
  775797
  822360
]
1.87 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small dick man"
]
1.83 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая член мужчин"
]
1.51 ms
(0.89%)
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.