Query Metrics
7
Database Queries
7
Different statements
158.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.38 ms (82.72%) |
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 387366 389458 395741 403579 404678 407505 407605 407644 411689 412262 413795 415541 416848 416850 418972 421838 427561 428837 432838 442750 443124 446135 446313 447961 448064 451501 452624 453013 453102 454056 454280 454295 455392 456612 456613 456614 456618 457420 460446 460671 460730 460742 463158 464868 465364 465380 466195 466208 466215 466256 468076 468641 470272 470279 470287 470459 471073 471617 472276 473489 474681 474686 474693 474695 474696 474700 474703 476335 477727 477991 480375 481467 484627 484629 484644 484670 484775 485695 486902 486915 489169 490873 490901 490908 491986 492272 494809 497497 497773 503444 528355 531528 533483 535012 544452 544524 546940 549507 549737 561507 562168 563060 563063 563128 563220 584019 584377 589709 592955 604290 607583 619663 631616 658797 665314 667543 675637 684265 761756 791803 ] |
||||||||||||||||||||||||||||||
|
18.32 ms (11.54%) |
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 489169 387366 456612 468641 484775 546940 563063 665314 465380 466256 465364 466195 470272 471073 471617 477991 474703 484627 490873 486915 492272 485695 491986 456614 404678 466208 466215 468076 463158 474696 484629 415541 416848 418972 416850 411689 460671 473489 446135 448064 453013 497497 503444 535012 533483 544524 544452 667543 684265 592955 619663 791803 761756 395741 407605 421838 413795 451501 452624 476335 454280 460730 464868 481467 490908 494809 407505 412262 477727 631616 589709 460742 474700 457420 470459 428837 470287 474681 474695 528355 484670 490901 456618 474693 474686 484644 403579 427561 446313 454295 456613 447961 480375 486902 531528 497773 460446 563060 562168 563128 549507 563220 584019 584377 675637 658797 549737 561507 607583 604290 407644 432838 443124 453102 454056 389458 442750 455392 470279 472276 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.72%) |
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 387366 389458 395741 403579 404678 407505 407605 407644 411689 412262 413795 415541 416848 416850 418972 421838 427561 428837 432838 442750 443124 446135 446313 447961 448064 451501 452624 453013 453102 454056 454280 454295 455392 456612 456613 456614 456618 457420 460446 460671 460730 460742 463158 464868 465364 465380 466195 466208 466215 466256 468076 468641 470272 470279 470287 470459 471073 471617 472276 473489 474681 474686 474693 474695 474696 474700 474703 476335 477727 477991 480375 481467 484627 484629 484644 484670 484775 485695 486902 486915 489169 490873 490901 490908 491986 492272 494809 497497 497773 503444 528355 531528 533483 535012 544452 544524 546940 549507 549737 561507 562168 563060 563063 563128 563220 584019 584377 589709 592955 604290 607583 619663 631616 658797 665314 667543 675637 684265 761756 791803 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mommy mature"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mommy mature"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mommy 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.