GET https://search.jues.net/search/embeds/6?q=latina%20bbc

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.20 ms
(83.96%)
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
  70082
  404175
  404459
  405178
  418759
  428603
  432574
  432799
  443232
  447143
  452114
  452206
  454802
  455984
  458125
  462829
  464133
  464644
  468826
  470848
  475273
  476138
  476901
  486674
  489167
  492134
  493801
  494349
  499890
  501255
  503241
  503683
  506024
  506034
  507824
  513894
  513910
  514676
  518176
  520766
  520841
  525777
  527091
  529166
  530497
  534650
  534961
  535672
  536569
  536699
  536869
  537673
  538653
  542224
  542859
  543393
  543875
  547865
  549858
  550834
  557102
  557526
  557546
  561309
  561451
  565418
  566059
  575863
  579138
  579425
  579761
  586244
  596200
  597753
  599637
  603038
  606599
  610284
  613452
  614020
  619392
  623180
  623962
  623973
  630575
  630870
  631199
  633113
  636275
  637085
  640686
  643046
  651668
  666538
  676090
  678201
  711554
  711565
  711568
  711569
  715615
  715630
  720291
  720340
  720394
  723986
  727692
  730216
  732331
  738030
  738047
  738050
  753077
  753211
  760068
  761432
  790853
  814798
  814816
  823303
]
16.69 ms
(10.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
  579761
  542859
  547865
  579138
  543393
  549858
  557546
  561451
  711568
  715615
  720340
  678201
  711554
  711569
  651668
  711565
  715630
  720394
  550834
  561309
  640686
  586244
  596200
  599637
  603038
  623180
  633113
  643046
  636275
  753077
  760068
  730216
  723986
  753211
  727692
  732331
  738050
  761432
  738030
  613452
  790853
  447143
  464644
  475273
  464133
  536869
  489167
  494349
  507824
  525777
  535672
  676090
  557526
  452114
  520766
  405178
  418759
  823303
  814798
  814816
  470848
  455984
  486674
  452206
  513910
  530497
  536699
  538653
  506024
  513894
  514676
  520841
  536569
  537673
  503241
  503683
  506034
  529166
  534961
  476138
  542224
  543875
  557102
  579425
  565418
  566059
  575863
  606599
  630575
  630870
  610284
  623973
  637085
  614020
  623962
  597753
  631199
  738047
  619392
  720291
  428603
  462829
  518176
  493801
  454802
  666538
  499890
  70082
  404175
  404459
  432799
  443232
  432574
  458125
  468826
  476901
  492134
  501255
  527091
  534650
]
2.84 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
  70082
  404175
  404459
  405178
  418759
  428603
  432574
  432799
  443232
  447143
  452114
  452206
  454802
  455984
  458125
  462829
  464133
  464644
  468826
  470848
  475273
  476138
  476901
  486674
  489167
  492134
  493801
  494349
  499890
  501255
  503241
  503683
  506024
  506034
  507824
  513894
  513910
  514676
  518176
  520766
  520841
  525777
  527091
  529166
  530497
  534650
  534961
  535672
  536569
  536699
  536869
  537673
  538653
  542224
  542859
  543393
  543875
  547865
  549858
  550834
  557102
  557526
  557546
  561309
  561451
  565418
  566059
  575863
  579138
  579425
  579761
  586244
  596200
  597753
  599637
  603038
  606599
  610284
  613452
  614020
  619392
  623180
  623962
  623973
  630575
  630870
  631199
  633113
  636275
  637085
  640686
  643046
  651668
  666538
  676090
  678201
  711554
  711565
  711568
  711569
  715615
  715630
  720291
  720340
  720394
  723986
  727692
  730216
  732331
  738030
  738047
  738050
  753077
  753211
  760068
  761432
  790853
  814798
  814816
  823303
]
1.71 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina bbc"
]
1.54 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "латинская bbc"
]
1.41 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская bbc"
]

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.