GET https://search.jues.net/search/embeds/3?q=big%20oral

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.99 ms
(84.40%)
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
  152276
  397495
  398491
  411552
  418297
  419158
  419839
  420641
  422131
  423600
  424010
  424539
  428872
  429750
  433701
  434531
  437451
  437782
  438035
  438049
  441217
  442852
  445655
  446182
  449292
  449342
  450115
  450119
  450160
  452732
  453117
  456055
  456566
  456946
  457843
  459586
  466105
  466332
  466854
  469196
  469658
  473118
  481270
  483842
  485984
  491096
  491414
  492835
  494168
  496231
  496405
  507508
  507674
  511213
  520901
  522450
  522801
  522820
  528267
  542488
  543369
  551625
  560243
  561806
  563390
  570301
  570310
  570325
  570348
  570498
  572429
  573683
  573811
  586322
  595404
  595665
  597992
  607109
  614170
  619458
  621099
  623361
  639720
  657246
  669771
  672989
  675829
  678018
  682877
  713208
  724609
  728869
  729265
  734003
  734047
  736363
  738347
  742757
  748928
  750816
  751732
  754260
  762540
  762743
  764250
  765102
  768797
  771571
  777526
  779534
  779576
  779768
  780072
  786542
  795632
  796009
  797340
  808260
  810683
  817086
]
15.94 ms
(9.28%)
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
  764250
  779534
  817086
  542488
  570301
  672989
  675829
  682877
  657246
  570498
  586322
  808260
  734003
  754260
  771571
  810683
  438035
  419839
  453117
  560243
  520901
  398491
  450160
  511213
  779768
  786542
  765102
  751732
  466105
  466332
  152276
  491414
  456946
  522450
  469196
  573683
  669771
  713208
  623361
  614170
  750816
  507508
  422131
  441217
  446182
  457843
  570325
  621099
  595665
  779576
  780072
  724609
  742757
  768797
  738347
  797340
  428872
  445655
  522801
  397495
  551625
  570348
  678018
  563390
  570310
  572429
  573811
  597992
  607109
  639720
  777526
  795632
  796009
  762540
  748928
  728869
  437782
  433701
  434531
  442852
  423600
  411552
  419158
  424010
  420641
  429750
  450115
  450119
  456566
  449342
  459586
  456055
  469658
  494168
  496231
  543369
  561806
  595404
  619458
  729265
  734047
  736363
  762743
  473118
  481270
  418297
  449292
  424539
  452732
  438049
  437451
  466854
  522820
  528267
  483842
  496405
  492835
  491096
  507674
  485984
]
3.15 ms
(1.84%)
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
  152276
  397495
  398491
  411552
  418297
  419158
  419839
  420641
  422131
  423600
  424010
  424539
  428872
  429750
  433701
  434531
  437451
  437782
  438035
  438049
  441217
  442852
  445655
  446182
  449292
  449342
  450115
  450119
  450160
  452732
  453117
  456055
  456566
  456946
  457843
  459586
  466105
  466332
  466854
  469196
  469658
  473118
  481270
  483842
  485984
  491096
  491414
  492835
  494168
  496231
  496405
  507508
  507674
  511213
  520901
  522450
  522801
  522820
  528267
  542488
  543369
  551625
  560243
  561806
  563390
  570301
  570310
  570325
  570348
  570498
  572429
  573683
  573811
  586322
  595404
  595665
  597992
  607109
  614170
  619458
  621099
  623361
  639720
  657246
  669771
  672989
  675829
  678018
  682877
  713208
  724609
  728869
  729265
  734003
  734047
  736363
  738347
  742757
  748928
  750816
  751732
  754260
  762540
  762743
  764250
  765102
  768797
  771571
  777526
  779534
  779576
  779768
  780072
  786542
  795632
  796009
  797340
  808260
  810683
  817086
]
2.13 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие oral"
]
2.13 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big oral"
]
1.57 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие oral"
]

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.