Query Metrics
7
Database Queries
7
Different statements
175.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.39 ms (85.03%) |
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 202902 385683 395622 396352 400482 402262 417960 419073 419420 425667 435019 439615 443599 447077 447229 447333 454856 455031 455836 457138 457266 458076 462294 463753 467934 468600 470767 471500 473091 475100 475979 476485 479995 480419 480705 482867 485059 487129 491363 491475 492245 495035 496086 496451 499147 499444 503370 504271 508078 508934 509509 511217 514030 514407 518334 520489 521899 524012 524298 525685 529238 529432 535306 543361 545601 547729 552441 554743 558359 558742 560160 560737 562734 564651 565158 565551 567537 567821 567860 569675 572827 573451 574839 575140 578060 579215 579935 580141 585767 586403 588305 589360 593850 597830 598731 599567 621122 625729 634517 646219 654846 656407 663914 665926 670295 677364 679350 679376 702927 718160 720871 741929 761573 762234 767384 771971 790397 799714 803596 807469 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (9.23%) |
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 508078 503370 767384 574839 799714 496451 514407 807469 471500 665926 447333 524298 654846 508934 492245 803596 385683 400482 482867 468600 499147 598731 575140 504271 562734 552441 475979 567821 457266 656407 435019 521899 565158 455836 529432 761573 547729 463753 509509 580141 402262 455031 480419 480705 579215 479995 396352 670295 589360 741929 417960 578060 443599 599567 625729 573451 585767 525685 679350 558359 579935 511217 790397 720871 560160 564651 679376 495035 447229 593850 425667 473091 395622 572827 543361 491475 467934 677364 514030 202902 569675 646219 447077 496086 554743 454856 621122 597830 567860 458076 524012 419420 663914 762234 586403 634517 702927 535306 419073 491363 718160 457138 545601 567537 565551 520489 470767 560737 558742 476485 487129 588305 485059 499444 475100 439615 771971 518334 529238 462294 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (1.86%) |
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 202902 385683 395622 396352 400482 402262 417960 419073 419420 425667 435019 439615 443599 447077 447229 447333 454856 455031 455836 457138 457266 458076 462294 463753 467934 468600 470767 471500 473091 475100 475979 476485 479995 480419 480705 482867 485059 487129 491363 491475 492245 495035 496086 496451 499147 499444 503370 504271 508078 508934 509509 511217 514030 514407 518334 520489 521899 524012 524298 525685 529238 529432 535306 543361 545601 547729 552441 554743 558359 558742 560160 560737 562734 564651 565158 565551 567537 567821 567860 569675 572827 573451 574839 575140 578060 579215 579935 580141 585767 586403 588305 589360 593850 597830 598731 599567 621122 625729 634517 646219 654846 656407 663914 665926 670295 677364 679350 679376 702927 718160 720871 741929 761573 762234 767384 771971 790397 799714 803596 807469 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob pretty girl"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс pretty девушк"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс pretty девушк"
]
|
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.