GET https://search.jues.net/search/embeds/2?q=russian%20beautiful%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.82 ms
(84.21%)
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
  16559
  29148
  194398
  233042
  365903
  371790
  386518
  386985
  387603
  390259
  398714
  401574
  412857
  420833
  424265
  424764
  425026
  429590
  433950
  444201
  444226
  446253
  450398
  451613
  452791
  454660
  455509
  456106
  456524
  457509
  458068
  458595
  458747
  460360
  461069
  461474
  461524
  461999
  462521
  462528
  462579
  464741
  465950
  467840
  470530
  470687
  470761
  471972
  475584
  477925
  478513
  481340
  481409
  482258
  488791
  489376
  490627
  491189
  495047
  495387
  497586
  499224
  502720
  509500
  509520
  510535
  518921
  521986
  523434
  523690
  525772
  527369
  529135
  529359
  531016
  533729
  537982
  543767
  546001
  546639
  552196
  552201
  561972
  567770
  577726
  579976
  590308
  592418
  597078
  597552
  598145
  598549
  598587
  598595
  598709
  617103
  631255
  653245
  655070
  656749
  658026
  659106
  660930
  691466
  717662
  719400
  731526
  738877
  741989
  743700
  751952
  777227
  784163
  784697
  788045
  789920
  792107
  804904
  813327
  826050
]
14.19 ms
(9.65%)
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
  738877
  777227
  29148
  470687
  194398
  386985
  458595
  481409
  398714
  458747
  461524
  509520
  523434
  495387
  481340
  465950
  446253
  454660
  470530
  537982
  598549
  233042
  467840
  386518
  546001
  552196
  617103
  660930
  656749
  470761
  477925
  371790
  523690
  444201
  462521
  497586
  531016
  631255
  691466
  456106
  16559
  509500
  579976
  527369
  518921
  529135
  784697
  804904
  424265
  489376
  461069
  653245
  813327
  659106
  751952
  452791
  590308
  597078
  433950
  455509
  475584
  482258
  425026
  456524
  502720
  529359
  658026
  792107
  552201
  741989
  478513
  655070
  458068
  462528
  499224
  490627
  719400
  491189
  743700
  533729
  717662
  597552
  451613
  464741
  420833
  788045
  461474
  429590
  365903
  561972
  401574
  543767
  546639
  462579
  598595
  510535
  457509
  471972
  444226
  525772
  731526
  598587
  789920
  450398
  567770
  577726
  592418
  826050
  784163
  390259
  412857
  424764
  460360
  521986
  598145
  598709
  461999
  495047
  387603
  488791
]
2.37 ms
(1.61%)
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
  16559
  29148
  194398
  233042
  365903
  371790
  386518
  386985
  387603
  390259
  398714
  401574
  412857
  420833
  424265
  424764
  425026
  429590
  433950
  444201
  444226
  446253
  450398
  451613
  452791
  454660
  455509
  456106
  456524
  457509
  458068
  458595
  458747
  460360
  461069
  461474
  461524
  461999
  462521
  462528
  462579
  464741
  465950
  467840
  470530
  470687
  470761
  471972
  475584
  477925
  478513
  481340
  481409
  482258
  488791
  489376
  490627
  491189
  495047
  495387
  497586
  499224
  502720
  509500
  509520
  510535
  518921
  521986
  523434
  523690
  525772
  527369
  529135
  529359
  531016
  533729
  537982
  543767
  546001
  546639
  552196
  552201
  561972
  567770
  577726
  579976
  590308
  592418
  597078
  597552
  598145
  598549
  598587
  598595
  598709
  617103
  631255
  653245
  655070
  656749
  658026
  659106
  660930
  691466
  717662
  719400
  731526
  738877
  741989
  743700
  751952
  777227
  784163
  784697
  788045
  789920
  792107
  804904
  813327
  826050
]
2.02 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian beautiful girl"
]
1.70 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск красивая девушк"
]
1.42 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск красивая девушк"
]

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.