GET https://search.jues.net/search/embeds/5?q=mature%20woman%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.15 ms
(85.86%)
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
  391158
  397780
  407567
  417080
  425405
  428799
  454416
  454930
  457010
  459128
  464936
  465246
  465437
  466492
  469121
  472336
  473634
  474102
  474509
  476246
  476270
  478265
  479355
  480397
  483350
  487396
  502840
  504620
  506009
  510937
  511609
  513541
  525734
  533711
  535053
  535811
  539641
  541738
  546336
  547413
  547464
  547781
  550172
  550429
  551704
  554226
  555444
  570932
  572259
  574252
  575663
  576463
  576493
  584400
  590306
  594856
  595086
  595309
  599768
  599995
  605266
  614384
  621315
  623939
  628148
  642075
  660364
  660688
  663893
  669857
  669899
  693055
  696052
  703556
  705516
  705736
  706900
  714042
  715881
  716339
  717009
  719899
  721755
  724023
  739925
  739950
  745558
  746095
  748353
  756192
  759369
  761147
  765359
  772284
  786388
  788404
  788734
  790885
  798935
  803025
  805287
  806057
  806403
  807636
  812979
  815388
  815616
  816340
  817455
  817594
  817846
  818225
  819020
  819053
  819151
  819240
  820656
  821688
  821783
  828370
]
13.69 ms
(8.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
  806057
  807636
  812979
  705516
  479355
  469121
  478265
  487396
  817846
  815388
  815616
  819151
  821688
  535053
  547464
  693055
  703556
  621315
  628148
  642075
  806403
  788734
  759369
  599995
  746095
  590306
  717009
  391158
  716339
  483350
  756192
  719899
  820656
  715881
  739925
  739950
  765359
  465437
  816340
  504620
  454930
  466492
  576493
  660688
  724023
  761147
  407567
  539641
  511609
  550429
  464936
  459128
  472336
  502840
  476246
  397780
  457010
  417080
  599768
  572259
  525734
  533711
  575663
  663893
  669857
  669899
  696052
  786388
  546336
  550172
  721755
  772284
  425405
  570932
  614384
  803025
  474509
  476270
  506009
  474102
  428799
  513541
  595309
  480397
  454416
  473634
  510937
  819240
  821783
  817455
  818225
  828370
  535811
  574252
  547413
  551704
  555444
  706900
  576463
  584400
  623939
  594856
  748353
  788404
  798935
  745558
  705736
  554226
  465246
  595086
  817594
  547781
  660364
  805287
  605266
  790885
  714042
  541738
  819053
  819020
]
2.72 ms
(1.63%)
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
  391158
  397780
  407567
  417080
  425405
  428799
  454416
  454930
  457010
  459128
  464936
  465246
  465437
  466492
  469121
  472336
  473634
  474102
  474509
  476246
  476270
  478265
  479355
  480397
  483350
  487396
  502840
  504620
  506009
  510937
  511609
  513541
  525734
  533711
  535053
  535811
  539641
  541738
  546336
  547413
  547464
  547781
  550172
  550429
  551704
  554226
  555444
  570932
  572259
  574252
  575663
  576463
  576493
  584400
  590306
  594856
  595086
  595309
  599768
  599995
  605266
  614384
  621315
  623939
  628148
  642075
  660364
  660688
  663893
  669857
  669899
  693055
  696052
  703556
  705516
  705736
  706900
  714042
  715881
  716339
  717009
  719899
  721755
  724023
  739925
  739950
  745558
  746095
  748353
  756192
  759369
  761147
  765359
  772284
  786388
  788404
  788734
  790885
  798935
  803025
  805287
  806057
  806403
  807636
  812979
  815388
  815616
  816340
  817455
  817594
  817846
  818225
  819020
  819053
  819151
  819240
  820656
  821688
  821783
  828370
]
2.06 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature woman public"
]
1.63 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин на улиц"
]
1.44 ms
(0.87%)
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.