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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.59 ms
(60.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step большие mom"
]
116.59 ms
(32.95%)
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
  398831
  403900
  409258
  409682
  417339
  420767
  427536
  437835
  438219
  442783
  451086
  463625
  479019
  481794
  489102
  512531
  515031
  517278
  525354
  525557
  531935
  532110
  532114
  532133
  532135
  533469
  534221
  536333
  538329
  539739
  554522
  563452
  565631
  567855
  571267
  571976
  573749
  573990
  579284
  580283
  586512
  591155
  591281
  596011
  613319
  616049
  617677
  619775
  644030
  646525
  664660
  667593
  667660
  680833
  693256
  695760
  702904
  706266
  710549
  710578
  712707
  713262
  714216
  714344
  715270
  715416
  715475
  715536
  716262
  717003
  718499
  718835
  725350
  725402
  725635
  725639
  726371
  726620
  726627
  728150
  731464
  736776
  738009
  740457
  742086
  744194
  744201
  756920
  759826
  760549
  760733
  767672
  771737
  772322
  775129
  775771
  779264
  788161
  790017
  790596
  791965
  793171
  794272
  795368
  795742
  796578
  799230
  802595
  803762
  805700
  807366
  807409
  807499
  808552
  818802
  820335
  820384
  821628
  824563
  826160
]
14.86 ms
(4.20%)
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
  706266
  596011
  617677
  775129
  795368
  791965
  794272
  807409
  760733
  790596
  799230
  802595
  759826
  767672
  738009
  795742
  398831
  565631
  571976
  571267
  586512
  613319
  715270
  796578
  715475
  715536
  437835
  818802
  533469
  532110
  532133
  525354
  667660
  714216
  736776
  726620
  728150
  772322
  644030
  579284
  427536
  479019
  463625
  567855
  409682
  826160
  824563
  489102
  525557
  646525
  702904
  715416
  716262
  693256
  710578
  712707
  554522
  807366
  725350
  744201
  756920
  788161
  808552
  779264
  790017
  532114
  531935
  573749
  619775
  403900
  438219
  451086
  517278
  820335
  664660
  820384
  580283
  667593
  680833
  714344
  717003
  718499
  563452
  775771
  771737
  726371
  740457
  725639
  725635
  710549
  420767
  539739
  481794
  573990
  616049
  591155
  731464
  713262
  417339
  442783
  409258
  515031
  725402
  821628
  538329
  536333
  512531
  532135
  534221
  695760
  591281
  803762
  807499
  742086
  744194
  793171
  805700
  726627
  760549
  718835
]
2.83 ms
(0.80%)
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
  398831
  403900
  409258
  409682
  417339
  420767
  427536
  437835
  438219
  442783
  451086
  463625
  479019
  481794
  489102
  512531
  515031
  517278
  525354
  525557
  531935
  532110
  532114
  532133
  532135
  533469
  534221
  536333
  538329
  539739
  554522
  563452
  565631
  567855
  571267
  571976
  573749
  573990
  579284
  580283
  586512
  591155
  591281
  596011
  613319
  616049
  617677
  619775
  644030
  646525
  664660
  667593
  667660
  680833
  693256
  695760
  702904
  706266
  710549
  710578
  712707
  713262
  714216
  714344
  715270
  715416
  715475
  715536
  716262
  717003
  718499
  718835
  725350
  725402
  725635
  725639
  726371
  726620
  726627
  728150
  731464
  736776
  738009
  740457
  742086
  744194
  744201
  756920
  759826
  760549
  760733
  767672
  771737
  772322
  775129
  775771
  779264
  788161
  790017
  790596
  791965
  793171
  794272
  795368
  795742
  796578
  799230
  802595
  803762
  805700
  807366
  807409
  807499
  808552
  818802
  820335
  820384
  821628
  824563
  826160
]
2.27 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step big mom"
]
2.01 ms
(0.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step большие 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.