Query Metrics
7
Database Queries
7
Different statements
239.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.33 ms (88.68%) |
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 69950 300984 383924 384371 388032 400621 407987 411910 417311 418792 419557 419666 421343 424299 430549 431882 433769 434257 435865 442100 446636 447106 448064 448168 448458 448678 448902 452025 452341 453899 455651 456127 456183 456939 459255 459859 459878 460192 460614 461760 461927 462235 462425 462747 462997 463246 464449 464667 464682 466194 467252 468026 469044 469060 469722 469769 470979 473650 473836 474085 474846 475260 475422 475637 476787 477687 478050 478852 479181 479780 479794 482659 483465 487526 491623 500680 502497 504299 505652 506765 506848 509245 511879 517383 522098 526837 528051 528534 528705 531818 541422 543594 549658 551337 552284 555465 556229 556491 559037 574690 577146 579664 585731 587197 592625 595988 597986 604044 607465 612795 625298 632198 636562 648703 650615 666080 670565 684706 755350 794424 ] |
||||||||||||||||||||||||||||||
|
17.00 ms (7.10%) |
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 300984 69950 625298 417311 431882 407987 442100 419557 433769 419666 455651 456939 469722 475422 448458 456127 459859 464449 483465 487526 448678 452341 491623 506848 528051 500680 531818 511879 528534 528705 459878 460192 473650 475637 482659 549658 552284 574690 543594 551337 556229 577146 650615 684706 648703 666080 670565 556491 559037 579664 585731 597986 587197 607465 592625 636562 794424 383924 462235 461927 469060 469769 470979 479181 384371 388032 400621 435865 448902 467252 475260 478852 452025 464667 466194 526837 502497 504299 506765 517383 522098 541422 411910 430549 434257 453899 460614 474846 479780 479794 473836 448064 456183 459255 462747 468026 509245 505652 461760 462425 463246 469044 477687 555465 595988 604044 612795 755350 632198 448168 462997 464682 474085 418792 421343 424299 446636 476787 478050 447106 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.17%) |
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 69950 300984 383924 384371 388032 400621 407987 411910 417311 418792 419557 419666 421343 424299 430549 431882 433769 434257 435865 442100 446636 447106 448064 448168 448458 448678 448902 452025 452341 453899 455651 456127 456183 456939 459255 459859 459878 460192 460614 461760 461927 462235 462425 462747 462997 463246 464449 464667 464682 466194 467252 468026 469044 469060 469722 469769 470979 473650 473836 474085 474846 475260 475422 475637 476787 477687 478050 478852 479181 479780 479794 482659 483465 487526 491623 500680 502497 504299 505652 506765 506848 509245 511879 517383 522098 526837 528051 528534 528705 531818 541422 543594 549658 551337 552284 555465 556229 556491 559037 574690 577146 579664 585731 587197 592625 595988 597986 604044 607465 612795 625298 632198 636562 648703 650615 666080 670565 684706 755350 794424 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina big"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин большие"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.64%) |
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.