GET https://search.jues.net/search/embeds/9?q=kitchen%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.02 ms
(80.12%)
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
  326017
  382858
  391253
  394329
  399966
  401226
  403716
  404314
  408179
  409881
  412159
  421868
  421918
  427486
  439791
  439856
  444917
  447467
  449360
  449603
  452339
  453155
  453242
  454001
  454256
  457444
  458692
  459441
  460132
  460258
  463790
  466288
  466961
  468890
  469814
  470772
  472142
  473913
  475269
  479027
  482029
  490001
  490454
  496410
  498939
  498984
  499323
  500046
  500118
  502600
  507647
  512168
  512215
  512257
  513032
  513755
  514681
  517761
  518016
  518158
  519123
  519151
  519589
  522113
  522326
  523729
  523850
  525282
  526176
  527115
  527709
  527731
  529160
  535433
  537022
  544576
  544834
  552493
  557322
  559067
  559960
  561830
  566109
  566128
  567431
  572927
  574375
  574433
  581901
  586398
  586886
  590989
  591048
  591067
  591450
  593073
  610543
  612537
  618948
  630083
  642367
  651594
  664584
  667136
  671730
  680890
  697000
  703987
  705310
  711589
  714380
  718720
  726512
  726587
  765311
  775207
  796227
  811076
  818315
  820143
]
26.58 ms
(14.49%)
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
  566128
  559960
  590989
  726512
  726587
  473913
  326017
  399966
  468890
  482029
  525282
  498984
  586886
  453242
  460258
  500046
  552493
  574433
  593073
  470772
  519151
  523729
  490001
  382858
  404314
  454001
  466961
  452339
  459441
  500118
  517761
  537022
  460132
  469814
  557322
  574375
  566109
  667136
  703987
  711589
  651594
  664584
  680890
  671730
  705310
  718720
  610543
  591048
  591450
  618948
  642367
  612537
  775207
  796227
  765311
  811076
  427486
  447467
  409881
  403716
  522326
  512168
  519123
  522113
  527709
  820143
  453155
  475269
  502600
  514681
  496410
  513032
  518158
  526176
  714380
  544834
  586398
  630083
  457444
  439856
  479027
  458692
  439791
  444917
  490454
  523850
  499323
  527731
  449360
  697000
  391253
  408179
  518016
  527115
  561830
  572927
  544576
  567431
  581901
  591067
  421918
  401226
  449603
  498939
  529160
  513755
  818315
  512215
  421868
  507647
  512257
  466288
  559067
  463790
  472142
  454256
  535433
  519589
  412159
  394329
]
2.61 ms
(1.42%)
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
  326017
  382858
  391253
  394329
  399966
  401226
  403716
  404314
  408179
  409881
  412159
  421868
  421918
  427486
  439791
  439856
  444917
  447467
  449360
  449603
  452339
  453155
  453242
  454001
  454256
  457444
  458692
  459441
  460132
  460258
  463790
  466288
  466961
  468890
  469814
  470772
  472142
  473913
  475269
  479027
  482029
  490001
  490454
  496410
  498939
  498984
  499323
  500046
  500118
  502600
  507647
  512168
  512215
  512257
  513032
  513755
  514681
  517761
  518016
  518158
  519123
  519151
  519589
  522113
  522326
  523729
  523850
  525282
  526176
  527115
  527709
  527731
  529160
  535433
  537022
  544576
  544834
  552493
  557322
  559067
  559960
  561830
  566109
  566128
  567431
  572927
  574375
  574433
  581901
  586398
  586886
  590989
  591048
  591067
  591450
  593073
  610543
  612537
  618948
  630083
  642367
  651594
  664584
  667136
  671730
  680890
  697000
  703987
  705310
  711589
  714380
  718720
  726512
  726587
  765311
  775207
  796227
  811076
  818315
  820143
]
2.11 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.11 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kitchen tits"
]
1.83 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кухн сиськ"
]
1.25 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кухн сиськ"
]

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.