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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.36 ms
(86.41%)
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
  384046
  395769
  397670
  399201
  418464
  427095
  440644
  470433
  492420
  493363
  494399
  517035
  517796
  529638
  530424
  531035
  531655
  537078
  537086
  538378
  538739
  541795
  541905
  541969
  543679
  546080
  547007
  549031
  553160
  553185
  554683
  554707
  556251
  563998
  567982
  569221
  571304
  573209
  574319
  575885
  576540
  576599
  579783
  582729
  584031
  584219
  584922
  588391
  595163
  607378
  607891
  609757
  609761
  611496
  613435
  614477
  614536
  619989
  620911
  623207
  623343
  623725
  629671
  636643
  636765
  637328
  643458
  647530
  650719
  652943
  661619
  662897
  666491
  669248
  669876
  684449
  696960
  702354
  702377
  702615
  705372
  710480
  714076
  730221
  740823
  744129
  745054
  749426
  751351
  751390
  752223
  753617
  754830
  758821
  765404
  772987
  777164
  779263
  780545
  785785
  790447
  797177
  800143
  801783
  801842
  802305
  803395
  807214
  807283
  809660
  811844
  811873
  811893
  812281
  813791
  814410
  823890
  824765
  827296
  827602
]
13.60 ms
(7.97%)
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
  827602
  530424
  537078
  531035
  537086
  517035
  517796
  553185
  573209
  575885
  579783
  584031
  543679
  569221
  650719
  661619
  705372
  710480
  714076
  647530
  684449
  696960
  702377
  702615
  652943
  666491
  669248
  669876
  567982
  574319
  582729
  584219
  584922
  613435
  611496
  619989
  623725
  637328
  607891
  614477
  614536
  620911
  623343
  629671
  636765
  643458
  588391
  607378
  609757
  623207
  780545
  803395
  807283
  777164
  812281
  730221
  740823
  797177
  800143
  801783
  809660
  811873
  811893
  752223
  772987
  758821
  765404
  744129
  745054
  753617
  749426
  751351
  751390
  754830
  609761
  702354
  779263
  785785
  790447
  801842
  802305
  807214
  811844
  397670
  384046
  418464
  440644
  541969
  662897
  595163
  636643
  395769
  427095
  492420
  494399
  399201
  827296
  813791
  824765
  814410
  823890
  470433
  493363
  529638
  538378
  538739
  531655
  553160
  554707
  571304
  541905
  547007
  549031
  563998
  541795
  546080
  554683
  556251
  576540
  576599
]
2.83 ms
(1.66%)
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
  384046
  395769
  397670
  399201
  418464
  427095
  440644
  470433
  492420
  493363
  494399
  517035
  517796
  529638
  530424
  531035
  531655
  537078
  537086
  538378
  538739
  541795
  541905
  541969
  543679
  546080
  547007
  549031
  553160
  553185
  554683
  554707
  556251
  563998
  567982
  569221
  571304
  573209
  574319
  575885
  576540
  576599
  579783
  582729
  584031
  584219
  584922
  588391
  595163
  607378
  607891
  609757
  609761
  611496
  613435
  614477
  614536
  619989
  620911
  623207
  623343
  623725
  629671
  636643
  636765
  637328
  643458
  647530
  650719
  652943
  661619
  662897
  666491
  669248
  669876
  684449
  696960
  702354
  702377
  702615
  705372
  710480
  714076
  730221
  740823
  744129
  745054
  749426
  751351
  751390
  752223
  753617
  754830
  758821
  765404
  772987
  777164
  779263
  780545
  785785
  790447
  797177
  800143
  801783
  801842
  802305
  803395
  807214
  807283
  809660
  811844
  811873
  811893
  812281
  813791
  814410
  823890
  824765
  827296
  827602
]
1.78 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam shower solo"
]
1.74 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер shower соло"
]
1.47 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер shower соло"
]

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.