GET https://search.jues.net/search/embeds/3?q=fuck%20to%20mouth

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.11 ms
(83.06%)
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
  615
  387320
  391874
  391938
  402434
  417263
  424116
  426665
  427064
  427092
  427971
  432466
  436461
  443468
  446662
  450657
  453772
  455470
  456055
  456512
  456678
  458983
  460619
  461180
  461728
  461784
  462616
  463352
  463725
  464808
  473608
  475503
  477453
  477794
  478319
  479200
  480822
  481178
  483825
  483971
  484023
  487868
  488827
  496475
  496627
  496881
  497858
  502586
  502596
  505525
  506110
  506187
  508345
  508419
  515499
  516865
  517316
  517986
  520325
  520450
  523113
  524532
  525027
  526158
  527513
  528013
  528653
  531935
  534620
  540805
  547815
  551171
  554219
  554514
  559236
  562141
  562421
  565378
  570995
  571106
  575236
  578240
  586658
  587963
  590363
  593151
  593810
  594644
  595978
  597929
  608273
  611299
  623422
  623436
  624756
  628681
  632611
  637141
  647140
  664468
  675081
  675093
  675679
  695828
  711565
  712540
  718864
  719299
  727499
  731303
  735687
  739038
  749374
  749693
  751120
  766866
  774245
  776678
  786525
  810783
]
16.54 ms
(10.72%)
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
  443468
  615
  481178
  483825
  461180
  456512
  391938
  766866
  718864
  774245
  786525
  562141
  608273
  475503
  695828
  597929
  587963
  593151
  810783
  391874
  402434
  462616
  534620
  565378
  647140
  593810
  497858
  517316
  456055
  479200
  571106
  675679
  749374
  735687
  417263
  496627
  461728
  477794
  480822
  508345
  562421
  751120
  506110
  453772
  463352
  578240
  719299
  664468
  731303
  456678
  551171
  554514
  776678
  739038
  463725
  525027
  464808
  554219
  712540
  623422
  427064
  426665
  427092
  477453
  517986
  520450
  528013
  483971
  711565
  727499
  496881
  526158
  505525
  516865
  528653
  675093
  484023
  515499
  488827
  520325
  628681
  586658
  624756
  478319
  502596
  496475
  570995
  590363
  611299
  455470
  502586
  446662
  461784
  450657
  427971
  540805
  531935
  559236
  594644
  595978
  506187
  524532
  487868
  527513
  523113
  508419
  547815
  432466
  749693
  632611
  387320
  675081
  623436
  424116
  473608
  575236
  637141
  436461
  458983
  460619
]
2.57 ms
(1.67%)
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
  615
  387320
  391874
  391938
  402434
  417263
  424116
  426665
  427064
  427092
  427971
  432466
  436461
  443468
  446662
  450657
  453772
  455470
  456055
  456512
  456678
  458983
  460619
  461180
  461728
  461784
  462616
  463352
  463725
  464808
  473608
  475503
  477453
  477794
  478319
  479200
  480822
  481178
  483825
  483971
  484023
  487868
  488827
  496475
  496627
  496881
  497858
  502586
  502596
  505525
  506110
  506187
  508345
  508419
  515499
  516865
  517316
  517986
  520325
  520450
  523113
  524532
  525027
  526158
  527513
  528013
  528653
  531935
  534620
  540805
  547815
  551171
  554219
  554514
  559236
  562141
  562421
  565378
  570995
  571106
  575236
  578240
  586658
  587963
  590363
  593151
  593810
  594644
  595978
  597929
  608273
  611299
  623422
  623436
  624756
  628681
  632611
  637141
  647140
  664468
  675081
  675093
  675679
  695828
  711565
  712540
  718864
  719299
  727499
  731303
  735687
  739038
  749374
  749693
  751120
  766866
  774245
  776678
  786525
  810783
]
1.78 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс mouth"
]
1.77 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс mouth"
]
1.74 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck to mouth"
]

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.