GET https://search.jues.net/search/embeds/2?q=mature%20big%20curvy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.51 ms
(54.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
151.04 ms
(39.17%)
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
  241603
  386759
  396961
  404585
  405114
  405116
  409259
  422053
  427543
  430244
  430818
  431341
  438284
  440826
  447911
  448055
  448084
  448104
  449869
  449880
  450312
  451672
  452189
  453648
  453686
  453705
  459620
  463159
  464308
  465472
  466092
  468702
  468724
  473439
  476117
  478037
  478933
  480645
  481584
  485285
  486868
  488954
  490188
  495660
  501529
  502792
  503418
  503556
  503565
  505394
  509590
  509637
  509656
  509923
  510844
  512541
  514004
  514565
  515025
  520217
  523034
  523441
  526213
  529227
  531435
  532629
  533040
  533643
  537591
  537937
  541220
  546838
  553283
  562059
  563827
  569133
  569544
  577037
  577402
  580765
  589708
  590410
  598376
  599203
  600453
  603507
  607509
  607640
  607694
  607696
  609102
  621426
  633521
  665781
  667975
  668668
  705424
  716765
  756469
  758079
  760211
  761066
  769502
  770897
  788260
  793662
  797461
  801348
  801941
  802379
  808537
  811152
  812911
  813101
  813532
  814971
  814981
  814983
  815714
  819920
]
17.06 ms
(4.42%)
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
  452189
  490188
  509590
  453686
  515025
  797461
  808537
  811152
  520217
  529227
  465472
  509923
  523034
  541220
  607696
  466092
  396961
  405116
  430244
  537591
  577037
  603507
  814981
  814983
  468702
  607509
  801348
  760211
  793662
  761066
  769502
  801941
  459620
  512541
  501529
  514565
  478037
  485285
  815714
  533040
  531435
  553283
  609102
  241603
  546838
  590410
  758079
  451672
  464308
  523441
  509656
  453648
  478933
  448104
  503565
  505394
  514004
  819920
  450312
  510844
  716765
  812911
  770897
  386759
  814971
  509637
  503418
  665781
  607640
  463159
  488954
  473439
  440826
  802379
  813101
  589708
  532629
  449869
  447911
  563827
  599203
  405114
  480645
  526213
  705424
  422053
  430818
  468724
  533643
  598376
  788260
  580765
  813532
  453705
  448055
  502792
  577402
  621426
  486868
  431341
  503556
  404585
  448084
  600453
  449880
  476117
  537937
  481584
  607694
  495660
  569133
  427543
  668668
  633521
  569544
  756469
  438284
  409259
  562059
  667975
]
2.71 ms
(0.70%)
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
  241603
  386759
  396961
  404585
  405114
  405116
  409259
  422053
  427543
  430244
  430818
  431341
  438284
  440826
  447911
  448055
  448084
  448104
  449869
  449880
  450312
  451672
  452189
  453648
  453686
  453705
  459620
  463159
  464308
  465472
  466092
  468702
  468724
  473439
  476117
  478037
  478933
  480645
  481584
  485285
  486868
  488954
  490188
  495660
  501529
  502792
  503418
  503556
  503565
  505394
  509590
  509637
  509656
  509923
  510844
  512541
  514004
  514565
  515025
  520217
  523034
  523441
  526213
  529227
  531435
  532629
  533040
  533643
  537591
  537937
  541220
  546838
  553283
  562059
  563827
  569133
  569544
  577037
  577402
  580765
  589708
  590410
  598376
  599203
  600453
  603507
  607509
  607640
  607694
  607696
  609102
  621426
  633521
  665781
  667975
  668668
  705424
  716765
  756469
  758079
  760211
  761066
  769502
  770897
  788260
  793662
  797461
  801348
  801941
  802379
  808537
  811152
  812911
  813101
  813532
  814971
  814981
  814983
  815714
  819920
]
1.96 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature big curvy"
]
1.86 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature большие curvy"
]
1.44 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature большие curvy"
]

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.