GET https://search.jues.net/search/embeds/7?q=dick%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.28 ms
(82.75%)
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
  382051
  386095
  388177
  389587
  395278
  395975
  396003
  397641
  398261
  400382
  410776
  413685
  413695
  414201
  417725
  417888
  424564
  428870
  429629
  430796
  433216
  446108
  448520
  450951
  453355
  453793
  453794
  453952
  455585
  463903
  463948
  468069
  482084
  496071
  510680
  523190
  536876
  542042
  575109
  579681
  591841
  592638
  595467
  598796
  611047
  628968
  629092
  639601
  640407
  649121
  650167
  651974
  660341
  660349
  662159
  662200
  666458
  670988
  670989
  673456
  683877
  690322
  692047
  693111
  693487
  698101
  698841
  699587
  700176
  709837
  715710
  717812
  718700
  718719
  719214
  720372
  720375
  720506
  722563
  722597
  724193
  725132
  725151
  727824
  727827
  728745
  728755
  731485
  732000
  735951
  735957
  742144
  742837
  743232
  746075
  746157
  746979
  747147
  747576
  748407
  749343
  749990
  753262
  753307
  753333
  753339
  753360
  753395
  753411
  753418
  753854
  753908
  754182
  755968
  757915
  760919
  785772
  793893
  819198
  822717
]
15.54 ms
(9.50%)
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
  482084
  396003
  463903
  417888
  429629
  446108
  510680
  496071
  523190
  536876
  386095
  397641
  819198
  822717
  579681
  650167
  660341
  660349
  673456
  692047
  715710
  718700
  722563
  722597
  649121
  651974
  662159
  670988
  670989
  690322
  693111
  698841
  700176
  719214
  720375
  720506
  662200
  666458
  683877
  693487
  698101
  699587
  717812
  720372
  591841
  598796
  628968
  629092
  592638
  639601
  611047
  640407
  595467
  793893
  785772
  746157
  747576
  753307
  753908
  725132
  725151
  727827
  735957
  742144
  746979
  753411
  753854
  754182
  746075
  748407
  755968
  760919
  724193
  728745
  728755
  732000
  735951
  742837
  747147
  753262
  753333
  753339
  753395
  753418
  757915
  727824
  731485
  743232
  749343
  749990
  753360
  709837
  718719
  400382
  410776
  395278
  389587
  575109
  542042
  395975
  382051
  388177
  398261
  413695
  417725
  428870
  430796
  413685
  414201
  433216
  424564
  448520
  450951
  453794
  463948
  468069
  453355
  453793
  453952
  455585
]
3.71 ms
(2.27%)
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
  382051
  386095
  388177
  389587
  395278
  395975
  396003
  397641
  398261
  400382
  410776
  413685
  413695
  414201
  417725
  417888
  424564
  428870
  429629
  430796
  433216
  446108
  448520
  450951
  453355
  453793
  453794
  453952
  455585
  463903
  463948
  468069
  482084
  496071
  510680
  523190
  536876
  542042
  575109
  579681
  591841
  592638
  595467
  598796
  611047
  628968
  629092
  639601
  640407
  649121
  650167
  651974
  660341
  660349
  662159
  662200
  666458
  670988
  670989
  673456
  683877
  690322
  692047
  693111
  693487
  698101
  698841
  699587
  700176
  709837
  715710
  717812
  718700
  718719
  719214
  720372
  720375
  720506
  722563
  722597
  724193
  725132
  725151
  727824
  727827
  728745
  728755
  731485
  732000
  735951
  735957
  742144
  742837
  743232
  746075
  746157
  746979
  747147
  747576
  748407
  749343
  749990
  753262
  753307
  753333
  753339
  753360
  753395
  753411
  753418
  753854
  753908
  754182
  755968
  757915
  760919
  785772
  793893
  819198
  822717
]
3.01 ms
(1.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член teen"
]
2.13 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick teen"
]
1.95 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член teen"
]

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.