GET https://search.jues.net/search/embeds/5?q=blonde%20tights

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
112.32 ms
(80.10%)
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
  188556
  388266
  390218
  399829
  401919
  412297
  420212
  424457
  430700
  445414
  448363
  451521
  452404
  456345
  459828
  461066
  461221
  462724
  470199
  471165
  475830
  483382
  484038
  486023
  487717
  488500
  490916
  490917
  491144
  491250
  492926
  493255
  494066
  502645
  502663
  503310
  504841
  512349
  512351
  512694
  521432
  521944
  525159
  525385
  527920
  538022
  542187
  567700
  568714
  572882
  592408
  595923
  611642
  611655
  648220
  688586
  721014
  810606
]
13.04 ms
(9.30%)
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
  521944
  502645
  490917
  491144
  512349
  512694
  525159
  491250
  503310
  527920
  567700
  572882
  568714
  721014
  390218
  451521
  470199
  399829
  462724
  456345
  538022
  483382
  493255
  488500
  512351
  521432
  188556
  445414
  420212
  388266
  424457
  461066
  484038
  492926
  502663
  486023
  459828
  461221
  490916
  611642
  592408
  810606
  448363
  452404
  525385
  412297
  475830
  648220
  595923
  688586
  611655
  401919
  471165
  504841
  430700
  487717
  494066
  542187
]
6.47 ms
(4.62%)
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:
[
  "blonde tights"
  "blonde tights"
  "blonde tights"
  20
]
2.48 ms
(1.77%)
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
  188556
  388266
  390218
  399829
  401919
  412297
  420212
  424457
  430700
  445414
  448363
  451521
  452404
  456345
  459828
  461066
  461221
  462724
  470199
  471165
  475830
  483382
  484038
  486023
  487717
  488500
  490916
  490917
  491144
  491250
  492926
  493255
  494066
  502645
  502663
  503310
  504841
  512349
  512351
  512694
  521432
  521944
  525159
  525385
  527920
  538022
  542187
  567700
  568714
  572882
  592408
  595923
  611642
  611655
  648220
  688586
  721014
  810606
]
1.77 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde tights"
]
1.51 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая колготк"
]
1.35 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.29 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.