GET https://search.jues.net/search/embeds/4?q=skinny%20mature%20russian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.86 ms
(80.07%)
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
  389474
  401953
  403419
  409948
  411619
  414125
  419545
  420635
  421871
  421890
  421907
  423920
  424001
  424200
  424470
  427100
  428830
  430374
  434322
  434334
  434338
  434360
  434361
  434364
  434367
  434369
  434374
  439156
  443802
  443855
  448055
  454132
  455373
  460731
  460813
  464997
  465818
  467868
  467873
  467879
  467882
  467897
  467905
  467934
  469603
  470487
  470593
  470596
  473248
  473938
  475911
  475914
  477990
  478918
  481295
  481939
  484981
  490513
  491130
  491612
  491932
  497868
  499019
  502866
  503153
  503481
  506273
  510742
  511058
  511372
  511374
  511530
  511825
  516635
  517554
  522610
  524361
  528380
  530001
  534034
  542960
  543317
  543609
  543817
  546761
  547722
  550230
  555127
  555168
  555716
  556006
  556877
  558008
  558609
  562190
  567581
  569129
  569919
  570753
  570842
  572916
  573729
  581618
  590404
  590633
  591216
  600256
  600302
  601938
  605378
  620243
  623716
  626399
  626405
  631179
  650155
  668747
  702621
  786911
  807011
]
20.10 ms
(13.21%)
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
  807011
  786911
  467905
  467873
  477990
  389474
  455373
  478918
  419545
  454132
  460813
  465818
  427100
  503481
  511530
  491612
  511374
  484981
  497868
  650155
  591216
  620243
  470596
  570753
  573729
  601938
  626405
  467879
  467934
  473248
  475911
  470593
  414125
  434364
  522610
  511058
  491130
  491932
  510742
  403419
  590404
  439156
  534034
  558609
  562190
  569129
  570842
  543317
  558008
  569919
  581618
  668747
  547722
  556877
  572916
  600302
  401953
  434334
  443802
  411619
  424001
  434367
  473938
  423920
  434338
  481939
  499019
  502866
  490513
  528380
  511825
  590633
  424200
  467868
  434360
  460731
  475914
  550230
  421871
  421890
  421907
  524361
  481295
  470487
  517554
  543609
  555127
  555168
  555716
  702621
  626399
  600256
  605378
  434361
  434374
  464997
  467882
  467897
  469603
  424470
  430374
  448055
  503153
  530001
  516635
  420635
  434369
  546761
  542960
  434322
  631179
  623716
  443855
  506273
  543817
  556006
  567581
  428830
  409948
  511372
]
3.18 ms
(2.09%)
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
  389474
  401953
  403419
  409948
  411619
  414125
  419545
  420635
  421871
  421890
  421907
  423920
  424001
  424200
  424470
  427100
  428830
  430374
  434322
  434334
  434338
  434360
  434361
  434364
  434367
  434369
  434374
  439156
  443802
  443855
  448055
  454132
  455373
  460731
  460813
  464997
  465818
  467868
  467873
  467879
  467882
  467897
  467905
  467934
  469603
  470487
  470593
  470596
  473248
  473938
  475911
  475914
  477990
  478918
  481295
  481939
  484981
  490513
  491130
  491612
  491932
  497868
  499019
  502866
  503153
  503481
  506273
  510742
  511058
  511372
  511374
  511530
  511825
  516635
  517554
  522610
  524361
  528380
  530001
  534034
  542960
  543317
  543609
  543817
  546761
  547722
  550230
  555127
  555168
  555716
  556006
  556877
  558008
  558609
  562190
  567581
  569129
  569919
  570753
  570842
  572916
  573729
  581618
  590404
  590633
  591216
  600256
  600302
  601938
  605378
  620243
  623716
  626399
  626405
  631179
  650155
  668747
  702621
  786911
  807011
]
2.29 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny mature russian"
]
1.87 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые mature русск"
]
1.37 ms
(0.90%)
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.