Query Metrics
7
Database Queries
7
Different statements
348.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
324.68 ms (93.11%) |
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 328609 379330 382256 396586 402754 483384 491178 508921 520988 529735 531576 532191 534717 537806 538165 539400 542677 542994 548499 553470 553647 557139 574985 583545 584338 585530 600419 604079 609452 617081 618651 619790 630654 633548 639364 641359 644709 645730 647074 648311 651565 654984 657759 659565 659675 661435 668145 669604 673580 684230 690830 692363 692481 693158 699145 701283 711850 713168 713658 714905 716599 716729 717229 717261 718731 719737 719755 723116 726047 726392 726987 733059 733175 733938 733963 734064 734239 736428 741041 746670 748918 752382 754004 755419 755919 755938 758591 760990 762426 763357 763458 771750 776835 780040 781600 788203 791970 793409 793461 799777 801414 803168 810219 810234 813896 815332 815343 816539 817765 817829 818511 819122 820801 822203 823320 824840 825011 825021 825207 825646 ] |
||||||||||||||||||||||||||||||
|
12.72 ms (3.65%) |
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 701283 825011 825021 692481 716729 644709 771750 736428 762426 818511 815332 793409 548499 825207 402754 820801 822203 542677 741041 726047 657759 815343 699145 673580 641359 758591 714905 491178 713658 531576 529735 508921 539400 734239 733938 604079 617081 813896 557139 574985 618651 726392 819122 538165 483384 553470 718731 651565 668145 645730 669604 609452 799777 752382 717229 723116 396586 754004 659565 553647 585530 633548 781600 733963 733059 630654 534717 537806 600419 379330 788203 816539 825646 532191 654984 716599 755919 755938 717261 793461 748918 328609 520988 542994 647074 659675 713168 661435 692363 693158 639364 619790 791970 780040 733175 810219 763458 719755 817765 755419 584338 690830 746670 803168 382256 817829 824840 684230 776835 801414 823320 583545 648311 719737 711850 810234 760990 726987 734064 763357 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (0.86%) |
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 328609 379330 382256 396586 402754 483384 491178 508921 520988 529735 531576 532191 534717 537806 538165 539400 542677 542994 548499 553470 553647 557139 574985 583545 584338 585530 600419 604079 609452 617081 618651 619790 630654 633548 639364 641359 644709 645730 647074 648311 651565 654984 657759 659565 659675 661435 668145 669604 673580 684230 690830 692363 692481 693158 699145 701283 711850 713168 713658 714905 716599 716729 717229 717261 718731 719737 719755 723116 726047 726392 726987 733059 733175 733938 733963 734064 734239 736428 741041 746670 748918 752382 754004 755419 755919 755938 758591 760990 762426 763357 763458 771750 776835 780040 781600 788203 791970 793409 793461 799777 801414 803168 810219 810234 813896 815332 815343 816539 817765 817829 818511 819122 820801 822203 823320 824840 825011 825021 825207 825646 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock глубокийминет минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock deepthroat"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.