GET https://search.jues.net/search/embeds/9?q=natural%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.84 ms
(84.95%)
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
  13954
  24218
  97570
  109233
  155175
  203788
  206386
  212864
  223010
  383582
  385086
  385245
  386877
  389142
  391580
  391954
  395166
  399659
  400892
  402551
  412582
  415805
  422144
  425509
  440490
  441799
  446728
  447251
  450549
  453714
  467966
  469107
  469227
  469590
  475293
  475681
  476968
  477619
  486588
  491859
  495040
  498061
  505344
  515372
  516487
  524489
  525768
  526219
  531321
  532078
  537296
  538917
  547094
  549894
  553165
  556569
  558107
  558431
  565199
  570815
  571350
  571792
  574711
  575897
  579608
  581680
  582768
  584649
  588411
  591489
  595508
  598371
  607976
  618660
  620400
  623955
  630176
  647133
  651039
  668603
  709894
  712703
  713425
  714399
  721411
  726795
  734174
  736432
  740955
  745366
  747530
  750374
  753738
  756864
  768841
  776514
  781935
  805698
  811865
  815358
  817041
  817170
  818315
  822590
  824702
  825249
  826436
  828259
  828441
  828489
  828493
  828530
  828598
  828659
  828708
  828711
  828750
  828821
  828859
]
13.49 ms
(8.14%)
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
  817041
  824187
  828821
  828530
  538917
  549894
  668603
  721411
  584649
  537296
  575897
  547094
  574711
  556569
  558107
  565199
  714399
  598371
  620400
  623955
  591489
  595508
  811865
  736432
  747530
  745366
  740955
  756864
  618660
  781935
  570815
  768841
  425509
  491859
  525768
  588411
  647133
  750374
  109233
  399659
  400892
  422144
  440490
  415805
  441799
  467966
  469227
  469590
  475293
  446728
  447251
  450549
  505344
  526219
  475681
  476968
  571350
  579608
  553165
  651039
  558431
  571792
  391954
  453714
  477619
  395166
  469107
  516487
  498061
  486588
  495040
  515372
  212864
  817170
  824702
  826436
  818315
  828859
  828750
  828259
  828489
  828711
  828659
  828493
  828598
  828708
  531321
  532078
  581680
  712703
  713425
  582768
  630176
  776514
  822590
  815358
  825249
  828441
  726795
  607976
  97570
  24218
  402551
  524489
  709894
  805698
  734174
  753738
  203788
  412582
  223010
  383582
  385245
  385086
  206386
  155175
  391580
  13954
  389142
  386877
]
4.51 ms
(2.72%)
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
  13954
  24218
  97570
  109233
  155175
  203788
  206386
  212864
  223010
  383582
  385086
  385245
  386877
  389142
  391580
  391954
  395166
  399659
  400892
  402551
  412582
  415805
  422144
  425509
  440490
  441799
  446728
  447251
  450549
  453714
  467966
  469107
  469227
  469590
  475293
  475681
  476968
  477619
  486588
  491859
  495040
  498061
  505344
  515372
  516487
  524489
  525768
  526219
  531321
  532078
  537296
  538917
  547094
  549894
  553165
  556569
  558107
  558431
  565199
  570815
  571350
  571792
  574711
  575897
  579608
  581680
  582768
  584649
  588411
  591489
  595508
  598371
  607976
  618660
  620400
  623955
  630176
  647133
  651039
  668603
  709894
  712703
  713425
  714399
  721411
  726795
  734174
  736432
  740955
  745366
  747530
  750374
  753738
  756864
  768841
  776514
  781935
  805698
  811865
  815358
  817041
  817170
  818315
  822590
  824702
  825249
  826436
  828259
  828441
  828489
  828493
  828530
  828598
  828659
  828708
  828711
  828750
  828821
  828859
]
1.90 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural milf"
]
1.75 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные milf"
]
1.71 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.95%)
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.