GET https://search.jues.net/search/embeds/3?q=milf%20asian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.20 ms
(79.04%)
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
  20190
  23104
  23524
  163006
  188655
  324568
  327421
  379377
  382812
  383734
  383735
  384038
  384092
  384433
  384492
  385448
  385590
  386023
  386050
  386323
  386605
  387143
  388027
  388771
  390305
  390754
  390804
  392739
  396922
  405727
  406330
  407566
  408988
  420135
  428450
  444218
  456862
  457097
  457980
  458327
  458844
  465076
  465235
  475450
  478454
  481941
  497235
  498620
  499485
  511038
  512683
  512955
  516430
  530348
  535434
  537932
  540788
  547871
  549319
  550617
  550618
  550776
  551028
  551949
  551969
  552017
  552028
  552053
  552897
  552913
  552933
  554343
  556398
  556409
  556662
  557815
  559873
  559897
  560216
  565990
  565998
  571813
  574642
  581972
  583298
  583667
  583934
  590966
  591849
  596422
  600631
  601081
  605848
  605919
  618483
  619487
  622266
  622650
  623515
  623608
  623610
  627728
  639310
  662069
  712154
  717298
  727334
  737105
  747958
  758601
  770665
  776554
  785005
  802533
  808775
  809163
  813507
  817757
  828085
  828866
]
22.36 ms
(14.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
  383735
  384038
  465235
  481941
  549319
  571813
  727334
  622650
  828866
  407566
  828085
  23524
  386023
  383734
  188655
  163006
  390305
  406330
  511038
  557815
  623515
  627728
  776554
  785005
  388027
  386050
  747958
  23104
  458844
  516430
  499485
  574642
  583298
  551028
  551969
  556409
  556398
  550776
  551949
  552028
  552897
  559873
  618483
  428450
  498620
  537932
  560216
  386605
  384092
  390804
  444218
  540788
  478454
  497235
  512683
  552933
  552017
  554343
  662069
  605919
  596422
  809163
  758601
  802533
  717298
  408988
  387143
  390754
  817757
  565990
  550617
  600631
  590966
  550618
  396922
  405727
  456862
  465076
  475450
  530348
  583667
  712154
  552913
  622266
  623608
  601081
  605848
  619487
  639310
  813507
  737105
  808775
  770665
  20190
  457097
  384433
  382812
  327421
  457980
  512955
  552053
  559897
  591849
  623610
  547871
  583934
  379377
  388771
  392739
  420135
  324568
  565998
  458327
  535434
  581972
  556662
  386323
  385448
  385590
  384492
]
3.30 ms
(2.08%)
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
  20190
  23104
  23524
  163006
  188655
  324568
  327421
  379377
  382812
  383734
  383735
  384038
  384092
  384433
  384492
  385448
  385590
  386023
  386050
  386323
  386605
  387143
  388027
  388771
  390305
  390754
  390804
  392739
  396922
  405727
  406330
  407566
  408988
  420135
  428450
  444218
  456862
  457097
  457980
  458327
  458844
  465076
  465235
  475450
  478454
  481941
  497235
  498620
  499485
  511038
  512683
  512955
  516430
  530348
  535434
  537932
  540788
  547871
  549319
  550617
  550618
  550776
  551028
  551949
  551969
  552017
  552028
  552053
  552897
  552913
  552933
  554343
  556398
  556409
  556662
  557815
  559873
  559897
  560216
  565990
  565998
  571813
  574642
  581972
  583298
  583667
  583934
  590966
  591849
  596422
  600631
  601081
  605848
  605919
  618483
  619487
  622266
  622650
  623515
  623608
  623610
  627728
  639310
  662069
  712154
  717298
  727334
  737105
  747958
  758601
  770665
  776554
  785005
  802533
  808775
  809163
  813507
  817757
  828085
  828866
]
2.18 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf asian"
]
2.04 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf азиатк"
]
1.68 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf азиатк"
]

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.