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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.73 ms
(85.40%)
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
  282006
  383880
  386095
  390746
  391255
  395306
  395492
  396003
  397641
  401076
  401322
  401989
  403166
  417888
  418887
  427544
  427970
  429009
  429629
  432797
  442632
  446108
  447642
  450690
  451755
  453468
  454633
  463819
  463884
  463903
  464696
  482084
  489359
  495824
  496071
  496082
  503468
  504389
  506299
  510680
  512419
  514794
  518995
  520969
  523190
  524002
  525028
  526901
  527630
  528929
  530697
  533016
  535006
  536251
  536396
  536876
  549089
  549871
  556335
  561880
  561895
  574848
  575160
  579681
  591841
  592638
  594226
  597803
  598734
  598796
  609204
  611047
  624280
  628968
  629092
  639601
  640407
  642044
  649121
  650167
  651974
  660341
  660349
  662159
  662200
  666458
  666868
  666871
  670988
  670989
  673456
  674959
  683877
  688660
  690322
  692047
  693111
  693487
  698101
  698841
  699587
  700176
  706629
  715710
  717812
  718700
  719214
  720372
  720375
  720506
  722563
  722597
  727289
  740392
  748787
  760772
  762568
  777074
  819198
  822717
]
14.21 ms
(8.81%)
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
  504389
  512419
  514794
  527630
  536396
  489359
  496082
  525028
  528929
  518995
  520969
  524002
  526901
  495824
  450690
  503468
  506299
  536251
  535006
  666871
  674959
  383880
  403166
  442632
  427544
  549089
  556335
  561895
  574848
  575160
  688660
  624280
  594226
  598734
  597803
  777074
  762568
  727289
  748787
  609204
  390746
  401076
  391255
  395492
  666868
  642044
  395306
  401989
  432797
  451755
  453468
  464696
  530697
  533016
  463884
  561880
  706629
  549871
  740392
  760772
  418887
  429009
  447642
  463819
  282006
  401322
  427970
  454633
  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
]
2.62 ms
(1.63%)
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
  282006
  383880
  386095
  390746
  391255
  395306
  395492
  396003
  397641
  401076
  401322
  401989
  403166
  417888
  418887
  427544
  427970
  429009
  429629
  432797
  442632
  446108
  447642
  450690
  451755
  453468
  454633
  463819
  463884
  463903
  464696
  482084
  489359
  495824
  496071
  496082
  503468
  504389
  506299
  510680
  512419
  514794
  518995
  520969
  523190
  524002
  525028
  526901
  527630
  528929
  530697
  533016
  535006
  536251
  536396
  536876
  549089
  549871
  556335
  561880
  561895
  574848
  575160
  579681
  591841
  592638
  594226
  597803
  598734
  598796
  609204
  611047
  624280
  628968
  629092
  639601
  640407
  642044
  649121
  650167
  651974
  660341
  660349
  662159
  662200
  666458
  666868
  666871
  670988
  670989
  673456
  674959
  683877
  688660
  690322
  692047
  693111
  693487
  698101
  698841
  699587
  700176
  706629
  715710
  717812
  718700
  719214
  720372
  720375
  720506
  722563
  722597
  727289
  740392
  748787
  760772
  762568
  777074
  819198
  822717
]
2.01 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen dick"
]
1.68 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen член"
]
1.61 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.