GET https://search.jues.net/search/embeds/9?q=doggy%20big%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.27 ms
(84.50%)
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
  9734
  9974
  33974
  34593
  61726
  125809
  206386
  383407
  383541
  386638
  386866
  388200
  388228
  389657
  396139
  407746
  415780
  422284
  422345
  425124
  427373
  435472
  444242
  444776
  450821
  451115
  453277
  453348
  453402
  454701
  456722
  458882
  459483
  462183
  465923
  466314
  468216
  470834
  470951
  475108
  475467
  475568
  476624
  478450
  480497
  481254
  482092
  482301
  483237
  489667
  490414
  490452
  491468
  493332
  496293
  497253
  498384
  506514
  506946
  508242
  508243
  509867
  511086
  513360
  516469
  517112
  517547
  519480
  520366
  523513
  524070
  525232
  525450
  526264
  534430
  539539
  549730
  549842
  555810
  556002
  559513
  561328
  570936
  577120
  584395
  585385
  586634
  589708
  590868
  591977
  606294
  607432
  619490
  651810
  660569
  662428
  701545
  706785
  713675
  720168
  725514
  726788
  727959
  732500
  745880
  745962
  750531
  755627
  758224
  758379
  764044
  783136
  784695
  790912
  796695
  804467
  814986
  828259
  828493
]
19.92 ms
(9.89%)
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
  589708
  386866
  534430
  706785
  585385
  796695
  790912
  516469
  549730
  453402
  511086
  513360
  444776
  814986
  465923
  462183
  466314
  584395
  662428
  555810
  556002
  570936
  586634
  725514
  758224
  804467
  422284
  422345
  453348
  470834
  478450
  480497
  482092
  475568
  490452
  493332
  125809
  9974
  539539
  745880
  396139
  523513
  651810
  606294
  828259
  828493
  206386
  450821
  453277
  454701
  660569
  758379
  764044
  33974
  427373
  481254
  388228
  407746
  475467
  755627
  476624
  498384
  483237
  561328
  750531
  415780
  435472
  458882
  468216
  456722
  482301
  509867
  607432
  727959
  425124
  519480
  489667
  506946
  517112
  524070
  526264
  491468
  459483
  490414
  506514
  525232
  508242
  517547
  34593
  388200
  475108
  720168
  383407
  61726
  9734
  496293
  389657
  713675
  783136
  784695
  619490
  590868
  745962
  386638
  701545
  383541
  444242
  783461
  732500
  508243
  520366
  497253
  726788
  470951
  525450
  451115
  577120
  559513
  549842
  591977
]
3.94 ms
(1.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.67 ms
(1.32%)
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
  9734
  9974
  33974
  34593
  61726
  125809
  206386
  383407
  383541
  386638
  386866
  388200
  388228
  389657
  396139
  407746
  415780
  422284
  422345
  425124
  427373
  435472
  444242
  444776
  450821
  451115
  453277
  453348
  453402
  454701
  456722
  458882
  459483
  462183
  465923
  466314
  468216
  470834
  470951
  475108
  475467
  475568
  476624
  478450
  480497
  481254
  482092
  482301
  483237
  489667
  490414
  490452
  491468
  493332
  496293
  497253
  498384
  506514
  506946
  508242
  508243
  509867
  511086
  513360
  516469
  517112
  517547
  519480
  520366
  523513
  524070
  525232
  525450
  526264
  534430
  539539
  549730
  549842
  555810
  556002
  559513
  561328
  570936
  577120
  584395
  585385
  586634
  589708
  590868
  591977
  606294
  607432
  619490
  651810
  660569
  662428
  701545
  706785
  713675
  720168
  725514
  726788
  727959
  732500
  745880
  745962
  750531
  755627
  758224
  758379
  764044
  783136
  784695
  790912
  796695
  804467
  814986
  828259
  828493
]
1.83 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy big tits"
]
1.54 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак большие сиськ"
]
1.34 ms
(0.66%)
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.