Query Metrics
7
Database Queries
7
Different statements
135.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
111.65 ms (82.19%) |
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 8497 97098 109233 129999 226195 383565 383911 384295 387542 390653 390696 391455 391928 392716 397873 402555 405895 408424 410366 411802 411984 413979 415636 415831 415906 418395 419566 420154 421501 422303 422665 422695 423190 423378 426015 426482 428562 429219 429839 435759 436089 438786 445058 445224 447007 447040 448402 450184 453335 453728 455670 455967 482404 483242 483647 483843 483878 483900 484780 484947 485446 485776 486040 486849 487355 487458 490803 490816 491205 493009 493024 494046 495087 497140 497331 497535 497882 501306 501608 503013 505042 505727 505987 506014 507273 507384 508015 508780 509797 510111 511535 511758 512235 512255 512488 512570 512640 513361 513727 513865 513906 514370 515285 516163 518892 520309 522251 523750 524023 525493 525578 525901 526433 528027 528156 529263 533351 535630 539356 ] |
||||||||||||||||||||||||||||||
|
14.80 ms (10.90%) |
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 494046 495087 497140 497331 501608 505987 506014 508780 510111 512255 512640 513361 516163 525578 535630 483843 483878 484947 485776 486849 490816 493009 493024 497882 503013 505042 505727 507273 508015 511758 513727 513865 513906 514370 515285 522251 523750 525493 527557 528156 483242 483647 483900 484780 485446 486040 487355 487458 490803 491205 497535 501306 507384 509797 511535 512235 512488 512570 518892 520309 524023 525901 526433 528027 529263 533351 539356 383911 384295 383565 129999 109233 226195 392716 391928 97098 8497 387542 390696 391455 390653 397873 402555 405895 408424 411984 415831 415906 422665 422695 423190 426482 428562 445058 445224 411802 413979 418395 420154 422303 435759 410366 415636 429219 436089 419566 423378 426015 429839 438786 421501 482404 447007 447040 448402 450184 453335 453728 455670 455967 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.72%) |
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 8497 97098 109233 129999 226195 383565 383911 384295 387542 390653 390696 391455 391928 392716 397873 402555 405895 408424 410366 411802 411984 413979 415636 415831 415906 418395 419566 420154 421501 422303 422665 422695 423190 423378 426015 426482 428562 429219 429839 435759 436089 438786 445058 445224 447007 447040 448402 450184 453335 453728 455670 455967 482404 483242 483647 483843 483878 483900 484780 484947 485446 485776 486040 486849 487355 487458 490803 490816 491205 493009 493024 494046 495087 497140 497331 497535 497882 501306 501608 503013 505042 505727 505987 506014 507273 507384 508015 508780 509797 510111 511535 511758 512235 512255 512488 512570 512640 513361 513727 513865 513906 514370 515285 516163 518892 520309 522251 523750 524023 525493 525578 525901 526433 528027 528156 529263 533351 535630 539356 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"щеку"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"щек"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"щек"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.14%) |
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.