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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.32 ms
(80.99%)
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
  398195
  402384
  420122
  421485
  440908
  457642
  487699
  518022
  528600
  538986
  539701
  540130
  540860
  540865
  542968
  553088
  553636
  553889
  556060
  569220
  578312
  583624
  587467
  591089
  604358
  617242
  617254
  628732
  634033
  635759
  636610
  638087
  643338
  646077
  651579
  654920
  659469
  660650
  661004
  661656
  662159
  662171
  667242
  676196
  688129
  698832
  699135
  703280
  703628
  714986
  715009
  716597
  716699
  720008
  720208
  727721
  729704
  734201
  736962
  738538
  740423
  741857
  744692
  749101
  751372
  754172
  759083
  761873
  762600
  763039
  766563
  767054
  771227
  774770
  775635
  778086
  778149
  778665
  780124
  780482
  782872
  782943
  783297
  783882
  784203
  784226
  784340
  785549
  787217
  787938
  788992
  791223
  791380
  791383
  794066
  794294
  796375
  796788
  796859
  796878
  796889
  797752
  799781
  803313
  803989
  804195
  804975
  807212
  807531
  809137
  809805
  810339
  810426
  810493
  812559
  814160
  817755
  819954
  827166
]
19.94 ms
(12.58%)
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
  784226
  791223
  794066
  794294
  796859
  804975
  810493
  791383
  796878
  759083
  784203
  803313
  810339
  734201
  766563
  729704
  767054
  763039
  751372
  776045
  780124
  782872
  796788
  804195
  807212
  807531
  421485
  457642
  540865
  540130
  542968
  553636
  583624
  651579
  659469
  660650
  688129
  703628
  667242
  703280
  646077
  654920
  661656
  662171
  676196
  698832
  699135
  553088
  634033
  636610
  643338
  591089
  604358
  635759
  754172
  518022
  716699
  628732
  398195
  420122
  817755
  819954
  827166
  553889
  569220
  661004
  720008
  720208
  716597
  578312
  638087
  810426
  775635
  778086
  778665
  780482
  787938
  788992
  727721
  784340
  803989
  812559
  741857
  744692
  749101
  771227
  740423
  736962
  761873
  617242
  617254
  783297
  783882
  797752
  809137
  528600
  402384
  538986
  587467
  556060
  738538
  440908
  814160
  540860
  487699
  539701
  662159
  715009
  774770
  778149
  796889
  799781
  791380
  796375
  809805
  782943
  762600
  714986
  785549
  787217
]
2.83 ms
(1.79%)
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
  398195
  402384
  420122
  421485
  440908
  457642
  487699
  518022
  528600
  538986
  539701
  540130
  540860
  540865
  542968
  553088
  553636
  553889
  556060
  569220
  578312
  583624
  587467
  591089
  604358
  617242
  617254
  628732
  634033
  635759
  636610
  638087
  643338
  646077
  651579
  654920
  659469
  660650
  661004
  661656
  662159
  662171
  667242
  676196
  688129
  698832
  699135
  703280
  703628
  714986
  715009
  716597
  716699
  720008
  720208
  727721
  729704
  734201
  736962
  738538
  740423
  741857
  744692
  749101
  751372
  754172
  759083
  761873
  762600
  763039
  766563
  767054
  771227
  774770
  775635
  778086
  778149
  778665
  780124
  780482
  782872
  782943
  783297
  783882
  784203
  784226
  784340
  785549
  787217
  787938
  788992
  791223
  791380
  791383
  794066
  794294
  796375
  796788
  796859
  796878
  796889
  797752
  799781
  803313
  803989
  804195
  804975
  807212
  807531
  809137
  809805
  810339
  810426
  810493
  812559
  814160
  817755
  819954
  827166
]
1.97 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "petite amateur"
]
1.95 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "petite любительск"
]
1.49 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "petite любительск"
]

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.