Query Metrics
7
Database Queries
7
Different statements
189.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.41 ms (87.10%) |
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 387146 394376 400143 401466 408293 413216 420540 427536 428472 428826 431691 442204 446022 451086 460179 464404 464407 465834 469061 479019 484768 494735 498501 502306 507834 509503 512895 513116 515031 516209 516886 516966 517278 518312 518927 519934 520021 522168 523323 524783 527151 529305 531528 531935 536347 537562 537729 538918 539501 547297 547323 547331 550007 550710 556656 556799 569746 601234 601520 604593 609823 629846 633426 689336 692115 699654 700288 702978 713035 718511 722191 723588 726210 727520 729570 734227 743817 744540 745630 746621 747924 747939 752928 755465 765304 768208 768560 769547 769978 771394 782564 787105 789671 795714 797844 797952 800939 801323 804770 805717 806348 807365 807367 807377 807925 813486 814565 815537 817043 817910 818423 818427 818467 818869 819231 819988 823536 823618 825004 ] |
||||||||||||||||||||||||||||||
|
14.30 ms (7.53%) |
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 722191 819988 539501 789671 531935 428472 464404 507834 516966 517278 516209 522168 818869 817043 537562 556799 713035 718511 797952 609823 692115 807377 765304 494735 550710 744540 524783 510295 420540 519934 817910 819231 805717 745630 752928 768208 702978 806348 536347 498501 446022 464407 460179 427536 428826 451086 479019 509503 520021 516886 523323 529305 513116 515031 814565 556656 743817 807367 818467 815537 825004 818427 823618 538918 547323 547331 550007 569746 547297 700288 689336 699654 633426 601520 629846 804770 813486 769978 747939 726210 729570 747924 771394 795714 394376 408293 401466 818423 782564 807365 734227 746621 823536 413216 601234 400143 537729 531528 801323 769547 431691 465834 484768 512895 442204 502306 469061 518927 723588 604593 727520 755465 787105 797844 807925 800939 387146 768560 527151 518312 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.73%) |
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 387146 394376 400143 401466 408293 413216 420540 427536 428472 428826 431691 442204 446022 451086 460179 464404 464407 465834 469061 479019 484768 494735 498501 502306 507834 509503 512895 513116 515031 516209 516886 516966 517278 518312 518927 519934 520021 522168 523323 524783 527151 529305 531528 531935 536347 537562 537729 538918 539501 547297 547323 547331 550007 550710 556656 556799 569746 601234 601520 604593 609823 629846 633426 689336 692115 699654 700288 702978 713035 718511 722191 723588 726210 727520 729570 734227 743817 744540 745630 746621 747924 747939 752928 755465 765304 768208 768560 769547 769978 771394 782564 787105 789671 795714 797844 797952 800939 801323 804770 805717 806348 807365 807367 807377 807925 813486 814565 815537 817043 817910 818423 818427 818467 818869 819231 819988 823536 823618 825004 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex mom beauty"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mom beauty"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mom beauty"
]
|
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.