Query Metrics
7
Database Queries
7
Different statements
171.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.43 ms (84.81%) |
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 108925 385562 390382 395402 397305 417223 417746 436250 450635 455051 459222 461049 462273 465071 465198 466727 468770 471441 471618 473364 474752 476262 476307 476310 476588 477224 480290 480291 486474 501830 502024 503828 503867 505186 510024 512240 514598 515774 518519 521046 523401 523427 524625 524982 525701 526547 530799 531521 533179 533481 534003 537600 540391 541833 543243 545181 546118 546637 555397 559584 560471 562065 566145 566312 567097 567108 569547 572303 572825 572862 573908 574561 578078 578124 580393 586397 589754 592408 594852 595086 599213 599229 599840 601838 604424 605948 606255 606262 606284 607123 607195 613635 624874 637982 638360 663439 663858 665317 665349 666123 667193 667317 667875 667878 673325 690310 690406 694380 710412 724297 725369 725891 727018 727087 759658 760794 784252 787007 821620 826776 ] |
||||||||||||||||||||||||||||||
|
15.98 ms (9.32%) |
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 546118 572825 592408 760794 465198 524982 534003 417746 462273 474752 518519 710412 526547 523401 461049 480290 826776 566145 663858 725891 390382 466727 525701 395402 821620 455051 471441 515774 531521 521046 533179 503867 476310 562065 567108 572862 546637 555397 560471 543243 545181 559584 569547 574561 578078 666123 667317 673325 690406 694380 663439 665349 667193 690310 567097 572303 573908 580393 589754 607123 637982 599229 606255 586397 594852 595086 599213 605948 606262 606284 784252 787007 725369 727087 724297 727018 613635 417223 540391 505186 436250 465071 471618 476307 502024 514598 537600 533481 510024 530799 665317 667878 667875 578124 601838 599840 638360 759658 604424 459222 468770 473364 501830 512240 524625 607195 476588 480291 486474 541833 523427 566312 397305 476262 503828 624874 477224 385562 108925 450635 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (1.90%) |
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 108925 385562 390382 395402 397305 417223 417746 436250 450635 455051 459222 461049 462273 465071 465198 466727 468770 471441 471618 473364 474752 476262 476307 476310 476588 477224 480290 480291 486474 501830 502024 503828 503867 505186 510024 512240 514598 515774 518519 521046 523401 523427 524625 524982 525701 526547 530799 531521 533179 533481 534003 537600 540391 541833 543243 545181 546118 546637 555397 559584 560471 562065 566145 566312 567097 567108 569547 572303 572825 572862 573908 574561 578078 578124 580393 586397 589754 592408 594852 595086 599213 599229 599840 601838 604424 605948 606255 606262 606284 607123 607195 613635 624874 637982 638360 663439 663858 665317 665349 666123 667193 667317 667875 667878 673325 690310 690406 694380 710412 724297 725369 725891 727018 727087 759658 760794 784252 787007 821620 826776 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature woman pickup"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин пикап"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.95%) |
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.