Query Metrics
7
Database Queries
7
Different statements
387.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
360.55 ms (93.16%) |
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 391668 391916 391944 391984 391992 391994 392004 418142 421052 423784 427008 427128 427132 427364 431960 432680 432824 434346 434376 435550 436132 439033 439078 439653 441050 444538 444548 448431 450599 450889 450948 454282 455004 455132 456226 456236 457541 460900 465148 466145 466869 467875 469223 471101 472096 475103 475232 477143 479107 481124 487273 490272 490380 493961 495501 496063 497482 498483 499288 506119 508986 510801 512442 514440 515969 517425 518671 518884 519604 520910 523726 526653 526905 528318 530005 536382 538977 541274 544404 547235 547890 554235 556879 556880 556890 556907 564311 569995 575401 578323 583085 583474 597190 598141 601861 641807 641830 656935 672944 673578 695386 706631 722384 742281 742318 745126 751546 761608 765817 766415 770410 770821 782854 791930 792741 801639 804319 806271 807329 808998 ] |
||||||||||||||||||||||||||||||
|
16.41 ms (4.24%) |
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 523726 526653 450889 672944 695386 706631 556890 556907 801639 804319 782854 742318 761608 791930 792741 391994 455004 391916 508986 514440 519604 569995 490380 435550 454282 601861 439653 471101 578323 455132 439078 547890 456226 456236 427132 450599 497482 444548 493961 472096 564311 421052 448431 475232 479107 481124 432680 467875 391992 418142 427008 431960 427364 439033 466145 528318 496063 498483 520910 466869 427128 526905 547235 544404 556880 641807 597190 598141 806271 807329 770821 808998 745126 751546 765817 432824 423784 487273 499288 515969 391944 477143 512442 538977 541274 575401 583474 656935 673578 722384 556879 641830 766415 742281 770410 391984 434346 450948 392004 441050 517425 518884 495501 490272 510801 506119 475103 518671 530005 434376 391668 460900 554235 583085 436132 457541 444538 465148 469223 536382 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (0.67%) |
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 391668 391916 391944 391984 391992 391994 392004 418142 421052 423784 427008 427128 427132 427364 431960 432680 432824 434346 434376 435550 436132 439033 439078 439653 441050 444538 444548 448431 450599 450889 450948 454282 455004 455132 456226 456236 457541 460900 465148 466145 466869 467875 469223 471101 472096 475103 475232 477143 479107 481124 487273 490272 490380 493961 495501 496063 497482 498483 499288 506119 508986 510801 512442 514440 515969 517425 518671 518884 519604 520910 523726 526653 526905 528318 530005 536382 538977 541274 544404 547235 547890 554235 556879 556880 556890 556907 564311 569995 575401 578323 583085 583474 597190 598141 601861 641807 641830 656935 672944 673578 695386 706631 722384 742281 742318 745126 751546 761608 765817 766415 770410 770821 782854 791930 792741 801639 804319 806271 807329 808998 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur russian fisting"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск русск фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.41%) |
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.