GET https://search.jues.net/search/embeds/7?q=amateur%20teen%20small

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
203.84 ms
(89.39%)
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
  429945
  432927
  441396
  445182
  446198
  447799
  453852
  454836
  454842
  456268
  459237
  459482
  460104
  464185
  473756
  475333
  475600
  479221
  491718
  494808
  497690
  498988
  509746
  516737
  522288
  522348
  538986
  540685
  540955
  541724
  542964
  543727
  544147
  547405
  548787
  548998
  549051
  551275
  552099
  552136
  552684
  553889
  556166
  558356
  560615
  569859
  570531
  571900
  574482
  574580
  574879
  575154
  575487
  575510
  575727
  576142
  578325
  579253
  579483
  585967
  588966
  594297
  594411
  594429
  596670
  597545
  598538
  602024
  603951
  609878
  630469
  644330
  658110
  658555
  662533
  685537
  685789
  686576
  697514
  712064
  716485
  718127
  718685
  720102
  720128
  723266
  724399
  727906
  734472
  735592
  736101
  736962
  737055
  738233
  740807
  744030
  750143
  751361
  754027
  764405
  765095
  766818
  773340
  776287
  778953
  781055
  782128
  784281
  784889
  787936
  788547
  789013
  791303
  797428
  800975
  807531
  814963
  819064
  827257
  827508
]
14.45 ms
(6.34%)
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
  579483
  720102
  807531
  574482
  552099
  575154
  575510
  441396
  814963
  460104
  494808
  473756
  475333
  479221
  789013
  766818
  447799
  453852
  475600
  516737
  509746
  538986
  543727
  685537
  697514
  594429
  594297
  594411
  446198
  819064
  827257
  827508
  540685
  553889
  558356
  549051
  578325
  544147
  579253
  662533
  685789
  718127
  712064
  723266
  547405
  548998
  576142
  776287
  781055
  797428
  734472
  740807
  744030
  754027
  784889
  765095
  735592
  764405
  773340
  724399
  738233
  727906
  736962
  737055
  750143
  751361
  716485
  718685
  720128
  778953
  782128
  784281
  787936
  788547
  791303
  658555
  800975
  551275
  540955
  560615
  569859
  574879
  575727
  542964
  548787
  552136
  571900
  552684
  570531
  575487
  609878
  598538
  736101
  644330
  432927
  459237
  459482
  497690
  522348
  603951
  456268
  445182
  454836
  454842
  429945
  464185
  522288
  491718
  658110
  686576
  597545
  630469
  596670
  556166
  541724
  574580
  602024
  588966
  585967
  498988
]
2.68 ms
(1.17%)
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
  429945
  432927
  441396
  445182
  446198
  447799
  453852
  454836
  454842
  456268
  459237
  459482
  460104
  464185
  473756
  475333
  475600
  479221
  491718
  494808
  497690
  498988
  509746
  516737
  522288
  522348
  538986
  540685
  540955
  541724
  542964
  543727
  544147
  547405
  548787
  548998
  549051
  551275
  552099
  552136
  552684
  553889
  556166
  558356
  560615
  569859
  570531
  571900
  574482
  574580
  574879
  575154
  575487
  575510
  575727
  576142
  578325
  579253
  579483
  585967
  588966
  594297
  594411
  594429
  596670
  597545
  598538
  602024
  603951
  609878
  630469
  644330
  658110
  658555
  662533
  685537
  685789
  686576
  697514
  712064
  716485
  718127
  718685
  720102
  720128
  723266
  724399
  727906
  734472
  735592
  736101
  736962
  737055
  738233
  740807
  744030
  750143
  751361
  754027
  764405
  765095
  766818
  773340
  776287
  778953
  781055
  782128
  784281
  784889
  787936
  788547
  789013
  791303
  797428
  800975
  807531
  814963
  819064
  827257
  827508
]
1.94 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur teen small"
]
1.86 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск teen маленькая"
]
1.80 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск teen маленькая"
]

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.