Query Metrics
7
Database Queries
7
Different statements
219.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.00 ms (85.50%) |
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 393694 402574 412941 419808 423426 442897 443749 444329 445736 447071 451799 454363 455099 455103 455106 456690 460194 460539 461124 461428 461516 461518 461524 461549 461552 461557 462052 465525 466322 467132 467174 467617 467632 468844 471886 472347 474052 476402 478527 478529 480831 482129 487025 487069 487080 487090 491199 491239 500503 507195 508844 511746 512239 512293 512321 512323 512335 512337 513278 513783 513891 515334 515379 517596 517654 522590 524697 524732 527807 533962 544992 547059 548656 549527 552116 552137 552142 558441 558860 560464 560476 566431 573773 573775 574509 574591 575148 575453 575743 575791 575805 576026 576351 576363 592728 597136 605553 632922 650018 650978 651003 653172 654812 656072 657591 658096 658250 658632 659548 660545 660923 663456 705398 715693 732266 742166 759463 782034 793578 818663 ] |
||||||||||||||||||||||||||||||
|
21.88 ms (9.95%) |
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 515379 512337 527807 467632 654812 656072 660923 659548 759463 468844 467174 549527 574591 576363 461518 461428 455103 455106 412941 455099 480831 461524 461557 513891 507195 478527 456690 533962 552137 715693 742166 508844 512321 575791 515334 402574 423426 451799 460539 445736 461124 491239 513783 548656 552142 560476 573773 575805 576026 573775 574509 575453 552116 558860 560464 575743 650018 663456 575148 576351 597136 632922 732266 462052 467132 460194 461549 461552 466322 474052 476402 442897 444329 447071 454363 472347 478529 482129 461516 467617 511746 512293 512323 522590 487090 512335 487025 487069 491199 487080 512239 524697 524732 419808 650978 705398 393694 443749 558441 500503 818663 658096 517654 592728 471886 517596 544992 658250 660545 566431 651003 513278 465525 605553 657591 658632 653172 547059 782034 793578 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.12%) |
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 393694 402574 412941 419808 423426 442897 443749 444329 445736 447071 451799 454363 455099 455103 455106 456690 460194 460539 461124 461428 461516 461518 461524 461549 461552 461557 462052 465525 466322 467132 467174 467617 467632 468844 471886 472347 474052 476402 478527 478529 480831 482129 487025 487069 487080 487090 491199 491239 500503 507195 508844 511746 512239 512293 512321 512323 512335 512337 513278 513783 513891 515334 515379 517596 517654 522590 524697 524732 527807 533962 544992 547059 548656 549527 552116 552137 552142 558441 558860 560464 560476 566431 573773 573775 574509 574591 575148 575453 575743 575791 575805 576026 576351 576363 592728 597136 605553 632922 650018 650978 651003 653172 654812 656072 657591 658096 658250 658632 659548 660545 660923 663456 705398 715693 732266 742166 759463 782034 793578 818663 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold fuck sex"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд секс секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.71%) |
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.