Query Metrics
7
Database Queries
7
Different statements
162.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.07 ms (84.12%) |
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 51911 110884 117905 117958 248347 346188 346209 387996 388057 388364 392843 397675 397882 399083 401768 408692 409035 413398 413418 414050 414342 415877 415988 416020 418886 419454 423663 428178 440087 440708 441032 445975 446002 446942 448199 449406 452889 453213 453822 459201 460070 462384 463855 470470 471660 471669 473448 477760 479542 482293 483705 486772 493763 493840 496345 497905 506149 513846 513992 514849 515490 519699 519816 521540 531249 531869 531888 536377 537861 541392 545379 545465 546202 547469 547480 550900 558715 571726 572654 576951 580069 583713 586914 595145 603362 606576 606597 628106 628110 628404 632302 633474 641985 647891 650187 656932 660047 662194 664192 671018 671049 673035 680143 680248 686130 686347 695559 713508 728540 740922 745448 751727 752605 752620 765260 765789 770219 782791 796905 825237 ] |
||||||||||||||||||||||||||||||
|
15.92 ms (9.77%) |
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 423663 448199 462384 449406 493840 446942 470470 497905 513992 413398 482293 428178 452889 453213 479542 445975 506149 110884 117905 473448 414342 419454 346209 117958 397882 471660 408692 765789 571726 413418 416020 415877 545379 656932 647891 633474 399083 446002 513846 531249 628110 752620 519699 418886 409035 441032 463855 545465 673035 680248 650187 606576 401768 477760 460070 459201 580069 414050 471669 514849 388364 671049 680143 440087 825237 493763 453822 496345 531888 537861 536377 531869 541392 583713 660047 695559 713508 546202 641985 595145 740922 728540 751727 752605 628106 632302 796905 51911 388057 397675 248347 415988 387996 346188 486772 521540 558715 550900 572654 662194 686347 547469 606597 745448 770219 782791 440708 483705 515490 519816 603362 392843 547480 686130 664192 671018 586914 765260 576951 628404 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.76%) |
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 51911 110884 117905 117958 248347 346188 346209 387996 388057 388364 392843 397675 397882 399083 401768 408692 409035 413398 413418 414050 414342 415877 415988 416020 418886 419454 423663 428178 440087 440708 441032 445975 446002 446942 448199 449406 452889 453213 453822 459201 460070 462384 463855 470470 471660 471669 473448 477760 479542 482293 483705 486772 493763 493840 496345 497905 506149 513846 513992 514849 515490 519699 519816 521540 531249 531869 531888 536377 537861 541392 545379 545465 546202 547469 547480 550900 558715 571726 572654 576951 580069 583713 586914 595145 603362 606576 606597 628106 628110 628404 632302 633474 641985 647891 650187 656932 660047 662194 664192 671018 671049 673035 680143 680248 686130 686347 695559 713508 728540 740922 745448 751727 752605 752620 765260 765789 770219 782791 796905 825237 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme gape anal"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор большая большие дырк анал"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор большая большие дырк анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
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.