Query Metrics
7
Database Queries
7
Different statements
178.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.69 ms (86.75%) |
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 132148 212893 233398 311007 381941 383281 385171 386350 386576 402375 412578 428543 428845 431496 445104 450383 454195 455834 458826 459494 461918 463978 465910 467032 467239 470395 470734 472705 474124 474410 474711 474722 479691 482867 483586 485512 488931 491357 494203 494919 494935 501434 503933 505851 509760 511815 512063 512593 515909 518452 518843 520545 520796 522582 523219 523674 525153 525762 528664 538590 539360 542855 546764 546934 547686 552059 555917 556396 556506 558284 559590 565358 566206 568060 572287 574085 580029 580129 589679 590343 596141 598565 599327 600758 603460 610859 619452 622929 624865 630686 663418 667671 675527 677360 678971 679441 680102 710250 711295 712130 712558 713156 719464 725687 730249 732782 735893 736054 749621 770888 774209 793341 794416 795065 798701 808542 810954 812993 814087 814512 ] |
||||||||||||||||||||||||||||||
|
14.22 ms (7.97%) |
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 474722 488931 494935 710250 712130 719464 622929 810954 749621 795065 381941 412578 491357 523674 212893 770888 385171 470395 538590 494919 679441 619452 598565 501434 455834 522582 483586 556506 574085 675527 711295 663418 546764 580129 630686 600758 808542 736054 610859 798701 812993 494203 512063 467032 542855 680102 713156 814087 461918 518843 566206 712558 677360 667671 794416 520545 386576 233398 445104 814512 474410 546934 555917 678971 558284 730249 735893 774209 431496 386350 472705 450383 505851 503933 132148 311007 454195 525153 467239 474711 565358 552059 559590 547686 556396 572287 589679 599327 624865 590343 596141 603460 793341 725687 732782 428845 458826 402375 459494 470734 511815 528664 525762 482867 485512 512593 383281 428543 463978 474124 479691 515909 523219 509760 518452 520796 539360 465910 568060 580029 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.51%) |
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 132148 212893 233398 311007 381941 383281 385171 386350 386576 402375 412578 428543 428845 431496 445104 450383 454195 455834 458826 459494 461918 463978 465910 467032 467239 470395 470734 472705 474124 474410 474711 474722 479691 482867 483586 485512 488931 491357 494203 494919 494935 501434 503933 505851 509760 511815 512063 512593 515909 518452 518843 520545 520796 522582 523219 523674 525153 525762 528664 538590 539360 542855 546764 546934 547686 552059 555917 556396 556506 558284 559590 565358 566206 568060 572287 574085 580029 580129 589679 590343 596141 598565 599327 600758 603460 610859 619452 622929 624865 630686 663418 667671 675527 677360 678971 679441 680102 710250 711295 712130 712558 713156 719464 725687 730249 732782 735893 736054 749621 770888 774209 793341 794416 795065 798701 808542 810954 812993 814087 814512 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck woman"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс woman"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс woman"
]
|
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.