Query Metrics
7
Database Queries
7
Different statements
169.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.94 ms (84.54%) |
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 382295 383786 418883 419001 419547 423551 427237 429708 429736 430535 435535 435651 440973 446849 452876 453323 454234 456220 456379 457498 458281 458312 459457 460465 462285 463361 465348 465381 465472 466186 466206 466851 467689 468974 469550 471076 473349 474645 474835 477589 480066 483376 485511 486965 491316 492011 495999 496732 497203 497206 502702 503255 505819 508804 510546 511197 511545 512099 513127 513131 514054 514400 516663 518595 519439 519871 521035 523436 523542 524770 524846 525841 526050 526499 527633 536779 542386 542508 550354 550507 552067 554489 555116 555969 558276 560969 563744 564709 566322 569249 572337 578141 579619 593649 594846 597182 599916 603347 603482 603985 606951 614493 615944 621040 621181 621845 623333 623701 681331 687190 696202 707693 720206 724466 739659 748242 756025 791164 800718 810848 ] |
||||||||||||||||||||||||||||||
|
15.95 ms (9.44%) |
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 597182 599916 623701 810848 756025 496732 435535 465472 460465 563744 579619 621040 800718 452876 521035 477589 474645 523436 527633 550507 681331 606951 724466 748242 615944 480066 383786 419547 457498 508804 526050 505819 382295 430535 459457 468974 469550 526499 560969 569249 550354 572337 696202 687190 621181 603482 621845 623333 791164 739659 458312 462285 467689 466186 511545 497206 511197 495999 512099 453323 463361 474835 513127 492011 554489 558276 542386 542508 552067 578141 603347 603985 594846 429736 465348 418883 423551 471076 465381 466206 419001 435651 524846 485511 519439 525841 524770 536779 427237 429708 513131 518595 502702 483376 555116 566322 564709 614493 720206 454234 440973 456220 466851 458281 446849 456379 519871 486965 497203 491316 516663 523542 503255 510546 514054 473349 555969 707693 593649 514400 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.97%) |
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 382295 383786 418883 419001 419547 423551 427237 429708 429736 430535 435535 435651 440973 446849 452876 453323 454234 456220 456379 457498 458281 458312 459457 460465 462285 463361 465348 465381 465472 466186 466206 466851 467689 468974 469550 471076 473349 474645 474835 477589 480066 483376 485511 486965 491316 492011 495999 496732 497203 497206 502702 503255 505819 508804 510546 511197 511545 512099 513127 513131 514054 514400 516663 518595 519439 519871 521035 523436 523542 524770 524846 525841 526050 526499 527633 536779 542386 542508 550354 550507 552067 554489 555116 555969 558276 560969 563744 564709 566322 569249 572337 578141 579619 593649 594846 597182 599916 603347 603482 603985 606951 614493 615944 621040 621181 621845 623333 623701 681331 687190 696202 707693 720206 724466 739659 748242 756025 791164 800718 810848 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"whore sex"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"whore секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"whore секс"
]
|
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.