GET https://search.jues.net/search/embeds/4?q=russian%20face

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
422.99 ms
(54.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск face"
]
210.06 ms
(26.90%)
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
  400867
  402235
  425737
  435020
  436423
  438033
  444819
  461717
  474182
  475548
  479988
  480904
  481036
  482456
  484431
  488703
  489035
  504655
  511996
  514205
  533772
  537371
  540253
  544927
  547606
  547787
  556450
  559616
  565837
  568675
  570411
  578768
  590223
  595361
  599130
  601871
  605714
  609381
  611521
  612465
  613922
  615041
  617587
  621248
  642237
  642249
  655539
  657760
  660111
  660292
  662480
  668983
  670991
  671479
  672891
  674615
  675585
  677862
  692564
  697249
  701513
  705167
  709507
  709764
  719124
  719532
  722966
  728467
  730012
  730852
  731215
  731396
  733708
  739886
  740032
  741832
  743606
  743766
  747566
  749328
  758512
  761777
  766368
  766457
  766788
  767479
  768914
  769448
  769789
  770601
  770607
  770958
  771370
  777202
  778619
  779049
  779237
  779278
  779293
  779775
  779951
  782828
  786098
  786791
  788338
  790634
  792415
  795613
  797751
  798856
  802652
  805005
  805536
  805618
  809327
  813161
  814295
  823454
  823634
  825499
]
128.94 ms
(16.51%)
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
  400867
  402235
  425737
  435020
  436423
  438033
  444819
  461717
  474182
  475548
  479988
  480904
  481036
  482456
  484431
  488703
  489035
  504655
  511996
  514205
  533772
  537371
  540253
  544927
  547606
  547787
  556450
  559616
  565837
  568675
  570411
  578768
  590223
  595361
  599130
  601871
  605714
  609381
  611521
  612465
  613922
  615041
  617587
  621248
  642237
  642249
  655539
  657760
  660111
  660292
  662480
  668983
  670991
  671479
  672891
  674615
  675585
  677862
  692564
  697249
  701513
  705167
  709507
  709764
  719124
  719532
  722966
  728467
  730012
  730852
  731215
  731396
  733708
  739886
  740032
  741832
  743606
  743766
  747566
  749328
  758512
  761777
  766368
  766457
  766788
  767479
  768914
  769448
  769789
  770601
  770607
  770958
  771370
  777202
  778619
  779049
  779237
  779278
  779293
  779775
  779951
  782828
  786098
  786791
  788338
  790634
  792415
  795613
  797751
  798856
  802652
  805005
  805536
  805618
  809327
  813161
  814295
  823454
  823634
  825499
]
13.88 ms
(1.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
  814295
  556450
  578768
  655539
  672891
  697249
  709764
  719532
  662480
  670991
  677862
  705167
  709507
  657760
  668983
  692564
  642237
  621248
  605714
  615041
  777202
  779775
  782828
  790634
  792415
  813161
  730012
  731215
  731396
  740032
  761777
  766368
  766457
  767479
  786098
  728467
  730852
  758512
  769789
  770958
  741832
  743606
  747566
  768914
  749328
  766788
  771370
  617587
  642249
  719124
  722966
  778619
  779049
  779293
  779951
  797751
  798856
  805536
  809327
  475548
  444819
  480904
  400867
  402235
  461717
  481036
  511996
  537371
  488703
  514205
  436423
  595361
  425737
  435020
  438033
  489035
  823634
  823454
  825499
  474182
  479988
  484431
  533772
  504655
  540253
  482456
  544927
  547606
  568675
  547787
  559616
  565837
  660292
  675585
  674615
  701513
  660111
  671479
  570411
  590223
  601871
  609381
  611521
  599130
  612465
  613922
  779237
  805618
  779278
  786791
  788338
  795613
  805005
  743766
  769448
  770601
  802652
  770607
  733708
  739886
]
1.92 ms
(0.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian face"
]
1.54 ms
(0.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск face"
]

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.