Query Metrics

8 Database Queries
8 Different statements
335.61 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.62 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.84 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian girl pussy"
]
3 14.14 ms
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
  487779
  505296
  435635
  814198
  448346
  652380
  623608
  748681
  595690
  565471
  559902
  717921
  559914
  754812
  408988
  494432
  122846
  443598
  473060
  551992
  546038
  623950
  428518
  540176
  510669
  572727
  721368
  623508
  416155
  610669
  414509
  430977
  512892
  516853
  532927
  552928
  720407
  614079
  634760
  383153
  820019
  384514
  823229
  576991
  422618
  540175
  572744
  624831
  748685
  785332
  496108
  417373
  427494
  554415
  591795
  412474
  556374
  456847
  446355
  540187
  550727
  658224
  713526
  688579
  688606
  591720
  810242
  768123
  418646
  429569
  456400
  623969
  422621
  462304
  566042
  658216
  662071
  673048
  722843
  767285
  730872
  431672
  510571
  383118
  401360
  421310
  429541
  550608
  590958
  603191
  524178
  554307
  385482
  382950
  429698
  417265
  452532
  462573
  463710
  457732
  552935
  658208
  692389
  591730
  638357
  622622
  760946
  784161
  476149
  401816
  484374
  390614
  408172
  411196
  552933
  720687
  720889
  800071
  818936
  532084
]
4 2.46 ms
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
  122846
  382950
  383118
  383153
  384514
  385482
  390614
  401360
  401816
  408172
  408988
  411196
  412474
  414509
  416155
  417265
  417373
  418646
  421310
  422618
  422621
  427494
  428518
  429541
  429569
  429698
  430977
  431672
  435635
  443598
  446355
  448346
  452532
  456400
  456847
  457732
  462304
  462573
  463710
  473060
  476149
  484374
  487779
  494432
  496108
  505296
  510571
  510669
  512892
  516853
  524178
  532084
  532927
  540175
  540176
  540187
  546038
  550608
  550727
  551992
  552928
  552933
  552935
  554307
  554415
  556374
  559902
  559914
  565471
  566042
  572727
  572744
  576991
  590958
  591720
  591730
  591795
  595690
  603191
  610669
  614079
  622622
  623508
  623608
  623950
  623969
  624831
  634760
  638357
  652380
  658208
  658216
  658224
  662071
  673048
  688579
  688606
  692389
  713526
  717921
  720407
  720687
  720889
  721368
  722843
  730872
  748681
  748685
  754812
  760946
  767285
  768123
  784161
  785332
  800071
  810242
  814198
  818936
  820019
  823229
]
5 271.44 ms
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
  122846
  382950
  383118
  383153
  384514
  385482
  390614
  401360
  401816
  408172
  408988
  411196
  412474
  414509
  416155
  417265
  417373
  418646
  421310
  422618
  422621
  427494
  428518
  429541
  429569
  429698
  430977
  431672
  435635
  443598
  446355
  448346
  452532
  456400
  456847
  457732
  462304
  462573
  463710
  473060
  476149
  484374
  487779
  494432
  496108
  505296
  510571
  510669
  512892
  516853
  524178
  532084
  532927
  540175
  540176
  540187
  546038
  550608
  550727
  551992
  552928
  552933
  552935
  554307
  554415
  556374
  559902
  559914
  565471
  566042
  572727
  572744
  576991
  590958
  591720
  591730
  591795
  595690
  603191
  610669
  614079
  622622
  623508
  623608
  623950
  623969
  624831
  634760
  638357
  652380
  658208
  658216
  658224
  662071
  673048
  688579
  688606
  692389
  713526
  717921
  720407
  720687
  720889
  721368
  722843
  730872
  748681
  748685
  754812
  760946
  767285
  768123
  784161
  785332
  800071
  810242
  814198
  818936
  820019
  823229
]
6 4.66 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк девушк pussy"
]
7 3.35 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "азиатк девушк pussy"
]
8 36.10 ms
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "asian girl pussy"
  "asian girl pussy"
  "asian girl pussy"
  20
]

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.