Query Metrics
7
Database Queries
7
Different statements
152.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.65 ms (81.61%) |
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 325253 337263 340242 385079 387301 387576 389631 391359 396374 396685 396716 396777 398504 400417 401134 401343 405042 413259 418336 419808 421066 422401 426325 426689 429008 429147 429162 429473 434486 442922 444258 445833 447533 452987 453785 458213 460988 463118 468085 469867 469874 474067 475092 481760 485304 485505 492829 493556 495148 495399 496244 500967 501603 504170 510418 511401 512973 548908 552921 557108 565954 567761 574067 575100 575145 577724 578147 587532 596161 597833 598421 598514 603394 611299 614262 624144 632028 633154 636791 641682 641737 642113 649121 649139 652872 653456 653523 654556 655114 655346 656045 660439 664994 669606 670989 671340 671633 676982 684914 689128 691286 693281 707071 710832 716675 724773 738779 742434 753486 756073 761488 765244 766866 783657 784265 784277 785981 797869 807806 810705 ] |
||||||||||||||||||||||||||||||
|
17.29 ms (11.32%) |
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 396374 396685 421066 691286 655346 656045 671633 636791 624144 810705 785981 724773 756073 761488 641737 693281 445833 653523 463118 468085 641682 596161 603394 753486 742434 387576 485505 337263 716675 614262 598514 707071 429473 442922 676982 389631 797869 807806 419808 429147 577724 426325 325253 396716 413259 671340 649121 653456 664994 669606 670989 654556 642113 784277 765244 784265 447533 565954 766866 783657 501603 400417 469874 655114 578147 587532 426689 474067 418336 422401 429008 434486 469867 500967 548908 611299 493556 511401 481760 512973 398504 552921 495399 649139 458213 495148 510418 567761 460988 496244 652872 633154 738779 405042 396777 453785 660439 475092 444258 492829 485304 429162 340242 575100 575145 391359 597833 684914 710832 387301 632028 401134 504170 452987 385079 401343 574067 689128 557108 598421 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.89%) |
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 325253 337263 340242 385079 387301 387576 389631 391359 396374 396685 396716 396777 398504 400417 401134 401343 405042 413259 418336 419808 421066 422401 426325 426689 429008 429147 429162 429473 434486 442922 444258 445833 447533 452987 453785 458213 460988 463118 468085 469867 469874 474067 475092 481760 485304 485505 492829 493556 495148 495399 496244 500967 501603 504170 510418 511401 512973 548908 552921 557108 565954 567761 574067 575100 575145 577724 578147 587532 596161 597833 598421 598514 603394 611299 614262 624144 632028 633154 636791 641682 641737 642113 649121 649139 652872 653456 653523 654556 655114 655346 656045 660439 664994 669606 670989 671340 671633 676982 684914 689128 691286 693281 707071 710832 716675 724773 738779 742434 753486 756073 761488 765244 766866 783657 784265 784277 785981 797869 807806 810705 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодая отсос"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодая девушк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"молодая девушк минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.13%) |
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.