GET https://search.jues.net/search/embeds/9?q=webcam%20shower

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.91 ms
(85.74%)
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
  25069
  391102
  391662
  393188
  396418
  397670
  399201
  418713
  423360
  423819
  430396
  442650
  467988
  475814
  478988
  495800
  509366
  519422
  580230
  587292
  607378
  608085
  609757
  609761
  623207
  629739
  632508
  635167
  702354
  704608
  705366
  712236
  715405
  723774
  724009
  725741
  728832
  730052
  730221
  730679
  733081
  734057
  734614
  735008
  735429
  736641
  737045
  737841
  738671
  740823
  741268
  742841
  744129
  744885
  745054
  747804
  748880
  749426
  751351
  751390
  752223
  753617
  754830
  758821
  760690
  764109
  764260
  764326
  764628
  765404
  766371
  766952
  767081
  767618
  767734
  769018
  772454
  772987
  775564
  776512
  777164
  779263
  780545
  780566
  780853
  785785
  789249
  790447
  795779
  796075
  797177
  800143
  801369
  801783
  801842
  801912
  801937
  802085
  802305
  802334
  803395
  806710
  807214
  807245
  807283
  809660
  809704
  810075
  810079
  810087
  811530
  811844
  811873
  811893
  812281
  817073
  818937
  823599
  824483
]
14.61 ms
(8.59%)
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
  607378
  608085
  609757
  623207
  629739
  632508
  775564
  780545
  780853
  795779
  801369
  801912
  803395
  807283
  776512
  777164
  780566
  796075
  811530
  812281
  723774
  730221
  734614
  735008
  736641
  740823
  741268
  742841
  744885
  767618
  769266
  772454
  789249
  797177
  800143
  801783
  802085
  802334
  806710
  809660
  810079
  811873
  811893
  737045
  737841
  747804
  748880
  752223
  766371
  766952
  767734
  772987
  724009
  735429
  758821
  764260
  765404
  725741
  730679
  738671
  744129
  745054
  753617
  764109
  767081
  728832
  730052
  733081
  734057
  749426
  751351
  751390
  754830
  760690
  764326
  764628
  769018
  609761
  635167
  702354
  704608
  705366
  712236
  715405
  779263
  785785
  790447
  801842
  801937
  802305
  807214
  807245
  809704
  810075
  810087
  811844
  397670
  423819
  442650
  423360
  430396
  475814
  478988
  509366
  580230
  393188
  467988
  495800
  519422
  587292
  418713
  391662
  25069
  391102
  396418
  399201
  823599
  817073
  818937
  824483
]
2.88 ms
(1.69%)
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
  25069
  391102
  391662
  393188
  396418
  397670
  399201
  418713
  423360
  423819
  430396
  442650
  467988
  475814
  478988
  495800
  509366
  519422
  580230
  587292
  607378
  608085
  609757
  609761
  623207
  629739
  632508
  635167
  702354
  704608
  705366
  712236
  715405
  723774
  724009
  725741
  728832
  730052
  730221
  730679
  733081
  734057
  734614
  735008
  735429
  736641
  737045
  737841
  738671
  740823
  741268
  742841
  744129
  744885
  745054
  747804
  748880
  749426
  751351
  751390
  752223
  753617
  754830
  758821
  760690
  764109
  764260
  764326
  764628
  765404
  766371
  766952
  767081
  767618
  767734
  769018
  772454
  772987
  775564
  776512
  777164
  779263
  780545
  780566
  780853
  785785
  789249
  790447
  795779
  796075
  797177
  800143
  801369
  801783
  801842
  801912
  801937
  802085
  802305
  802334
  803395
  806710
  807214
  807245
  807283
  809660
  809704
  810075
  810079
  810087
  811530
  811844
  811873
  811893
  812281
  817073
  818937
  823599
  824483
]
1.81 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер shower"
]
1.70 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер shower"
]
1.68 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam shower"
]
1.58 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.