GET https://search.jues.net/search/embeds/10?q=solo%20mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.82 ms
(84.19%)
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
  182135
  311520
  397225
  397666
  400942
  410346
  415857
  426247
  429699
  429737
  429869
  440633
  450302
  455078
  457376
  460199
  465323
  465653
  466427
  467901
  469463
  469502
  471022
  471045
  471687
  472621
  473786
  475097
  475702
  475767
  480496
  486243
  488213
  488753
  489291
  491238
  495381
  495385
  525092
  529362
  529583
  529609
  529648
  529871
  530409
  531822
  531839
  531850
  531856
  532498
  534548
  535320
  535409
  535939
  541377
  543951
  545222
  545901
  547775
  547858
  548834
  550916
  551494
  555020
  556899
  561519
  562408
  566914
  568261
  574656
  576482
  576517
  576925
  577284
  583798
  584314
  587215
  588387
  599773
  602261
  604418
  605232
  607296
  609887
  613032
  620260
  624903
  628518
  643325
  643386
  660079
  660400
  664189
  665958
  665975
  668082
  671049
  672836
  680252
  681746
  693378
  713247
  713501
  713507
  715420
  720468
  720511
  720516
  733073
  744191
  761473
  781862
  805360
  805813
  810889
  819218
  819241
  824868
  825514
  826503
]
12.81 ms
(9.15%)
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
  551494
  555020
  665975
  410346
  415857
  429699
  429737
  429869
  455078
  469463
  525092
  535939
  693378
  672836
  810889
  397225
  819241
  489291
  535409
  529871
  529362
  543951
  576482
  720511
  720468
  720516
  599773
  605232
  805813
  805360
  733073
  744191
  761473
  397666
  819218
  450302
  491238
  311520
  668082
  781862
  182135
  400942
  440633
  426247
  826503
  824868
  825514
  465323
  465653
  473786
  475767
  488753
  469502
  471687
  472621
  475097
  480496
  457376
  467901
  471022
  471045
  486243
  495381
  529583
  529648
  529609
  530409
  531822
  531856
  532498
  534548
  495385
  531839
  531850
  535320
  460199
  466427
  475702
  488213
  547858
  561519
  577284
  545222
  550916
  556899
  566914
  541377
  548834
  574656
  576517
  576925
  583798
  584314
  664189
  671049
  660079
  660400
  713247
  715420
  665958
  680252
  681746
  713501
  713507
  545901
  547775
  562408
  568261
  628518
  643386
  588387
  602261
  604418
  607296
  613032
  620260
  643325
  587215
  609887
  624903
]
2.64 ms
(1.89%)
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
  182135
  311520
  397225
  397666
  400942
  410346
  415857
  426247
  429699
  429737
  429869
  440633
  450302
  455078
  457376
  460199
  465323
  465653
  466427
  467901
  469463
  469502
  471022
  471045
  471687
  472621
  473786
  475097
  475702
  475767
  480496
  486243
  488213
  488753
  489291
  491238
  495381
  495385
  525092
  529362
  529583
  529609
  529648
  529871
  530409
  531822
  531839
  531850
  531856
  532498
  534548
  535320
  535409
  535939
  541377
  543951
  545222
  545901
  547775
  547858
  548834
  550916
  551494
  555020
  556899
  561519
  562408
  566914
  568261
  574656
  576482
  576517
  576925
  577284
  583798
  584314
  587215
  588387
  599773
  602261
  604418
  605232
  607296
  609887
  613032
  620260
  624903
  628518
  643325
  643386
  660079
  660400
  664189
  665958
  665975
  668082
  671049
  672836
  680252
  681746
  693378
  713247
  713501
  713507
  715420
  720468
  720511
  720516
  733073
  744191
  761473
  781862
  805360
  805813
  810889
  819218
  819241
  824868
  825514
  826503
]
2.13 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo mother"
]
1.63 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло мам женщин"
]
1.31 ms
(0.94%)
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.