GET https://search.jues.net/search/embeds/9?q=%D1%82%D1%80%D0%B0%D1%85%20%D0%BD%D0%B0%20%D0%BF%D0%BE%D0%BF%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.57 ms
(85.23%)
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
  27777
  161427
  185859
  274100
  383266
  391296
  398579
  407122
  407538
  411279
  415099
  416853
  424547
  430390
  440265
  440939
  443089
  446611
  452310
  453395
  457715
  458946
  459798
  462286
  463114
  463898
  464006
  465543
  469172
  469236
  471170
  473274
  475516
  479622
  480400
  489173
  489278
  492355
  499706
  504666
  504853
  508645
  510126
  512043
  513239
  521367
  521410
  521926
  522483
  526585
  527021
  527633
  532952
  534573
  534585
  534864
  536063
  537251
  538907
  539178
  539300
  542252
  542736
  542837
  544610
  546628
  547618
  559087
  559212
  560297
  561631
  568452
  569447
  570087
  571061
  580864
  584713
  588290
  592605
  596954
  598626
  601034
  602306
  606206
  608637
  609799
  613579
  614253
  615605
  620196
  621158
  623656
  628798
  636003
  637460
  644943
  647212
  655268
  664193
  670490
  702331
  719945
  739487
  759472
  761143
  768013
  793214
  799503
  801267
  801322
  802822
  806403
  814713
  817881
  819314
  820624
  821071
  823841
  826249
  828034
]
19.99 ms
(9.60%)
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
  569447
  647212
  561631
  801267
  479622
  522483
  580864
  623656
  637460
  416853
  814713
  542736
  499706
  521367
  440265
  471170
  383266
  510126
  407122
  430390
  452310
  469236
  458946
  459798
  527021
  539178
  513239
  504666
  508645
  521410
  560297
  571061
  568452
  570087
  615605
  473274
  521926
  821071
  826249
  799503
  492355
  644943
  664193
  806403
  636003
  185859
  614253
  424547
  592605
  489173
  443089
  537251
  464006
  601034
  161427
  512043
  534573
  544610
  407538
  440939
  759472
  391296
  609799
  628798
  702331
  534585
  761143
  489278
  819314
  823841
  542252
  504853
  274100
  802822
  457715
  536063
  415099
  453395
  463114
  463898
  469172
  532952
  547618
  546628
  608637
  598626
  621158
  801322
  584713
  739487
  828034
  538907
  820624
  817881
  719945
  559212
  534864
  27777
  398579
  411279
  793214
  596954
  475516
  465543
  655268
  588290
  606206
  768013
  620196
  602306
  480400
  542837
  613579
  526585
  539300
  527633
  670490
  559087
  446611
  462286
]
3.33 ms
(1.60%)
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
  27777
  161427
  185859
  274100
  383266
  391296
  398579
  407122
  407538
  411279
  415099
  416853
  424547
  430390
  440265
  440939
  443089
  446611
  452310
  453395
  457715
  458946
  459798
  462286
  463114
  463898
  464006
  465543
  469172
  469236
  471170
  473274
  475516
  479622
  480400
  489173
  489278
  492355
  499706
  504666
  504853
  508645
  510126
  512043
  513239
  521367
  521410
  521926
  522483
  526585
  527021
  527633
  532952
  534573
  534585
  534864
  536063
  537251
  538907
  539178
  539300
  542252
  542736
  542837
  544610
  546628
  547618
  559087
  559212
  560297
  561631
  568452
  569447
  570087
  571061
  580864
  584713
  588290
  592605
  596954
  598626
  601034
  602306
  606206
  608637
  609799
  613579
  614253
  615605
  620196
  621158
  623656
  628798
  636003
  637460
  644943
  647212
  655268
  664193
  670490
  702331
  719945
  739487
  759472
  761143
  768013
  793214
  799503
  801267
  801322
  802822
  806403
  814713
  817881
  819314
  820624
  821071
  823841
  826249
  828034
]
2.19 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трах на попу"
]
1.84 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс на жоп"
]
1.77 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.79%)
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.