GET https://search.jues.net/search/embeds/5?q=amateur%20erotic

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.08 ms
(85.46%)
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
  382552
  399540
  424950
  517901
  529725
  529868
  531017
  531047
  531052
  531813
  531842
  531984
  532411
  532832
  533154
  533778
  533784
  534692
  535737
  536574
  537055
  537067
  537081
  537506
  540558
  542402
  547192
  550147
  553533
  579217
  591299
  594856
  602597
  606813
  610590
  613769
  617697
  628021
  628253
  631274
  643211
  657864
  669321
  681802
  696145
  705779
  716235
  725172
  727322
  729166
  730017
  730499
  730738
  732922
  733376
  735891
  737031
  737799
  738019
  738071
  738087
  738950
  740140
  740264
  740656
  741215
  742808
  743689
  745335
  745389
  745558
  746113
  747538
  748449
  748573
  749655
  750656
  751365
  752289
  752335
  752389
  752396
  752418
  752484
  752583
  752844
  753067
  753127
  754085
  754521
  754586
  754602
  754983
  757060
  757827
  758449
  758862
  759090
  759361
  760371
  760718
  768963
  769331
  773048
  777607
  779644
  780142
  782848
  783280
  783656
  784368
  785949
  788404
  789224
  789418
  795712
  799823
  804424
  812546
  823885
]
11.23 ms
(7.86%)
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
  628253
  613769
  594856
  606813
  631274
  777607
  783280
  789224
  812546
  782848
  785949
  795712
  729166
  730017
  730738
  741215
  749655
  750656
  752335
  752396
  754521
  757060
  758862
  773048
  799823
  745335
  745558
  752389
  753067
  754602
  754983
  759361
  760371
  727322
  730499
  733376
  737799
  748573
  752844
  754085
  758449
  759090
  738071
  742808
  743689
  752289
  752484
  757827
  769331
  725172
  737031
  738019
  738087
  738950
  740140
  740656
  752583
  753127
  754586
  617697
  705779
  716235
  784368
  789418
  399540
  382552
  823885
  535737
  804424
  783656
  745389
  752418
  788404
  732922
  740264
  735891
  747538
  760718
  746113
  768963
  779644
  780142
  424950
  669321
  628021
  748449
  547192
  550147
  553533
  542402
  579217
  696145
  657864
  681802
  602597
  643211
  751365
  610590
  531047
  591299
  517901
  532411
  532832
  533154
  533778
  533784
  534692
  536574
  529725
  531017
  531052
  531813
  531842
  537055
  537067
  537081
  537506
  540558
  529868
  531984
]
2.65 ms
(1.86%)
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
  382552
  399540
  424950
  517901
  529725
  529868
  531017
  531047
  531052
  531813
  531842
  531984
  532411
  532832
  533154
  533778
  533784
  534692
  535737
  536574
  537055
  537067
  537081
  537506
  540558
  542402
  547192
  550147
  553533
  579217
  591299
  594856
  602597
  606813
  610590
  613769
  617697
  628021
  628253
  631274
  643211
  657864
  669321
  681802
  696145
  705779
  716235
  725172
  727322
  729166
  730017
  730499
  730738
  732922
  733376
  735891
  737031
  737799
  738019
  738071
  738087
  738950
  740140
  740264
  740656
  741215
  742808
  743689
  745335
  745389
  745558
  746113
  747538
  748449
  748573
  749655
  750656
  751365
  752289
  752335
  752389
  752396
  752418
  752484
  752583
  752844
  753067
  753127
  754085
  754521
  754586
  754602
  754983
  757060
  757827
  758449
  758862
  759090
  759361
  760371
  760718
  768963
  769331
  773048
  777607
  779644
  780142
  782848
  783280
  783656
  784368
  785949
  788404
  789224
  789418
  795712
  799823
  804424
  812546
  823885
]
1.94 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск эротик"
]
1.92 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur erotic"
]
1.55 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск эротик"
]
1.47 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.