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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
109.16 ms
(75.57%)
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
  382446
  406121
  428596
  428761
  435108
  443590
  446874
  447917
  447959
  448464
  453769
  456695
  457884
  459362
  459611
  468132
  473418
  474600
  478186
  486871
  497448
  497459
  498297
  501641
  508542
  523364
  528489
  585984
  594074
  595471
  604261
  623481
  633015
  660079
  682926
  706058
  715085
  720836
  722190
  724023
  726143
  730380
  739997
  747054
  748391
  749232
  766864
  766896
  767043
  767271
  772708
  775758
  775855
  775904
  775934
  782516
  811764
  812552
  816140
  823864
]
17.11 ms
(11.84%)
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:
[
  "amateur atm"
  "amateur atm"
  "amateur atm"
  20
]
8.95 ms
(6.19%)
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
  748391
  447917
  447959
  715085
  722190
  594074
  446874
  682926
  749232
  604261
  775904
  767043
  726143
  724023
  812552
  811764
  706058
  633015
  775934
  739997
  772708
  497448
  766864
  730380
  775758
  775855
  767271
  766896
  782516
  823864
  816140
  747054
  660079
  382446
  623481
  428596
  528489
  497459
  498297
  453769
  468132
  523364
  508542
  585984
  474600
  448464
  459611
  443590
  478186
  456695
  720836
  435108
  459362
  457884
  406121
  501641
  428761
  473418
  486871
  595471
]
2.32 ms
(1.61%)
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
  382446
  406121
  428596
  428761
  435108
  443590
  446874
  447917
  447959
  448464
  453769
  456695
  457884
  459362
  459611
  468132
  473418
  474600
  478186
  486871
  497448
  497459
  498297
  501641
  508542
  523364
  528489
  585984
  594074
  595471
  604261
  623481
  633015
  660079
  682926
  706058
  715085
  720836
  722190
  724023
  726143
  730380
  739997
  747054
  748391
  749232
  766864
  766896
  767043
  767271
  772708
  775758
  775855
  775904
  775934
  782516
  811764
  812552
  816140
  823864
]
1.92 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur atm"
]
1.67 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск atm"
]
1.49 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск atm"
]

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.