GET https://search.jues.net/search/embeds/6?q=big%20tits%20pantyhose

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.06 ms
(90.88%)
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
  83932
  187252
  202970
  329508
  334941
  365901
  384133
  384460
  385015
  385216
  387806
  388024
  389918
  390846
  408518
  418545
  422230
  429863
  451521
  455005
  470948
  480392
  491242
  513091
  515866
  517204
  525268
  527514
  529826
  531945
  540102
  548313
  550172
  560209
  564797
  565644
  567734
  583937
  589578
  606066
  606242
  606411
  618237
  619626
  626576
  629334
  629528
  629599
  631637
  635369
  637458
  638168
  642281
  646858
  668182
  671920
  695403
  702470
  704542
  713012
  713658
  714169
  714394
  715443
  721746
  734073
  743786
  744325
  746447
  751521
  753078
  755989
  758283
  770259
  772878
  775649
  780624
  781828
  781911
  789985
  790740
  794219
  794750
  796549
  798951
  800478
  800904
  801600
  805949
  807088
  807417
  808071
  808476
  808494
  808635
  809183
  811107
  811109
  815243
  816925
  817170
  817355
  817562
  817579
  818240
  818304
  818955
  821994
  822427
  822979
  823955
  824017
  825186
  826304
  828052
  828389
  828479
  828659
  828679
]
11.72 ms
(4.91%)
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
  513091
  525268
  808494
  408518
  540102
  564797
  187252
  480392
  770259
  387806
  775649
  567734
  619626
  618237
  629334
  751521
  824017
  828389
  828052
  637458
  811107
  808635
  515866
  714169
  385015
  548313
  642281
  606242
  781828
  704542
  790740
  418545
  385216
  334941
  626576
  470948
  817562
  817355
  801600
  202970
  818955
  583937
  794750
  796549
  817170
  828659
  491242
  629599
  365901
  389918
  695403
  384133
  646858
  451521
  429863
  550172
  743786
  758283
  798951
  780624
  83932
  816925
  635369
  329508
  384460
  390846
  455005
  826304
  713658
  638168
  825186
  828702
  828679
  631637
  794219
  527514
  529826
  565644
  715443
  671920
  808071
  808476
  809183
  772878
  800904
  714394
  817579
  721746
  789985
  517204
  746447
  560209
  422230
  821994
  807088
  822427
  818304
  822979
  668182
  713012
  753078
  744325
  734073
  805949
  388024
  800478
  629528
  807417
  811109
  531945
  702470
  828479
  589578
  755989
  815243
  818240
  823955
  606411
  606066
  781911
]
2.86 ms
(1.20%)
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
  83932
  187252
  202970
  329508
  334941
  365901
  384133
  384460
  385015
  385216
  387806
  388024
  389918
  390846
  408518
  418545
  422230
  429863
  451521
  455005
  470948
  480392
  491242
  513091
  515866
  517204
  525268
  527514
  529826
  531945
  540102
  548313
  550172
  560209
  564797
  565644
  567734
  583937
  589578
  606066
  606242
  606411
  618237
  619626
  626576
  629334
  629528
  629599
  631637
  635369
  637458
  638168
  642281
  646858
  668182
  671920
  695403
  702470
  704542
  713012
  713658
  714169
  714394
  715443
  721746
  734073
  743786
  744325
  746447
  751521
  753078
  755989
  758283
  770259
  772878
  775649
  780624
  781828
  781911
  789985
  790740
  794219
  794750
  796549
  798951
  800478
  800904
  801600
  805949
  807088
  807417
  808071
  808476
  808494
  808635
  809183
  811107
  811109
  815243
  816925
  817170
  817355
  817562
  817579
  818240
  818304
  818955
  821994
  822427
  822979
  823955
  824017
  825186
  826304
  828052
  828389
  828479
  828659
  828679
]
2.07 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits pantyhose"
]
2.05 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ pantyhose"
]
1.39 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ pantyhose"
]

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.