GET https://search.jues.net/search/embeds/5?q=cum%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.62 ms
(81.71%)
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
  396088
  409685
  422305
  434470
  435213
  447692
  451240
  451791
  454541
  460330
  469500
  473166
  475305
  484520
  486147
  488628
  488995
  499860
  508167
  509704
  513843
  515808
  516963
  527372
  529526
  529710
  530908
  536682
  539225
  554248
  563778
  585627
  595832
  600439
  600442
  600669
  610091
  610148
  611028
  613805
  616650
  619597
  621477
  625605
  627307
  632294
  640905
  643132
  644722
  645626
  674815
  678180
  682259
  684980
  701613
  703977
  710805
  711542
  711552
  711555
  714515
  714521
  718011
  729181
  732428
  733142
  733498
  737130
  737177
  738480
  738748
  742100
  744370
  745980
  746100
  746117
  752308
  754124
  756703
  758847
  759015
  759754
  763626
  764307
  765357
  767607
  770954
  770964
  771221
  771564
  772385
  774794
  776080
  784793
  785624
  787864
  788828
  790844
  790862
  794609
  795701
  796168
  799523
  800211
  802364
  806797
  809670
  810906
  811079
  811906
  812827
  814212
  814257
  814497
  815208
  817320
  818072
  822042
  823275
  824174
]
17.38 ms
(11.97%)
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
  486147
  814212
  814257
  814497
  817320
  822042
  460330
  454541
  475305
  484520
  527372
  529526
  530908
  516963
  563778
  674815
  678180
  682259
  701613
  711542
  711555
  684980
  703977
  645626
  710805
  711552
  554248
  600669
  621477
  600442
  613805
  644722
  595832
  600439
  610091
  616650
  625605
  643132
  585627
  619597
  627307
  787864
  790844
  796168
  776080
  784793
  790862
  794609
  799523
  810906
  811906
  812827
  745980
  754124
  767607
  772385
  802364
  732428
  742100
  746117
  752308
  759754
  738480
  738748
  765357
  770954
  771221
  729181
  733142
  737177
  746100
  756703
  771564
  733498
  737130
  758847
  759015
  763626
  764307
  770964
  610148
  632294
  640905
  714515
  714521
  718011
  774794
  785624
  788828
  795701
  800211
  806797
  809670
  811079
  434470
  396088
  513843
  451240
  435213
  515808
  529710
  488995
  744370
  611028
  409685
  422305
  818072
  823275
  815208
  824174
  447692
  469500
  473166
  451791
  488628
  508167
  499860
  509704
  536682
  539225
]
2.26 ms
(1.55%)
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
  396088
  409685
  422305
  434470
  435213
  447692
  451240
  451791
  454541
  460330
  469500
  473166
  475305
  484520
  486147
  488628
  488995
  499860
  508167
  509704
  513843
  515808
  516963
  527372
  529526
  529710
  530908
  536682
  539225
  554248
  563778
  585627
  595832
  600439
  600442
  600669
  610091
  610148
  611028
  613805
  616650
  619597
  621477
  625605
  627307
  632294
  640905
  643132
  644722
  645626
  674815
  678180
  682259
  684980
  701613
  703977
  710805
  711542
  711552
  711555
  714515
  714521
  718011
  729181
  732428
  733142
  733498
  737130
  737177
  738480
  738748
  742100
  744370
  745980
  746100
  746117
  752308
  754124
  756703
  758847
  759015
  759754
  763626
  764307
  765357
  767607
  770954
  770964
  771221
  771564
  772385
  774794
  776080
  784793
  785624
  787864
  788828
  790844
  790862
  794609
  795701
  796168
  799523
  800211
  802364
  806797
  809670
  810906
  811079
  811906
  812827
  814212
  814257
  814497
  815208
  817320
  818072
  822042
  823275
  824174
]
2.15 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum latina"
]
1.90 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum латинская"
]
1.38 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum латинская"
]

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.