Query Metrics
7
Database Queries
7
Different statements
155.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.26 ms (83.77%) |
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 193874 418256 429083 435403 445715 449313 449623 449653 450524 455362 457531 460251 461807 461956 462117 462229 466306 485008 485417 488171 493550 494483 498646 499741 500782 502497 503758 508648 509142 514658 514852 515560 517349 518514 519355 519379 519575 520152 520706 521599 522171 524155 524695 525732 526187 526298 526541 527067 528881 529093 529369 539875 541501 544292 545630 545820 546634 546972 549553 553229 553441 554819 555440 559405 560000 560996 562015 562195 562204 562959 567119 568214 569592 569765 570495 573724 577997 580656 580713 581713 582812 583223 583383 584405 585818 585854 586285 587156 587435 587534 587809 588128 593119 593497 594254 595610 596220 597101 600125 601052 601218 603106 603491 604785 604943 605670 608869 622297 623995 624148 628561 632823 653521 666681 670034 671791 676188 740512 747320 750896 ] |
||||||||||||||||||||||||||||||
|
15.69 ms (10.09%) |
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 596220 605670 740512 462229 449653 450524 429083 449623 526298 485417 498646 515560 520706 509142 519355 524155 524695 449313 460251 573724 555440 560000 562959 676188 604943 587435 597101 193874 461807 488171 445715 493550 514658 520152 521599 526187 514852 519379 519575 529369 539875 503758 508648 525732 526541 529093 518514 528881 553229 553441 554819 569765 583383 544292 546634 546972 560996 562015 568214 580656 582812 541501 545630 545820 549553 562195 562204 567119 570495 580713 581713 584405 653521 671791 666681 670034 559405 569592 577997 583223 586285 587809 585854 587534 594254 595610 600125 601218 608869 622297 624148 632823 585818 593119 593497 603106 604785 628561 587156 588128 601052 623995 750896 747320 603491 418256 462117 466306 455362 435403 457531 461956 485008 494483 502497 522171 527067 500782 517349 499741 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.79%) |
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 193874 418256 429083 435403 445715 449313 449623 449653 450524 455362 457531 460251 461807 461956 462117 462229 466306 485008 485417 488171 493550 494483 498646 499741 500782 502497 503758 508648 509142 514658 514852 515560 517349 518514 519355 519379 519575 520152 520706 521599 522171 524155 524695 525732 526187 526298 526541 527067 528881 529093 529369 539875 541501 544292 545630 545820 546634 546972 549553 553229 553441 554819 555440 559405 560000 560996 562015 562195 562204 562959 567119 568214 569592 569765 570495 573724 577997 580656 580713 581713 582812 583223 583383 584405 585818 585854 586285 587156 587435 587534 587809 588128 593119 593497 594254 595610 596220 597101 600125 601052 601218 603106 603491 604785 604943 605670 608869 622297 623995 624148 628561 632823 653521 666681 670034 671791 676188 740512 747320 750896 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long clitoris fuck"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные клитор секс"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.86%) |
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.