GET https://search.jues.net/search/embeds/3?q=double%20licking

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.31 ms
(88.00%)
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
  12573
  44120
  96581
  105093
  185208
  210072
  382818
  389409
  396030
  400556
  404957
  409405
  410657
  414357
  415954
  420559
  421273
  426416
  427383
  427971
  446394
  454857
  458125
  461503
  461591
  468631
  471429
  473474
  473739
  476108
  477879
  486426
  500467
  507591
  508180
  512509
  513949
  516091
  516350
  522596
  522913
  530373
  530625
  533773
  534328
  539232
  541849
  543124
  543177
  546953
  553352
  558138
  565172
  566503
  572763
  598107
  599861
  599969
  600249
  601584
  603187
  608744
  617410
  623296
  626097
  630524
  631163
  637086
  637694
  639784
  640524
  641983
  641999
  642700
  645236
  646450
  646896
  653600
  665728
  678081
  685791
  689558
  695199
  699516
  706599
  707560
  709684
  717066
  717947
  720219
  720576
  721611
  721903
  730246
  731844
  732004
  738830
  740832
  748257
  748354
  748538
  767501
  769806
  770819
  770884
  775758
  775899
  787564
  796250
  796652
  805780
  807744
  811072
  813505
  814861
  814895
  815536
  815955
  820772
  823447
]
13.83 ms
(7.19%)
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
  813505
  732004
  738830
  641999
  382818
  210072
  473474
  400556
  814895
  653600
  730246
  717066
  96581
  410657
  414357
  446394
  471429
  476108
  512509
  500467
  522596
  530625
  558138
  566503
  541849
  646450
  685791
  599861
  601584
  639784
  641983
  598107
  617410
  631163
  421273
  461503
  404957
  468631
  420559
  461591
  516350
  507591
  522913
  513949
  458125
  454857
  534328
  665728
  678081
  695199
  699516
  721611
  706599
  603187
  608744
  623296
  775758
  787564
  769806
  796250
  807744
  770884
  748257
  748538
  748354
  637694
  640524
  811072
  105093
  185208
  823447
  546953
  543124
  720576
  796652
  731844
  626097
  396030
  426416
  486426
  530373
  508180
  533773
  539232
  473739
  572763
  645236
  565172
  599969
  630524
  637086
  600249
  415954
  516091
  553352
  646896
  477879
  44120
  409405
  815536
  815955
  543177
  720219
  707560
  721903
  689558
  717947
  805780
  775899
  740832
  767501
  770819
  709684
  12573
  389409
  642700
  427383
  427971
  820772
  814861
]
2.70 ms
(1.40%)
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
  12573
  44120
  96581
  105093
  185208
  210072
  382818
  389409
  396030
  400556
  404957
  409405
  410657
  414357
  415954
  420559
  421273
  426416
  427383
  427971
  446394
  454857
  458125
  461503
  461591
  468631
  471429
  473474
  473739
  476108
  477879
  486426
  500467
  507591
  508180
  512509
  513949
  516091
  516350
  522596
  522913
  530373
  530625
  533773
  534328
  539232
  541849
  543124
  543177
  546953
  553352
  558138
  565172
  566503
  572763
  598107
  599861
  599969
  600249
  601584
  603187
  608744
  617410
  623296
  626097
  630524
  631163
  637086
  637694
  639784
  640524
  641983
  641999
  642700
  645236
  646450
  646896
  653600
  665728
  678081
  685791
  689558
  695199
  699516
  706599
  707560
  709684
  717066
  717947
  720219
  720576
  721611
  721903
  730246
  731844
  732004
  738830
  740832
  748257
  748354
  748538
  767501
  769806
  770819
  770884
  775758
  775899
  787564
  796250
  796652
  805780
  807744
  811072
  813505
  814861
  814895
  815536
  815955
  820772
  823447
]
1.75 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double licking"
]
1.71 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double лиза"
]
1.46 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double лиза"
]

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.