Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
635.73 ms
(78.02%)
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
  386719
  414688
  415833
  472352
  399023
  512838
  491143
  549306
  571643
  559902
  715453
  552192
  792057
  399306
  476060
  619435
  789213
  699602
  382957
  382545
  425590
  424181
  435520
  457979
  470794
  440986
  538191
  575485
  564461
  561734
  636270
  388378
  436642
  820416
  558619
  569878
  570354
  542144
  553722
  558987
  566867
  569852
  571893
  575070
  657066
  677343
  718561
  721426
  656466
  663414
  674216
  554540
  556362
  571887
  572436
  573685
  576307
  598812
  607203
  613471
  622210
  623628
  635236
  596545
  596653
  606749
  611754
  611924
  600063
  624240
  607285
  804753
  730642
  730764
  740331
  754128
  753814
  755178
  743877
  612106
  613155
  714439
  721793
  386204
  474072
  390592
  382734
  812143
  389728
  500712
  536096
  501678
  561725
  564086
  679372
  680616
  710970
  608426
  742035
  806045
  811814
  728196
  771740
  745012
  623209
  785922
  790966
  418659
  476266
  820122
  577614
  548660
  572508
  570525
  573286
  558573
  569913
  570672
  571585
  574978
]
169.53 ms
(20.81%)
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
  382545
  382734
  382957
  386204
  386719
  388378
  389728
  390592
  399023
  399306
  414688
  415833
  418659
  424181
  425590
  435520
  436642
  440986
  457979
  470794
  472352
  474072
  476060
  476266
  491143
  500712
  501678
  512838
  536096
  538191
  542144
  548660
  549306
  552192
  553722
  554540
  556362
  558573
  558619
  558987
  559902
  561725
  561734
  564086
  564461
  566867
  569852
  569878
  569913
  570354
  570525
  570672
  571585
  571643
  571887
  571893
  572436
  572508
  573286
  573685
  574978
  575070
  575485
  576307
  577614
  596545
  596653
  598812
  600063
  606749
  607203
  607285
  608426
  611754
  611924
  612106
  613155
  613471
  619435
  622210
  623209
  623628
  624240
  635236
  636270
  656466
  657066
  663414
  674216
  677343
  679372
  680616
  699602
  710970
  714439
  715453
  718561
  721426
  721793
  728196
  730642
  730764
  740331
  742035
  743877
  745012
  753814
  754128
  755178
  771740
  785922
  789213
  790966
  792057
  804753
  806045
  811814
  812143
  820122
  820416
]
2.45 ms
(0.30%)
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
  382545
  382734
  382957
  386204
  386719
  388378
  389728
  390592
  399023
  399306
  414688
  415833
  418659
  424181
  425590
  435520
  436642
  440986
  457979
  470794
  472352
  474072
  476060
  476266
  491143
  500712
  501678
  512838
  536096
  538191
  542144
  548660
  549306
  552192
  553722
  554540
  556362
  558573
  558619
  558987
  559902
  561725
  561734
  564086
  564461
  566867
  569852
  569878
  569913
  570354
  570525
  570672
  571585
  571643
  571887
  571893
  572436
  572508
  573286
  573685
  574978
  575070
  575485
  576307
  577614
  596545
  596653
  598812
  600063
  606749
  607203
  607285
  608426
  611754
  611924
  612106
  613155
  613471
  619435
  622210
  623209
  623628
  624240
  635236
  636270
  656466
  657066
  663414
  674216
  677343
  679372
  680616
  699602
  710970
  714439
  715453
  718561
  721426
  721793
  728196
  730642
  730764
  740331
  742035
  743877
  745012
  753814
  754128
  755178
  771740
  785922
  789213
  790966
  792057
  804753
  806045
  811814
  812143
  820122
  820416
]
2.17 ms
(0.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy маленькая"
]
1.80 ms
(0.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy маленькая"
]
1.66 ms
(0.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy small"
]
1.45 ms
(0.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.