Query Metrics
7
Database Queries
7
Different statements
153.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.86 ms (85.33%) |
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 15364 185589 382443 382761 398922 402570 402585 410853 412899 418485 426912 436632 436644 436646 436862 452702 459436 460841 467861 472908 490060 502103 508468 516215 524717 528744 530351 530353 530361 532089 537552 537579 542776 543796 544360 547342 549266 549394 549898 549910 549946 549950 549955 551708 562609 566799 567052 570780 570783 570806 571549 572505 583841 612288 612296 612754 622405 627695 629859 631986 632816 641654 642788 654530 656368 656426 657305 657591 658063 659662 668429 668845 674899 676599 679309 695636 696126 697379 700745 712092 715431 715703 717833 718479 729784 732410 733202 734256 735699 740193 741109 744337 747219 747632 760488 768117 772118 773210 780550 780719 784415 786133 786399 786502 788991 794643 795252 795378 813312 818362 818762 818839 819965 825770 826104 826339 826421 827613 828057 ] |
||||||||||||||||||||||||||||||
|
11.78 ms (7.68%) |
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 524717 410853 508468 715703 740193 490060 467861 641654 459436 516215 741109 784415 780550 402570 452702 542776 632816 436646 426912 715431 402585 794643 795378 412899 436632 768117 382761 436644 631986 718479 813312 733202 772118 436862 747219 418485 744337 460841 472908 530351 502103 528744 826421 696126 734256 828057 567052 824020 551708 826104 549946 622405 818362 549950 612288 729784 732410 382443 760488 825770 544360 668429 695636 629859 642788 612754 788991 747632 819965 549910 697379 658063 674899 818762 532089 562609 570780 712092 627695 780719 773210 537579 530361 656368 583841 185589 398922 668845 571549 818839 826339 543796 566799 570783 676599 547342 549266 572505 786133 786399 700745 827613 530353 537552 549955 570806 549394 657591 679309 549898 786502 795252 735699 717833 15364 657305 654530 656426 659662 612296 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.95%) |
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 15364 185589 382443 382761 398922 402570 402585 410853 412899 418485 426912 436632 436644 436646 436862 452702 459436 460841 467861 472908 490060 502103 508468 516215 524717 528744 530351 530353 530361 532089 537552 537579 542776 543796 544360 547342 549266 549394 549898 549910 549946 549950 549955 551708 562609 566799 567052 570780 570783 570806 571549 572505 583841 612288 612296 612754 622405 627695 629859 631986 632816 641654 642788 654530 656368 656426 657305 657591 658063 659662 668429 668845 674899 676599 679309 695636 696126 697379 700745 712092 715431 715703 717833 718479 729784 732410 733202 734256 735699 740193 741109 744337 747219 747632 760488 768117 772118 773210 780550 780719 784415 786133 786399 786502 788991 794643 795252 795378 813312 818362 818762 818839 819965 825770 826104 826339 826421 827613 828057 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kissing girl"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"kissing девушк"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"kissing девушк"
]
|
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.