GET https://search.jues.net/search/embeds/7?q=cum%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.42 ms
(89.17%)
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
  388782
  396305
  397672
  417941
  423937
  442384
  449468
  453730
  455860
  460066
  462087
  476861
  477193
  482828
  483050
  493431
  496793
  500067
  507787
  507915
  508524
  509170
  513558
  514101
  516215
  516226
  516488
  521647
  523878
  527635
  527835
  529103
  530216
  531935
  540612
  540805
  543592
  552880
  555452
  558415
  563686
  563880
  564122
  566295
  574018
  574051
  577314
  590603
  595226
  595313
  609986
  610050
  612287
  618629
  620465
  624377
  626910
  636166
  639120
  640472
  641524
  641764
  648009
  649731
  671697
  675167
  679287
  689407
  697707
  704399
  707474
  710108
  713309
  713311
  715440
  721076
  726126
  738323
  753158
  755004
  759854
  766224
  768577
  768625
  768643
  770637
  773776
  778462
  782705
  784635
  788561
  788653
  791872
  794407
  797290
  802067
  803340
  811209
  819287
  823736
  823981
  824267
  824323
  824966
  825046
  825434
  825891
  826094
  826164
  826412
  826533
  828205
  828351
  828471
  828581
  828766
  828806
]
12.60 ms
(6.16%)
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
  493431
  641764
  574018
  707474
  636166
  626910
  811209
  397672
  823736
  825046
  825891
  826094
  828205
  828581
  766224
  396305
  609986
  496793
  540805
  476861
  508524
  516215
  527635
  531935
  552880
  558415
  566295
  590603
  462087
  442384
  455860
  500067
  527835
  483050
  514101
  516488
  523878
  509170
  555452
  697707
  704399
  713309
  721076
  618629
  639120
  610050
  791872
  755004
  759854
  825203
  828806
  824267
  825932
  828580
  788653
  423937
  449468
  530216
  516226
  540612
  543592
  802067
  417941
  477193
  521647
  513558
  388782
  564122
  612287
  826412
  826164
  577314
  574051
  648009
  649731
  671697
  710108
  713311
  675167
  689407
  679287
  563686
  595313
  641524
  624377
  782705
  726126
  738323
  753158
  620465
  640472
  715440
  778462
  797290
  824966
  823981
  825434
  794407
  768625
  768643
  784635
  768577
  770637
  773776
  788561
  826533
  819287
  824323
  828766
  828351
  803340
  595226
  828471
  563880
  482828
  460066
  453730
  507915
  507787
  529103
]
3.49 ms
(1.71%)
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
  388782
  396305
  397672
  417941
  423937
  442384
  449468
  453730
  455860
  460066
  462087
  476861
  477193
  482828
  483050
  493431
  496793
  500067
  507787
  507915
  508524
  509170
  513558
  514101
  516215
  516226
  516488
  521647
  523878
  527635
  527835
  529103
  530216
  531935
  540612
  540805
  543592
  552880
  555452
  558415
  563686
  563880
  564122
  566295
  574018
  574051
  577314
  590603
  595226
  595313
  609986
  610050
  612287
  618629
  620465
  624377
  626910
  636166
  639120
  640472
  641524
  641764
  648009
  649731
  671697
  675167
  679287
  689407
  697707
  704399
  707474
  710108
  713309
  713311
  715440
  721076
  726126
  738323
  753158
  755004
  759854
  766224
  768577
  768625
  768643
  770637
  773776
  778462
  782705
  784635
  788561
  788653
  791872
  794407
  797290
  802067
  803340
  811209
  819287
  823736
  823981
  824267
  824323
  824966
  825046
  825434
  825891
  826094
  826164
  826412
  826533
  828205
  828351
  828471
  828581
  828766
  828806
]
1.67 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum amateur"
]
1.64 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum любительск"
]
1.44 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.31 ms
(0.64%)
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.