Query Metrics
7
Database Queries
7
Different statements
177.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.17 ms (86.94%) |
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 69876 69940 147173 385166 396335 396909 398399 399952 401570 401630 407550 426211 437486 443359 447813 447940 462899 466654 469189 482995 497749 500533 500943 500945 505291 508268 508279 523946 528307 529394 529834 532571 538746 567037 568513 580354 580624 580652 583077 587087 594469 615897 619602 621509 622649 629828 633480 641533 647721 652964 682929 689898 695782 700853 701447 709340 710795 714949 717120 718685 718856 723454 725025 726454 729928 732027 735982 738911 739920 746432 746612 749538 750276 751357 755445 755959 756620 757006 757117 762339 763393 767798 769643 771311 771909 772863 773019 773639 775484 776057 777033 777046 778810 779014 783355 783928 783937 783945 786456 788091 788259 792024 792166 797286 797287 800026 801300 802227 802231 803448 804301 805261 805336 806097 807472 809640 812082 812434 813984 824800 ] |
||||||||||||||||||||||||||||||
|
13.65 ms (7.70%) |
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 778810 786456 800026 805336 812434 399952 443359 385166 532571 523946 615897 776057 802227 802231 807472 783945 755445 622649 812082 824800 647721 147173 401630 508279 528307 729928 633480 69940 437486 447813 462899 500943 505291 529394 500945 508268 580624 580652 482995 396335 396909 813984 652964 682929 700853 710795 580354 594469 621509 805261 797287 732027 757117 783928 773019 756620 769643 771311 762339 735982 751357 771909 641533 709340 718685 792024 806097 447940 466654 69876 398399 469189 529834 538746 568513 567037 583077 689898 718856 701447 714949 717120 695782 723454 587087 619602 629828 775484 777046 792166 777033 779014 788259 804301 757006 763393 772863 773639 783355 788091 809640 725025 726454 739920 746612 755959 738911 746432 749538 750276 767798 783937 797286 801300 803448 426211 401570 497749 407550 500533 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.35%) |
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 69876 69940 147173 385166 396335 396909 398399 399952 401570 401630 407550 426211 437486 443359 447813 447940 462899 466654 469189 482995 497749 500533 500943 500945 505291 508268 508279 523946 528307 529394 529834 532571 538746 567037 568513 580354 580624 580652 583077 587087 594469 615897 619602 621509 622649 629828 633480 641533 647721 652964 682929 689898 695782 700853 701447 709340 710795 714949 717120 718685 718856 723454 725025 726454 729928 732027 735982 738911 739920 746432 746612 749538 750276 751357 755445 755959 756620 757006 757117 762339 763393 767798 769643 771311 771909 772863 773019 773639 775484 776057 777033 777046 778810 779014 783355 783928 783937 783945 786456 788091 788259 792024 792166 797286 797287 800026 801300 802227 802231 803448 804301 805261 805336 806097 807472 809640 812082 812434 813984 824800 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation girl"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк девушк"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
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.