GET https://search.jues.net/search/embeds/5?q=domina%20facesitting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.98 ms
(37.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "доминирован фейсситтинг"
]
207.52 ms
(35.94%)
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
  392981
  397793
  418928
  418959
  421326
  422908
  425477
  429810
  430416
  431133
  431442
  440581
  442173
  442238
  442276
  443150
  445390
  448036
  448046
  449261
  449320
  450814
  450939
  453858
  454241
  457149
  457515
  460969
  463783
  464209
  464623
  465933
  468765
  468827
  470222
  470424
  470443
  474617
  475824
  478829
  481173
  482245
  482360
  482584
  483309
  484461
  486004
  486619
  486694
  487087
  489656
  490492
  490896
  490927
  494171
  495144
  496611
  496613
  497332
  500526
  501426
  503121
  503488
  503619
  503655
  504139
  507943
  511162
  514149
  514746
  515378
  515415
  516003
  516683
  516750
  516761
  516770
  516979
  517129
  517196
  517650
  517723
  519546
  520151
  521201
  521227
  521741
  522086
  523169
  524873
  525180
  525396
  528356
  530532
  530734
  531251
  532799
  533186
  536637
  537122
  538608
  542059
  545544
  547815
  550960
  554461
  559228
  560198
  565149
  595769
  600382
  603243
  610668
  630870
  639748
  643013
  647877
  700284
  714119
  720387
]
126.55 ms
(21.92%)
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
  392981
  397793
  418928
  418959
  421326
  422908
  425477
  429810
  430416
  431133
  431442
  440581
  442173
  442238
  442276
  443150
  445390
  448036
  448046
  449261
  449320
  450814
  450939
  453858
  454241
  457149
  457515
  460969
  463783
  464209
  464623
  465933
  468765
  468827
  470222
  470424
  470443
  474617
  475824
  478829
  481173
  482245
  482360
  482584
  483309
  484461
  486004
  486619
  486694
  487087
  489656
  490492
  490896
  490927
  494171
  495144
  496611
  496613
  497332
  500526
  501426
  503121
  503488
  503619
  503655
  504139
  507943
  511162
  514149
  514746
  515378
  515415
  516003
  516683
  516750
  516761
  516770
  516979
  517129
  517196
  517650
  517723
  519546
  520151
  521201
  521227
  521741
  522086
  523169
  524873
  525180
  525396
  528356
  530532
  530734
  531251
  532799
  533186
  536637
  537122
  538608
  542059
  545544
  547815
  550960
  554461
  559228
  560198
  565149
  595769
  600382
  603243
  610668
  630870
  639748
  643013
  647877
  700284
  714119
  720387
]
21.04 ms
(3.64%)
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
  517129
  516003
  519546
  515415
  610668
  442276
  442238
  450939
  496613
  521227
  457515
  478829
  397793
  470443
  483309
  517723
  523169
  511162
  515378
  643013
  448036
  503619
  392981
  425477
  449261
  486619
  496611
  500526
  530734
  503655
  507943
  537122
  495144
  516761
  530532
  516979
  525180
  525396
  533186
  538608
  475824
  482360
  554461
  559228
  545544
  547815
  630870
  603243
  700284
  468827
  464209
  421326
  443150
  445390
  450814
  454241
  468765
  528356
  490492
  503488
  521201
  522086
  486004
  490927
  521741
  430416
  470424
  431442
  489656
  503121
  464623
  524873
  647877
  418928
  442173
  418959
  422908
  482584
  453858
  482245
  474617
  494171
  517196
  532799
  517650
  516750
  520151
  536637
  486694
  560198
  542059
  565149
  714119
  720387
  600382
  595769
  465933
  463783
  470222
  429810
  448046
  431133
  449320
  460969
  481173
  516683
  516770
  497332
  514149
  514746
  484461
  487087
  501426
  490896
  504139
  457149
  440581
  550960
  639748
  531251
]
2.54 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "domina facesitting"
]
1.94 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "доминирован фейсситтинг"
]
1.84 ms
(0.32%)
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.