Query Metrics
7
Database Queries
7
Different statements
147.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.10 ms (83.92%) |
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 6741 395826 395856 395981 401305 404939 405809 409901 411069 421537 424023 431498 444142 444414 447920 453624 454272 456063 462506 466023 473139 477020 477409 502717 504764 511889 515202 518566 520003 523680 527116 530578 542942 552534 554068 555530 561897 562114 566886 568440 574089 576043 580276 581206 583210 584666 587431 587532 593172 593900 594095 594261 595127 595654 599011 605329 605841 606258 607086 609712 615622 616481 617603 622509 623413 624487 624508 628289 663414 672744 675424 692337 693341 693457 694116 702320 707881 714822 715077 716675 718889 719143 720821 721120 721496 723932 732775 733295 736866 740489 743009 747954 753548 753677 756521 756567 758465 761862 762559 770444 775284 775630 786715 787616 787950 789870 790101 790391 797247 800275 800377 801272 801305 803144 803244 803261 805257 807183 807663 823300 ] |
||||||||||||||||||||||||||||||
|
14.86 ms (10.05%) |
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 523680 542942 562114 568440 566886 581206 583210 584666 552534 554068 693341 707881 714822 675424 720821 617603 606258 609712 624508 587532 599011 587431 595654 775630 789870 786715 790101 801305 803144 803261 770444 787950 797247 800377 736866 740489 723932 732775 743009 753548 758465 761862 762559 753677 747954 702320 715077 775284 800275 803244 805257 807663 424023 477409 405809 454272 456063 462506 444142 444414 453624 502717 530578 473139 6741 515202 607086 594261 787616 431498 623413 504764 511889 580276 672744 692337 716675 616481 605841 615622 622509 593172 593900 594095 733295 624487 628289 411069 409901 823300 718889 694116 721496 663414 693457 721120 605329 801272 790391 807183 756521 756567 719143 466023 395826 401305 404939 421537 447920 576043 395981 395856 518566 520003 477020 555530 595127 527116 561897 574089 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.63%) |
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 6741 395826 395856 395981 401305 404939 405809 409901 411069 421537 424023 431498 444142 444414 447920 453624 454272 456063 462506 466023 473139 477020 477409 502717 504764 511889 515202 518566 520003 523680 527116 530578 542942 552534 554068 555530 561897 562114 566886 568440 574089 576043 580276 581206 583210 584666 587431 587532 593172 593900 594095 594261 595127 595654 599011 605329 605841 606258 607086 609712 615622 616481 617603 622509 623413 624487 624508 628289 663414 672744 675424 692337 693341 693457 694116 702320 707881 714822 715077 716675 718889 719143 720821 721120 721496 723932 732775 733295 736866 740489 743009 747954 753548 753677 756521 756567 758465 761862 762559 770444 775284 775630 786715 787616 787950 789870 790101 790391 797247 800275 800377 801272 801305 803144 803244 803261 805257 807183 807663 823300 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur old man"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск old мужчин"
]
|
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.