Query Metrics
7
Database Queries
7
Different statements
147.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.42 ms (81.71%) |
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 384016 397639 397679 400254 404478 404693 405074 406121 406698 406935 408262 417344 417708 421155 421566 425523 425656 428494 428987 429906 429990 430436 434310 435225 435479 441203 445543 446027 446038 446811 447104 448795 448821 449180 449869 451040 456200 457165 462483 464127 464395 465688 474989 477183 481581 481878 486963 487632 492268 492534 495608 495705 496784 497866 499636 501119 503840 507078 507211 509118 510466 512896 516040 524773 524896 526267 527377 528358 528395 528406 528702 530884 534280 535684 540350 543266 552319 553054 553056 557534 558196 563844 564786 575890 578416 578465 581902 582234 583774 584759 586497 589591 590721 598225 601669 604555 607293 611241 620070 622714 649838 672159 682531 689634 690124 713564 714698 722373 724305 801016 805222 807363 808964 809930 814429 814892 815017 815250 820122 820340 ] |
||||||||||||||||||||||||||||||
|
16.86 ms (11.44%) |
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 528406 496784 499636 507211 527377 495705 512896 404478 509118 434310 564786 501119 474989 503840 400254 404693 406935 429906 435225 814429 814892 481878 449180 451040 535684 510466 526267 534280 528358 528395 492268 557534 563844 578416 584759 649838 689634 583774 620070 807363 622714 447104 464395 477183 428987 446027 446038 446811 417344 428494 481581 487632 507078 495608 397639 397679 448795 456200 808964 590721 815017 457165 465688 524773 528702 530884 552319 575890 690124 713564 722373 589591 607293 598225 611241 384016 430436 441203 435479 462483 464127 497866 553056 815250 820340 558196 405074 406698 408262 421155 429990 486963 492534 448821 553054 581902 582234 682531 586497 604555 601669 724305 809930 445543 449869 425523 406121 421566 524896 516040 540350 820122 672159 714698 801016 425656 417708 543266 578465 805222 ] |
||||||||||||||||||||||||||||||
|
2.94 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 384016 397639 397679 400254 404478 404693 405074 406121 406698 406935 408262 417344 417708 421155 421566 425523 425656 428494 428987 429906 429990 430436 434310 435225 435479 441203 445543 446027 446038 446811 447104 448795 448821 449180 449869 451040 456200 457165 462483 464127 464395 465688 474989 477183 481581 481878 486963 487632 492268 492534 495608 495705 496784 497866 499636 501119 503840 507078 507211 509118 510466 512896 516040 524773 524896 526267 527377 528358 528395 528406 528702 530884 534280 535684 540350 543266 552319 553054 553056 557534 558196 563844 564786 575890 578416 578465 581902 582234 583774 584759 586497 589591 590721 598225 601669 604555 607293 611241 620070 622714 649838 672159 682531 689634 690124 713564 714698 722373 724305 801016 805222 807363 808964 809930 814429 814892 815017 815250 820122 820340 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina hairy"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.