Query Metrics
7
Database Queries
7
Different statements
153.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.60 ms (83.67%) |
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 172191 372986 385782 389583 392117 393417 395271 398547 401873 404052 405040 407339 466894 468552 532054 533441 542441 546518 551685 556305 565059 591895 598737 614950 636143 636858 638131 644307 644871 644883 648001 650478 660618 663408 665877 667274 669751 671935 671969 681055 687206 690446 691223 692412 693174 693702 698187 698196 709425 714905 716588 718299 718353 719253 719677 722685 724560 724792 730958 731685 734229 736467 737478 738804 739443 739567 740759 742836 744726 745333 747420 748379 748385 748579 749710 752288 754792 756030 761380 762130 762426 764751 768122 768370 769650 775396 777990 780657 781086 782330 783225 784232 789305 791991 792124 792209 797881 799590 803223 804001 804216 804490 806237 807343 807608 808212 810129 815836 817956 818599 818647 818910 818947 819659 820101 820359 820648 820966 821205 825075 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (9.24%) |
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 698196 614950 799590 748379 764751 808212 738804 739567 754792 638131 698187 714905 546518 636858 762426 532054 804490 804001 744726 468552 663408 806237 734229 736467 818947 819659 533441 718299 768122 781086 405040 385782 644871 644883 820648 821205 556305 667274 669751 693174 660618 665877 691223 719677 792209 780657 797881 761380 762130 756030 745333 769650 740759 748385 719253 393417 783225 389583 820359 818910 565059 709425 598737 404052 742836 172191 398547 818599 818647 825075 693702 718353 722685 690446 692412 591895 791991 775396 784232 804216 789305 807608 730958 739443 782330 807343 401873 820966 395271 392117 407339 815836 817956 820101 542441 551685 687206 648001 650478 671969 716588 752288 724792 731685 748579 749710 768370 737478 747420 644307 803223 372986 466894 671935 681055 636143 792124 810129 724560 777990 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (2.09%) |
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 172191 372986 385782 389583 392117 393417 395271 398547 401873 404052 405040 407339 466894 468552 532054 533441 542441 546518 551685 556305 565059 591895 598737 614950 636143 636858 638131 644307 644871 644883 648001 650478 660618 663408 665877 667274 669751 671935 671969 681055 687206 690446 691223 692412 693174 693702 698187 698196 709425 714905 716588 718299 718353 719253 719677 722685 724560 724792 730958 731685 734229 736467 737478 738804 739443 739567 740759 742836 744726 745333 747420 748379 748385 748579 749710 752288 754792 756030 761380 762130 762426 764751 768122 768370 769650 775396 777990 780657 781086 782330 783225 784232 789305 791991 792124 792209 797881 799590 803223 804001 804216 804490 806237 807343 807608 808212 810129 815836 817956 818599 818647 818910 818947 819659 820101 820359 820648 820966 821205 825075 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex big"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс большие"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.07%) |
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.