Query Metrics
7
Database Queries
7
Different statements
275.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
245.01 ms (88.88%) |
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 416680 421922 422155 424332 424375 424648 426416 427263 428761 429848 432929 432955 433323 436703 439621 439728 439749 439764 440693 446109 446894 447095 448773 448954 451157 453906 455941 456202 458191 459513 459565 460325 460431 464724 464953 465075 467555 473139 481144 482534 482570 485061 485527 486643 490261 493083 494233 496526 496794 497921 497923 499182 502249 503617 511675 513832 515538 515633 517564 517779 518111 518151 519561 519563 523021 523840 527218 528308 528382 528702 529143 531189 533848 534023 535282 537670 537672 537815 537914 540267 541074 541076 551991 562626 564533 572716 577400 577593 584236 585079 588517 590469 594353 599967 600995 604419 606624 609531 620124 621548 626136 629967 632020 634193 637016 637421 639810 647328 658208 659215 668528 679657 681121 693778 693799 725153 750701 786552 810109 814850 ] |
||||||||||||||||||||||||||||||
|
20.58 ms (7.46%) |
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 786552 750701 447095 481144 440693 460325 421922 456202 497923 523840 448954 494233 523021 432955 534023 658208 693799 486643 493083 540267 496526 606624 637016 439621 439749 604419 639810 814850 485527 531189 533848 490261 541074 577593 647328 725153 416680 511675 429848 459565 464724 499182 502249 518111 562626 659215 551991 436703 424375 424648 465075 439728 527218 537914 464953 432929 529143 439764 422155 517564 621548 459513 485061 517779 634193 424332 482570 515633 577400 668528 455941 515538 448773 453906 528702 681121 609531 594353 467555 458191 433323 679657 588517 541076 626136 497921 564533 620124 426416 528382 496794 629967 473139 503617 585079 537672 535282 537670 600995 428761 482534 519561 519563 572716 632020 590469 427263 537815 518151 460431 528308 446109 446894 584236 451157 693778 810109 599967 637421 513832 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (0.96%) |
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 416680 421922 422155 424332 424375 424648 426416 427263 428761 429848 432929 432955 433323 436703 439621 439728 439749 439764 440693 446109 446894 447095 448773 448954 451157 453906 455941 456202 458191 459513 459565 460325 460431 464724 464953 465075 467555 473139 481144 482534 482570 485061 485527 486643 490261 493083 494233 496526 496794 497921 497923 499182 502249 503617 511675 513832 515538 515633 517564 517779 518111 518151 519561 519563 523021 523840 527218 528308 528382 528702 529143 531189 533848 534023 535282 537670 537672 537815 537914 540267 541074 541076 551991 562626 564533 572716 577400 577593 584236 585079 588517 590469 594353 599967 600995 604419 606624 609531 620124 621548 626136 629967 632020 634193 637016 637421 639810 647328 658208 659215 668528 679657 681121 693778 693799 725153 750701 786552 810109 814850 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал real"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal real"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал real"
]
|
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.