GET https://search.jues.net/search/embeds/3?q=webcam%20mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
195.17 ms
(89.72%)
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
  85250
  118227
  154123
  187992
  293121
  382898
  387047
  387145
  388740
  397080
  397937
  401491
  411072
  411811
  412855
  415741
  419998
  420333
  420431
  434364
  452946
  454338
  459633
  467114
  468277
  468357
  468508
  469305
  469508
  471028
  472196
  475028
  475137
  475727
  475901
  476163
  478633
  479832
  484234
  486784
  487556
  491102
  495602
  496009
  504016
  510945
  511376
  512465
  513629
  514023
  526717
  533655
  541845
  541858
  542739
  547927
  555267
  564301
  566767
  583539
  585214
  604153
  605285
  611171
  615827
  632112
  660851
  680284
  686158
  715813
  724123
  724523
  725205
  727741
  728262
  729247
  729291
  731349
  733548
  738018
  753772
  754649
  756666
  756677
  759566
  759921
  759931
  765616
  765723
  765792
  768764
  769131
  773271
  776121
  778133
  778215
  782027
  782122
  784209
  785107
  785495
  791883
  792539
  794895
  795763
  795916
  796119
  798696
  800582
  800721
  801253
  801398
  802093
  802160
  809648
  810308
  823731
  824615
  827431
  827632
]
12.47 ms
(5.73%)
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
  604153
  615827
  776121
  791883
  769131
  154123
  434364
  511376
  387047
  472196
  475028
  491102
  585214
  475901
  555267
  773271
  823731
  725205
  795763
  798696
  768764
  513629
  401491
  759931
  794895
  796119
  467114
  476163
  547927
  827431
  459633
  680284
  715813
  583539
  802160
  738018
  765616
  782122
  785495
  733548
  724123
  759566
  795916
  475727
  827632
  778133
  784209
  756666
  724523
  728262
  778215
  475137
  542739
  420431
  411072
  415741
  479832
  484234
  512465
  471028
  660851
  468508
  487556
  514023
  469305
  478633
  468277
  454338
  510945
  495602
  541845
  541858
  605285
  382898
  496009
  526717
  801398
  504016
  452946
  802093
  782027
  387145
  611171
  792539
  753772
  809648
  419998
  824615
  533655
  566767
  564301
  754649
  765792
  729291
  765723
  756677
  731349
  397080
  388740
  632112
  759921
  727741
  411811
  293121
  118227
  187992
  810308
  85250
  468357
  412855
  469508
  486784
  420333
  397937
  729247
  686158
  785107
  800582
  800721
  801253
]
2.71 ms
(1.25%)
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
  85250
  118227
  154123
  187992
  293121
  382898
  387047
  387145
  388740
  397080
  397937
  401491
  411072
  411811
  412855
  415741
  419998
  420333
  420431
  434364
  452946
  454338
  459633
  467114
  468277
  468357
  468508
  469305
  469508
  471028
  472196
  475028
  475137
  475727
  475901
  476163
  478633
  479832
  484234
  486784
  487556
  491102
  495602
  496009
  504016
  510945
  511376
  512465
  513629
  514023
  526717
  533655
  541845
  541858
  542739
  547927
  555267
  564301
  566767
  583539
  585214
  604153
  605285
  611171
  615827
  632112
  660851
  680284
  686158
  715813
  724123
  724523
  725205
  727741
  728262
  729247
  729291
  731349
  733548
  738018
  753772
  754649
  756666
  756677
  759566
  759921
  759931
  765616
  765723
  765792
  768764
  769131
  773271
  776121
  778133
  778215
  782027
  782122
  784209
  785107
  785495
  791883
  792539
  794895
  795763
  795916
  796119
  798696
  800582
  800721
  801253
  801398
  802093
  802160
  809648
  810308
  823731
  824615
  827431
  827632
]
1.91 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam mother"
]
1.83 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер мам женщин"
]
1.74 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер мам женщин"
]
1.70 ms
(0.78%)
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.