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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.87 ms
(51.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ shower"
]
173.87 ms
(42.06%)
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
  24034
  24158
  24218
  34391
  191075
  383282
  385933
  386217
  388116
  388591
  397176
  404483
  412681
  417099
  417511
  425529
  427498
  443862
  444991
  452482
  453469
  455738
  456281
  457005
  458382
  458713
  463637
  467663
  473504
  478753
  488100
  488359
  490210
  496324
  496928
  504352
  511808
  514321
  517372
  517599
  521746
  523450
  523959
  525469
  526515
  529430
  532444
  533630
  538731
  540088
  546142
  548081
  554844
  555989
  558849
  564172
  566012
  570873
  571182
  573209
  577664
  579726
  587935
  588494
  590930
  603407
  604121
  604881
  607926
  610271
  614428
  619606
  620089
  626560
  629646
  631607
  636736
  645842
  648545
  650128
  658266
  659015
  663547
  663971
  673791
  677975
  702615
  706666
  710465
  719895
  736581
  737650
  745744
  759113
  765860
  774730
  775494
  781931
  781934
  788563
  790204
  795258
  797153
  806140
  806160
  806359
  807219
  808041
  810025
  813253
  813729
  817304
  820372
  821326
  823778
  824350
  827630
  827712
  827730
  828592
]
15.47 ms
(3.74%)
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
  521746
  467663
  663547
  631607
  775494
  806140
  806160
  765860
  813253
  463637
  496928
  523450
  648545
  817304
  737650
  790204
  603407
  529430
  24158
  610271
  191075
  453469
  588494
  452482
  577664
  570873
  620089
  607926
  417099
  457005
  412681
  425529
  659015
  546142
  781934
  736581
  383282
  781931
  797153
  828592
  24218
  388116
  385933
  386217
  663971
  24034
  532444
  587935
  807219
  388591
  458382
  455738
  443862
  478753
  514321
  504352
  526515
  490210
  511808
  590930
  566012
  573209
  774730
  533630
  827630
  827730
  813729
  824350
  538731
  496324
  540088
  719895
  548081
  604121
  604881
  636736
  788563
  795258
  810025
  759113
  706666
  404483
  473504
  558849
  564172
  579726
  614428
  488100
  456281
  444991
  458713
  525469
  555989
  417511
  823778
  645842
  808041
  488359
  517372
  571182
  821326
  650128
  677975
  629646
  34391
  745744
  397176
  554844
  658266
  626560
  827712
  710465
  619606
  427498
  673791
  517599
  523959
  820372
  702615
  806359
]
3.67 ms
(0.89%)
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
  24034
  24158
  24218
  34391
  191075
  383282
  385933
  386217
  388116
  388591
  397176
  404483
  412681
  417099
  417511
  425529
  427498
  443862
  444991
  452482
  453469
  455738
  456281
  457005
  458382
  458713
  463637
  467663
  473504
  478753
  488100
  488359
  490210
  496324
  496928
  504352
  511808
  514321
  517372
  517599
  521746
  523450
  523959
  525469
  526515
  529430
  532444
  533630
  538731
  540088
  546142
  548081
  554844
  555989
  558849
  564172
  566012
  570873
  571182
  573209
  577664
  579726
  587935
  588494
  590930
  603407
  604121
  604881
  607926
  610271
  614428
  619606
  620089
  626560
  629646
  631607
  636736
  645842
  648545
  650128
  658266
  659015
  663547
  663971
  673791
  677975
  702615
  706666
  710465
  719895
  736581
  737650
  745744
  759113
  765860
  774730
  775494
  781931
  781934
  788563
  790204
  795258
  797153
  806140
  806160
  806359
  807219
  808041
  810025
  813253
  813729
  817304
  820372
  821326
  823778
  824350
  827630
  827712
  827730
  828592
]
1.93 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ shower"
]
1.79 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits shower"
]

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.