GET https://search.jues.net/search/embeds/3?q=big%20ass%20doggystyle

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
227.30 ms
(56.82%)
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
  823848
  828110
  486816
  680259
  706211
  650070
  662869
  677447
  664191
  583211
  602067
  643786
  594626
  600208
  627279
  797438
  798715
  786342
  755601
  731297
  731304
  736037
  758851
  752895
  725657
  729985
  750864
  622677
  640046
  703968
  713467
  717122
  794337
  809813
  403147
  578427
  710255
  794914
  788188
  803926
  559237
  472881
  530300
  808084
  820540
  820099
  468345
  529639
  529260
  533175
  695715
  711988
  646066
  778981
  739568
  725779
  426778
  522516
  555954
  514237
  769100
  539930
  545114
  647809
  716796
  620828
  589383
  811704
  754073
  759913
  765717
  609634
  632216
  806097
  642176
  618494
  733041
  812359
  341118
  816394
  817940
  819177
  468151
  481718
  533954
  518956
  533230
  497903
  499331
  559207
  580537
  562187
  711346
  716657
  720051
  658943
  663203
  675613
  695398
  713398
  581834
  629631
  620968
  628469
  588487
  590154
  592646
  594419
  606881
  611282
  635353
  636873
  638500
  786916
  790806
  791530
  799742
  801574
  784299
  801012
]
162.92 ms
(40.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
  341118
  403147
  426778
  468151
  468345
  472881
  481718
  486816
  497903
  499331
  514237
  518956
  522516
  529260
  529639
  530300
  533175
  533230
  533954
  539930
  545114
  555954
  559207
  559237
  562187
  578427
  580537
  581834
  583211
  588487
  589383
  590154
  592646
  594419
  594626
  600208
  602067
  606881
  609634
  611282
  618494
  620828
  620968
  622677
  627279
  628469
  629631
  632216
  635353
  636873
  638500
  640046
  642176
  643786
  646066
  647809
  650070
  658943
  662869
  663203
  664191
  675613
  677447
  680259
  695398
  695715
  703968
  706211
  710255
  711346
  711988
  713398
  713467
  716657
  716796
  717122
  720051
  725657
  725779
  729985
  731297
  731304
  733041
  736037
  739568
  750864
  752895
  754073
  755601
  758851
  759913
  765717
  769100
  778981
  784299
  786342
  786916
  788188
  790806
  791530
  794337
  794914
  797438
  798715
  799742
  801012
  801574
  803926
  806097
  808084
  809813
  811704
  812359
  816394
  817940
  819177
  820099
  820540
  823848
  828110
]
2.46 ms
(0.61%)
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
  341118
  403147
  426778
  468151
  468345
  472881
  481718
  486816
  497903
  499331
  514237
  518956
  522516
  529260
  529639
  530300
  533175
  533230
  533954
  539930
  545114
  555954
  559207
  559237
  562187
  578427
  580537
  581834
  583211
  588487
  589383
  590154
  592646
  594419
  594626
  600208
  602067
  606881
  609634
  611282
  618494
  620828
  620968
  622677
  627279
  628469
  629631
  632216
  635353
  636873
  638500
  640046
  642176
  643786
  646066
  647809
  650070
  658943
  662869
  663203
  664191
  675613
  677447
  680259
  695398
  695715
  703968
  706211
  710255
  711346
  711988
  713398
  713467
  716657
  716796
  717122
  720051
  725657
  725779
  729985
  731297
  731304
  733041
  736037
  739568
  750864
  752895
  754073
  755601
  758851
  759913
  765717
  769100
  778981
  784299
  786342
  786916
  788188
  790806
  791530
  794337
  794914
  797438
  798715
  799742
  801012
  801574
  803926
  806097
  808084
  809813
  811704
  812359
  816394
  817940
  819177
  820099
  820540
  823848
  828110
]
2.10 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass doggystyle"
]
1.76 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп doggystyle"
]
1.59 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп doggystyle"
]

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.