GET https://search.jues.net/search/embeds/6?q=sweet%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.31 ms
(84.46%)
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
  13166
  382017
  385633
  386717
  391508
  395379
  396408
  396748
  402018
  408586
  418851
  429278
  429566
  432753
  436485
  441427
  441485
  444109
  447146
  452664
  464573
  471172
  476728
  493308
  499777
  502164
  505285
  506216
  506850
  512651
  518520
  521245
  525658
  528340
  528901
  532661
  540313
  540429
  541268
  550341
  551211
  551973
  560952
  564080
  570409
  573276
  577593
  585254
  587587
  590409
  594283
  597522
  597983
  599448
  600123
  600172
  605825
  612438
  616025
  617185
  620990
  623200
  623204
  624759
  634155
  640732
  644674
  651926
  652519
  659448
  669296
  671085
  672472
  673448
  679687
  680374
  680625
  695872
  701114
  701131
  703713
  704971
  705832
  718739
  720096
  722019
  724143
  727052
  727811
  733847
  733861
  733873
  733902
  735103
  736345
  740653
  741284
  742439
  744266
  746884
  747237
  748530
  751110
  751309
  754175
  760471
  762296
  766337
  769743
  771177
  777173
  777921
  785777
  786052
  786301
  786354
  787632
  797006
  813268
  817317
]
14.85 ms
(9.48%)
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
  762296
  740653
  744266
  754175
  760471
  742439
  746884
  766337
  701114
  701131
  722019
  786354
  797006
  385633
  436485
  396408
  532661
  382017
  441427
  441485
  471172
  505285
  506216
  528340
  493308
  550341
  570409
  671085
  672472
  695872
  652519
  659448
  680374
  704971
  718739
  720096
  651926
  669296
  673448
  679687
  680625
  703713
  587587
  597522
  605825
  624759
  585254
  590409
  599448
  612438
  594283
  597983
  600172
  786301
  785777
  724143
  733902
  736345
  747237
  786052
  733847
  735103
  751309
  727811
  733873
  727052
  733861
  769743
  771177
  741284
  751110
  617185
  777173
  777921
  787632
  813268
  408586
  386717
  402018
  432753
  512651
  499777
  577593
  705832
  600123
  616025
  640732
  623200
  634155
  623204
  748530
  620990
  644674
  447146
  395379
  391508
  13166
  396748
  444109
  418851
  429278
  429566
  817317
  452664
  476728
  521245
  525658
  540429
  506850
  518520
  528901
  502164
  540313
  464573
  551211
  551973
  564080
  560952
  541268
  573276
]
2.90 ms
(1.85%)
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
  13166
  382017
  385633
  386717
  391508
  395379
  396408
  396748
  402018
  408586
  418851
  429278
  429566
  432753
  436485
  441427
  441485
  444109
  447146
  452664
  464573
  471172
  476728
  493308
  499777
  502164
  505285
  506216
  506850
  512651
  518520
  521245
  525658
  528340
  528901
  532661
  540313
  540429
  541268
  550341
  551211
  551973
  560952
  564080
  570409
  573276
  577593
  585254
  587587
  590409
  594283
  597522
  597983
  599448
  600123
  600172
  605825
  612438
  616025
  617185
  620990
  623200
  623204
  624759
  634155
  640732
  644674
  651926
  652519
  659448
  669296
  671085
  672472
  673448
  679687
  680374
  680625
  695872
  701114
  701131
  703713
  704971
  705832
  718739
  720096
  722019
  724143
  727052
  727811
  733847
  733861
  733873
  733902
  735103
  736345
  740653
  741284
  742439
  744266
  746884
  747237
  748530
  751110
  751309
  754175
  760471
  762296
  766337
  769743
  771177
  777173
  777921
  785777
  786052
  786301
  786354
  787632
  797006
  813268
  817317
]
1.99 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sweet teen"
]
1.64 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "милая teen"
]
1.58 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.89%)
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.