GET https://search.jues.net/search/embeds/5?q=mother%20love

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.30 ms
(86.43%)
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
  358603
  383105
  384977
  386403
  390537
  396482
  399659
  401615
  414317
  415734
  421856
  424850
  430351
  431234
  433826
  437316
  438004
  438049
  445530
  452216
  454140
  454540
  455362
  461902
  464419
  465324
  466178
  469004
  470647
  473800
  477532
  488337
  488476
  490539
  492537
  495446
  506353
  513839
  519649
  522881
  523147
  539370
  540541
  542793
  543896
  550720
  555443
  563204
  571217
  571961
  574957
  575553
  584981
  591861
  596763
  597663
  604519
  615057
  633435
  639398
  639879
  653061
  662522
  664192
  669894
  677707
  691179
  697760
  698457
  701476
  718437
  721571
  726479
  726494
  726681
  727513
  733264
  736354
  742674
  742891
  742970
  748197
  748451
  752965
  755121
  762882
  765884
  765913
  773709
  783205
  783494
  787248
  791182
  794135
  794559
  794567
  794581
  795536
  796014
  796635
  800191
  800835
  800968
  801235
  801521
  802011
  803927
  804474
  804612
  806032
  809533
  810618
  819152
  819412
  819836
  823750
  824913
  825249
  826112
  826495
]
12.44 ms
(7.55%)
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
  726479
  765884
  726681
  415734
  465324
  490539
  522881
  809533
  358603
  727513
  574957
  464419
  571961
  597663
  791182
  794567
  748197
  615057
  804612
  384977
  488476
  701476
  438004
  431234
  495446
  633435
  445530
  421856
  819412
  826495
  823750
  825249
  826112
  824913
  819152
  819836
  543896
  653061
  662522
  718437
  669894
  639398
  800968
  783494
  794559
  801521
  803927
  773709
  794581
  810618
  742674
  762882
  733264
  755121
  748451
  765913
  787248
  796635
  800835
  396482
  461902
  454540
  470647
  571217
  677707
  698457
  604519
  800191
  801235
  783205
  454140
  466178
  430351
  539370
  506353
  563204
  721571
  742970
  424850
  383105
  437316
  488337
  469004
  542793
  752965
  455362
  390537
  438049
  523147
  492537
  519649
  401615
  584981
  550720
  555443
  697760
  575553
  802011
  795536
  806032
  433826
  386403
  513839
  399659
  414317
  477532
  452216
  473800
  540541
  691179
  664192
  591861
  596763
  639879
  796014
  804474
  794135
  736354
  742891
  726494
]
2.90 ms
(1.76%)
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
  358603
  383105
  384977
  386403
  390537
  396482
  399659
  401615
  414317
  415734
  421856
  424850
  430351
  431234
  433826
  437316
  438004
  438049
  445530
  452216
  454140
  454540
  455362
  461902
  464419
  465324
  466178
  469004
  470647
  473800
  477532
  488337
  488476
  490539
  492537
  495446
  506353
  513839
  519649
  522881
  523147
  539370
  540541
  542793
  543896
  550720
  555443
  563204
  571217
  571961
  574957
  575553
  584981
  591861
  596763
  597663
  604519
  615057
  633435
  639398
  639879
  653061
  662522
  664192
  669894
  677707
  691179
  697760
  698457
  701476
  718437
  721571
  726479
  726494
  726681
  727513
  733264
  736354
  742674
  742891
  742970
  748197
  748451
  752965
  755121
  762882
  765884
  765913
  773709
  783205
  783494
  787248
  791182
  794135
  794559
  794567
  794581
  795536
  796014
  796635
  800191
  800835
  800968
  801235
  801521
  802011
  803927
  804474
  804612
  806032
  809533
  810618
  819152
  819412
  819836
  823750
  824913
  825249
  826112
  826495
]
2.00 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother love"
]
1.83 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин love"
]
1.56 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин love"
]

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.