Query Metrics
7
Database Queries
7
Different statements
368.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.59 ms (56.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"голые порно"
]
|
||||||||||||||||||||||||||||||
|
132.03 ms (35.85%) |
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 34087 43029 43207 53780 56601 68084 69782 126104 133698 157046 226412 230935 230974 248084 250587 268633 274100 339474 381997 382665 383276 385781 387374 387415 388857 389314 391266 391449 391774 397663 401638 401802 403501 404052 404404 408812 414736 415464 419346 419893 426639 429494 429590 432467 447733 448393 449225 452934 457596 458604 459304 459876 461621 463189 467863 469190 474159 479744 496130 504014 507396 515504 531036 534714 534939 534951 541975 544451 547559 549329 549420 550523 550987 552552 553511 554024 560860 563085 568217 568297 570931 571355 572561 573173 573441 574183 574338 582014 608711 609761 632085 648489 650254 673312 673499 679412 701706 718412 787825 803702 804358 805981 809954 812060 814305 817815 818690 818993 819026 819028 820990 821489 821587 823997 824000 824103 824468 824684 824990 827699 ] |
||||||||||||||||||||||||||||||
|
22.61 ms (6.14%) |
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 608711 609761 632085 701706 718412 787825 803702 804358 805981 809954 812060 43029 53780 401802 248084 387415 463189 69782 387374 389314 391449 459876 467863 43207 56601 133698 381997 382665 414736 419893 429590 571355 549420 385781 68084 383276 226412 250587 230935 157046 126104 230974 391774 268633 274100 339474 34087 388857 391266 397663 401638 404052 404404 403501 429494 419346 426639 432467 408812 415464 818993 821587 823997 824103 819026 819028 820990 824684 814305 817815 818690 821489 824000 824468 824990 827699 447733 449225 459304 479744 448393 452934 457596 458604 461621 469190 474159 534939 507396 496130 504014 531036 534951 515504 534714 568217 568297 573173 573441 582014 541975 547559 549329 552552 554024 560860 572561 544451 550523 550987 553511 563085 570931 574183 574338 648489 650254 673312 673499 679412 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (0.68%) |
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 34087 43029 43207 53780 56601 68084 69782 126104 133698 157046 226412 230935 230974 248084 250587 268633 274100 339474 381997 382665 383276 385781 387374 387415 388857 389314 391266 391449 391774 397663 401638 401802 403501 404052 404404 408812 414736 415464 419346 419893 426639 429494 429590 432467 447733 448393 449225 452934 457596 458604 459304 459876 461621 463189 467863 469190 474159 479744 496130 504014 507396 515504 531036 534714 534939 534951 541975 544451 547559 549329 549420 550523 550987 552552 553511 554024 560860 563085 568217 568297 570931 571355 572561 573173 573441 574183 574338 582014 608711 609761 632085 648489 650254 673312 673499 679412 701706 718412 787825 803702 804358 805981 809954 812060 814305 817815 818690 818993 819026 819028 820990 821489 821587 823997 824000 824103 824468 824684 824990 827699 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"голые порн"
]
|
||||||||||||||||||||||||||||||
|
1.28 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.