Query Metrics
7
Database Queries
7
Different statements
164.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.34 ms (83.72%) |
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 31432 96341 209373 318463 361993 382255 383902 385970 388845 389171 390991 396746 400270 407769 408974 409783 411047 418417 421107 426370 426576 430331 431805 446025 450774 451802 454663 454738 455016 456137 457801 462088 466340 471979 475065 484838 490627 495622 495746 496711 502566 506790 509373 509376 512823 515729 519995 524173 527070 527648 528809 528825 531965 532355 532641 532974 533361 533832 533854 538237 539066 548730 550821 552595 557975 565346 572308 572533 576062 576356 582143 588535 589152 595732 595786 595804 598939 603166 603253 606540 607719 622235 632256 634475 637679 640154 647875 648840 649154 651489 656577 668137 668508 670763 673957 675373 676887 677075 679461 680111 680138 680180 681137 681302 681587 717793 718732 718970 720923 722504 738440 755176 771820 775790 804462 812320 814948 815413 820772 820776 ] |
||||||||||||||||||||||||||||||
|
16.01 ms (9.76%) |
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 407769 527070 718970 681302 812320 495746 680111 680138 668137 632256 738440 565346 681137 815413 755176 411047 649154 680180 775790 475065 318463 640154 603166 389171 519995 576356 603253 408974 454738 502566 572533 576062 637679 390991 385970 421107 400270 96341 426576 509376 557975 396746 457801 527648 528809 512823 484838 490627 430331 466340 454663 456137 471979 450774 31432 383902 539066 509373 495622 538237 209373 446025 679461 606540 496711 528825 533832 572308 595786 804462 388845 524173 552595 648840 681587 431805 361993 382255 532974 533361 533854 651489 717793 720923 588535 595804 598939 634475 595732 418417 451802 462088 820772 820776 532641 550821 582143 670763 722504 673957 677075 647875 656577 668508 589152 622235 771820 718732 426370 455016 506790 409783 814948 531965 532355 515729 548730 675373 676887 607719 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.99%) |
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 31432 96341 209373 318463 361993 382255 383902 385970 388845 389171 390991 396746 400270 407769 408974 409783 411047 418417 421107 426370 426576 430331 431805 446025 450774 451802 454663 454738 455016 456137 457801 462088 466340 471979 475065 484838 490627 495622 495746 496711 502566 506790 509373 509376 512823 515729 519995 524173 527070 527648 528809 528825 531965 532355 532641 532974 533361 533832 533854 538237 539066 548730 550821 552595 557975 565346 572308 572533 576062 576356 582143 588535 589152 595732 595786 595804 598939 603166 603253 606540 607719 622235 632256 634475 637679 640154 647875 648840 649154 651489 656577 668137 668508 670763 673957 675373 676887 677075 679461 680111 680138 680180 681137 681302 681587 717793 718732 718970 720923 722504 738440 755176 771820 775790 804462 812320 814948 815413 820772 820776 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group deep throat"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group глубокийминет минет оральн секс"
]
|
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.