GET https://search.jues.net/search/embeds/5?q=massage%20sex%20fuck

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.22 ms
(84.13%)
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
  7753
  8347
  106347
  156525
  185249
  185494
  185606
  185861
  205147
  282864
  320786
  357839
  379578
  382188
  382292
  384864
  385538
  386747
  387052
  387652
  389518
  393848
  397499
  401492
  402604
  402607
  404127
  406445
  406578
  408017
  408043
  410026
  415691
  415934
  418421
  420091
  447020
  447542
  447842
  450763
  451116
  454974
  463867
  463882
  464195
  464474
  481087
  498875
  500178
  500689
  504444
  506147
  506795
  510045
  510049
  531725
  538352
  538365
  543791
  551334
  551386
  551405
  551432
  557337
  560101
  561669
  564462
  569824
  573932
  574902
  580644
  592054
  592815
  595865
  600628
  606637
  618938
  621418
  623950
  623958
  624285
  628345
  636522
  641663
  653497
  661078
  663533
  677030
  684572
  685612
  689311
  689591
  694610
  711057
  715853
  725570
  727454
  741631
  744480
  744631
  747345
  748663
  758812
  770159
  773024
  773068
  773098
  773199
  782420
  784702
  794719
  799310
  799956
  800069
  801905
  805398
  805566
  813771
  818784
  825204
]
15.08 ms
(8.17%)
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
  543791
  385538
  510049
  564462
  592815
  623958
  389518
  805566
  418421
  560101
  606637
  401492
  415934
  406445
  801905
  747345
  379578
  773098
  463882
  406578
  408043
  451116
  551432
  569824
  684572
  711057
  551334
  624285
  621418
  782420
  799310
  741631
  727454
  641663
  799956
  800069
  500689
  531725
  185606
  408017
  573932
  715853
  725570
  387652
  447542
  463867
  464195
  818784
  661078
  402604
  402607
  410026
  813771
  538352
  504444
  580644
  653497
  551405
  636522
  618938
  805398
  784702
  748663
  744631
  185249
  387052
  447020
  592054
  393848
  205147
  106347
  282864
  557337
  561669
  689591
  551386
  574902
  600628
  773199
  773024
  744480
  7753
  8347
  415691
  454974
  510045
  506147
  694610
  404127
  420091
  185494
  382292
  357839
  450763
  685612
  623950
  794719
  770159
  758812
  481087
  447842
  397499
  825204
  677030
  386747
  384864
  156525
  185861
  320786
  506795
  538365
  689311
  663533
  595865
  628345
  773068
  382188
  464474
  500178
  498875
]
6.89 ms
(3.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage sex fuck"
]
2.86 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
  7753
  8347
  106347
  156525
  185249
  185494
  185606
  185861
  205147
  282864
  320786
  357839
  379578
  382188
  382292
  384864
  385538
  386747
  387052
  387652
  389518
  393848
  397499
  401492
  402604
  402607
  404127
  406445
  406578
  408017
  408043
  410026
  415691
  415934
  418421
  420091
  447020
  447542
  447842
  450763
  451116
  454974
  463867
  463882
  464195
  464474
  481087
  498875
  500178
  500689
  504444
  506147
  506795
  510045
  510049
  531725
  538352
  538365
  543791
  551334
  551386
  551405
  551432
  557337
  560101
  561669
  564462
  569824
  573932
  574902
  580644
  592054
  592815
  595865
  600628
  606637
  618938
  621418
  623950
  623958
  624285
  628345
  636522
  641663
  653497
  661078
  663533
  677030
  684572
  685612
  689311
  689591
  694610
  711057
  715853
  725570
  727454
  741631
  744480
  744631
  747345
  748663
  758812
  770159
  773024
  773068
  773098
  773199
  782420
  784702
  794719
  799310
  799956
  800069
  801905
  805398
  805566
  813771
  818784
  825204
]
1.59 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "массаж секс секс"
]
1.55 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(0.71%)
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.