GET https://search.jues.net/search/embeds/7?q=sex%20date

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.61 ms
(85.00%)
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
  393342
  399861
  413740
  413950
  420002
  421704
  424314
  424380
  424926
  426336
  427180
  427898
  432721
  434574
  441356
  441631
  441640
  442307
  442965
  444343
  445652
  447102
  447434
  448971
  449462
  450941
  451141
  452492
  454924
  455062
  456531
  456987
  457564
  457587
  458730
  459946
  463478
  464662
  465326
  466376
  468779
  469475
  471319
  473006
  473537
  484084
  488219
  488373
  488409
  493842
  495479
  495579
  496603
  496973
  497300
  501680
  506674
  507800
  508198
  508483
  509611
  510575
  511152
  512996
  513049
  513098
  513182
  513662
  516989
  517478
  518334
  519378
  520260
  520623
  520728
  520736
  521025
  522433
  526933
  527123
  528447
  528640
  528743
  528888
  548735
  551147
  561073
  561850
  562789
  565400
  569033
  569232
  571508
  575361
  575406
  575756
  578812
  579670
  584724
  586659
  591385
  592724
  593558
  594009
  595730
  597720
  600449
  603663
  606377
  616909
  624805
  624925
  625244
  625951
  649174
  666903
  667417
  681370
  766590
  814460
]
17.82 ms
(9.80%)
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
  526933
  814460
  459946
  455062
  458730
  510575
  569033
  592724
  616909
  434574
  413740
  518334
  496973
  501680
  519378
  579670
  551147
  593558
  420002
  457587
  427898
  508483
  488409
  469475
  649174
  548735
  528743
  456987
  528888
  495479
  444343
  473537
  513662
  442307
  451141
  465326
  522433
  597720
  399861
  512996
  562789
  565400
  591385
  595730
  624805
  766590
  497300
  421704
  432721
  484084
  447102
  527123
  575361
  681370
  667417
  571508
  600449
  586659
  393342
  448971
  426336
  427180
  447434
  493842
  520623
  441631
  424926
  424314
  450941
  520260
  509611
  464662
  569232
  578812
  473006
  452492
  521025
  511152
  495579
  575406
  625951
  471319
  507800
  413950
  445652
  666903
  625244
  454924
  513098
  603663
  575756
  442965
  520728
  496603
  561850
  508198
  456531
  513049
  516989
  594009
  463478
  528447
  424380
  468779
  517478
  606377
  449462
  506674
  457564
  584724
  441356
  488373
  528640
  488219
  520736
  513182
  441640
  466376
  561073
  624925
]
2.58 ms
(1.42%)
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
  393342
  399861
  413740
  413950
  420002
  421704
  424314
  424380
  424926
  426336
  427180
  427898
  432721
  434574
  441356
  441631
  441640
  442307
  442965
  444343
  445652
  447102
  447434
  448971
  449462
  450941
  451141
  452492
  454924
  455062
  456531
  456987
  457564
  457587
  458730
  459946
  463478
  464662
  465326
  466376
  468779
  469475
  471319
  473006
  473537
  484084
  488219
  488373
  488409
  493842
  495479
  495579
  496603
  496973
  497300
  501680
  506674
  507800
  508198
  508483
  509611
  510575
  511152
  512996
  513049
  513098
  513182
  513662
  516989
  517478
  518334
  519378
  520260
  520623
  520728
  520736
  521025
  522433
  526933
  527123
  528447
  528640
  528743
  528888
  548735
  551147
  561073
  561850
  562789
  565400
  569033
  569232
  571508
  575361
  575406
  575756
  578812
  579670
  584724
  586659
  591385
  592724
  593558
  594009
  595730
  597720
  600449
  603663
  606377
  616909
  624805
  624925
  625244
  625951
  649174
  666903
  667417
  681370
  766590
  814460
]
1.87 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex date"
]
1.85 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс date"
]
1.66 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс date"
]

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.