Query Metrics
7
Database Queries
7
Different statements
166.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.12 ms (81.13%) |
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 16851 34697 73052 129999 191199 370755 385562 389442 395974 397113 405224 407708 407756 407800 408424 409506 409909 418840 428922 429461 429601 436393 440877 446034 454531 455343 455793 457422 461046 464596 465207 471617 471809 472007 472654 474095 477225 478453 479979 484540 499551 500458 500459 502061 509808 510675 511356 512962 521794 525413 533603 533832 533933 534532 536538 542965 544420 550380 551551 556889 557163 560409 563424 563425 579373 581471 600962 604523 607369 614852 617115 628589 634770 636466 660014 669207 670763 676252 677974 696131 702454 710856 712332 713508 714378 715094 717981 720236 733812 736770 740632 744217 745957 746679 756986 758910 761570 764161 772547 779178 788260 788812 789540 800891 801306 803194 805431 808236 808500 808679 811005 811465 813835 814129 815849 817010 820072 823804 824258 824587 ] |
||||||||||||||||||||||||||||||
|
18.84 ms (11.31%) |
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 455793 129999 824587 740632 811465 779178 808500 712332 407708 745957 746679 744217 696131 801306 702454 813835 803194 550380 823804 714378 397113 817010 636466 676252 815849 710856 385562 533933 407756 408424 824258 407800 789540 73052 551551 733812 370755 617115 715094 614852 720236 525413 484540 717981 761570 534532 772547 756986 800891 581471 510675 814129 512962 502061 808236 405224 395974 474095 499551 34697 500458 820072 191199 563425 808679 764161 628589 758910 472654 713508 805431 788812 478453 418840 556889 660014 471617 389442 429601 409909 563424 465207 477225 521794 429461 511356 677974 409506 440877 811005 428922 533603 479979 472007 533832 604523 557163 670763 600962 736770 454531 500459 634770 607369 436393 669207 16851 560409 461046 455343 464596 542965 579373 457422 544420 446034 471809 788260 536538 509808 ] |
||||||||||||||||||||||||||||||
|
2.93 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 16851 34697 73052 129999 191199 370755 385562 389442 395974 397113 405224 407708 407756 407800 408424 409506 409909 418840 428922 429461 429601 436393 440877 446034 454531 455343 455793 457422 461046 464596 465207 471617 471809 472007 472654 474095 477225 478453 479979 484540 499551 500458 500459 502061 509808 510675 511356 512962 521794 525413 533603 533832 533933 534532 536538 542965 544420 550380 551551 556889 557163 560409 563424 563425 579373 581471 600962 604523 607369 614852 617115 628589 634770 636466 660014 669207 670763 676252 677974 696131 702454 710856 712332 713508 714378 715094 717981 720236 733812 736770 740632 744217 745957 746679 756986 758910 761570 764161 772547 779178 788260 788812 789540 800891 801306 803194 805431 808236 808500 808679 811005 811465 813835 814129 815849 817010 820072 823804 824258 824587 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature super секс"
]
|
||||||||||||||||||||||||||||||
|
2.60 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature super sex"
]
|
||||||||||||||||||||||||||||||
|
2.28 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature super секс"
]
|
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.