Query Metrics
7
Database Queries
7
Different statements
116.78 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.39 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.73 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sexwife russian"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.43 ms |
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 391909 471569 533779 470577 543977 546664 567581 533761 566446 702140 691640 745491 780949 763553 470592 530289 479175 534104 743846 768245 755167 543721 655603 795202 461983 613309 492081 553645 546667 593837 641792 768423 392178 764082 759327 663546 569579 429857 453670 470565 392109 567222 574000 731058 470634 582321 492054 509853 483970 547952 719461 609574 778243 748542 397895 470628 429538 456419 492690 443926 492689 495193 567539 460528 522442 461932 526329 509852 648657 702125 488331 423940 474957 548319 605735 517579 454127 507767 513953 517556 518003 470584 485398 478562 456684 516823 542082 548056 525337 ] |
||||||||||||||||||||||||||||||
| 4 | 2.92 ms |
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 391909 392109 392178 397895 423940 429538 429857 443926 453670 454127 456419 456684 460528 461932 461983 470565 470577 470584 470592 470628 470634 471569 474957 478562 479175 483970 485398 488331 492054 492081 492689 492690 495193 507767 509852 509853 513953 516823 517556 517579 518003 522442 525337 526329 530289 533761 533779 534104 542082 543721 543977 546664 546667 547952 548056 548319 553645 566446 567222 567539 567581 569579 574000 582321 593837 605735 609574 613309 641792 648657 655603 663546 691640 702125 702140 719461 731058 743846 745491 748542 755167 759327 763553 764082 768245 768423 778243 780949 795202 ] |
||||||||||||||||||||||||||||||
| 5 | 95.16 ms |
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 391909 392109 392178 397895 423940 429538 429857 443926 453670 454127 456419 456684 460528 461932 461983 470565 470577 470584 470592 470628 470634 471569 474957 478562 479175 483970 485398 488331 492054 492081 492689 492690 495193 507767 509852 509853 513953 516823 517556 517579 518003 522442 525337 526329 530289 533761 533779 534104 542082 543721 543977 546664 546667 547952 548056 548319 553645 566446 567222 567539 567581 569579 574000 582321 593837 605735 609574 613309 641792 648657 655603 663546 691640 702125 702140 719461 731058 743846 745491 748542 755167 759327 763553 764082 768245 768423 778243 780949 795202 ] |
||||||||||||||||||||||||||||||
| 6 | 1.81 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск sexwife русск"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.34 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск sexwife русск"
]
|
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.