GET https://search.jues.net/search/embeds/8?q=russian%20teens%20group

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.57 ms
(86.79%)
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
  418417
  421146
  428958
  434931
  436032
  436042
  436178
  442841
  446172
  451563
  451572
  455912
  457783
  457793
  461609
  462700
  464327
  466230
  468527
  469764
  470291
  470541
  470596
  472567
  473780
  474016
  474024
  484051
  485147
  488728
  488734
  490836
  494557
  495710
  495741
  497569
  504098
  504183
  506259
  506820
  509998
  510742
  510756
  511023
  513539
  517577
  521535
  521866
  525704
  526597
  527647
  531177
  533726
  534028
  534090
  535597
  535631
  538237
  540908
  540955
  544455
  546614
  548755
  549786
  551222
  551223
  551243
  552267
  552643
  557948
  557981
  558126
  561334
  564808
  565247
  565367
  567304
  568315
  569413
  574833
  575459
  575737
  575810
  575856
  579900
  582549
  584654
  586770
  587098
  595756
  598057
  599969
  600061
  600071
  601478
  603803
  606571
  621612
  622228
  622799
  622817
  631247
  647936
  648845
  650155
  655705
  659323
  661256
  676989
  683259
  683264
  702166
  714511
  716030
  716032
  731665
  733870
  733884
  733908
  825812
]
19.27 ms
(8.78%)
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
  825812
  510756
  531177
  535597
  552267
  558126
  552643
  557981
  564808
  574833
  584654
  575737
  582549
  683259
  716032
  548755
  549786
  565247
  567304
  598057
  600061
  601478
  622799
  733884
  733908
  731665
  716030
  434931
  474016
  421146
  446172
  436042
  451572
  466230
  469764
  526597
  504183
  506820
  540955
  484051
  494557
  495710
  506259
  497569
  509998
  535631
  540908
  551223
  488734
  659323
  485147
  622228
  621612
  534028
  557948
  568315
  569413
  579900
  551243
  575856
  702166
  714511
  676989
  561334
  565367
  575810
  586770
  606571
  587098
  733870
  631247
  473780
  428958
  451563
  442841
  470291
  472567
  517577
  521535
  521866
  488728
  655705
  622817
  474024
  455912
  511023
  513539
  470541
  418417
  538237
  650155
  464327
  436178
  470596
  533726
  551222
  575459
  544455
  647936
  683264
  603803
  599969
  595756
  600071
  436032
  457783
  457793
  462700
  504098
  527647
  495741
  510742
  461609
  468527
  490836
  546614
  648845
  525704
  661256
  534090
]
2.81 ms
(1.28%)
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
  418417
  421146
  428958
  434931
  436032
  436042
  436178
  442841
  446172
  451563
  451572
  455912
  457783
  457793
  461609
  462700
  464327
  466230
  468527
  469764
  470291
  470541
  470596
  472567
  473780
  474016
  474024
  484051
  485147
  488728
  488734
  490836
  494557
  495710
  495741
  497569
  504098
  504183
  506259
  506820
  509998
  510742
  510756
  511023
  513539
  517577
  521535
  521866
  525704
  526597
  527647
  531177
  533726
  534028
  534090
  535597
  535631
  538237
  540908
  540955
  544455
  546614
  548755
  549786
  551222
  551223
  551243
  552267
  552643
  557948
  557981
  558126
  561334
  564808
  565247
  565367
  567304
  568315
  569413
  574833
  575459
  575737
  575810
  575856
  579900
  582549
  584654
  586770
  587098
  595756
  598057
  599969
  600061
  600071
  601478
  603803
  606571
  621612
  622228
  622799
  622817
  631247
  647936
  648845
  650155
  655705
  659323
  661256
  676989
  683259
  683264
  702166
  714511
  716030
  716032
  731665
  733870
  733884
  733908
  825812
]
2.18 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian teens group"
]
1.67 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск teens group"
]
1.45 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск teens group"
]

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.