Query Metrics
7
Database Queries
7
Different statements
163.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.17 ms (87.20%) |
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 79570 383110 384494 385742 387033 388224 390334 390717 390914 390917 391224 399222 403382 403559 405973 407223 410452 411834 415412 416476 425824 427929 428804 438959 445048 454682 462782 486721 494548 516716 517741 525144 530051 540074 540887 550088 557959 563326 565090 588098 588278 593079 593149 597694 597728 600543 606742 607559 607923 610132 612229 621296 629194 629610 634831 636258 636623 642723 646111 651857 660106 665959 676778 677284 682854 692413 693011 693507 698976 706223 711458 715352 717082 720342 720874 721894 723559 727474 731682 733003 734990 735750 737589 740035 740526 746335 747186 752454 752895 753208 756190 756367 758495 761257 765114 771276 784144 784245 801342 804596 809283 810197 810217 810276 812878 813074 813112 821142 821642 821681 822181 822186 822211 822362 822434 823304 826213 827331 ] |
||||||||||||||||||||||||||||||
|
11.97 ms (7.34%) |
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 593149 784144 698976 565090 821681 629194 438959 610132 775033 813074 390917 822186 822434 651857 629610 765114 427929 822129 822362 693507 706223 676778 692413 721894 693011 636258 607559 607923 733003 740035 737589 752895 734990 753208 621296 390914 391224 384494 462782 405973 390717 813112 407223 425824 385742 540887 79570 390334 494548 516716 540074 563326 720342 597694 597728 804596 812878 821142 826213 416476 486721 771276 600543 634831 810217 810276 784245 761257 735750 731682 606742 717082 383110 747186 530051 550088 593079 740526 758495 746335 525144 445048 403559 403382 411834 822211 454682 517741 715352 677284 612229 801342 727474 756190 809283 752454 756367 810197 387033 388224 642723 410452 415412 720874 428804 827331 821642 399222 822181 723559 823304 557959 660106 665959 682854 711458 646111 636623 588098 588278 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.42%) |
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 79570 383110 384494 385742 387033 388224 390334 390717 390914 390917 391224 399222 403382 403559 405973 407223 410452 411834 415412 416476 425824 427929 428804 438959 445048 454682 462782 486721 494548 516716 517741 525144 530051 540074 540887 550088 557959 563326 565090 588098 588278 593079 593149 597694 597728 600543 606742 607559 607923 610132 612229 621296 629194 629610 634831 636258 636623 642723 646111 651857 660106 665959 676778 677284 682854 692413 693011 693507 698976 706223 711458 715352 717082 720342 720874 721894 723559 727474 731682 733003 734990 735750 737589 740035 740526 746335 747186 752454 752895 753208 756190 756367 758495 761257 765114 771276 784144 784245 801342 804596 809283 810197 810217 810276 812878 813074 813112 821142 821642 821681 822181 822186 822211 822362 822434 823304 826213 827331 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina big cock"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская большие cock"
]
|
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.