Query Metrics
7
Database Queries
7
Different statements
243.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.53 ms (89.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 402190 424370 426553 429266 444330 451225 451386 452722 459061 460317 462271 463496 464800 465267 466448 467671 467994 469236 470122 475622 479311 480718 484371 488745 495049 498196 499444 500332 500874 501491 502470 503124 503464 505548 509108 510224 511143 512753 518880 521011 523022 524003 525297 527116 527193 527456 531162 539861 540846 545219 552811 552814 556645 558592 560968 561427 564459 565051 566395 573936 575082 576357 577674 580282 581961 583091 588517 591898 595365 597591 599409 603897 605649 608215 611037 617672 619573 625181 626437 626902 627818 628630 633978 641806 647129 653503 671396 673092 677878 682916 682963 690066 692817 700299 704215 706411 706721 708799 710275 714188 718044 720281 720985 721249 728652 733896 739489 741855 744863 750469 753073 756495 756990 767116 779193 785148 810059 811125 812325 821849 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (6.03%) |
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 576357 577674 564459 566395 545219 573936 581961 677878 692817 700299 706721 720985 721249 671396 673092 706411 718044 720281 647129 682963 690066 704215 708799 710275 714188 561427 580282 599409 611037 595365 619573 591898 597591 627818 605649 608215 617672 626902 628630 641806 785148 810059 753073 812325 728652 744863 750469 756495 767116 739489 741855 756990 603897 633978 779193 402190 466448 500332 518880 426553 429266 424370 444330 821849 511143 527456 460317 462271 558592 682916 588517 811125 733896 475622 523022 512753 484371 488745 498196 499444 502470 505548 556645 575082 560968 503124 524003 540846 467671 469236 459061 463496 465267 470122 479311 480718 451225 451386 452722 495049 510224 500874 509108 501491 503464 521011 525297 527116 527193 531162 539861 464800 467994 552811 653503 552814 565051 583091 626437 625181 ] |
||||||||||||||||||||||||||||||
|
4.03 ms (1.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
2.51 ms (1.03%) |
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 402190 424370 426553 429266 444330 451225 451386 452722 459061 460317 462271 463496 464800 465267 466448 467671 467994 469236 470122 475622 479311 480718 484371 488745 495049 498196 499444 500332 500874 501491 502470 503124 503464 505548 509108 510224 511143 512753 518880 521011 523022 524003 525297 527116 527193 527456 531162 539861 540846 545219 552811 552814 556645 558592 560968 561427 564459 565051 566395 573936 575082 576357 577674 580282 581961 583091 588517 591898 595365 597591 599409 603897 605649 608215 611037 617672 619573 625181 626437 626902 627818 628630 633978 641806 647129 653503 671396 673092 677878 682916 682963 690066 692817 700299 704215 706411 706721 708799 710275 714188 718044 720281 720985 721249 728652 733896 739489 741855 744863 750469 753073 756495 756990 767116 779193 785148 810059 811125 812325 821849 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.