Query Metrics
7
Database Queries
7
Different statements
219.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.81 ms (87.10%) |
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 6670 12710 14599 44968 51972 68383 76836 107362 129791 150507 184909 185208 205910 265933 318318 336987 363488 374819 381854 381875 382172 382857 383145 386613 387625 388149 388264 390758 391393 395463 395833 396069 396191 396421 397793 399187 400906 401966 404000 405082 407298 407434 408987 409867 414432 415836 416335 418552 418835 419845 420348 424280 424541 432504 434656 435289 435462 439900 444243 448403 452369 453352 456090 457283 458031 458570 461892 464284 467216 468176 470563 473314 483328 485371 486316 486640 487283 490164 492601 497515 499891 505846 506766 512103 513207 514577 518270 521401 522351 522547 525749 527416 538803 541332 543479 547947 552969 554425 562219 565185 565351 566356 567024 569684 573065 576138 578138 583678 589769 597866 598151 599475 611375 616787 629017 636268 642121 659347 724753 794126 ] |
||||||||||||||||||||||||||||||
|
18.66 ms (8.52%) |
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 569684 573065 6670 395833 396191 397793 405082 499891 512103 492601 497515 541332 415836 435462 458031 629017 453352 456090 486316 383145 185208 184909 265933 388264 418552 424541 598151 444243 487283 382857 129791 318318 381854 381875 382172 44968 14599 396069 435289 461892 468176 578138 599475 401966 467216 473314 470563 205910 439900 525749 522547 565351 583678 552969 543479 554425 565185 567024 659347 589769 636268 611375 597866 616787 518270 522351 527416 538803 483328 514577 485371 513207 386613 68383 76836 150507 107362 51972 388149 419845 409867 458570 457283 562219 576138 642121 794126 724753 424280 374819 390758 404000 407434 432504 400906 521401 387625 448403 416335 414432 506766 505846 418835 336987 363488 12710 396421 420348 434656 486640 452369 490164 464284 547947 566356 391393 395463 399187 407298 408987 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.08%) |
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 6670 12710 14599 44968 51972 68383 76836 107362 129791 150507 184909 185208 205910 265933 318318 336987 363488 374819 381854 381875 382172 382857 383145 386613 387625 388149 388264 390758 391393 395463 395833 396069 396191 396421 397793 399187 400906 401966 404000 405082 407298 407434 408987 409867 414432 415836 416335 418552 418835 419845 420348 424280 424541 432504 434656 435289 435462 439900 444243 448403 452369 453352 456090 457283 458031 458570 461892 464284 467216 468176 470563 473314 483328 485371 486316 486640 487283 490164 492601 497515 499891 505846 506766 512103 513207 514577 518270 521401 522351 522547 525749 527416 538803 541332 543479 547947 552969 554425 562219 565185 565351 566356 567024 569684 573065 576138 578138 583678 589769 597866 598151 599475 611375 616787 629017 636268 642121 659347 724753 794126 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мужик баба"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.