GET https://search.jues.net/search/embeds/6?q=webcam%20with%20sister

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.89 ms
(86.02%)
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
  417948
  420565
  421652
  424575
  424641
  424995
  425654
  426779
  427064
  427085
  428154
  430110
  432368
  432477
  432532
  432563
  432715
  433218
  434093
  434220
  435174
  437924
  438349
  438852
  439274
  444836
  446220
  449120
  449186
  453720
  453726
  455390
  456453
  457413
  457542
  457568
  457613
  459517
  459533
  460439
  460570
  462242
  462994
  473229
  473626
  475320
  478999
  487251
  491748
  492657
  492975
  494814
  499021
  499764
  500622
  501015
  511555
  511588
  514158
  516455
  516513
  517169
  517824
  520885
  521062
  521608
  522318
  523479
  523578
  524855
  525591
  527592
  527890
  532605
  547820
  550485
  557027
  557090
  558874
  558878
  561155
  564177
  564190
  564658
  567185
  569989
  572220
  574049
  575709
  577468
  582238
  583112
  584197
  584315
  584741
  588557
  588600
  590118
  591154
  591940
  592382
  592898
  604155
  604338
  605671
  617107
  619935
  621353
  621745
  625088
  625127
  695719
  695831
  714082
  720262
  721579
  737848
  760705
  766734
  792651
]
16.82 ms
(8.47%)
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
  564190
  572220
  582238
  569989
  550485
  558874
  558878
  574049
  584315
  695831
  721579
  547820
  557090
  584741
  591940
  621745
  590118
  588557
  591154
  605671
  760705
  737848
  766734
  604155
  792651
  420565
  424575
  427064
  427085
  432368
  434220
  438349
  438852
  457542
  457613
  462242
  475320
  460439
  421652
  432532
  437924
  456453
  478999
  426779
  428154
  432563
  433218
  434093
  457568
  473229
  473626
  417948
  424641
  425654
  430110
  439274
  449186
  453720
  455390
  457413
  459517
  460570
  511588
  516513
  492975
  523479
  492657
  499764
  521062
  494814
  499021
  511555
  522318
  453726
  524855
  500622
  424995
  435174
  432715
  444836
  459533
  487251
  449120
  446220
  462994
  491748
  517169
  520885
  527890
  501015
  517824
  521608
  525591
  516455
  532605
  514158
  523578
  527592
  557027
  564658
  575709
  564177
  561155
  567185
  695719
  720262
  714082
  577468
  583112
  584197
  588600
  592382
  617107
  619935
  621353
  592898
  604338
  625127
  625088
  432477
]
4.33 ms
(2.18%)
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
  417948
  420565
  421652
  424575
  424641
  424995
  425654
  426779
  427064
  427085
  428154
  430110
  432368
  432477
  432532
  432563
  432715
  433218
  434093
  434220
  435174
  437924
  438349
  438852
  439274
  444836
  446220
  449120
  449186
  453720
  453726
  455390
  456453
  457413
  457542
  457568
  457613
  459517
  459533
  460439
  460570
  462242
  462994
  473229
  473626
  475320
  478999
  487251
  491748
  492657
  492975
  494814
  499021
  499764
  500622
  501015
  511555
  511588
  514158
  516455
  516513
  517169
  517824
  520885
  521062
  521608
  522318
  523479
  523578
  524855
  525591
  527592
  527890
  532605
  547820
  550485
  557027
  557090
  558874
  558878
  561155
  564177
  564190
  564658
  567185
  569989
  572220
  574049
  575709
  577468
  582238
  583112
  584197
  584315
  584741
  588557
  588600
  590118
  591154
  591940
  592382
  592898
  604155
  604338
  605671
  617107
  619935
  621353
  621745
  625088
  625127
  695719
  695831
  714082
  720262
  721579
  737848
  760705
  766734
  792651
]
1.76 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam with sister"
]
1.76 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер sister"
]
1.73 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер sister"
]
1.37 ms
(0.69%)
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.