Query Metrics
7
Database Queries
7
Different statements
156.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.03 ms (82.46%) |
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 414071 423653 427832 433302 458115 464659 477427 491208 524497 531193 532797 533855 534636 536576 538703 542247 542993 544753 546957 547756 547797 547800 550221 551494 552971 554319 554411 554840 554918 555177 555340 557551 558197 558804 559071 559324 561119 562950 564306 564782 564821 565505 566825 566928 570726 571239 571266 572263 573176 573938 574441 575329 575863 578426 579484 579651 580160 583370 584737 585476 585736 589166 590312 590870 591593 592854 593445 596001 597683 597834 598348 598940 600276 600344 600355 600495 604558 605563 606148 606583 606599 607236 616338 621966 623522 634475 634533 636271 636316 639736 640795 644257 648733 649583 650470 660422 660739 663346 666585 671764 673035 675006 678767 690020 694056 699625 701337 714522 714776 720258 784143 803086 803142 806239 815202 815370 820682 820772 820776 823298 ] |
||||||||||||||||||||||||||||||
|
16.32 ms (10.43%) |
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 639736 784143 803142 806239 477427 600355 701337 433302 427832 458115 554918 600344 573938 803086 675006 491208 414071 423653 815370 820772 820682 815202 823298 820776 464659 538703 531193 532797 536576 524497 533855 534636 542247 551494 552971 554840 555340 558804 559324 564782 566825 571266 579651 542993 544753 546957 547756 559071 564306 570726 572263 573176 579484 583370 584737 547797 547800 550221 554319 557551 561119 565505 571239 578426 580160 650470 660739 671764 673035 690020 694056 714522 714776 720258 649583 663346 666585 678767 699625 648733 660422 554411 555177 558197 562950 564821 566928 574441 575329 575863 585736 592854 597834 598940 600276 600495 606148 606583 606599 616338 623522 636271 640795 644257 589166 591593 593445 598348 604558 605563 607236 621966 634533 585476 590870 596001 597683 634475 636316 590312 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (2.11%) |
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 414071 423653 427832 433302 458115 464659 477427 491208 524497 531193 532797 533855 534636 536576 538703 542247 542993 544753 546957 547756 547797 547800 550221 551494 552971 554319 554411 554840 554918 555177 555340 557551 558197 558804 559071 559324 561119 562950 564306 564782 564821 565505 566825 566928 570726 571239 571266 572263 573176 573938 574441 575329 575863 578426 579484 579651 580160 583370 584737 585476 585736 589166 590312 590870 591593 592854 593445 596001 597683 597834 598348 598940 600276 600344 600355 600495 604558 605563 606148 606583 606599 607236 616338 621966 623522 634475 634533 636271 636316 639736 640795 644257 648733 649583 650470 660422 660739 663346 666585 671764 673035 675006 678767 690020 694056 699625 701337 714522 714776 720258 784143 803086 803142 806239 815202 815370 820682 820772 820776 823298 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom gape"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom большая большие дырк"
]
|
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.