GET https://search.jues.net/search/embeds/3?q=small%20teen%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.46 ms
(83.46%)
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
  396286
  417336
  418706
  419383
  420028
  420233
  421544
  424617
  424996
  434588
  448524
  457141
  459234
  459801
  462854
  464872
  468591
  471727
  471990
  474613
  495358
  500266
  509399
  514483
  533207
  535637
  538986
  539197
  541393
  541724
  543727
  544019
  547380
  549086
  549091
  549098
  552622
  552921
  555807
  556521
  562769
  567082
  568731
  570721
  572954
  576445
  576990
  580735
  584721
  588190
  593594
  594272
  594429
  594503
  595536
  598433
  600132
  600805
  601970
  602802
  603603
  604371
  605437
  610965
  629171
  655281
  658173
  658555
  662148
  683303
  683341
  686576
  715808
  731978
  740860
  748192
  750334
  756269
  758979
  762980
  765659
  766076
  767125
  769848
  774022
  777410
  780243
  780650
  787611
  789838
  790542
  795490
  795555
  797204
  800523
  801916
  802552
  802952
  804327
  805536
  807669
  809121
  810512
  811632
  813285
  814237
  814527
  814959
  815092
  815132
  818516
  818518
  818527
  818544
  821445
  821553
  821716
  823092
  823529
  827858
]
18.81 ms
(11.02%)
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
  419383
  594503
  462854
  417336
  629171
  748192
  421544
  821445
  814237
  818516
  823529
  821553
  509399
  538986
  543727
  547380
  562769
  549091
  658173
  683341
  683303
  655281
  658555
  594429
  600805
  604371
  795555
  801916
  810512
  813285
  787611
  811632
  802952
  756269
  766076
  767125
  774022
  740860
  765659
  715808
  795490
  802552
  804327
  420233
  464872
  539197
  777410
  662148
  572954
  552921
  567082
  541724
  541393
  570721
  576990
  549086
  552622
  588190
  600132
  758979
  459234
  544019
  555807
  420028
  533207
  818527
  459801
  457141
  500266
  495358
  731978
  815132
  576445
  602802
  605437
  780650
  424617
  814527
  818544
  814959
  823092
  815092
  818518
  821716
  827858
  448524
  514483
  535637
  556521
  584721
  549098
  580735
  610965
  593594
  598433
  603603
  594272
  601970
  595536
  790542
  797204
  800523
  789838
  807669
  809121
  762980
  769848
  750334
  780243
  805536
  434588
  418706
  396286
  424996
  471990
  468591
  471727
  474613
  568731
  686576
]
2.57 ms
(1.51%)
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
  396286
  417336
  418706
  419383
  420028
  420233
  421544
  424617
  424996
  434588
  448524
  457141
  459234
  459801
  462854
  464872
  468591
  471727
  471990
  474613
  495358
  500266
  509399
  514483
  533207
  535637
  538986
  539197
  541393
  541724
  543727
  544019
  547380
  549086
  549091
  549098
  552622
  552921
  555807
  556521
  562769
  567082
  568731
  570721
  572954
  576445
  576990
  580735
  584721
  588190
  593594
  594272
  594429
  594503
  595536
  598433
  600132
  600805
  601970
  602802
  603603
  604371
  605437
  610965
  629171
  655281
  658173
  658555
  662148
  683303
  683341
  686576
  715808
  731978
  740860
  748192
  750334
  756269
  758979
  762980
  765659
  766076
  767125
  769848
  774022
  777410
  780243
  780650
  787611
  789838
  790542
  795490
  795555
  797204
  800523
  801916
  802552
  802952
  804327
  805536
  807669
  809121
  810512
  811632
  813285
  814237
  814527
  814959
  815092
  815132
  818516
  818518
  818527
  818544
  821445
  821553
  821716
  823092
  823529
  827858
]
2.08 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая teen пов"
]
2.02 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small teen pov"
]
1.49 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.24 ms
(0.73%)
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.