Query Metrics
7
Database Queries
7
Different statements
208.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.75 ms (85.37%) |
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 95673 142493 385474 397306 415004 417250 418450 423499 428116 434286 441095 443150 444111 447132 447253 448798 450226 451252 456333 456818 460209 463305 463764 465061 465256 466685 472125 474688 475454 476117 477147 477557 478032 478475 478528 480425 482788 486202 488477 488747 489471 490196 490520 491273 491398 491940 494513 496702 496835 497332 497907 497921 503153 503899 506705 507939 508909 509799 509800 512215 512680 514088 514765 515363 516499 517005 518577 519390 522348 526891 528297 530268 530371 530765 531131 532922 532969 533831 533844 534988 534999 537114 537595 541887 543849 543888 545081 546773 551904 553292 555872 560664 561024 561132 565423 574756 580263 591590 597224 600225 603649 604631 607374 620160 637413 637746 638416 638991 641642 649147 666532 700284 711998 718745 746366 749242 775846 804487 806113 808472 ] |
||||||||||||||||||||||||||||||
|
18.89 ms (9.07%) |
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 649147 666532 638416 591590 597224 775846 804487 806113 746366 749242 475454 514088 428116 526891 509800 530371 447132 463764 534988 519390 537114 607374 637413 441095 423499 456818 507939 518577 503899 509799 496702 460209 486202 555872 553292 711998 561024 603649 465061 142493 385474 434286 443150 478528 480425 456333 477147 515363 491940 506705 490196 530765 508909 522348 580263 450226 463305 465256 488477 517005 497921 537595 533844 565423 95673 444111 530268 478032 551904 546773 808472 478475 415004 447253 503153 491398 497332 496835 528297 489471 543849 512680 638991 418450 417250 451252 516499 532969 531131 514765 532922 534999 541887 574756 637746 620160 600225 604631 641642 700284 477557 474688 472125 490520 476117 466685 560664 448798 491273 397306 482788 494513 497907 533831 512215 488747 561132 543888 545081 718745 ] |
||||||||||||||||||||||||||||||
|
4.29 ms (2.06%) |
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 95673 142493 385474 397306 415004 417250 418450 423499 428116 434286 441095 443150 444111 447132 447253 448798 450226 451252 456333 456818 460209 463305 463764 465061 465256 466685 472125 474688 475454 476117 477147 477557 478032 478475 478528 480425 482788 486202 488477 488747 489471 490196 490520 491273 491398 491940 494513 496702 496835 497332 497907 497921 503153 503899 506705 507939 508909 509799 509800 512215 512680 514088 514765 515363 516499 517005 518577 519390 522348 526891 528297 530268 530371 530765 531131 532922 532969 533831 533844 534988 534999 537114 537595 541887 543849 543888 545081 546773 551904 553292 555872 560664 561024 561132 565423 574756 580263 591590 597224 600225 603649 604631 607374 620160 637413 637746 638416 638991 641642 649147 666532 700284 711998 718745 746366 749242 775846 804487 806113 808472 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal slave"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал доминирован"
]
|
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.