Query Metrics
7
Database Queries
7
Different statements
191.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.99 ms (88.57%) |
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 168977 402950 406372 411540 415005 420480 420761 425653 428305 429553 432735 434325 437999 440655 442870 445681 445975 446217 446300 446547 446606 447882 447941 449412 451040 451310 452189 454977 455816 458764 458793 459557 460156 461937 464096 465964 470403 470434 470848 475015 476128 476136 477242 478041 478285 479285 486161 492177 496368 498808 500250 500665 503426 506115 513159 513223 513894 514085 523298 524520 525852 533851 540512 546425 555128 556876 559315 565917 566205 569554 582908 584200 584402 591596 593764 596120 598194 601670 606549 607261 608415 614186 615756 615966 621742 624578 632021 636958 660690 667986 674129 678707 700470 708062 714029 718810 720424 722751 724098 729337 737438 746489 756406 760032 771650 772233 775015 788567 789840 795398 795426 801348 801877 802817 805431 808909 812911 814361 814511 820986 ] |
||||||||||||||||||||||||||||||
|
13.21 ms (6.88%) |
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 513159 168977 460156 500250 540512 606549 795426 805431 737438 808909 729337 746489 771650 437999 470434 498808 718810 714029 591596 608415 801877 428305 476136 406372 820986 514085 506115 708062 678707 446606 479285 476128 446300 415005 451040 814361 486161 615756 614186 593764 454977 523298 601670 788567 442870 458793 500665 402950 447882 449412 451310 569554 582908 546425 584200 801348 425653 607261 432735 565917 566205 584402 598194 475015 446217 465964 513223 615966 724098 775015 411540 445681 420480 525852 478285 772233 621742 802817 446547 464096 458764 478041 461937 559315 700470 795398 434325 455816 555128 720424 632021 814511 496368 513894 420761 445975 470848 477242 533851 674129 789840 756406 812911 760032 440655 452189 556876 722751 596120 624578 447941 503426 492177 524520 667986 470403 660690 636958 459557 429553 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.47%) |
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 168977 402950 406372 411540 415005 420480 420761 425653 428305 429553 432735 434325 437999 440655 442870 445681 445975 446217 446300 446547 446606 447882 447941 449412 451040 451310 452189 454977 455816 458764 458793 459557 460156 461937 464096 465964 470403 470434 470848 475015 476128 476136 477242 478041 478285 479285 486161 492177 496368 498808 500250 500665 503426 506115 513159 513223 513894 514085 523298 524520 525852 533851 540512 546425 555128 556876 559315 565917 566205 569554 582908 584200 584402 591596 593764 596120 598194 601670 606549 607261 608415 614186 615756 615966 621742 624578 632021 636958 660690 667986 674129 678707 700470 708062 714029 718810 720424 722751 724098 729337 737438 746489 756406 760032 771650 772233 775015 788567 789840 795398 795426 801348 801877 802817 805431 808909 812911 814361 814511 820986 ] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard масл секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard oil sex"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard масл секс"
]
|
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.