GET https://search.jues.net/search/embeds/4?q=son%20and%20mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.21 ms
(84.59%)
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
  55266
  310672
  383224
  390566
  392787
  395909
  397174
  397447
  397894
  400481
  400507
  402383
  408493
  411914
  413136
  414153
  417162
  421862
  425865
  428539
  428844
  428910
  429584
  433249
  433681
  439727
  440292
  446282
  473954
  474794
  486251
  492302
  500806
  508450
  512343
  518954
  520892
  526449
  532113
  532126
  532130
  538329
  542957
  543798
  560892
  561453
  562967
  563452
  589260
  591276
  599715
  606619
  608355
  609819
  612574
  619116
  620245
  621637
  622670
  623226
  642187
  644027
  662140
  687940
  710587
  714502
  715163
  716014
  716329
  716535
  718130
  724225
  725493
  725502
  725511
  725526
  726403
  727036
  731022
  731269
  740117
  741044
  743022
  744184
  744809
  746089
  746091
  746603
  749766
  756424
  761607
  771490
  773814
  779534
  779768
  786542
  788142
  793282
  793486
  794114
  794403
  795040
  795044
  795816
  796208
  796212
  803565
  805063
  805344
  806698
  807411
  808015
  808859
  809307
  809800
  811263
  819489
  820746
  821762
  826659
]
15.09 ms
(9.30%)
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
  563452
  589260
  793486
  805344
  725502
  743022
  731022
  727036
  761607
  644027
  715163
  795816
  796212
  809800
  710587
  622670
  400507
  417162
  716329
  414153
  744184
  520892
  526449
  606619
  779534
  392787
  808015
  608355
  390566
  819489
  820746
  821762
  724225
  807411
  428539
  411914
  474794
  542957
  662140
  561453
  562967
  500806
  543798
  397174
  492302
  532126
  560892
  718130
  621637
  591276
  619116
  741044
  808859
  771490
  716535
  421862
  383224
  440292
  826659
  486251
  532113
  740117
  473954
  402383
  408493
  433249
  446282
  538329
  518954
  687940
  612574
  642187
  599715
  788142
  794114
  796208
  805063
  809307
  811263
  806698
  744809
  795044
  725493
  731269
  749766
  725526
  726403
  746091
  773814
  725511
  746089
  746603
  756424
  609819
  623226
  714502
  793282
  794403
  795040
  803565
  395909
  413136
  508450
  55266
  429584
  425865
  512343
  716014
  779768
  786542
  428844
  397447
  433681
  532130
  620245
  428910
  397894
  400481
  439727
  310672
]
3.17 ms
(1.95%)
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
  55266
  310672
  383224
  390566
  392787
  395909
  397174
  397447
  397894
  400481
  400507
  402383
  408493
  411914
  413136
  414153
  417162
  421862
  425865
  428539
  428844
  428910
  429584
  433249
  433681
  439727
  440292
  446282
  473954
  474794
  486251
  492302
  500806
  508450
  512343
  518954
  520892
  526449
  532113
  532126
  532130
  538329
  542957
  543798
  560892
  561453
  562967
  563452
  589260
  591276
  599715
  606619
  608355
  609819
  612574
  619116
  620245
  621637
  622670
  623226
  642187
  644027
  662140
  687940
  710587
  714502
  715163
  716014
  716329
  716535
  718130
  724225
  725493
  725502
  725511
  725526
  726403
  727036
  731022
  731269
  740117
  741044
  743022
  744184
  744809
  746089
  746091
  746603
  749766
  756424
  761607
  771490
  773814
  779534
  779768
  786542
  788142
  793282
  793486
  794114
  794403
  795040
  795044
  795816
  796208
  796212
  803565
  805063
  805344
  806698
  807411
  808015
  808859
  809307
  809800
  811263
  819489
  820746
  821762
  826659
]
1.79 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "son мам женщин"
]
1.79 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "son and mother"
]
1.68 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "son мам женщин"
]
1.50 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.