GET https://search.jues.net/search/embeds/7?q=facesitting%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.07 ms
(84.65%)
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
  6710
  12887
  95586
  383565
  383650
  386709
  387915
  395746
  397782
  404194
  407007
  410688
  421148
  424480
  440852
  443142
  448064
  451509
  456902
  457010
  462371
  464125
  465607
  466434
  466939
  468031
  469300
  470625
  474030
  475277
  480755
  481965
  482306
  482553
  482664
  482755
  483109
  485051
  496778
  505100
  509635
  526250
  532270
  532352
  532782
  532808
  533040
  554796
  555335
  555356
  557190
  563235
  563415
  567754
  569423
  578701
  581833
  584705
  592596
  594896
  596000
  596477
  604383
  609991
  610228
  613117
  613495
  619645
  623643
  629818
  648890
  660748
  665182
  665862
  668537
  679457
  694484
  697210
  702077
  714864
  715556
  716405
  717523
  724133
  724328
  728169
  728931
  728933
  737521
  742965
  750063
  750461
  757364
  758617
  766624
  774613
  786460
  789968
  790784
  794800
  796014
  801975
  807993
  809421
  810286
  813442
  814124
  815057
  815449
  816261
  816507
  817024
  817298
  817855
  818214
  820335
  821069
  821449
  825116
  826278
]
19.16 ms
(9.71%)
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
  424480
  386709
  95586
  383565
  383650
  395746
  12887
  6710
  387915
  397782
  404194
  410688
  440852
  407007
  443142
  421148
  816507
  816261
  817024
  817298
  817855
  818214
  815057
  815449
  820335
  821449
  825116
  826278
  814124
  821069
  456902
  457010
  466434
  466939
  469300
  474030
  482306
  482664
  483109
  451509
  468031
  470625
  475277
  480755
  448064
  481965
  482553
  482755
  485051
  505100
  532808
  496778
  532270
  526250
  532782
  533040
  509635
  532352
  462371
  464125
  465607
  563235
  578701
  584705
  554796
  557190
  567754
  569423
  581833
  648890
  665182
  694484
  702077
  714864
  716405
  697210
  717523
  660748
  665862
  668537
  679457
  715556
  555335
  555356
  563415
  592596
  596477
  619645
  629818
  594896
  596000
  610228
  623643
  609991
  786460
  790784
  794800
  796014
  774613
  801975
  809421
  813442
  789968
  807993
  810286
  728931
  737521
  750063
  724133
  724328
  728169
  742965
  757364
  728933
  750461
  758617
  766624
  604383
  613117
  613495
]
3.83 ms
(1.94%)
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
  6710
  12887
  95586
  383565
  383650
  386709
  387915
  395746
  397782
  404194
  407007
  410688
  421148
  424480
  440852
  443142
  448064
  451509
  456902
  457010
  462371
  464125
  465607
  466434
  466939
  468031
  469300
  470625
  474030
  475277
  480755
  481965
  482306
  482553
  482664
  482755
  483109
  485051
  496778
  505100
  509635
  526250
  532270
  532352
  532782
  532808
  533040
  554796
  555335
  555356
  557190
  563235
  563415
  567754
  569423
  578701
  581833
  584705
  592596
  594896
  596000
  596477
  604383
  609991
  610228
  613117
  613495
  619645
  623643
  629818
  648890
  660748
  665182
  665862
  668537
  679457
  694484
  697210
  702077
  714864
  715556
  716405
  717523
  724133
  724328
  728169
  728931
  728933
  737521
  742965
  750063
  750461
  757364
  758617
  766624
  774613
  786460
  789968
  790784
  794800
  796014
  801975
  807993
  809421
  810286
  813442
  814124
  815057
  815449
  816261
  816507
  817024
  817298
  817855
  818214
  820335
  821069
  821449
  825116
  826278
]
2.11 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "facesitting mature"
]
1.98 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фейсситтинг mature"
]
1.55 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фейсситтинг mature"
]

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.