GET https://search.jues.net/search/embeds/9?q=a%20skinny%20man

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.95 ms
(81.70%)
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
  18
  9853
  155291
  338225
  393706
  396619
  410057
  418802
  422631
  422876
  426075
  429342
  430332
  430616
  443303
  445039
  447358
  455016
  463957
  465168
  466154
  467344
  468600
  470799
  470840
  471823
  472436
  483531
  488330
  491220
  492239
  494362
  494426
  495759
  500904
  502566
  506665
  508841
  509393
  513304
  513873
  515116
  515205
  519986
  520251
  522321
  522591
  525648
  530392
  539519
  540776
  544301
  547340
  547642
  548562
  549912
  550612
  550679
  552004
  552900
  559145
  561907
  563877
  565169
  565265
  565518
  567400
  577378
  579480
  580664
  581137
  589134
  590346
  590796
  601317
  609279
  609880
  609929
  612395
  612842
  617407
  622394
  624864
  626755
  632969
  645004
  652600
  653496
  655401
  655685
  655691
  656381
  657730
  657949
  658066
  658419
  659601
  670074
  673985
  680177
  684088
  685891
  693023
  701345
  705093
  712913
  721325
  721574
  730556
  730788
  745496
  747650
  772388
  788512
  788963
  789886
  802406
  810701
  820427
  827084
]
24.58 ms
(13.13%)
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
  418802
  422876
  426075
  429342
  455016
  468600
  470799
  430332
  430616
  445039
  466154
  467344
  470840
  472436
  506665
  513304
  520251
  483531
  494362
  509393
  515116
  519986
  522321
  494426
  513873
  488330
  491220
  492239
  495759
  502566
  508841
  515205
  155291
  393706
  338225
  9853
  396619
  540776
  827084
  820427
  18
  447358
  539519
  530392
  550612
  547642
  548562
  549912
  544301
  563877
  580664
  652600
  655401
  657730
  658066
  655691
  657949
  658419
  673985
  705093
  712913
  655685
  656381
  659601
  670074
  685891
  721574
  547340
  552900
  565518
  612395
  590346
  612842
  626755
  788963
  789886
  772388
  730556
  745496
  701345
  788512
  802406
  552004
  577378
  565169
  561907
  609929
  590796
  609279
  609880
  463957
  525648
  500904
  550679
  617407
  422631
  410057
  645004
  465168
  471823
  522591
  579480
  559145
  567400
  581137
  565265
  653496
  680177
  684088
  693023
  622394
  624864
  589134
  601317
  810701
  730788
  747650
  632969
  721325
  443303
]
2.87 ms
(1.53%)
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
  18
  9853
  155291
  338225
  393706
  396619
  410057
  418802
  422631
  422876
  426075
  429342
  430332
  430616
  443303
  445039
  447358
  455016
  463957
  465168
  466154
  467344
  468600
  470799
  470840
  471823
  472436
  483531
  488330
  491220
  492239
  494362
  494426
  495759
  500904
  502566
  506665
  508841
  509393
  513304
  513873
  515116
  515205
  519986
  520251
  522321
  522591
  525648
  530392
  539519
  540776
  544301
  547340
  547642
  548562
  549912
  550612
  550679
  552004
  552900
  559145
  561907
  563877
  565169
  565265
  565518
  567400
  577378
  579480
  580664
  581137
  589134
  590346
  590796
  601317
  609279
  609880
  609929
  612395
  612842
  617407
  622394
  624864
  626755
  632969
  645004
  652600
  653496
  655401
  655685
  655691
  656381
  657730
  657949
  658066
  658419
  659601
  670074
  673985
  680177
  684088
  685891
  693023
  701345
  705093
  712913
  721325
  721574
  730556
  730788
  745496
  747650
  772388
  788512
  788963
  789886
  802406
  810701
  820427
  827084
]
2.05 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "a skinny man"
]
1.94 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые мужчин"
]
1.25 ms
(0.67%)
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.