GET https://search.jues.net/search/embeds/7?q=%D0%B1%D0%BE%D0%BB%D1%82%20%D1%85%D1%85%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.09 ms
(86.96%)
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
  6768
  122661
  123011
  125762
  199489
  209790
  236378
  239151
  263752
  382902
  384315
  384501
  391066
  393872
  393980
  396765
  397110
  397692
  397802
  399061
  401982
  404272
  448701
  455937
  458275
  460487
  463596
  466484
  472463
  472646
  473042
  474215
  477606
  477613
  477698
  478614
  481032
  481193
  482182
  484280
  487039
  489234
  489546
  490700
  491011
  492313
  493004
  494835
  496673
  497783
  505454
  507099
  512635
  512637
  513262
  521658
  526863
  527400
  529357
  530294
  531331
  531946
  532196
  532457
  532770
  533109
  540892
  575831
  716845
  752343
  815321
  815424
  815612
  815660
  815894
  816207
  816296
  816459
  816578
  816674
  816759
  816913
  816918
  816967
  817141
  817501
  820806
  821025
  821030
  821095
  821104
  821994
  822254
  822430
  822631
  822662
  822683
  822854
  822956
  823084
  823307
  823343
  823375
  823387
  823507
  823954
  823972
  824170
  826004
  826107
  826554
  828099
  828353
  828395
  828589
  828825
  828828
  828847
  828849
]
11.11 ms
(7.00%)
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
  529357
  527400
  521658
  532457
  460487
  575831
  716845
  752343
  384501
  384315
  382902
  199489
  122661
  123011
  209790
  125762
  236378
  239151
  393872
  393980
  263752
  6768
  391066
  396765
  397110
  397692
  397802
  399061
  401982
  404272
  815424
  815612
  815660
  816578
  816918
  821030
  822956
  823291
  823507
  824170
  826004
  540892
  826554
  815321
  815894
  816674
  816759
  817141
  821994
  822254
  823084
  823954
  816207
  816459
  816913
  816967
  817501
  820806
  821025
  821095
  822430
  822683
  823343
  816296
  821104
  822631
  822662
  822854
  823307
  823375
  823387
  823972
  826107
  828828
  828395
  828825
  828849
  828099
  828353
  828847
  828589
  474215
  477613
  489234
  489546
  490700
  455937
  458275
  463596
  472463
  472646
  473042
  477698
  478614
  481193
  491011
  492313
  493004
  448701
  466484
  477606
  481032
  482182
  484280
  487039
  494835
  496673
  497783
  505454
  507099
  512635
  512637
  513262
  526863
  530294
  531331
  531946
  532196
  532770
  533109
]
2.47 ms
(1.56%)
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
  6768
  122661
  123011
  125762
  199489
  209790
  236378
  239151
  263752
  382902
  384315
  384501
  391066
  393872
  393980
  396765
  397110
  397692
  397802
  399061
  401982
  404272
  448701
  455937
  458275
  460487
  463596
  466484
  472463
  472646
  473042
  474215
  477606
  477613
  477698
  478614
  481032
  481193
  482182
  484280
  487039
  489234
  489546
  490700
  491011
  492313
  493004
  494835
  496673
  497783
  505454
  507099
  512635
  512637
  513262
  521658
  526863
  527400
  529357
  530294
  531331
  531946
  532196
  532457
  532770
  533109
  540892
  575831
  716845
  752343
  815321
  815424
  815612
  815660
  815894
  816207
  816296
  816459
  816578
  816674
  816759
  816913
  816918
  816967
  817141
  817501
  820806
  821025
  821030
  821095
  821104
  821994
  822254
  822430
  822631
  822662
  822683
  822854
  822956
  823084
  823307
  823343
  823375
  823387
  823507
  823954
  823972
  824170
  826004
  826107
  826554
  828099
  828353
  828395
  828589
  828825
  828828
  828847
  828849
]
2.09 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "болт ххх"
]
1.79 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член ххх"
]
1.70 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.97%)
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.