GET https://search.jues.net/search/embeds/5?q=piss%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.24 ms
(88.00%)
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
  539328
  540099
  540103
  540134
  540574
  541750
  541783
  541795
  542431
  542459
  542724
  543660
  546218
  546291
  547412
  547415
  547445
  549018
  549034
  550864
  552608
  553697
  554572
  554696
  555205
  555210
  555761
  558631
  559295
  561039
  565260
  572262
  574001
  574926
  576482
  576506
  576562
  577028
  578718
  579675
  583301
  586127
  592833
  595491
  597227
  597841
  598193
  599242
  600778
  605262
  618144
  622115
  623343
  628381
  628592
  629666
  630572
  632256
  633523
  633773
  636644
  637122
  637438
  639638
  640046
  641604
  643706
  643737
  644663
  647726
  649348
  649356
  651144
  651158
  659472
  664477
  664492
  668678
  670448
  671977
  672685
  675010
  675503
  676066
  676111
  677671
  677784
  678003
  679280
  679317
  679757
  679774
  679863
  680127
  680138
  680149
  683262
  689547
  693504
  702164
  707971
  709874
  725392
  733842
  734038
  734827
  743993
  744010
  744551
  744810
  752622
  757230
  757257
  786525
  787858
  788640
  789678
  790102
  811873
  814160
]
13.92 ms
(7.11%)
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
  630572
  790102
  640046
  552608
  632256
  679774
  558631
  651144
  679757
  680138
  693504
  744551
  540134
  541783
  543660
  554696
  542431
  583301
  554572
  649356
  670448
  641604
  599242
  622115
  623343
  636644
  639638
  643706
  743993
  757230
  811873
  757257
  789678
  540103
  547412
  547445
  549018
  553697
  576562
  576482
  542459
  546291
  547415
  555205
  555210
  555761
  561039
  649348
  651158
  664477
  668678
  675503
  546218
  574926
  600778
  629666
  592833
  752622
  744810
  788640
  539328
  541750
  576506
  549034
  579675
  707971
  586127
  605262
  595491
  628592
  744010
  643737
  559295
  672685
  676111
  680149
  677671
  679317
  597841
  633523
  675010
  677784
  540099
  541795
  577028
  664492
  647726
  659472
  671977
  678003
  679280
  689547
  572262
  574001
  644663
  618144
  734827
  787858
  578718
  709874
  679863
  786525
  702164
  565260
  597227
  814160
  542724
  550864
  680127
  676066
  683262
  628381
  637122
  637438
  598193
  725392
  733842
  734038
  633773
  540574
]
3.13 ms
(1.60%)
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
  539328
  540099
  540103
  540134
  540574
  541750
  541783
  541795
  542431
  542459
  542724
  543660
  546218
  546291
  547412
  547415
  547445
  549018
  549034
  550864
  552608
  553697
  554572
  554696
  555205
  555210
  555761
  558631
  559295
  561039
  565260
  572262
  574001
  574926
  576482
  576506
  576562
  577028
  578718
  579675
  583301
  586127
  592833
  595491
  597227
  597841
  598193
  599242
  600778
  605262
  618144
  622115
  623343
  628381
  628592
  629666
  630572
  632256
  633523
  633773
  636644
  637122
  637438
  639638
  640046
  641604
  643706
  643737
  644663
  647726
  649348
  649356
  651144
  651158
  659472
  664477
  664492
  668678
  670448
  671977
  672685
  675010
  675503
  676066
  676111
  677671
  677784
  678003
  679280
  679317
  679757
  679774
  679863
  680127
  680138
  680149
  683262
  689547
  693504
  702164
  707971
  709874
  725392
  733842
  734038
  734827
  743993
  744010
  744551
  744810
  752622
  757230
  757257
  786525
  787858
  788640
  789678
  790102
  811873
  814160
]
1.69 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss girls"
]
1.64 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг девушк"
]
1.45 ms
(0.74%)
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.