GET https://search.jues.net/search/embeds/3?q=%D0%B2%20%D0%B6%D0%BC%D0%B6%20%D0%B0%D0%BD%D0%B0%D0%BB

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.33 ms
(87.73%)
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
  218026
  382818
  383086
  383375
  387848
  388227
  390144
  395596
  395701
  395723
  396253
  396646
  396670
  397982
  398888
  401140
  401278
  404768
  404773
  404922
  407324
  410913
  411237
  411547
  411736
  411829
  412925
  416118
  419885
  422686
  425886
  426117
  426214
  430584
  433156
  433212
  433244
  433343
  433486
  443558
  443810
  447858
  447861
  449435
  451626
  452010
  453087
  453349
  455816
  463783
  465976
  467815
  472317
  473240
  477437
  477743
  478009
  478433
  483582
  484664
  484809
  485575
  489831
  490864
  492597
  492606
  493143
  493482
  494075
  499121
  500571
  502274
  503044
  504399
  508277
  510627
  518563
  523416
  530770
  541252
  542565
  546744
  557540
  559029
  559181
  562843
  563536
  563537
  569070
  571445
  576678
  589718
  596057
  598513
  604597
  605303
  621976
  629969
  632038
  637007
  638326
  646433
  648526
  651190
  653492
  660747
  681647
  693075
  699621
  705160
  717635
  720720
  724559
  734038
  761004
  770824
  784315
  788886
  801484
  810770
]
14.49 ms
(7.69%)
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
  493482
  407324
  499121
  693075
  493143
  589718
  401140
  387848
  396646
  629969
  810770
  596057
  383086
  411829
  404768
  430584
  681647
  557540
  801484
  395596
  411547
  518563
  563536
  472317
  502274
  452010
  500571
  425886
  447858
  510627
  478433
  477437
  404922
  660747
  419885
  569070
  699621
  542565
  705160
  621976
  598513
  465976
  604597
  395723
  503044
  504399
  395701
  390144
  397982
  398888
  563537
  410913
  467815
  477743
  485575
  632038
  433156
  541252
  492606
  494075
  396253
  404773
  576678
  416118
  653492
  562843
  401278
  559181
  433486
  784315
  426214
  646433
  648526
  571445
  449435
  530770
  433343
  523416
  559029
  433244
  451626
  411237
  720720
  508277
  447861
  483582
  463783
  492597
  734038
  443558
  218026
  478009
  411736
  422686
  453087
  546744
  605303
  788886
  396670
  433212
  717635
  761004
  484664
  382818
  383375
  443810
  489831
  412925
  453349
  388227
  473240
  724559
  484809
  638326
  637007
  770824
  426117
  490864
  455816
  651190
]
2.28 ms
(1.21%)
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
  218026
  382818
  383086
  383375
  387848
  388227
  390144
  395596
  395701
  395723
  396253
  396646
  396670
  397982
  398888
  401140
  401278
  404768
  404773
  404922
  407324
  410913
  411237
  411547
  411736
  411829
  412925
  416118
  419885
  422686
  425886
  426117
  426214
  430584
  433156
  433212
  433244
  433343
  433486
  443558
  443810
  447858
  447861
  449435
  451626
  452010
  453087
  453349
  455816
  463783
  465976
  467815
  472317
  473240
  477437
  477743
  478009
  478433
  483582
  484664
  484809
  485575
  489831
  490864
  492597
  492606
  493143
  493482
  494075
  499121
  500571
  502274
  503044
  504399
  508277
  510627
  518563
  523416
  530770
  541252
  542565
  546744
  557540
  559029
  559181
  562843
  563536
  563537
  569070
  571445
  576678
  589718
  596057
  598513
  604597
  605303
  621976
  629969
  632038
  637007
  638326
  646433
  648526
  651190
  653492
  660747
  681647
  693075
  699621
  705160
  717635
  720720
  724559
  734038
  761004
  770824
  784315
  788886
  801484
  810770
]
1.75 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в жмж анал"
]
1.60 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "в жмж секс втро анал"
]
1.56 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в жмж секс втро анал"
]
1.45 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.