Query Metrics
7
Database Queries
7
Different statements
191.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.35 ms (84.16%) |
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 6715 20460 51456 51524 390840 392069 396543 417343 419057 424068 452366 456220 456433 458588 458967 459626 465263 470827 476972 478143 479481 480922 481711 482475 482867 483295 501115 541199 542916 549546 550121 558152 558912 559974 562911 563458 564096 567862 580050 583005 585785 588670 594312 608826 610693 612494 623830 638111 638968 640826 640868 640964 643515 647114 650293 653848 659482 682671 682728 691235 699142 699235 705436 706121 708317 708664 709771 712065 712293 715620 718069 718571 720676 729351 731434 731641 732664 735716 736048 740406 741591 743439 743654 744064 745763 747340 751404 754038 757915 758391 758912 760206 763919 763977 764597 766494 768831 770373 772471 776088 776359 778597 779848 783064 786585 789277 790225 790251 791469 791788 792392 798831 798904 798927 798975 804612 805426 807319 807861 809345 ] |
||||||||||||||||||||||||||||||
|
18.77 ms (9.79%) |
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 798831 798927 729351 760206 791788 807319 731641 740406 758912 770373 731434 743439 754038 763919 735716 744064 743654 758391 608826 708317 708664 718069 718571 778597 786585 392069 741591 390840 419057 541199 542916 567862 583005 709771 715620 682728 563458 580050 610693 640868 643515 623830 638111 789277 783064 791469 757915 712293 804612 396543 51456 550121 558152 699142 588670 594312 751404 768831 772471 736048 747340 640964 705436 776088 807861 465263 456220 483295 478143 417343 476972 501115 480922 558912 6715 20460 482475 456433 459626 452366 458588 458967 481711 470827 549546 559974 424068 479481 482867 564096 51524 647114 706121 720676 653848 659482 691235 650293 682671 699235 712065 562911 638968 640826 585785 612494 779848 798904 798975 776359 790225 790251 805426 766494 792392 809345 732664 745763 763977 764597 ] |
||||||||||||||||||||||||||||||
|
3.64 ms (1.90%) |
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 6715 20460 51456 51524 390840 392069 396543 417343 419057 424068 452366 456220 456433 458588 458967 459626 465263 470827 476972 478143 479481 480922 481711 482475 482867 483295 501115 541199 542916 549546 550121 558152 558912 559974 562911 563458 564096 567862 580050 583005 585785 588670 594312 608826 610693 612494 623830 638111 638968 640826 640868 640964 643515 647114 650293 653848 659482 682671 682728 691235 699142 699235 705436 706121 708317 708664 709771 712065 712293 715620 718069 718571 720676 729351 731434 731641 732664 735716 736048 740406 741591 743439 743654 744064 745763 747340 751404 754038 757915 758391 758912 760206 763919 763977 764597 766494 768831 770373 772471 776088 776359 778597 779848 783064 786585 789277 790225 790251 791469 791788 792392 798831 798904 798927 798975 804612 805426 807319 807861 809345 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl car"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.92%) |
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.