Query Metrics
7
Database Queries
7
Different statements
144.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.66 ms (83.98%) |
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 554990 556825 571695 574227 578045 579902 582203 585633 587787 587831 588054 588302 589235 591112 591120 591708 593031 596071 596253 596770 598429 599813 600223 600265 600783 600853 601860 603343 603383 604090 604840 605137 605233 605262 605265 612700 615395 618284 618341 619431 627153 629334 633836 635721 637318 637454 637877 639624 639642 639841 641435 641767 642326 643405 643543 644016 645366 650503 661039 669896 699764 706587 710937 713442 715413 718950 720527 724122 726122 733824 738092 740458 742317 745476 748509 752194 752865 752915 757093 758287 760148 760158 763393 763874 768607 770122 770231 771944 773259 774757 776816 776868 777654 777715 781269 781832 781835 782665 783308 785157 785750 787337 787677 790407 793506 797032 800680 801617 802739 804403 805355 805560 807210 808707 810444 810801 811109 811308 812489 812545 ] |
||||||||||||||||||||||||||||||
|
13.47 ms (9.30%) |
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 699764 713442 715413 718950 645366 650503 661039 669896 706587 710937 720527 554990 556825 571695 574227 578045 579902 582203 588054 591120 591708 593031 598429 603383 633836 637877 588302 600265 605262 615395 618284 629334 642326 585633 587787 587831 596071 596253 600223 600853 601860 603343 604090 604840 605233 619431 635721 637318 639624 639642 643405 643543 589235 591112 596770 599813 600783 605137 605265 612700 618341 627153 637454 639841 641435 641767 644016 774757 776816 777654 777715 781832 781835 782665 785157 785750 787337 790407 800680 802739 805560 810444 810801 811308 812489 812545 776868 797032 801617 804403 805355 811109 738092 742317 745476 752915 757093 758287 760158 763393 770231 771944 773259 781269 783308 787677 793506 807210 808707 724122 726122 733824 740458 748509 752194 752865 760148 763874 768607 770122 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.24%) |
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 554990 556825 571695 574227 578045 579902 582203 585633 587787 587831 588054 588302 589235 591112 591120 591708 593031 596071 596253 596770 598429 599813 600223 600265 600783 600853 601860 603343 603383 604090 604840 605137 605233 605262 605265 612700 615395 618284 618341 619431 627153 629334 633836 635721 637318 637454 637877 639624 639642 639841 641435 641767 642326 643405 643543 644016 645366 650503 661039 669896 699764 706587 710937 713442 715413 718950 720527 724122 726122 733824 738092 740458 742317 745476 748509 752194 752865 752915 757093 758287 760148 760158 763393 763874 768607 770122 770231 771944 773259 774757 776816 776868 777654 777715 781269 781832 781835 782665 783308 785157 785750 787337 787677 790407 793506 797032 800680 801617 802739 804403 805355 805560 807210 808707 810444 810801 811109 811308 812489 812545 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"erotic mom"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эротик mom"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"эротик mom"
]
|
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.