GET https://search.jues.net/search/embeds/2?q=dick%20and%20jane

Query Metrics

8 Database Queries
8 Different statements
116.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
73.25 ms
(62.86%)
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
  33707
  383211
  401261
  421015
  428460
  428805
  428834
  429243
  443959
  447454
  447473
  447485
  449872
  450977
  456095
  456893
  472320
  484519
  489837
  489838
  490003
  493143
  502679
  502819
  508515
  511678
  517000
  520673
  524274
  524334
  524765
  532956
  541871
  546568
  549857
  556822
  570332
  574781
  574893
  575501
  576119
  586596
  591585
  604395
  612259
  628329
  639824
  640716
  641681
  643020
  647885
  657882
  659396
  663448
  663455
  663947
  705737
  815154
]
24.10 ms
(20.68%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "dick and jane"
  "dick and jane"
  "dick and jane"
  20
]
10.69 ms
(9.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
  428805
  657882
  33707
  447485
  815154
  570332
  659396
  705737
  428834
  532956
  604395
  546568
  443959
  428460
  493143
  456095
  520673
  575501
  574893
  574781
  429243
  490003
  524274
  576119
  401261
  449872
  502679
  612259
  628329
  447454
  447473
  489838
  524765
  524334
  489837
  556822
  383211
  421015
  456893
  641681
  549857
  663448
  640716
  663947
  450977
  502819
  508515
  647885
  663455
  511678
  586596
  472320
  639824
  643020
  484519
  591585
  541871
  517000
]
2.24 ms
(1.93%)
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
  33707
  383211
  401261
  421015
  428460
  428805
  428834
  429243
  443959
  447454
  447473
  447485
  449872
  450977
  456095
  456893
  472320
  484519
  489837
  489838
  490003
  493143
  502679
  502819
  508515
  511678
  517000
  520673
  524274
  524334
  524765
  532956
  541871
  546568
  549857
  556822
  570332
  574781
  574893
  575501
  576119
  586596
  591585
  604395
  612259
  628329
  639824
  640716
  641681
  643020
  647885
  657882
  659396
  663448
  663455
  663947
  705737
  815154
]
1.86 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick and jane"
]
1.63 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член jane"
]
1.39 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.35 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член jane"
]

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.