GET https://search.jues.net/search/embeds/7?q=19%20old%20casting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.16 ms
(77.18%)
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
  418727
  420207
  421537
  422565
  422594
  422599
  422600
  422626
  422633
  422639
  422652
  422670
  422688
  422712
  422863
  422958
  423018
  423027
  423245
  423400
  426152
  426383
  443364
  443513
  446266
  452317
  463809
  463937
  465051
  472486
  474642
  474744
  479847
  491253
  491354
  492067
  494618
  496032
  502889
  503151
  508527
  508769
  509454
  510964
  513888
  514218
  515644
  516450
  519469
  520740
  521444
  521989
  525102
  525849
  528993
  529129
  529184
  529855
  530018
  530025
  530048
  530370
  530494
  530663
  530768
  531090
  531433
  532984
  533519
  533738
  536748
  537206
  537209
  539210
  540434
  541879
  543877
  544784
  565255
  565276
  568327
  573477
  575472
  576398
  579328
  580669
  584540
  590731
  596323
  597227
  597253
  597263
  598590
  598828
  600084
  612222
  622401
  624173
  624505
  627804
  628380
  628388
  628392
  628409
  633782
  633798
  637023
  637078
  637123
  647969
  651188
  671676
  679816
  680126
  680154
  680207
  702164
  709748
  714497
  732878
]
24.31 ms
(15.88%)
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
  423245
  421537
  422633
  422670
  422712
  426383
  422565
  420207
  422599
  422688
  423018
  423027
  443364
  422600
  422626
  463937
  479847
  446266
  452317
  508527
  530370
  530663
  533519
  540434
  510964
  529184
  530018
  530768
  536748
  530048
  530494
  531090
  531433
  509454
  529129
  530025
  532984
  537206
  537209
  541879
  573477
  579328
  584540
  543877
  544784
  565255
  647969
  680154
  709748
  679816
  702164
  651188
  671676
  680126
  714497
  575472
  576398
  624505
  590731
  597227
  622401
  633798
  637023
  596323
  597253
  597263
  598590
  627804
  628388
  628392
  628409
  637078
  598828
  612222
  732878
  633782
  423400
  463809
  418727
  422639
  465051
  422594
  474642
  422863
  513888
  525102
  491354
  492067
  496032
  503151
  516450
  520740
  491253
  494618
  508769
  502889
  514218
  515644
  519469
  568327
  472486
  474744
  600084
  528993
  521989
  525849
  565276
  680207
  580669
  624173
  637123
  628380
  521444
  422958
  443513
  426152
  422652
  529855
  533738
  539210
]
3.45 ms
(2.25%)
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
  418727
  420207
  421537
  422565
  422594
  422599
  422600
  422626
  422633
  422639
  422652
  422670
  422688
  422712
  422863
  422958
  423018
  423027
  423245
  423400
  426152
  426383
  443364
  443513
  446266
  452317
  463809
  463937
  465051
  472486
  474642
  474744
  479847
  491253
  491354
  492067
  494618
  496032
  502889
  503151
  508527
  508769
  509454
  510964
  513888
  514218
  515644
  516450
  519469
  520740
  521444
  521989
  525102
  525849
  528993
  529129
  529184
  529855
  530018
  530025
  530048
  530370
  530494
  530663
  530768
  531090
  531433
  532984
  533519
  533738
  536748
  537206
  537209
  539210
  540434
  541879
  543877
  544784
  565255
  565276
  568327
  573477
  575472
  576398
  579328
  580669
  584540
  590731
  596323
  597227
  597253
  597263
  598590
  598828
  600084
  612222
  622401
  624173
  624505
  627804
  628380
  628388
  628392
  628409
  633782
  633798
  637023
  637078
  637123
  647969
  651188
  671676
  679816
  680126
  680154
  680207
  702164
  709748
  714497
  732878
]
2.07 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "19 old кастинг"
]
1.85 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "19 old casting"
]
1.67 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "19 old кастинг"
]
1.57 ms
(1.03%)
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.