Query Metrics
7
Database Queries
7
Different statements
155.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.61 ms (82.48%) |
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 381776 382450 389364 397849 402085 413134 424481 425875 426481 427946 428368 429313 429328 446179 447076 447511 447529 447551 447571 448616 454066 455855 462091 466113 469824 472249 473937 474964 481297 485258 485589 490945 491654 494705 496795 499018 502722 502729 504320 511707 512247 512269 512306 514384 519141 520421 522244 523222 525681 527627 527630 527632 529471 530734 535006 536868 538198 538368 538372 538816 541888 551212 552099 552650 552798 554365 558839 558999 560520 564711 565742 565771 568566 573566 573663 574490 574585 574601 574605 574800 574803 574807 575062 575093 575103 575206 575735 575807 576083 576371 576374 576399 576638 580661 597812 598558 599246 599542 599734 601472 613823 623815 626482 634505 645926 646183 646205 653545 664157 667810 671888 679365 696226 721187 722258 799262 800198 804180 807527 817430 ] |
||||||||||||||||||||||||||||||
|
18.04 ms (11.57%) |
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 554365 558839 564711 565742 568566 573566 574601 574605 574800 574803 574807 575062 575093 575735 575807 576371 646183 646205 664157 696226 721187 645926 653545 679365 722258 667810 671888 551212 552099 552650 552798 558999 565771 573663 574490 574585 575103 575206 576083 576374 580661 598558 599734 601472 626482 613823 599246 597812 599542 623815 634505 800198 807527 804180 799262 382450 402085 424481 425875 429313 429328 447571 473937 481297 447511 447529 454066 462091 428368 446179 474964 447076 447551 466113 472249 520421 523222 527627 491654 494705 504320 527630 485589 496795 499018 502722 511707 512269 514384 519141 522244 538368 538372 485258 490945 502729 527632 529471 538198 427946 535006 576399 560520 541888 576638 381776 389364 397849 413134 426481 817430 469824 455855 448616 525681 530734 536868 512306 512247 538816 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.81%) |
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 381776 382450 389364 397849 402085 413134 424481 425875 426481 427946 428368 429313 429328 446179 447076 447511 447529 447551 447571 448616 454066 455855 462091 466113 469824 472249 473937 474964 481297 485258 485589 490945 491654 494705 496795 499018 502722 502729 504320 511707 512247 512269 512306 514384 519141 520421 522244 523222 525681 527627 527630 527632 529471 530734 535006 536868 538198 538368 538372 538816 541888 551212 552099 552650 552798 554365 558839 558999 560520 564711 565742 565771 568566 573566 573663 574490 574585 574601 574605 574800 574803 574807 575062 575093 575103 575206 575735 575807 576083 576371 576374 576399 576638 580661 597812 598558 599246 599542 599734 601472 613823 623815 626482 634505 645926 646183 646205 653545 664157 667810 671888 679365 696226 721187 722258 799262 800198 804180 807527 817430 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking porn"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза porn"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза porn"
]
|
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.