Query Metrics
7
Database Queries
7
Different statements
424.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.64 ms (50.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные анал"
]
|
||||||||||||||||||||||||||||||
|
175.75 ms (41.43%) |
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 382578 387749 387848 388642 395284 403896 414103 414114 416170 416523 416539 416632 416668 416692 416701 416718 416724 421369 428860 431385 441027 443250 443255 449024 452274 452876 453208 459170 462922 463840 465468 467112 468219 469096 470453 473453 475649 476184 482775 483731 485468 487414 495467 511274 512442 512933 513842 514254 530110 531183 531403 536628 542707 544439 545854 547494 547556 548464 561034 561038 590281 598141 600269 604781 614957 624191 624942 627409 628553 633147 633731 639782 641997 642065 656935 660359 669075 669079 669386 670368 695868 696597 699718 708714 713505 721106 721992 733582 739165 745125 749219 749254 749259 751546 751615 752636 752672 758778 763739 765712 765714 770270 777012 782653 782790 782806 786876 786906 788800 790219 800293 805543 808641 814270 815559 816094 818387 821409 ] |
||||||||||||||||||||||||||||||
|
25.60 ms (6.04%) |
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 395284 387848 403896 414103 416632 416692 443250 416718 814270 818387 821409 815559 816094 449024 467112 483731 452274 485468 487414 453208 511274 512442 512933 514254 531403 465468 468219 469096 544439 548464 545854 561034 695868 656935 669075 708714 721106 721992 660359 670368 696597 699718 713505 616047 633731 598141 600269 628553 639782 641997 642065 782653 782790 782806 786906 777012 800293 733582 752672 805543 749219 749259 751615 745125 751546 770270 739165 749254 752636 758778 763739 765712 765714 627409 633147 786876 788800 790219 808641 428860 382578 416701 416724 452876 416523 416668 459170 470453 495467 513842 547556 388642 536628 462922 473453 531183 547494 561038 669079 669386 614957 624942 604781 630427 590281 387749 416170 431385 441027 443255 463840 482775 476184 530110 475649 542707 624191 414114 416539 421369 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (0.77%) |
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 382578 387749 387848 388642 395284 403896 414103 414114 416170 416523 416539 416632 416668 416692 416701 416718 416724 421369 428860 431385 441027 443250 443255 449024 452274 452876 453208 459170 462922 463840 465468 467112 468219 469096 470453 473453 475649 476184 482775 483731 485468 487414 495467 511274 512442 512933 513842 514254 530110 531183 531403 536628 542707 544439 545854 547494 547556 548464 561034 561038 590281 598141 600269 604781 614957 624191 624942 627409 628553 633147 633731 639782 641997 642065 656935 660359 669075 669079 669386 670368 695868 696597 699718 708714 713505 721106 721992 733582 739165 745125 749219 749254 749259 751546 751615 752636 752672 758778 763739 765712 765714 770270 777012 782653 782790 782806 786876 786906 788800 790219 800293 805543 808641 814270 815559 816094 818387 821409 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge anal"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные анал"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.43%) |
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.