GET https://search.jues.net/search/embeds/3?q=big%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
189.27 ms
(84.75%)
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
  263868
  390931
  395530
  395699
  396862
  398178
  401014
  401621
  407288
  407346
  407664
  411867
  412620
  413097
  413111
  413112
  414302
  417008
  420407
  421132
  424191
  424850
  425691
  429306
  430245
  433070
  438199
  438208
  445914
  446277
  447937
  449243
  450801
  450813
  451880
  453540
  454043
  454057
  459143
  464144
  464412
  469487
  469549
  471408
  490167
  490456
  492115
  502791
  511823
  519821
  519934
  519938
  520691
  520693
  525720
  527449
  552047
  556511
  556607
  556641
  556653
  556656
  586682
  589616
  591048
  608049
  609966
  610114
  624286
  624300
  625435
  639127
  662140
  673654
  684030
  715662
  717948
  724706
  725362
  726621
  726891
  740156
  742839
  746621
  753722
  758414
  758605
  765023
  770494
  771243
  772612
  775414
  777154
  777792
  779224
  780340
  782626
  786455
  787342
  789698
  790534
  793121
  793294
  793372
  796206
  799645
  801223
  801356
  802188
  802402
  805715
  806767
  807369
  807373
  807490
  807491
  807636
  817269
  818502
  819231
]
23.51 ms
(10.53%)
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
  787342
  263868
  395530
  425691
  430245
  817269
  447937
  552047
  673654
  793294
  806767
  609966
  414302
  511823
  818502
  819231
  802402
  758605
  413112
  556653
  556511
  556641
  662140
  717948
  624286
  624300
  591048
  625435
  589616
  586682
  789698
  801223
  801356
  807491
  742839
  726621
  753722
  608049
  779224
  807373
  469549
  411867
  454057
  407664
  429306
  424191
  502791
  450801
  450813
  786455
  610114
  807490
  771243
  793121
  724706
  725362
  726891
  639127
  790534
  424850
  556656
  777154
  793372
  758414
  746621
  777792
  412620
  454043
  519938
  556607
  459143
  398178
  407346
  420407
  438199
  445914
  492115
  520691
  490456
  527449
  413097
  464144
  449243
  519821
  715662
  684030
  775414
  782626
  772612
  390931
  401621
  407288
  413111
  453540
  469487
  471408
  421132
  464412
  451880
  433070
  438208
  490167
  519934
  520693
  395699
  446277
  525720
  802188
  807369
  770494
  796206
  805715
  807636
  740156
  765023
  780340
  799645
  417008
  396862
  401014
]
3.68 ms
(1.65%)
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
  263868
  390931
  395530
  395699
  396862
  398178
  401014
  401621
  407288
  407346
  407664
  411867
  412620
  413097
  413111
  413112
  414302
  417008
  420407
  421132
  424191
  424850
  425691
  429306
  430245
  433070
  438199
  438208
  445914
  446277
  447937
  449243
  450801
  450813
  451880
  453540
  454043
  454057
  459143
  464144
  464412
  469487
  469549
  471408
  490167
  490456
  492115
  502791
  511823
  519821
  519934
  519938
  520691
  520693
  525720
  527449
  552047
  556511
  556607
  556641
  556653
  556656
  586682
  589616
  591048
  608049
  609966
  610114
  624286
  624300
  625435
  639127
  662140
  673654
  684030
  715662
  717948
  724706
  725362
  726621
  726891
  740156
  742839
  746621
  753722
  758414
  758605
  765023
  770494
  771243
  772612
  775414
  777154
  777792
  779224
  780340
  782626
  786455
  787342
  789698
  790534
  793121
  793294
  793372
  796206
  799645
  801223
  801356
  802188
  802402
  805715
  806767
  807369
  807373
  807490
  807491
  807636
  817269
  818502
  819231
]
2.19 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big mom"
]
1.57 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие mom"
]
1.49 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие mom"
]

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.