Query Metrics
8
Database Queries
8
Different statements
396.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.50 ms (53.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск черноволосая анал"
]
|
||||||||||||||||||||||||||||||
|
159.11 ms (40.14%) |
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 233426 270601 358592 373768 373875 373897 387015 389197 389765 390217 391042 391595 391908 391911 391920 392007 392015 396753 397390 397397 397874 397878 397921 402201 402206 409469 411322 411345 413690 414750 415221 417448 419818 422161 422190 423917 424406 429077 429889 434334 435535 435599 439784 439822 440217 441577 443977 443986 444361 448376 451463 451498 455337 461998 462351 467872 468097 470169 475883 478362 489329 490173 490176 491952 494409 496734 496780 501652 501757 503016 504182 518264 521835 521905 538002 541251 543572 543823 554992 555023 555048 561880 570260 572297 573607 575212 576524 596578 597030 597502 597950 598501 600146 619070 652911 671252 677021 677344 683301 692040 721312 737453 742279 743331 745448 754180 757897 759759 761129 769749 783194 794886 794941 795702 799837 799911 816184 816639 827001 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (4.30%) |
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 575212 555048 597030 434334 423917 391920 448376 468097 496780 538002 541251 490176 496734 521905 501652 543823 598501 270601 402201 358592 387015 414750 424406 435535 554992 683301 392015 389765 389197 816184 827870 794886 794941 743331 402206 397874 397397 397921 769749 761129 491952 742279 391911 572297 392007 443986 467872 470169 475883 429889 435599 518264 490173 504182 455337 816639 827001 737453 757897 677021 597950 543572 391595 413690 478362 233426 415221 390217 429077 391908 440217 596578 411345 397878 396753 573607 597502 443977 373768 409469 417448 501757 494409 521835 419818 555023 439784 439822 462351 422190 444361 422161 373897 652911 671252 692040 677344 576524 600146 619070 795702 799911 745448 754180 783194 799837 759759 721312 373875 397390 441577 570260 391042 489329 561880 451498 461998 503016 451463 411322 ] |
||||||||||||||||||||||||||||||
|
3.18 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 233426 270601 358592 373768 373875 373897 387015 389197 389765 390217 391042 391595 391908 391911 391920 392007 392015 396753 397390 397397 397874 397878 397921 402201 402206 409469 411322 411345 413690 414750 415221 417448 419818 422161 422190 423917 424406 429077 429889 434334 435535 435599 439784 439822 440217 441577 443977 443986 444361 448376 451463 451498 455337 461998 462351 467872 468097 470169 475883 478362 489329 490173 490176 491952 494409 496734 496780 501652 501757 503016 504182 518264 521835 521905 538002 541251 543572 543823 554992 555023 555048 561880 570260 572297 573607 575212 576524 596578 597030 597502 597950 598501 600146 619070 652911 671252 677021 677344 683301 692040 721312 737453 742279 743331 745448 754180 757897 759759 761129 769749 783194 794886 794941 795702 799837 799911 816184 816639 827001 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.44%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01—ŒòeÚr×y?XLX\x02c"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian brunette anal"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.