GET https://search.jues.net/search/embeds/3?q=%D1%81%D0%B5%D0%BA%D1%81%20%D0%B7%D0%B0%D0%BB

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.37 ms
(88.63%)
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
  72607
  352045
  382837
  383321
  390180
  397535
  401452
  405128
  410913
  412173
  418088
  419242
  421543
  434202
  434646
  438353
  439450
  440199
  444336
  446346
  446795
  446972
  447476
  449277
  450607
  452397
  452410
  454541
  454679
  455788
  456791
  458638
  461058
  461254
  463445
  465850
  470329
  476501
  478111
  479353
  485736
  486047
  486280
  490987
  491639
  493285
  493337
  493772
  494738
  499762
  501608
  502411
  506339
  506580
  507341
  507429
  509189
  509478
  509781
  510698
  511375
  512603
  514364
  515635
  518555
  519995
  521473
  521906
  521945
  523704
  523849
  523967
  523969
  524185
  524426
  525392
  526045
  526147
  526461
  526930
  528781
  535242
  536119
  536395
  542655
  548736
  552392
  555089
  558843
  560979
  565379
  565922
  567754
  569655
  569941
  570666
  573669
  576069
  576097
  576405
  578363
  578449
  578492
  583728
  589169
  594817
  598514
  598537
  598642
  601753
  619092
  702031
  749723
  756689
  761591
  769160
  773287
  785763
  810052
]
11.92 ms
(6.55%)
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
  507429
  573669
  761591
  446346
  455788
  418088
  461058
  524426
  494738
  507341
  383321
  439450
  452397
  446795
  454541
  450607
  526461
  702031
  569655
  785763
  769160
  773287
  756689
  461254
  463445
  510698
  521473
  523969
  501608
  509189
  491639
  509781
  485736
  478111
  536119
  594817
  589169
  810052
  512603
  490987
  525392
  493285
  526930
  421543
  458638
  598514
  434202
  506339
  583728
  382837
  390180
  523704
  352045
  405128
  486047
  578363
  548736
  576405
  401452
  419242
  524185
  456791
  536395
  570666
  576069
  576097
  560979
  447476
  440199
  506580
  412173
  446972
  555089
  567754
  542655
  552392
  565922
  558843
  578449
  619092
  601753
  749723
  454679
  476501
  397535
  502411
  521906
  521945
  523967
  526147
  514364
  578492
  479353
  470329
  523849
  499762
  528781
  465850
  535242
  569941
  598537
  452410
  515635
  518555
  493337
  509478
  519995
  434646
  449277
  444336
  438353
  493772
  526045
  511375
  565379
  72607
  410913
  486280
  574070
  598642
]
2.42 ms
(1.33%)
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
  72607
  352045
  382837
  383321
  390180
  397535
  401452
  405128
  410913
  412173
  418088
  419242
  421543
  434202
  434646
  438353
  439450
  440199
  444336
  446346
  446795
  446972
  447476
  449277
  450607
  452397
  452410
  454541
  454679
  455788
  456791
  458638
  461058
  461254
  463445
  465850
  470329
  476501
  478111
  479353
  485736
  486047
  486280
  490987
  491639
  493285
  493337
  493772
  494738
  499762
  501608
  502411
  506339
  506580
  507341
  507429
  509189
  509478
  509781
  510698
  511375
  512603
  514364
  515635
  518555
  519995
  521473
  521906
  521945
  523704
  523849
  523967
  523969
  524185
  524426
  525392
  526045
  526147
  526461
  526930
  528781
  535242
  536119
  536395
  542655
  548736
  552392
  555089
  558843
  560979
  565379
  565922
  567754
  569655
  569941
  570666
  573669
  576069
  576097
  576405
  578363
  578449
  578492
  583728
  589169
  594817
  598514
  598537
  598642
  601753
  619092
  702031
  749723
  756689
  761591
  769160
  773287
  785763
  810052
]
1.70 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс зал"
]
1.63 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс зал"
]
1.41 ms
(0.77%)
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.