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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.29 ms
(83.86%)
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
  322090
  382567
  382827
  384025
  384422
  396859
  399952
  401574
  401584
  402404
  402901
  419099
  419238
  424095
  427517
  428173
  430365
  441656
  450671
  452853
  459786
  459792
  460006
  461460
  461476
  462248
  462622
  462724
  463310
  464523
  464745
  465841
  467689
  469095
  470141
  472192
  474500
  475577
  476761
  478274
  478726
  478850
  479980
  480651
  481158
  481218
  485343
  486361
  487446
  488786
  488791
  488793
  492661
  505035
  510504
  511959
  514785
  518058
  519665
  519680
  519871
  521872
  524526
  540730
  542072
  546019
  547604
  552159
  552206
  558856
  561695
  561972
  565551
  570299
  570366
  573848
  578503
  598390
  603712
  605814
  621872
  656044
  656089
  656468
  657603
  658608
  659091
  659656
  660476
  676527
  689458
  693236
  697322
  704599
  705009
  711050
  722853
  723599
  741261
  743700
  754829
  761471
  761797
  764107
  771736
  772588
  773826
  777169
  777799
  778226
  778761
  781087
  781120
  782969
  789926
  792455
  796701
  804871
  807434
  811626
]
13.76 ms
(8.99%)
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
  723599
  540730
  547604
  656089
  658608
  659656
  660476
  656468
  657603
  659091
  689458
  704599
  705009
  711050
  656044
  598390
  778761
  792455
  778226
  781120
  796701
  761471
  741261
  754829
  761797
  764107
  772588
  743700
  771736
  621872
  781087
  399952
  519665
  552159
  570366
  561972
  573848
  676527
  693236
  697322
  546019
  605814
  782969
  777169
  777799
  811626
  789926
  804871
  773826
  722853
  384025
  465841
  382567
  474500
  401574
  488793
  479980
  462248
  486361
  552206
  570299
  807434
  603712
  401584
  459792
  461476
  462622
  464523
  480651
  396859
  460006
  463310
  478274
  402404
  452853
  461460
  464745
  481158
  322090
  382827
  402901
  427517
  459786
  478726
  450671
  469095
  481218
  485343
  492661
  488786
  488791
  514785
  424095
  384422
  419238
  565551
  578503
  542072
  558856
  561695
  441656
  475577
  419099
  428173
  470141
  467689
  478850
  462724
  476761
  430365
  472192
  511959
  518058
  519680
  519871
  521872
  524526
  487446
  505035
  510504
]
2.52 ms
(1.65%)
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
  322090
  382567
  382827
  384025
  384422
  396859
  399952
  401574
  401584
  402404
  402901
  419099
  419238
  424095
  427517
  428173
  430365
  441656
  450671
  452853
  459786
  459792
  460006
  461460
  461476
  462248
  462622
  462724
  463310
  464523
  464745
  465841
  467689
  469095
  470141
  472192
  474500
  475577
  476761
  478274
  478726
  478850
  479980
  480651
  481158
  481218
  485343
  486361
  487446
  488786
  488791
  488793
  492661
  505035
  510504
  511959
  514785
  518058
  519665
  519680
  519871
  521872
  524526
  540730
  542072
  546019
  547604
  552159
  552206
  558856
  561695
  561972
  565551
  570299
  570366
  573848
  578503
  598390
  603712
  605814
  621872
  656044
  656089
  656468
  657603
  658608
  659091
  659656
  660476
  676527
  689458
  693236
  697322
  704599
  705009
  711050
  722853
  723599
  741261
  743700
  754829
  761471
  761797
  764107
  771736
  772588
  773826
  777169
  777799
  778226
  778761
  781087
  781120
  782969
  789926
  792455
  796701
  804871
  807434
  811626
]
2.19 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful russian"
]
2.18 ms
(1.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.15 ms
(1.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая русск"
]
1.88 ms
(1.23%)
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.