Query Metrics
7
Database Queries
7
Different statements
211.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.10 ms (89.70%) |
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 396280 399439 399456 401378 402079 409088 415598 422352 437366 438208 441692 443183 445502 447574 447979 450399 455652 456061 457688 458231 460191 462994 463691 463703 464144 464200 464805 467663 471628 472295 473375 473673 479298 482251 483496 484764 486540 489250 492115 492366 492614 496537 505973 514813 518046 521997 522653 523475 525273 527197 529134 540073 544103 548489 558876 559679 561441 565050 568098 569394 577899 579227 581092 581893 582197 584666 584765 590735 592933 594108 596539 598178 599710 602707 604155 607697 609759 609827 613855 613922 616679 619103 621356 622308 630630 685068 687503 689002 696567 696888 698224 699604 709760 711341 713552 714062 716954 726390 726882 727147 727680 727891 730904 738525 743429 743431 743463 753205 755695 756797 757501 758564 761275 761986 771055 777096 790015 820337 ] |
||||||||||||||||||||||||||||||
|
13.11 ms (6.19%) |
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 592933 594108 622308 777096 730904 743429 727147 726390 738525 756797 619103 711341 527197 486540 761275 471628 399439 399456 402079 401378 437366 441692 443183 445502 463691 463703 464805 523475 464200 473375 484764 716936 727891 743431 761986 699604 396280 455652 479298 492614 565050 456061 472295 482251 415598 462994 522653 790015 457688 458231 581893 582197 685068 696567 579227 602707 613922 616679 727680 755695 771055 743463 757501 758564 697943 483496 525273 473673 460191 450399 489250 492115 518046 521997 561441 568098 609827 604155 464144 514813 540073 559679 607697 613855 596539 409088 438208 505973 529134 621356 422352 820337 447574 447979 467663 492366 584765 577899 687503 609759 630630 590735 753205 726882 496537 544103 558876 569394 584666 581092 709760 714062 689002 696888 713552 698224 716954 548489 598178 599710 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.21%) |
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 396280 399439 399456 401378 402079 409088 415598 422352 437366 438208 441692 443183 445502 447574 447979 450399 455652 456061 457688 458231 460191 462994 463691 463703 464144 464200 464805 467663 471628 472295 473375 473673 479298 482251 483496 484764 486540 489250 492115 492366 492614 496537 505973 514813 518046 521997 522653 523475 525273 527197 529134 540073 544103 548489 558876 559679 561441 565050 568098 569394 577899 579227 581092 581893 582197 584666 584765 590735 592933 594108 596539 598178 599710 602707 604155 607697 609759 609827 613855 613922 616679 619103 621356 622308 630630 685068 687503 689002 696567 696888 698224 699604 709760 711341 713552 714062 716954 726390 726882 727147 727680 727891 730904 738525 743429 743431 743463 753205 755695 756797 757501 758564 761275 761986 771055 777096 790015 820337 ] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock step"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock step"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock step"
]
|
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.