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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.17 ms
(83.24%)
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
  29367
  53755
  194398
  210619
  233042
  233333
  233335
  333706
  365898
  365903
  365945
  382382
  386518
  386985
  388290
  388346
  398714
  401614
  402091
  402700
  402893
  404267
  404532
  420598
  421182
  423863
  424265
  429590
  431636
  433950
  443443
  444201
  444226
  454078
  455439
  457509
  458747
  459032
  459560
  461999
  466078
  466197
  467840
  470115
  471972
  473977
  476388
  486857
  488814
  491189
  492824
  495047
  495387
  497586
  499224
  508117
  509500
  509520
  509761
  511759
  512641
  518942
  523434
  525772
  533721
  534084
  535648
  537983
  543662
  546001
  549804
  559017
  559978
  560653
  567676
  590308
  596431
  597078
  597500
  598549
  598599
  598709
  598710
  601379
  603751
  652231
  654572
  695498
  715411
  719400
  724779
  727827
  731526
  736185
  738877
  744725
  745665
  750004
  768701
  768741
  776191
  777227
  778264
  778656
  779809
  780218
  780445
  781333
  783206
  784319
  788045
  790920
  791329
  793985
  804853
  810497
  810759
  810780
]
14.25 ms
(9.11%)
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
  596431
  601379
  559017
  597500
  233335
  534084
  780445
  810780
  459560
  727827
  365945
  791329
  53755
  768741
  473977
  512641
  466078
  736185
  780218
  533721
  810497
  455439
  745665
  750004
  781333
  365898
  778656
  549804
  431636
  402091
  466197
  421182
  509761
  518942
  543662
  423863
  560653
  233333
  535648
  724779
  779809
  365903
  210619
  790920
  784319
  804853
  459032
  598710
  420598
  424265
  444201
  388290
  382382
  497586
  652231
  654572
  695498
  744725
  738877
  776191
  777227
  793985
  194398
  402893
  386985
  537983
  476388
  16559
  404532
  509500
  598599
  457509
  471972
  444226
  398714
  454078
  458747
  509520
  525772
  486857
  488814
  523434
  731526
  598549
  598709
  778264
  233042
  461999
  467840
  386518
  470115
  495047
  715411
  719400
  603751
  810759
  333706
  491189
  29148
  788045
  402700
  388346
  429590
  492824
  508117
  511759
  546001
  499224
  783206
  768701
  495387
  559978
  567676
  590308
  597078
  29367
  401614
  433950
  404267
  443443
]
3.68 ms
(2.35%)
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
  29367
  53755
  194398
  210619
  233042
  233333
  233335
  333706
  365898
  365903
  365945
  382382
  386518
  386985
  388290
  388346
  398714
  401614
  402091
  402700
  402893
  404267
  404532
  420598
  421182
  423863
  424265
  429590
  431636
  433950
  443443
  444201
  444226
  454078
  455439
  457509
  458747
  459032
  459560
  461999
  466078
  466197
  467840
  470115
  471972
  473977
  476388
  486857
  488814
  491189
  492824
  495047
  495387
  497586
  499224
  508117
  509500
  509520
  509761
  511759
  512641
  518942
  523434
  525772
  533721
  534084
  535648
  537983
  543662
  546001
  549804
  559017
  559978
  560653
  567676
  590308
  596431
  597078
  597500
  598549
  598599
  598709
  598710
  601379
  603751
  652231
  654572
  695498
  715411
  719400
  724779
  727827
  731526
  736185
  738877
  744725
  745665
  750004
  768701
  768741
  776191
  777227
  778264
  778656
  779809
  780218
  780445
  781333
  783206
  784319
  788045
  790920
  791329
  793985
  804853
  810497
  810759
  810780
]
2.26 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian beautiful"
]
2.11 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск красивая"
]
1.97 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.