GET https://search.jues.net/search/embeds/4?q=amateur%20cowgirl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.08 ms
(88.38%)
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
  394029
  403136
  423799
  427797
  440986
  446510
  448253
  449854
  478321
  501322
  501678
  509521
  512616
  525911
  527595
  529680
  549065
  550565
  552692
  557223
  557797
  571425
  572703
  574026
  579500
  582056
  583439
  589931
  590031
  591913
  595285
  595300
  597279
  605440
  608812
  611491
  621653
  622961
  626239
  629389
  635610
  636049
  647534
  647547
  647586
  648378
  652784
  659250
  662823
  668623
  668738
  668740
  668741
  675473
  677862
  679676
  681386
  685036
  699446
  701188
  703960
  709300
  710679
  712185
  713705
  714300
  714367
  717139
  722276
  722931
  724063
  725285
  725301
  738374
  738870
  739290
  739849
  740959
  745607
  746344
  750397
  757213
  757318
  758725
  758731
  759184
  761706
  761740
  762315
  764044
  764647
  765413
  767675
  770378
  778124
  779873
  781063
  781512
  783194
  788463
  791601
  793815
  794453
  796418
  797709
  799567
  801686
  801740
  801916
  805188
  809583
  810581
  811740
  812799
  813310
  814248
  814992
  819874
  826579
  826676
]
13.57 ms
(6.59%)
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
  582056
  549065
  648378
  659250
  701188
  647534
  675473
  647586
  621653
  622961
  636049
  590031
  597279
  608812
  611491
  527595
  819874
  501322
  529680
  583439
  699446
  591913
  801916
  759184
  403136
  394029
  427797
  826676
  826579
  571425
  574026
  722276
  550565
  779873
  788463
  794453
  805188
  778124
  813310
  724063
  725285
  725301
  740959
  757213
  767675
  739290
  738870
  745607
  758731
  761740
  739849
  758725
  764647
  781063
  796418
  811740
  440986
  509521
  448253
  712185
  746344
  668738
  814992
  814248
  579500
  717139
  572703
  799567
  801740
  791601
  810581
  761706
  762315
  781512
  783194
  793815
  809583
  812799
  757318
  765413
  738374
  750397
  770378
  797709
  801686
  446510
  512616
  501678
  478321
  552692
  557223
  557797
  703960
  662823
  668623
  668740
  668741
  677862
  679676
  685036
  647547
  652784
  681386
  714367
  595285
  589931
  605440
  635610
  595300
  626239
  764044
  629389
  709300
  710679
  713705
  714300
  722931
  423799
  525911
  449854
]
3.22 ms
(1.56%)
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
  394029
  403136
  423799
  427797
  440986
  446510
  448253
  449854
  478321
  501322
  501678
  509521
  512616
  525911
  527595
  529680
  549065
  550565
  552692
  557223
  557797
  571425
  572703
  574026
  579500
  582056
  583439
  589931
  590031
  591913
  595285
  595300
  597279
  605440
  608812
  611491
  621653
  622961
  626239
  629389
  635610
  636049
  647534
  647547
  647586
  648378
  652784
  659250
  662823
  668623
  668738
  668740
  668741
  675473
  677862
  679676
  681386
  685036
  699446
  701188
  703960
  709300
  710679
  712185
  713705
  714300
  714367
  717139
  722276
  722931
  724063
  725285
  725301
  738374
  738870
  739290
  739849
  740959
  745607
  746344
  750397
  757213
  757318
  758725
  758731
  759184
  761706
  761740
  762315
  764044
  764647
  765413
  767675
  770378
  778124
  779873
  781063
  781512
  783194
  788463
  791601
  793815
  794453
  796418
  797709
  799567
  801686
  801740
  801916
  805188
  809583
  810581
  811740
  812799
  813310
  814248
  814992
  819874
  826579
  826676
]
1.93 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск cowgirl"
]
1.92 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur cowgirl"
]
1.84 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск cowgirl"
]

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.