GET https://search.jues.net/search/embeds/3?q=casting%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.00 ms
(83.45%)
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
  10077
  384337
  397995
  406390
  411768
  428571
  433069
  435665
  450253
  453130
  454777
  457645
  458921
  458992
  462908
  464024
  464451
  467666
  469537
  469619
  472209
  474761
  477491
  478098
  485066
  486699
  492726
  506376
  509837
  513323
  513704
  514183
  518519
  519694
  523654
  527480
  528688
  529070
  529256
  529525
  532356
  535045
  536640
  536915
  543892
  543894
  549472
  556036
  566032
  566068
  572828
  575711
  579813
  580157
  585726
  587566
  591902
  591965
  595679
  600686
  601034
  606714
  608629
  612807
  612854
  619392
  622411
  626118
  630277
  631654
  632336
  636043
  637060
  640789
  643376
  647891
  648213
  650179
  652282
  653179
  661935
  665727
  667749
  673969
  674127
  674452
  676150
  678940
  696063
  707472
  712717
  713083
  714518
  716334
  720117
  720397
  724977
  726649
  726661
  727396
  731685
  732347
  733968
  737343
  738793
  750712
  753104
  755989
  756200
  758332
  758523
  760041
  775940
  793855
  795074
  808084
  810221
  811759
  811947
  814240
]
14.59 ms
(10.06%)
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
  724977
  731685
  756200
  733968
  737343
  713083
  714518
  775940
  457645
  458992
  469537
  472209
  458921
  647891
  566032
  601034
  600686
  632336
  732347
  519694
  529256
  527480
  485066
  637060
  433069
  814240
  467666
  477491
  514183
  536915
  529525
  648213
  653179
  673969
  712717
  587566
  595679
  622411
  793855
  760041
  808084
  811759
  726649
  726661
  727396
  753104
  612807
  384337
  486699
  453130
  462908
  535045
  536640
  464451
  566068
  397995
  406390
  428571
  435665
  478098
  518519
  572828
  543892
  469619
  492726
  513704
  506376
  556036
  529070
  523654
  513323
  543894
  549472
  665727
  707472
  720397
  676150
  716334
  591965
  606714
  636043
  626118
  795074
  810221
  811947
  750712
  755989
  758523
  738793
  758332
  630277
  720117
  10077
  450253
  454777
  411768
  575711
  619392
  474761
  464024
  650179
  640789
  608629
  643376
  528688
  509837
  532356
  580157
  579813
  674452
  667749
  674127
  696063
  652282
  661935
  678940
  585726
  631654
  591902
  612854
]
2.57 ms
(1.78%)
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
  10077
  384337
  397995
  406390
  411768
  428571
  433069
  435665
  450253
  453130
  454777
  457645
  458921
  458992
  462908
  464024
  464451
  467666
  469537
  469619
  472209
  474761
  477491
  478098
  485066
  486699
  492726
  506376
  509837
  513323
  513704
  514183
  518519
  519694
  523654
  527480
  528688
  529070
  529256
  529525
  532356
  535045
  536640
  536915
  543892
  543894
  549472
  556036
  566032
  566068
  572828
  575711
  579813
  580157
  585726
  587566
  591902
  591965
  595679
  600686
  601034
  606714
  608629
  612807
  612854
  619392
  622411
  626118
  630277
  631654
  632336
  636043
  637060
  640789
  643376
  647891
  648213
  650179
  652282
  653179
  661935
  665727
  667749
  673969
  674127
  674452
  676150
  678940
  696063
  707472
  712717
  713083
  714518
  716334
  720117
  720397
  724977
  726649
  726661
  727396
  731685
  732347
  733968
  737343
  738793
  750712
  753104
  755989
  756200
  758332
  758523
  760041
  775940
  793855
  795074
  808084
  810221
  811759
  811947
  814240
]
1.97 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting latina"
]
1.68 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг латинская"
]
1.56 ms
(1.08%)
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.