GET https://search.jues.net/search/embeds/2?q=erotic%20sexy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.63 ms
(86.71%)
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
  235677
  298293
  381813
  385630
  389283
  408787
  409340
  459833
  505174
  523368
  523376
  524030
  528987
  530422
  532391
  536112
  548855
  553374
  555970
  561374
  575662
  576613
  577032
  577085
  590522
  600199
  603348
  604035
  605113
  611232
  611382
  618537
  619178
  625096
  629853
  634457
  637293
  641053
  642876
  655470
  656279
  658846
  671097
  687718
  704626
  708543
  712171
  712806
  716360
  718489
  720516
  732077
  733055
  735672
  736008
  738104
  740509
  741330
  744130
  744226
  744770
  745296
  745543
  745616
  745991
  746838
  748183
  748574
  749376
  749393
  751002
  751210
  751365
  751392
  751780
  752239
  752394
  753737
  755565
  758107
  768598
  769093
  772940
  773031
  773151
  776725
  777149
  777150
  777835
  784045
  784128
  788012
  789090
  789676
  790242
  790731
  792888
  792932
  792969
  793928
  797398
  798153
  802259
  803018
  805918
  806813
  807040
  807088
  808607
  812736
  814441
  816659
  816730
  816738
  819117
  825335
  827241
  827286
  827537
]
12.70 ms
(7.36%)
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
  642876
  777149
  789676
  790731
  777150
  732077
  745991
  746838
  748574
  749376
  772940
  793928
  733055
  751392
  773031
  735672
  751002
  768598
  744226
  745296
  753737
  736008
  740509
  749393
  751365
  712806
  784045
  789090
  798153
  808607
  298293
  389283
  381813
  409340
  523376
  528987
  523368
  575662
  553374
  603348
  524030
  235677
  408787
  825335
  814441
  816659
  819117
  827241
  827537
  816730
  816738
  827286
  459833
  532391
  536112
  505174
  530422
  561374
  577032
  577085
  687718
  656279
  658846
  655470
  671097
  704626
  708543
  720516
  548855
  590522
  611382
  641053
  604035
  618537
  637293
  600199
  605113
  611232
  619178
  625096
  634457
  777835
  788012
  790242
  792969
  797398
  805918
  744770
  751210
  752394
  792932
  741330
  745616
  748183
  758107
  745543
  751780
  755565
  773151
  744130
  752239
  769093
  738104
  629853
  712171
  716360
  718489
  776051
  776725
  784128
  792888
  802259
  803018
  806813
  807040
  807088
  812736
  385630
  555970
  576613
]
2.47 ms
(1.43%)
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
  235677
  298293
  381813
  385630
  389283
  408787
  409340
  459833
  505174
  523368
  523376
  524030
  528987
  530422
  532391
  536112
  548855
  553374
  555970
  561374
  575662
  576613
  577032
  577085
  590522
  600199
  603348
  604035
  605113
  611232
  611382
  618537
  619178
  625096
  629853
  634457
  637293
  641053
  642876
  655470
  656279
  658846
  671097
  687718
  704626
  708543
  712171
  712806
  716360
  718489
  720516
  732077
  733055
  735672
  736008
  738104
  740509
  741330
  744130
  744226
  744770
  745296
  745543
  745616
  745991
  746838
  748183
  748574
  749376
  749393
  751002
  751210
  751365
  751392
  751780
  752239
  752394
  753737
  755565
  758107
  768598
  769093
  772940
  773031
  773151
  776725
  777149
  777150
  777835
  784045
  784128
  788012
  789090
  789676
  790242
  790731
  792888
  792932
  792969
  793928
  797398
  798153
  802259
  803018
  805918
  806813
  807040
  807088
  808607
  812736
  814441
  816659
  816730
  816738
  819117
  825335
  827241
  827286
  827537
]
2.13 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "erotic sexy"
]
2.01 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "эротик sexy"
]
1.69 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "эротик sexy"
]

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.