Query Metrics
7
Database Queries
7
Different statements
386.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.01 ms (55.08%) |
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 54301 396762 397981 427239 446868 460855 464639 466486 468862 476956 478346 480248 483982 486174 486271 488532 497331 497335 498438 506487 509837 513766 514067 526012 530097 533238 535272 538601 539338 544666 549519 550592 561536 581042 585804 587829 591741 593542 595104 595701 596133 599049 607142 611039 615943 620757 621337 625250 626344 640050 645048 646228 650096 650366 659318 665507 684916 687056 697180 697427 697631 710510 715816 715859 716403 716860 718203 718527 727143 728605 731423 731880 733045 734740 736461 740154 740524 741803 741877 742568 744556 748159 748226 750790 752266 762561 763054 765328 765640 767267 769258 770605 772287 772681 774918 781980 783866 784471 791567 792189 794840 794933 794974 794977 795272 795497 797883 803938 808013 811054 811259 811274 813621 814103 814728 817933 818488 819363 823488 825756 ] |
||||||||||||||||||||||||||||||
|
149.38 ms (38.63%) |
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 54301 396762 397981 427239 446868 460855 464639 466486 468862 476956 478346 480248 483982 486174 486271 488532 497331 497335 498438 506487 509837 513766 514067 526012 530097 533238 535272 538601 539338 544666 549519 550592 561536 581042 585804 587829 591741 593542 595104 595701 596133 599049 607142 611039 615943 620757 621337 625250 626344 640050 645048 646228 650096 650366 659318 665507 684916 687056 697180 697427 697631 710510 715816 715859 716403 716860 718203 718527 727143 728605 731423 731880 733045 734740 736461 740154 740524 741803 741877 742568 744556 748159 748226 750790 752266 762561 763054 765328 765640 767267 769258 770605 772287 772681 774918 781980 783866 784471 791567 792189 794840 794933 794974 794977 795272 795497 797883 803938 808013 811054 811259 811274 813621 814103 814728 817933 818488 819363 823488 825756 ] |
||||||||||||||||||||||||||||||
|
16.36 ms (4.23%) |
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 585804 765328 733045 741877 770605 818488 509837 736461 397981 506487 716403 784471 803938 396762 752266 825756 464639 561536 593542 783866 767267 794840 819363 535272 665507 687056 762561 765640 478346 460855 715859 488532 549519 621337 476956 513766 620757 640050 811274 480248 792189 772287 446868 514067 533238 539338 716860 772681 817933 823488 526012 538601 650366 684916 650096 595104 587829 599049 769258 794977 731423 731880 740524 742568 763054 697631 466486 497335 813621 498438 544666 646228 697180 591741 794974 795497 808013 811259 727143 740154 748226 794933 748159 750790 715816 427239 645048 595701 615943 54301 550592 596133 611039 734740 744556 625250 795272 814728 814103 486174 710510 607142 791567 811054 728605 741803 797883 718203 781980 468862 497331 486271 483982 530097 581042 659318 697427 718527 626344 774918 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sucking big tits"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sucking большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sucking большие сиськ"
]
|
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.