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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.18 ms
(87.87%)
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
  288584
  394224
  406217
  409701
  415640
  416385
  426059
  428082
  438952
  454091
  472514
  477516
  479781
  484952
  512038
  519694
  525182
  536852
  540542
  558623
  560510
  578718
  583570
  612700
  616026
  628081
  646001
  661570
  669315
  674865
  703500
  704281
  706784
  707386
  708055
  709326
  709707
  710285
  711536
  711616
  713083
  713143
  715687
  718069
  724004
  724921
  727963
  728249
  728412
  730333
  730517
  732203
  732976
  735013
  735709
  735761
  738004
  738447
  740543
  749460
  750536
  750854
  752415
  752474
  756538
  757654
  759749
  759880
  760527
  760646
  762033
  762815
  765367
  766956
  767095
  768164
  770084
  770086
  775396
  775715
  785638
  788151
  792585
  796597
  797143
  797477
  797744
  799692
  800594
  802478
  803098
  804257
  805945
  807738
  808448
  809368
  810948
  812419
  813472
  813832
  813870
  813888
  814034
  814278
  815028
  815819
  816214
  816624
  816998
  817383
  817931
  818985
  819653
  820990
  823439
  823475
  825910
  826273
]
14.57 ms
(7.44%)
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
  738004
  760527
  797143
  807738
  735013
  750854
  759880
  728249
  732976
  750536
  735709
  757654
  759749
  767095
  770086
  703500
  710285
  715687
  718069
  775715
  792585
  797744
  800594
  288584
  788151
  409701
  454091
  479781
  578718
  661570
  805945
  809368
  416385
  519694
  394224
  415640
  428082
  484952
  472514
  560510
  616026
  406217
  426059
  438952
  477516
  512038
  813832
  818985
  819653
  820990
  813888
  815028
  825910
  525182
  706784
  711536
  711616
  674865
  709707
  669315
  708055
  558623
  583570
  628081
  612700
  785638
  802478
  810948
  812419
  775396
  776494
  804257
  813472
  735761
  752474
  762815
  797477
  799692
  803098
  808448
  727963
  728412
  724004
  738447
  749460
  766956
  768164
  730333
  730517
  740543
  752415
  756538
  770084
  732203
  760646
  762033
  765367
  704281
  707386
  709326
  713083
  713143
  776323
  796597
  646001
  724921
  814034
  816214
  817383
  823439
  826273
  813870
  816624
  816998
  823475
  814278
  815819
  817931
  536852
  540542
]
3.47 ms
(1.77%)
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
  288584
  394224
  406217
  409701
  415640
  416385
  426059
  428082
  438952
  454091
  472514
  477516
  479781
  484952
  512038
  519694
  525182
  536852
  540542
  558623
  560510
  578718
  583570
  612700
  616026
  628081
  646001
  661570
  669315
  674865
  703500
  704281
  706784
  707386
  708055
  709326
  709707
  710285
  711536
  711616
  713083
  713143
  715687
  718069
  724004
  724921
  727963
  728249
  728412
  730333
  730517
  732203
  732976
  735013
  735709
  735761
  738004
  738447
  740543
  749460
  750536
  750854
  752415
  752474
  756538
  757654
  759749
  759880
  760527
  760646
  762033
  762815
  765367
  766956
  767095
  768164
  770084
  770086
  775396
  775715
  785638
  788151
  792585
  796597
  797143
  797477
  797744
  799692
  800594
  802478
  803098
  804257
  805945
  807738
  808448
  809368
  810948
  812419
  813472
  813832
  813870
  813888
  814034
  814278
  815028
  815819
  816214
  816624
  816998
  817383
  817931
  818985
  819653
  820990
  823439
  823475
  825910
  826273
]
1.52 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina hot"
]
1.47 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "латинская hot"
]
1.38 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская hot"
]

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.