GET https://search.jues.net/search/embeds/4?q=%D0%B7%D0%B0%D0%BB

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.08 ms
(82.69%)
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
  339821
  382837
  385034
  385814
  390180
  397535
  401452
  405045
  410913
  415095
  419242
  434202
  434646
  438353
  439617
  440199
  440771
  442262
  443335
  443793
  444336
  444637
  446667
  446757
  447476
  449277
  450476
  451737
  452410
  453771
  454679
  455525
  456137
  458806
  463291
  467461
  467689
  470329
  474088
  474852
  476501
  477639
  479353
  480969
  481939
  484600
  486280
  493337
  493772
  495606
  498630
  499762
  501849
  502411
  503161
  503488
  505251
  506339
  506452
  506580
  506830
  508508
  509478
  510257
  511375
  511936
  514364
  515635
  516523
  518301
  518555
  519995
  520340
  521906
  521945
  521968
  522737
  522779
  523121
  523364
  523704
  523849
  523967
  524185
  524567
  526045
  526147
  527852
  528781
  536115
  547877
  547986
  553097
  554255
  558064
  560899
  561832
  564648
  565379
  567503
  569542
  569941
  570954
  576405
  578449
  578477
  578492
  590384
  598514
  598537
  598642
  601753
  617076
  619092
  633450
  749723
  791943
  813185
]
18.32 ms
(11.21%)
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
  569941
  576405
  578449
  578492
  619092
  601753
  633450
  598514
  598537
  749723
  382837
  454679
  476501
  480969
  385814
  397535
  401452
  434646
  447476
  449277
  479353
  434202
  444336
  477639
  390180
  419242
  438353
  440199
  452410
  470329
  522737
  523704
  523849
  524185
  493772
  498630
  502411
  515635
  518555
  521906
  521945
  523967
  526045
  493337
  506339
  506580
  526147
  499762
  509478
  511375
  514364
  528781
  72607
  385034
  339821
  410913
  442262
  415095
  443335
  455525
  458806
  456137
  486280
  474852
  510257
  523121
  523364
  536115
  520340
  527852
  501849
  547986
  574070
  564648
  567503
  569542
  578477
  553097
  561832
  570954
  547877
  554255
  558064
  560899
  565379
  590384
  617076
  598642
  791943
  813185
  440771
  443793
  451737
  405045
  453771
  463291
  439617
  450476
  467461
  467689
  444637
  446667
  474088
  481939
  446757
  503161
  506452
  518301
  519995
  521968
  522779
  484600
  495606
  503488
  505251
  506830
  508508
  511936
  516523
  524567
]
2.42 ms
(1.48%)
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
  339821
  382837
  385034
  385814
  390180
  397535
  401452
  405045
  410913
  415095
  419242
  434202
  434646
  438353
  439617
  440199
  440771
  442262
  443335
  443793
  444336
  444637
  446667
  446757
  447476
  449277
  450476
  451737
  452410
  453771
  454679
  455525
  456137
  458806
  463291
  467461
  467689
  470329
  474088
  474852
  476501
  477639
  479353
  480969
  481939
  484600
  486280
  493337
  493772
  495606
  498630
  499762
  501849
  502411
  503161
  503488
  505251
  506339
  506452
  506580
  506830
  508508
  509478
  510257
  511375
  511936
  514364
  515635
  516523
  518301
  518555
  519995
  520340
  521906
  521945
  521968
  522737
  522779
  523121
  523364
  523704
  523849
  523967
  524185
  524567
  526045
  526147
  527852
  528781
  536115
  547877
  547986
  553097
  554255
  558064
  560899
  561832
  564648
  565379
  567503
  569542
  569941
  570954
  576405
  578449
  578477
  578492
  590384
  598514
  598537
  598642
  601753
  617076
  619092
  633450
  749723
  791943
  813185
]
1.98 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зал"
]
1.94 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "зал"
]
1.87 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.