Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.59 ms
(56.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск минет оральн секс рыжая"
]
131.97 ms
(35.10%)
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
  233224
  387851
  400479
  400491
  421880
  421927
  438657
  439696
  439724
  439801
  443176
  447475
  450977
  453285
  453686
  454102
  456524
  466015
  466268
  466885
  467033
  467494
  467498
  467507
  468906
  476438
  478379
  481978
  483450
  484402
  484760
  486897
  494842
  501181
  502657
  503154
  508414
  509559
  509904
  510116
  518798
  518824
  519610
  520302
  523819
  524014
  524687
  546688
  548191
  549739
  562176
  563414
  565691
  566667
  570097
  574911
  577966
  578147
  579151
  585094
  586576
  590403
  595498
  597107
  610046
  613988
  656434
  657594
  658358
  659093
  675892
  701205
  714151
  719537
  722297
  723017
  731399
  736463
  739894
  742607
  743615
  743627
  745280
  754946
  762767
  763883
  766183
  766839
  768414
  769822
  776782
  778241
  778654
  780047
  780934
  781226
  785822
  787456
  788386
  789158
  789164
  789732
  791696
  792513
  792535
  793956
  795614
  796038
  802881
  805035
  809560
  809624
  811145
  816099
  816113
  817995
  818004
  820842
  824912
  827805
]
22.88 ms
(6.09%)
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
  722297
  657594
  613988
  778241
  785822
  789158
  731399
  742607
  781226
  792513
  789164
  789732
  570097
  562176
  502657
  520302
  510116
  523819
  549739
  443176
  481978
  519610
  524014
  483450
  484760
  793956
  788386
  762767
  466268
  658358
  548191
  586576
  816099
  824912
  827805
  546688
  565691
  450977
  478379
  577966
  484402
  400479
  467033
  400491
  578147
  456524
  590403
  486897
  595498
  447475
  566667
  597107
  466015
  518824
  509559
  468906
  439801
  494842
  467498
  233224
  719537
  739894
  805035
  659093
  787456
  792535
  743627
  754946
  766839
  809624
  809560
  811145
  610046
  585094
  780047
  439696
  509904
  467494
  387851
  467507
  476438
  453285
  466885
  816113
  675892
  714151
  723017
  656434
  780934
  795614
  763883
  766183
  768414
  745280
  743615
  701205
  791696
  421880
  818004
  817995
  574911
  736463
  802881
  776782
  769822
  508414
  820842
  454102
  439724
  421927
  453686
  524687
  503154
  518798
  563414
  501181
  579151
  438657
  796038
  778654
]
2.43 ms
(0.65%)
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
  233224
  387851
  400479
  400491
  421880
  421927
  438657
  439696
  439724
  439801
  443176
  447475
  450977
  453285
  453686
  454102
  456524
  466015
  466268
  466885
  467033
  467494
  467498
  467507
  468906
  476438
  478379
  481978
  483450
  484402
  484760
  486897
  494842
  501181
  502657
  503154
  508414
  509559
  509904
  510116
  518798
  518824
  519610
  520302
  523819
  524014
  524687
  546688
  548191
  549739
  562176
  563414
  565691
  566667
  570097
  574911
  577966
  578147
  579151
  585094
  586576
  590403
  595498
  597107
  610046
  613988
  656434
  657594
  658358
  659093
  675892
  701205
  714151
  719537
  722297
  723017
  731399
  736463
  739894
  742607
  743615
  743627
  745280
  754946
  762767
  763883
  766183
  766839
  768414
  769822
  776782
  778241
  778654
  780047
  780934
  781226
  785822
  787456
  788386
  789158
  789164
  789732
  791696
  792513
  792535
  793956
  795614
  796038
  802881
  805035
  809560
  809624
  811145
  816099
  816113
  817995
  818004
  820842
  824912
  827805
]
1.74 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск минет оральн секс рыжая"
]
1.71 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русское миньет рыжая"
]
1.66 ms
(0.44%)
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.