GET https://search.jues.net/search/embeds/6?q=big%20tits%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
364.17 ms
(92.69%)
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
  7240
  53698
  80505
  91254
  153249
  197300
  250226
  334299
  367962
  382946
  383290
  383791
  385105
  386893
  387046
  388232
  388578
  389406
  391518
  393298
  396349
  396413
  396804
  397457
  410015
  417847
  419058
  425648
  425997
  426515
  439749
  441452
  443189
  444144
  444177
  444810
  446865
  447970
  447981
  448095
  448670
  453738
  454957
  455123
  457441
  457821
  459602
  459959
  460433
  460572
  466092
  467824
  472409
  473341
  474559
  476613
  478406
  479030
  480852
  481262
  481401
  485400
  486334
  487045
  487307
  489382
  489942
  493470
  495244
  501701
  502194
  504785
  506207
  506329
  506860
  508741
  511478
  513772
  514020
  518152
  528254
  543296
  546466
  546527
  554466
  564054
  564467
  591741
  592198
  596958
  599674
  603043
  631684
  639921
  640349
  662387
  668768
  682399
  683078
  684706
  700010
  705073
  711599
  717517
  718882
  732986
  733480
  737318
  738836
  742636
  742642
  748063
  769474
  779419
  784641
  794850
  797585
  812055
  818841
  824370
]
18.82 ms
(4.79%)
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
  393298
  389406
  457821
  508741
  506207
  441452
  455123
  495244
  518152
  460572
  478406
  481401
  474559
  528254
  385105
  546527
  682399
  732986
  738836
  91254
  334299
  7240
  386893
  683078
  700010
  639921
  784641
  737318
  388578
  396804
  419058
  397457
  426515
  453738
  596958
  742636
  457441
  506860
  489382
  493470
  383290
  486334
  487045
  631684
  501701
  153249
  448670
  487307
  460433
  459959
  459602
  444144
  511478
  818841
  546466
  748063
  514020
  425648
  444177
  824370
  481262
  543296
  592198
  640349
  599674
  812055
  794850
  742642
  769474
  779419
  417847
  391518
  447981
  564054
  383791
  80505
  425997
  733480
  448095
  367962
  396349
  504785
  443189
  489942
  684706
  717517
  705073
  711599
  591741
  603043
  797585
  382946
  388232
  479030
  410015
  662387
  473341
  446865
  485400
  502194
  564467
  554466
  467824
  476613
  466092
  472409
  480852
  506329
  250226
  439749
  513772
  668768
  197300
  53698
  447970
  718882
  454957
  444810
  396413
  387046
]
2.65 ms
(0.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
  7240
  53698
  80505
  91254
  153249
  197300
  250226
  334299
  367962
  382946
  383290
  383791
  385105
  386893
  387046
  388232
  388578
  389406
  391518
  393298
  396349
  396413
  396804
  397457
  410015
  417847
  419058
  425648
  425997
  426515
  439749
  441452
  443189
  444144
  444177
  444810
  446865
  447970
  447981
  448095
  448670
  453738
  454957
  455123
  457441
  457821
  459602
  459959
  460433
  460572
  466092
  467824
  472409
  473341
  474559
  476613
  478406
  479030
  480852
  481262
  481401
  485400
  486334
  487045
  487307
  489382
  489942
  493470
  495244
  501701
  502194
  504785
  506207
  506329
  506860
  508741
  511478
  513772
  514020
  518152
  528254
  543296
  546466
  546527
  554466
  564054
  564467
  591741
  592198
  596958
  599674
  603043
  631684
  639921
  640349
  662387
  668768
  682399
  683078
  684706
  700010
  705073
  711599
  717517
  718882
  732986
  733480
  737318
  738836
  742636
  742642
  748063
  769474
  779419
  784641
  794850
  797585
  812055
  818841
  824370
]
2.19 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits doggy"
]
1.97 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ рак"
]
1.38 ms
(0.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ рак"
]

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.