Query Metrics
7
Database Queries
7
Different statements
143.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.13 ms (82.32%) |
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 461921 490267 496061 510556 510685 511904 514341 527761 544140 549559 550464 550466 550806 552358 554215 566418 569354 569971 577638 584145 584261 584517 590621 591931 592396 593714 595831 597547 598433 601597 602291 602511 604349 606210 610689 631851 633746 636230 638770 640098 640737 647043 647743 652613 656488 656545 656643 662204 663231 664532 678012 704654 706727 706931 710189 713855 714986 715886 717886 719454 720232 725645 729160 731243 735338 736204 736603 736735 737321 740888 743436 743905 744044 747474 747558 749793 750223 750349 750539 751441 751761 753638 754200 756331 756498 756685 757298 759914 761500 761521 761997 763059 765100 765464 765647 766101 766969 767399 768760 769039 774495 776304 777694 786328 786988 788650 792649 794369 794917 796384 796880 801535 803457 804194 805030 812266 813906 814138 ] |
||||||||||||||||||||||||||||||
|
14.66 ms (10.22%) |
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 737321 765464 725645 756685 757298 768760 735338 747474 749793 765647 710189 714986 715886 717886 796880 566418 704654 756498 766101 510556 511904 550466 550806 584261 549559 550464 664532 678012 719454 713855 664379 569971 602291 631851 593714 601597 604349 636230 638770 640098 786328 805030 761500 796384 744044 761997 765100 750349 767399 729160 731243 750223 794369 813906 652613 662204 663231 610689 598433 743905 753638 490267 577638 647743 606210 777694 776304 761521 792649 794917 736735 754200 756331 763059 786988 788650 814138 510685 514341 527761 544140 554215 552358 590621 591931 592396 602511 774495 812266 759914 803457 766969 736603 743436 751761 747558 736204 740888 750539 751441 633746 640737 804194 461921 706931 595831 597547 769039 801535 496061 569354 584145 584517 656488 706727 713291 647043 656643 720232 656545 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (2.11%) |
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 461921 490267 496061 510556 510685 511904 514341 527761 544140 549559 550464 550466 550806 552358 554215 566418 569354 569971 577638 584145 584261 584517 590621 591931 592396 593714 595831 597547 598433 601597 602291 602511 604349 606210 610689 631851 633746 636230 638770 640098 640737 647043 647743 652613 656488 656545 656643 662204 663231 664532 678012 704654 706727 706931 710189 713855 714986 715886 717886 719454 720232 725645 729160 731243 735338 736204 736603 736735 737321 740888 743436 743905 744044 747474 747558 749793 750223 750349 750539 751441 751761 753638 754200 756331 756498 756685 757298 759914 761500 761521 761997 763059 765100 765464 765647 766101 766969 767399 768760 769039 774495 776304 777694 786328 786988 788650 792649 794369 794917 796384 796880 801535 803457 804194 805030 812266 813906 814138 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс перв раз"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс вперв"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.