Query Metrics
7
Database Queries
7
Different statements
204.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.19 ms (83.88%) |
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 24076 24255 185143 190773 193890 391121 393496 396317 396364 399945 400375 403770 407115 410980 418070 418441 418951 420352 420495 421861 422767 425529 425863 427220 428096 430705 431321 432884 438127 440966 443785 445497 446078 446936 447244 450277 450377 452454 453884 458223 462574 467342 469150 469300 471397 471648 478814 480381 480604 483087 488100 496851 509019 510425 513990 519754 520415 521294 521919 523248 523289 523848 527427 528562 532008 532334 532484 536919 541550 567313 574442 577105 578851 586791 586899 589331 589661 593022 593136 598973 602632 604195 607010 607469 609968 611347 619718 620491 642779 652881 660811 662897 665289 669708 700815 707840 710852 714958 716144 721500 721983 724320 726289 728255 740694 751138 753628 754403 755578 756673 765268 773438 781117 781967 785733 791981 792440 793622 803306 824215 ] |
||||||||||||||||||||||||||||||
|
21.89 ms (10.72%) |
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 24255 792440 467342 478814 604195 462574 418070 824215 496851 190773 469300 765268 391121 432884 450277 480381 513990 577105 611347 593022 740694 425529 420495 527427 509019 193890 652881 665289 700815 589331 726289 756673 781967 574442 403770 422767 483087 532334 523248 586791 803306 791981 418951 443785 445497 669708 428096 431321 450377 593136 609968 488100 523848 589661 773438 446078 662897 714958 724320 393496 536919 469150 602632 620491 410980 425863 532008 523289 567313 721500 728255 446936 452454 520415 440966 521294 427220 578851 619718 607010 400375 586899 751138 396364 24076 510425 420352 528562 532484 471648 185143 430705 418441 453884 519754 721983 710852 607469 598973 642779 480604 399945 447244 471397 438127 421861 521919 541550 407115 707840 660811 754403 781117 396317 458223 716144 785733 793622 753628 755578 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.63%) |
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 24076 24255 185143 190773 193890 391121 393496 396317 396364 399945 400375 403770 407115 410980 418070 418441 418951 420352 420495 421861 422767 425529 425863 427220 428096 430705 431321 432884 438127 440966 443785 445497 446078 446936 447244 450277 450377 452454 453884 458223 462574 467342 469150 469300 471397 471648 478814 480381 480604 483087 488100 496851 509019 510425 513990 519754 520415 521294 521919 523248 523289 523848 527427 528562 532008 532334 532484 536919 541550 567313 574442 577105 578851 586791 586899 589331 589661 593022 593136 598973 602632 604195 607010 607469 609968 611347 619718 620491 642779 652881 660811 662897 665289 669708 700815 707840 710852 714958 716144 721500 721983 724320 726289 728255 740694 751138 753628 754403 755578 756673 765268 773438 781117 781967 785733 791981 792440 793622 803306 824215 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom ass fuck"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
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.