Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.94 ms
(59.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "порн азиатк"
]
122.68 ms
(34.32%)
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
  7271
  23104
  60843
  122846
  172125
  383186
  384451
  385370
  385471
  391072
  392423
  393049
  398132
  398523
  400854
  403593
  403896
  414248
  414865
  422506
  423010
  434439
  491452
  499485
  500693
  510578
  512180
  512220
  516430
  523399
  528593
  530709
  533126
  538657
  546038
  550138
  550618
  550776
  551028
  551949
  551969
  551972
  552028
  552897
  552898
  556374
  556398
  556409
  558391
  558426
  558431
  559159
  559855
  559865
  559873
  559926
  565992
  572738
  574642
  575276
  582908
  583298
  585381
  590949
  591278
  592286
  593023
  593431
  595949
  596394
  597263
  598515
  600455
  600806
  608009
  610650
  612085
  618483
  619431
  619433
  619448
  619449
  622602
  622615
  622618
  622654
  623509
  623955
  634866
  637737
  640685
  702438
  721756
  724460
  724480
  725378
  729857
  730579
  734064
  735002
  735898
  737119
  740831
  742469
  742474
  758302
  760210
  765679
  766781
  766792
  767044
  777426
  780631
  784466
  787884
  790918
  800710
  804941
  810051
  828161
]
13.86 ms
(3.88%)
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
  610650
  619449
  593023
  596394
  600455
  612085
  619431
  619448
  622602
  622618
  622654
  623955
  634866
  592286
  595949
  622615
  780631
  784466
  810051
  790918
  724480
  740831
  742469
  800710
  725378
  766781
  742474
  766792
  729857
  730579
  735898
  737119
  760210
  724460
  734064
  735002
  758302
  765679
  767044
  623509
  702438
  721756
  777426
  787884
  804941
  172125
  434439
  403593
  422506
  398523
  414248
  500693
  383186
  384451
  60843
  828161
  414865
  550618
  556374
  423010
  530709
  559159
  597263
  552898
  510578
  512220
  516430
  538657
  523399
  512180
  533126
  499485
  528593
  491452
  558391
  559865
  559926
  574642
  583298
  551028
  551969
  551972
  556409
  575276
  556398
  565992
  582908
  546038
  550138
  550776
  551949
  552028
  552897
  558426
  558431
  559855
  559873
  572738
  590949
  600806
  591278
  619433
  593431
  598515
  637737
  585381
  618483
  608009
  640685
  385471
  385370
  122846
  393049
  392423
  23104
  7271
  391072
  398132
  400854
  403896
]
3.25 ms
(0.91%)
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
  7271
  23104
  60843
  122846
  172125
  383186
  384451
  385370
  385471
  391072
  392423
  393049
  398132
  398523
  400854
  403593
  403896
  414248
  414865
  422506
  423010
  434439
  491452
  499485
  500693
  510578
  512180
  512220
  516430
  523399
  528593
  530709
  533126
  538657
  546038
  550138
  550618
  550776
  551028
  551949
  551969
  551972
  552028
  552897
  552898
  556374
  556398
  556409
  558391
  558426
  558431
  559159
  559855
  559865
  559873
  559926
  565992
  572738
  574642
  575276
  582908
  583298
  585381
  590949
  591278
  592286
  593023
  593431
  595949
  596394
  597263
  598515
  600455
  600806
  608009
  610650
  612085
  618483
  619431
  619433
  619448
  619449
  622602
  622615
  622618
  622654
  623509
  623955
  634866
  637737
  640685
  702438
  721756
  724460
  724480
  725378
  729857
  730579
  734064
  735002
  735898
  737119
  740831
  742469
  742474
  758302
  760210
  765679
  766781
  766792
  767044
  777426
  780631
  784466
  787884
  790918
  800710
  804941
  810051
  828161
]
1.84 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно с азиаткой"
]
1.36 ms
(0.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.