GET https://search.jues.net/search/embeds/3?q=dad%20dick

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.38 ms
(81.78%)
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
  386712
  388647
  391565
  392620
  393731
  393758
  400447
  401362
  401996
  409100
  413732
  413934
  417010
  418725
  421132
  425554
  427282
  430144
  430308
  433748
  434168
  434185
  434661
  435613
  435735
  435768
  437336
  441506
  442380
  443064
  445501
  446331
  446354
  448560
  449431
  453548
  454043
  455060
  455957
  455973
  457113
  457675
  460247
  460677
  461645
  464307
  465507
  466368
  466775
  467313
  467663
  469022
  469514
  471408
  471775
  471962
  472436
  472466
  475174
  477699
  479021
  481795
  485187
  486946
  493138
  493817
  494040
  505973
  506130
  506227
  506778
  507363
  512061
  513495
  513584
  514272
  516410
  516757
  516792
  517526
  519934
  520004
  521391
  523323
  524518
  524910
  526394
  526591
  526611
  526830
  527181
  527663
  537020
  546894
  557961
  560885
  565012
  566337
  567014
  572028
  572943
  575704
  578078
  591690
  591735
  598483
  604157
  607214
  610021
  612601
  618893
  636070
  645273
  647856
  662140
  714062
  717895
  789067
  789698
  812593
]
16.63 ms
(11.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
  409100
  386712
  471408
  425554
  441506
  460247
  516410
  519934
  493817
  516792
  505973
  400447
  434661
  442380
  435768
  446354
  449431
  467313
  493138
  454043
  517526
  526394
  506130
  524910
  467663
  469022
  567014
  572943
  560885
  636070
  418725
  433748
  437336
  421132
  457675
  472466
  466368
  512061
  513584
  485187
  494040
  521391
  392620
  388647
  401996
  413732
  427282
  465507
  457113
  546894
  557961
  572028
  565012
  578078
  714062
  662140
  717895
  610021
  604157
  789698
  812593
  789067
  607214
  612601
  393731
  477699
  391565
  466775
  455973
  524518
  486946
  430308
  443064
  516757
  566337
  647856
  591690
  591735
  598483
  618893
  417010
  514272
  471962
  527181
  455957
  506778
  471775
  507363
  537020
  434185
  435735
  434168
  455060
  461645
  527663
  469514
  446331
  475174
  393758
  435613
  464307
  472436
  526591
  506227
  513495
  523323
  526611
  520004
  526830
  401362
  413934
  430144
  445501
  481795
  448560
  453548
  460677
  479021
  575704
  645273
]
2.92 ms
(1.97%)
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
  386712
  388647
  391565
  392620
  393731
  393758
  400447
  401362
  401996
  409100
  413732
  413934
  417010
  418725
  421132
  425554
  427282
  430144
  430308
  433748
  434168
  434185
  434661
  435613
  435735
  435768
  437336
  441506
  442380
  443064
  445501
  446331
  446354
  448560
  449431
  453548
  454043
  455060
  455957
  455973
  457113
  457675
  460247
  460677
  461645
  464307
  465507
  466368
  466775
  467313
  467663
  469022
  469514
  471408
  471775
  471962
  472436
  472466
  475174
  477699
  479021
  481795
  485187
  486946
  493138
  493817
  494040
  505973
  506130
  506227
  506778
  507363
  512061
  513495
  513584
  514272
  516410
  516757
  516792
  517526
  519934
  520004
  521391
  523323
  524518
  524910
  526394
  526591
  526611
  526830
  527181
  527663
  537020
  546894
  557961
  560885
  565012
  566337
  567014
  572028
  572943
  575704
  578078
  591690
  591735
  598483
  604157
  607214
  610021
  612601
  618893
  636070
  645273
  647856
  662140
  714062
  717895
  789067
  789698
  812593
]
2.02 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dad dick"
]
1.88 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dad член"
]
1.78 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dad член"
]

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.