Query Metrics
7
Database Queries
7
Different statements
150.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.16 ms (82.61%) |
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 29148 116757 159380 163135 381997 384595 387352 389891 392691 395453 396235 397353 400026 400439 402859 403348 430858 431839 432762 450683 467061 487189 491326 491683 492553 492822 496040 497580 502634 502747 502763 505130 508427 510354 510392 510547 513313 517911 521588 523100 527378 527568 527629 528965 529067 530478 538740 540347 552194 561906 569511 575212 575771 594162 595515 597553 598001 598476 598712 599929 600082 601970 604259 605329 620279 633746 636530 642097 645508 646076 652273 653229 654460 656079 659432 662047 665714 671660 677367 678339 679908 696970 697135 715377 718693 721264 721329 721417 721424 722225 722629 722782 722899 740373 740538 740651 742188 743391 747402 753155 753302 753800 758726 758887 758977 760942 761482 765278 777053 777529 788540 792485 800575 803133 806870 808412 814019 818798 819677 825109 ] |
||||||||||||||||||||||||||||||
|
15.68 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 508427 527629 491683 492822 497580 502763 505130 527378 487189 491326 492553 510392 513313 521588 527568 530478 496040 502634 389891 575771 575212 403348 523100 29148 538740 645508 679908 715377 721264 646076 678339 656079 600082 620279 599929 777529 803133 808412 740538 758726 758977 777053 159380 163135 395453 467061 116757 384595 381997 392691 502747 510354 825109 540347 569511 722225 696970 697135 552194 601970 642097 633746 806870 400439 430858 431839 450683 387352 528965 517911 529067 402859 432762 818798 819677 814019 510547 652273 654460 665714 677367 721329 722629 722899 653229 659432 671660 721424 662047 721417 561906 597553 598001 598476 605329 636530 594162 595515 598712 604259 800575 740373 740651 743391 753302 753800 761482 788540 792485 758887 760942 765278 742188 747402 753155 718693 722782 396235 397353 400026 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.91%) |
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 29148 116757 159380 163135 381997 384595 387352 389891 392691 395453 396235 397353 400026 400439 402859 403348 430858 431839 432762 450683 467061 487189 491326 491683 492553 492822 496040 497580 502634 502747 502763 505130 508427 510354 510392 510547 513313 517911 521588 523100 527378 527568 527629 528965 529067 530478 538740 540347 552194 561906 569511 575212 575771 594162 595515 597553 598001 598476 598712 599929 600082 601970 604259 605329 620279 633746 636530 642097 645508 646076 652273 653229 654460 656079 659432 662047 665714 671660 677367 678339 679908 696970 697135 715377 718693 721264 721329 721417 721424 722225 722629 722782 722899 740373 740538 740651 742188 743391 747402 753155 753302 753800 758726 758887 758977 760942 761482 765278 777053 777529 788540 792485 800575 803133 806870 808412 814019 818798 819677 825109 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen красивая"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen красивая"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.