Query Metrics
7
Database Queries
7
Different statements
213.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.64 ms (88.26%) |
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 13370 143891 233143 233166 233298 233556 233686 326110 365839 366284 366478 382433 384181 386583 387868 388546 389517 391760 394498 397439 397902 400754 401952 412150 414647 420680 422135 424222 425748 426785 426870 426909 426925 426990 427764 428835 431608 433352 435016 440818 441593 443762 443837 443953 444237 450653 451988 453397 453667 455297 458750 460360 460581 461009 461983 461999 464553 464769 468077 470611 470670 471072 471576 471643 472020 473962 474190 476274 476500 476980 484181 485365 489371 490433 494401 495646 496054 496067 496882 497120 501068 505166 506065 506222 506241 506731 509084 509508 510670 512657 513618 517309 519539 522814 523022 523528 524707 526049 543736 555668 557524 563400 563454 566866 571391 571646 571936 571944 573813 575697 578840 578937 655663 696781 764097 767972 778206 778548 784697 804863 ] |
||||||||||||||||||||||||||||||
|
15.16 ms (7.10%) |
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 428835 461999 143891 394498 233166 426870 426909 233298 400754 431608 470670 573813 13370 386583 458750 512657 578937 804863 366284 382433 233556 387868 388546 422135 426925 555668 444237 426785 443837 472020 460581 543736 566866 563454 764097 453667 326110 412150 451988 461009 365839 453397 476500 433352 489371 495646 485365 496054 509508 571391 384181 233143 490433 506065 443953 470611 424222 557524 571646 476980 474190 460360 522814 501068 510670 391760 473962 471576 696781 778548 767972 778206 784697 233686 366478 389517 471072 571936 563400 420680 443762 397439 464769 578840 655663 513618 506241 524707 455297 509084 496067 476274 575697 571944 397902 401952 435016 450653 425748 427764 440818 414647 468077 506731 523022 484181 494401 496882 505166 526049 523528 506222 519539 497120 426990 441593 471643 517309 461983 464553 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.45%) |
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 13370 143891 233143 233166 233298 233556 233686 326110 365839 366284 366478 382433 384181 386583 387868 388546 389517 391760 394498 397439 397902 400754 401952 412150 414647 420680 422135 424222 425748 426785 426870 426909 426925 426990 427764 428835 431608 433352 435016 440818 441593 443762 443837 443953 444237 450653 451988 453397 453667 455297 458750 460360 460581 461009 461983 461999 464553 464769 468077 470611 470670 471072 471576 471643 472020 473962 474190 476274 476500 476980 484181 485365 489371 490433 494401 495646 496054 496067 496882 497120 501068 505166 506065 506222 506241 506731 509084 509508 510670 512657 513618 517309 519539 522814 523022 523528 524707 526049 543736 555668 557524 563400 563454 566866 571391 571646 571936 571944 573813 575697 578840 578937 655663 696781 764097 767972 778206 778548 784697 804863 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"украинки в порно"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск в порн"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.68%) |
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.