GET https://search.jues.net/search/embeds/7?q=mother%20double

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
375.65 ms
(93.45%)
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
  95855
  182118
  183074
  184359
  191575
  312264
  322815
  341546
  385324
  386935
  387293
  388492
  388957
  390378
  393067
  398773
  408262
  414360
  421228
  425181
  440045
  442986
  443903
  446695
  451758
  454275
  457776
  460168
  469084
  474872
  486243
  489230
  512079
  514594
  520753
  522882
  526082
  530703
  531117
  531137
  534532
  534542
  534545
  534551
  536210
  538824
  544748
  563265
  566079
  571136
  571194
  600359
  603151
  613032
  622241
  629409
  630552
  631944
  633172
  634477
  639274
  645233
  645861
  648819
  651082
  658784
  662069
  670108
  670773
  671740
  671751
  672144
  674492
  684126
  689558
  690827
  696355
  697261
  703523
  707570
  708439
  712010
  715497
  717615
  719026
  720007
  720243
  721025
  721113
  724109
  728215
  728555
  746339
  770916
  772714
  775810
  775956
  789521
  789529
  790382
  803656
  804504
  805596
  806022
  807196
  814893
  815192
  815298
  815467
  816015
  816211
  816317
  816423
  816520
  816937
  818404
  818852
  820768
  821877
  827484
]
14.99 ms
(3.73%)
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
  827484
  815467
  486243
  534532
  538824
  522882
  544748
  563265
  658784
  690827
  721113
  697261
  707570
  662069
  674492
  703523
  717615
  571136
  600359
  613032
  629409
  724109
  772714
  803656
  807196
  728555
  728215
  489230
  530703
  531117
  520753
  514594
  566079
  645861
  622241
  630552
  312264
  457776
  571194
  720007
  789521
  182118
  388957
  386935
  446695
  408262
  818852
  818404
  689558
  95855
  385324
  322815
  388492
  387293
  390378
  421228
  425181
  414360
  469084
  474872
  451758
  442986
  454275
  191575
  341546
  183074
  393067
  440045
  184359
  443903
  398773
  815298
  816423
  816520
  821877
  814893
  816015
  816317
  816937
  815192
  816211
  820768
  460168
  534545
  536210
  531137
  534551
  512079
  534542
  526082
  651082
  670773
  672144
  712010
  715497
  719026
  645233
  670108
  696355
  721025
  648819
  671740
  671751
  684126
  708439
  720243
  631944
  634477
  639274
  603151
  633172
  775810
  804504
  805596
  806022
  775956
  746339
  770916
  789529
  790382
]
4.05 ms
(1.01%)
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
  95855
  182118
  183074
  184359
  191575
  312264
  322815
  341546
  385324
  386935
  387293
  388492
  388957
  390378
  393067
  398773
  408262
  414360
  421228
  425181
  440045
  442986
  443903
  446695
  451758
  454275
  457776
  460168
  469084
  474872
  486243
  489230
  512079
  514594
  520753
  522882
  526082
  530703
  531117
  531137
  534532
  534542
  534545
  534551
  536210
  538824
  544748
  563265
  566079
  571136
  571194
  600359
  603151
  613032
  622241
  629409
  630552
  631944
  633172
  634477
  639274
  645233
  645861
  648819
  651082
  658784
  662069
  670108
  670773
  671740
  671751
  672144
  674492
  684126
  689558
  690827
  696355
  697261
  703523
  707570
  708439
  712010
  715497
  717615
  719026
  720007
  720243
  721025
  721113
  724109
  728215
  728555
  746339
  770916
  772714
  775810
  775956
  789521
  789529
  790382
  803656
  804504
  805596
  806022
  807196
  814893
  815192
  815298
  815467
  816015
  816211
  816317
  816423
  816520
  816937
  818404
  818852
  820768
  821877
  827484
]
2.19 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother double"
]
1.82 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин double"
]
1.55 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.