Query Metrics
7
Database Queries
7
Different statements
208.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.42 ms (87.62%) |
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 114360 140181 156525 383744 384527 384793 388591 390363 394103 394243 396983 401119 407177 408000 415722 417303 417634 419843 445565 445928 447850 448584 453843 454785 456952 462546 470340 484832 487173 488352 492061 495750 502119 502435 502441 507814 511515 512319 521235 534778 538406 539013 547082 549397 550285 551149 552008 552898 563986 576371 580710 581001 583688 585159 593622 593672 593853 593858 593883 594774 596604 601958 613001 617664 624866 625532 628185 630908 641757 650810 650818 651940 652202 652577 653740 654269 659305 663467 663482 663493 665123 665182 667290 669430 670513 674330 676907 677587 693410 693772 703212 706933 711286 712823 714086 717631 723592 724410 728370 729536 730098 730914 731801 734825 737098 737728 741203 742834 745999 747249 748552 748999 750809 753257 776892 780774 796970 807677 808167 825500 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (7.25%) |
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 613001 594774 593883 741203 731801 750809 734825 453843 484832 114360 156525 447850 445928 521235 550285 651940 652202 677587 654269 659305 676907 706933 712823 714086 717631 650810 665123 630908 807677 729536 748999 753257 737728 745999 748552 808167 470340 492061 487173 538406 140181 384527 625532 384793 723592 825500 534778 495750 547082 551149 669430 670513 617664 593858 776892 747249 711286 780774 415722 454785 419843 796970 401119 693410 593853 552008 653740 390363 663482 641757 394103 383744 552898 511515 549397 663467 585159 388591 408000 417303 456952 502119 539013 580710 583688 576371 581001 667290 674330 693772 624866 593622 596604 724410 448584 462546 488352 502435 417634 394243 396983 407177 507814 502441 512319 665182 650818 652577 703212 663493 563986 628185 593672 601958 730914 737098 728370 730098 742834 445565 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.64%) |
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 114360 140181 156525 383744 384527 384793 388591 390363 394103 394243 396983 401119 407177 408000 415722 417303 417634 419843 445565 445928 447850 448584 453843 454785 456952 462546 470340 484832 487173 488352 492061 495750 502119 502435 502441 507814 511515 512319 521235 534778 538406 539013 547082 549397 550285 551149 552008 552898 563986 576371 580710 581001 583688 585159 593622 593672 593853 593858 593883 594774 596604 601958 613001 617664 624866 625532 628185 630908 641757 650810 650818 651940 652202 652577 653740 654269 659305 663467 663482 663493 665123 665182 667290 669430 670513 674330 676907 677587 693410 693772 703212 706933 711286 712823 714086 717631 723592 724410 728370 729536 730098 730914 731801 734825 737098 737728 741203 742834 745999 747249 748552 748999 750809 753257 776892 780774 796970 807677 808167 825500 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens sex"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens секс"
]
|
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.