GET https://search.jues.net/search/embeds/10?q=milf%20brunette%20maid

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.71 ms
(83.70%)
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
  403463
  406650
  406882
  411326
  414845
  416791
  417875
  418520
  424265
  424429
  430783
  434097
  438446
  439605
  439642
  443756
  449991
  455313
  457851
  459883
  463155
  464757
  477131
  478362
  480630
  481937
  484527
  485943
  487471
  488653
  489249
  491926
  497497
  502753
  504109
  504751
  507110
  507111
  511046
  511309
  511779
  511797
  516812
  516817
  518327
  519262
  520935
  522850
  524491
  524499
  525176
  525980
  528915
  528917
  530183
  531919
  532209
  532993
  533897
  540157
  546393
  547873
  549128
  549836
  550317
  551933
  552495
  553972
  556010
  556021
  556816
  557463
  560444
  561439
  562291
  562343
  562993
  564655
  566958
  568052
  568320
  569038
  569568
  571820
  574432
  577617
  578496
  582369
  582554
  582787
  583607
  584563
  591052
  591519
  593050
  599167
  600977
  606333
  609815
  615974
  617375
  623643
  632734
  638578
  663429
  665442
  667942
  668660
  695868
  697002
  721537
  725135
  726538
  730961
  731105
  766734
  782777
  790026
  796105
  799553
]
17.13 ms
(10.12%)
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
  504109
  504751
  507110
  511779
  511797
  519262
  522850
  530183
  533897
  497497
  502753
  511309
  516812
  528917
  531919
  532993
  540157
  507111
  511046
  525176
  525980
  528915
  532209
  524491
  524499
  459883
  546393
  551933
  553972
  568320
  569038
  569568
  577617
  578496
  584563
  547873
  549128
  557463
  564655
  571820
  582369
  582787
  560444
  561439
  562343
  562993
  566958
  663429
  665442
  668660
  695868
  721537
  667942
  549836
  550317
  552495
  556010
  556021
  556816
  562291
  568052
  574432
  582554
  583607
  609815
  615974
  617375
  591052
  591519
  599167
  600977
  606333
  632734
  593050
  623643
  638578
  782777
  790026
  796105
  799553
  725135
  731105
  726538
  766734
  730961
  697002
  414845
  424429
  438446
  443756
  477131
  478362
  481937
  439605
  463155
  464757
  403463
  416791
  418520
  430783
  449991
  411326
  424265
  434097
  439642
  457851
  480630
  406650
  406882
  417875
  455313
  518327
  485943
  487471
  488653
  516817
  520935
  484527
  489249
  491926
]
2.96 ms
(1.75%)
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
  403463
  406650
  406882
  411326
  414845
  416791
  417875
  418520
  424265
  424429
  430783
  434097
  438446
  439605
  439642
  443756
  449991
  455313
  457851
  459883
  463155
  464757
  477131
  478362
  480630
  481937
  484527
  485943
  487471
  488653
  489249
  491926
  497497
  502753
  504109
  504751
  507110
  507111
  511046
  511309
  511779
  511797
  516812
  516817
  518327
  519262
  520935
  522850
  524491
  524499
  525176
  525980
  528915
  528917
  530183
  531919
  532209
  532993
  533897
  540157
  546393
  547873
  549128
  549836
  550317
  551933
  552495
  553972
  556010
  556021
  556816
  557463
  560444
  561439
  562291
  562343
  562993
  564655
  566958
  568052
  568320
  569038
  569568
  571820
  574432
  577617
  578496
  582369
  582554
  582787
  583607
  584563
  591052
  591519
  593050
  599167
  600977
  606333
  609815
  615974
  617375
  623643
  632734
  638578
  663429
  665442
  667942
  668660
  695868
  697002
  721537
  725135
  726538
  730961
  731105
  766734
  782777
  790026
  796105
  799553
]
1.99 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf brunette maid"
]
1.98 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf черноволосая горничн"
]
1.82 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf черноволосая горничн"
]
1.72 ms
(1.02%)
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.