Query Metrics
7
Database Queries
7
Different statements
144.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.00 ms (85.73%) |
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 390928 514925 529922 532879 536111 541915 541920 553221 554836 556896 576869 586100 588427 588429 589428 589572 589652 589807 589882 591451 591869 593241 595590 598267 603345 604807 605628 610144 610953 613943 614182 615398 619094 623830 625819 629723 636959 637697 638398 643978 644216 647030 649008 650232 664623 666058 671561 691362 692772 700033 700947 702318 703946 705634 707481 708626 710795 711975 712239 712628 713367 713453 714253 714365 719451 735535 736028 736339 740169 740450 741243 743994 744003 746190 746191 752447 752771 752938 753688 753699 754341 754434 756562 756785 757190 759036 761953 766285 767830 768503 770049 776469 777299 777529 778768 781424 783247 784019 784035 784047 785136 785461 790396 791861 796433 797035 803478 804241 804251 804482 808010 811024 811060 812235 812383 819246 821402 821988 825376 ] |
||||||||||||||||||||||||||||||
|
11.78 ms (8.14%) |
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 705634 708626 714253 664623 671561 692772 710795 712628 713367 556896 589428 589882 605628 615398 636959 643978 589807 614182 586100 588429 598267 619094 591451 595590 610144 623830 776469 790396 812383 753699 770049 785461 804251 808010 761953 741243 754341 754434 759036 735535 753688 768503 746190 625819 638398 703946 714365 784019 784035 784047 785136 791861 811060 390928 821402 825376 819246 821988 536111 514925 529922 532879 541915 541920 553221 650232 666058 691362 700947 702318 707481 713453 649008 700033 711975 647030 712239 719451 554836 576869 589572 593241 603345 629723 644216 588427 589652 591869 604807 637697 610953 613943 777299 777529 778768 803478 804482 783247 797035 811024 752447 766285 769374 781424 796433 804241 812235 740450 743994 736028 746191 756785 757190 736339 740169 744003 752938 756562 767830 752771 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.59%) |
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 390928 514925 529922 532879 536111 541915 541920 553221 554836 556896 576869 586100 588427 588429 589428 589572 589652 589807 589882 591451 591869 593241 595590 598267 603345 604807 605628 610144 610953 613943 614182 615398 619094 623830 625819 629723 636959 637697 638398 643978 644216 647030 649008 650232 664623 666058 671561 691362 692772 700033 700947 702318 703946 705634 707481 708626 710795 711975 712239 712628 713367 713453 714253 714365 719451 735535 736028 736339 740169 740450 741243 743994 744003 746190 746191 752447 752771 752938 753688 753699 754341 754434 756562 756785 757190 759036 761953 766285 767830 768503 770049 776469 777299 777529 778768 781424 783247 784019 784035 784047 785136 785461 790396 791861 796433 797035 803478 804241 804251 804482 808010 811024 811060 812235 812383 819246 821402 821988 825376 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo big pussy"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло большие pussy"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.