Query Metrics
7
Database Queries
7
Different statements
190.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.83 ms (85.59%) |
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 385815 391756 395252 397531 401190 409597 415937 417547 418253 419895 419987 420005 420314 421619 421801 421940 423326 423916 424011 424156 424349 424734 425506 425727 426561 432366 432464 432487 435737 435937 437006 437980 439291 440724 440867 441169 441666 441748 441800 443896 444002 444234 447217 449712 450296 450446 451324 454016 455202 457403 458296 459070 460319 460408 461057 461601 463420 463469 463991 465869 466756 467060 467787 468275 468942 471850 472814 473634 473825 475605 477503 478633 479696 480339 482914 484939 486628 487761 487948 488914 490287 510785 513203 513257 513628 516596 517277 521014 522510 528465 534601 540816 543945 555925 560768 585073 599789 637250 725012 731159 738212 751260 751581 752765 759134 763726 763729 763740 764046 768603 768851 783303 785841 790094 799118 802236 804725 805538 808143 824889 ] |
||||||||||||||||||||||||||||||
|
16.07 ms (8.45%) |
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 790094 805538 763740 764046 768603 731159 751581 752765 763726 763729 768851 783303 785841 799118 804725 385815 424156 432366 432464 441748 444234 454016 475605 477503 419895 420005 421619 460408 466756 418253 421801 421940 461057 468275 480339 395252 439291 441800 450446 455202 459070 463469 479696 449712 451324 467787 472814 513628 488914 513203 482914 528465 484939 510785 516596 521014 423916 534601 560768 555925 637250 738212 808143 444002 517277 522510 759134 397531 440867 435737 450296 468942 463420 490287 543945 599789 802236 725012 751260 473634 425727 487761 513257 486628 391756 401190 417547 424011 432487 437980 443896 415937 419987 425506 441169 420314 424734 426561 440724 409597 423326 437006 424349 435937 441666 540816 585073 824889 458296 461601 467060 478633 487948 447217 457403 460319 463991 465869 471850 473825 ] |
||||||||||||||||||||||||||||||
|
3.74 ms (1.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife naked"
]
|
||||||||||||||||||||||||||||||
|
2.78 ms (1.46%) |
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 385815 391756 395252 397531 401190 409597 415937 417547 418253 419895 419987 420005 420314 421619 421801 421940 423326 423916 424011 424156 424349 424734 425506 425727 426561 432366 432464 432487 435737 435937 437006 437980 439291 440724 440867 441169 441666 441748 441800 443896 444002 444234 447217 449712 450296 450446 451324 454016 455202 457403 458296 459070 460319 460408 461057 461601 463420 463469 463991 465869 466756 467060 467787 468275 468942 471850 472814 473634 473825 475605 477503 478633 479696 480339 482914 484939 486628 487761 487948 488914 490287 510785 513203 513257 513628 516596 517277 521014 522510 528465 534601 540816 543945 555925 560768 585073 599789 637250 725012 731159 738212 751260 751581 752765 759134 763726 763729 763740 764046 768603 768851 783303 785841 790094 799118 802236 804725 805538 808143 824889 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен голые"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.75%) |
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.