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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.09 ms
(90.04%)
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
  24149
  34087
  67200
  98749
  368131
  390554
  391049
  395862
  405272
  415588
  464373
  488604
  494261
  494266
  495709
  509228
  515881
  517491
  520162
  536979
  540957
  546485
  555152
  563645
  568192
  571154
  572202
  577210
  577295
  577437
  579304
  581394
  581427
  583955
  591167
  597557
  599525
  603212
  603507
  603548
  606496
  609278
  612383
  629818
  634851
  649625
  650643
  650842
  651886
  651888
  651889
  664271
  664823
  664855
  665876
  667498
  667888
  670488
  674091
  681682
  682423
  686069
  704540
  710263
  710407
  710544
  713635
  717313
  721913
  724528
  727917
  729266
  731777
  731784
  731954
  732377
  732696
  732744
  732786
  733076
  733347
  736141
  744212
  747145
  750751
  752596
  759766
  760137
  760774
  766583
  771453
  778895
  781762
  785333
  790802
  791571
  792801
  793406
  793555
  793716
  794703
  794795
  794826
  797126
  799951
  800709
  804504
  806300
  809934
  811050
  813018
  814236
  815325
  817748
  818169
  825894
  826230
  827106
  827416
  827516
]
10.74 ms
(5.25%)
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
  405272
  609278
  793716
  629818
  809934
  583955
  603212
  727917
  731954
  649625
  793406
  731784
  732744
  540957
  651888
  651889
  495709
  781762
  368131
  759766
  515881
  665876
  717313
  581427
  517491
  597557
  670488
  794826
  732786
  747145
  710407
  606496
  778895
  825894
  581394
  563645
  568192
  826230
  790802
  791571
  536979
  733347
  817748
  794703
  650842
  721913
  793555
  794795
  733076
  667498
  732696
  752596
  494266
  682423
  464373
  571154
  24149
  827516
  674091
  732377
  760774
  520162
  634851
  792801
  415588
  750751
  67200
  579304
  664855
  815325
  681682
  603507
  736141
  766583
  731777
  806300
  488604
  664271
  827416
  664823
  612383
  785333
  744212
  771453
  98749
  804504
  572202
  391049
  509228
  651886
  704540
  34087
  546485
  686069
  577437
  799951
  811050
  390554
  713635
  818169
  814236
  813018
  395862
  494261
  599525
  827106
  710544
  724528
  555152
  591167
  797126
  603548
  800709
  650643
  760137
  577295
  667888
  710263
  729266
  577210
]
2.67 ms
(1.31%)
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
  24149
  34087
  67200
  98749
  368131
  390554
  391049
  395862
  405272
  415588
  464373
  488604
  494261
  494266
  495709
  509228
  515881
  517491
  520162
  536979
  540957
  546485
  555152
  563645
  568192
  571154
  572202
  577210
  577295
  577437
  579304
  581394
  581427
  583955
  591167
  597557
  599525
  603212
  603507
  603548
  606496
  609278
  612383
  629818
  634851
  649625
  650643
  650842
  651886
  651888
  651889
  664271
  664823
  664855
  665876
  667498
  667888
  670488
  674091
  681682
  682423
  686069
  704540
  710263
  710407
  710544
  713635
  717313
  721913
  724528
  727917
  729266
  731777
  731784
  731954
  732377
  732696
  732744
  732786
  733076
  733347
  736141
  744212
  747145
  750751
  752596
  759766
  760137
  760774
  766583
  771453
  778895
  781762
  785333
  790802
  791571
  792801
  793406
  793555
  793716
  794703
  794795
  794826
  797126
  799951
  800709
  804504
  806300
  809934
  811050
  813018
  814236
  815325
  817748
  818169
  825894
  826230
  827106
  827416
  827516
]
1.95 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "trio big tits"
]
1.80 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро большие сиськ"
]
1.26 ms
(0.62%)
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.