GET https://search.jues.net/search/embeds/5?q=red%20hair%20tattoo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.50 ms
(83.25%)
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
  387487
  424862
  458615
  468589
  471839
  473424
  485010
  506595
  521638
  523198
  526086
  531150
  532371
  541519
  542346
  544870
  548893
  548900
  549378
  555826
  558521
  561343
  567672
  569423
  570723
  572714
  600111
  614646
  633062
  634223
  663293
  685433
  697770
  698010
  699678
  705893
  712298
  721204
  729843
  736599
  740756
  741074
  741881
  743721
  745696
  747599
  747610
  748330
  749015
  751610
  755502
  765518
  765665
  766075
  768172
  768199
  768765
  768796
  769165
  771643
  771679
  772680
  772739
  773015
  773129
  775577
  781428
  782115
  783268
  784197
  787115
  789833
  793664
  793701
  794513
  795024
  797785
  799254
  800233
  801623
  802625
  802830
  803566
  803625
  806097
  806658
  807496
  808079
  812815
  812837
  813182
  813508
  813953
  814090
  814571
  815895
  815977
  816113
  816960
  817711
  817912
  818062
  818123
  818133
  819034
  819743
  819901
  819926
  819939
  822955
  823433
  824028
  824604
  825488
  825494
  825505
  825567
  828157
]
14.75 ms
(9.79%)
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
  794513
  795024
  801623
  802830
  807496
  812837
  741074
  747599
  748330
  749015
  755502
  765518
  766075
  768199
  768765
  772739
  782115
  783268
  784197
  787115
  793664
  799254
  800233
  803566
  806658
  812815
  813508
  762176
  768796
  736599
  751610
  729843
  741881
  743721
  745696
  747610
  768172
  769165
  771643
  771679
  773129
  740756
  765665
  772680
  773015
  614646
  698010
  721204
  774965
  775577
  781428
  789833
  802625
  803625
  806097
  808079
  813182
  793701
  387487
  471839
  549378
  572714
  506595
  458615
  633062
  468589
  523198
  424862
  473424
  569423
  570723
  634223
  600111
  797785
  813953
  814090
  817711
  819901
  819926
  824604
  825494
  825505
  825567
  814571
  816960
  818123
  818133
  819034
  823433
  815895
  816113
  817912
  818062
  819743
  819939
  822955
  824028
  815977
  825488
  828157
  485010
  521638
  526086
  532371
  531150
  542346
  544870
  555826
  561343
  567672
  541519
  548893
  548900
  558521
  685433
  697770
  699678
  705893
  712298
  663293
]
2.73 ms
(1.81%)
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
  387487
  424862
  458615
  468589
  471839
  473424
  485010
  506595
  521638
  523198
  526086
  531150
  532371
  541519
  542346
  544870
  548893
  548900
  549378
  555826
  558521
  561343
  567672
  569423
  570723
  572714
  600111
  614646
  633062
  634223
  663293
  685433
  697770
  698010
  699678
  705893
  712298
  721204
  729843
  736599
  740756
  741074
  741881
  743721
  745696
  747599
  747610
  748330
  749015
  751610
  755502
  765518
  765665
  766075
  768172
  768199
  768765
  768796
  769165
  771643
  771679
  772680
  772739
  773015
  773129
  775577
  781428
  782115
  783268
  784197
  787115
  789833
  793664
  793701
  794513
  795024
  797785
  799254
  800233
  801623
  802625
  802830
  803566
  803625
  806097
  806658
  807496
  808079
  812815
  812837
  813182
  813508
  813953
  814090
  814571
  815895
  815977
  816113
  816960
  817711
  817912
  818062
  818123
  818133
  819034
  819743
  819901
  819926
  819939
  822955
  823433
  824028
  824604
  825488
  825494
  825505
  825567
  828157
]
2.22 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "red hair tattoo"
]
1.98 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "red hair татуированные"
]
1.64 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "red hair татуированные"
]

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.