Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "pov domina"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pov domina' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  517118
  533450
  485790
  488372
  500110
  523577
  533195
  562222
  560286
  567848
  540723
  533891
  515392
  417866
  425131
  446054
  490520
  474896
  496206
  495522
  555114
  573409
  577473
  442390
  422805
  455660
  459099
  443550
  420351
  475984
  520570
  526238
  501414
  488030
  509684
  516505
  531905
  533186
  428116
  459488
  486861
  479791
  507511
  493992
  453368
  443971
  422208
  468433
  440987
  518558
  522050
  512610
  528199
  529530
  452178
  473923
  527078
  564563
  422398
  524142
  485892
  522084
  441166
  526373
  650992
  610605
  540073
  451410
  526895
  446234
  495813
  511920
  501228
  526912
  616990
  599078
  524276
  525941
  522013
  540071
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (517118, 533450, 485790, 488372, 500110, 523577, 533195, 562222, 560286, 567848, 540723, 533891, 515392, 417866, 425131, 446054, 490520, 474896, 496206, 495522, 555114, 573409, 577473, 442390, 422805, 455660, 459099, 443550, 420351, 475984, 520570, 526238, 501414, 488030, 509684, 516505, 531905, 533186, 428116, 459488, 486861, 479791, 507511, 493992, 453368, 443971, 422208, 468433, 440987, 518558, 522050, 512610, 528199, 529530, 452178, 473923, 527078, 564563, 422398, 524142, 485892, 522084, 441166, 526373, 650992, 610605, 540073, 451410, 526895, 446234, 495813, 511920, 501228, 526912, 616990, 599078, 524276, 525941, 522013, 540071);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  417866
  420351
  422208
  422398
  422805
  425131
  428116
  440987
  441166
  442390
  443550
  443971
  446054
  446234
  451410
  452178
  453368
  455660
  459099
  459488
  468433
  473923
  474896
  475984
  479791
  485790
  485892
  486861
  488030
  488372
  490520
  493992
  495522
  495813
  496206
  500110
  501228
  501414
  507511
  509684
  511920
  512610
  515392
  516505
  517118
  518558
  520570
  522013
  522050
  522084
  523577
  524142
  524276
  525941
  526238
  526373
  526895
  526912
  527078
  528199
  529530
  531905
  533186
  533195
  533450
  533891
  540071
  540073
  540723
  555114
  560286
  562222
  564563
  567848
  573409
  577473
  599078
  610605
  616990
  650992
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (417866, 420351, 422208, 422398, 422805, 425131, 428116, 440987, 441166, 442390, 443550, 443971, 446054, 446234, 451410, 452178, 453368, 455660, 459099, 459488, 468433, 473923, 474896, 475984, 479791, 485790, 485892, 486861, 488030, 488372, 490520, 493992, 495522, 495813, 496206, 500110, 501228, 501414, 507511, 509684, 511920, 512610, 515392, 516505, 517118, 518558, 520570, 522013, 522050, 522084, 523577, 524142, 524276, 525941, 526238, 526373, 526895, 526912, 527078, 528199, 529530, 531905, 533186, 533195, 533450, 533891, 540071, 540073, 540723, 555114, 560286, 562222, 564563, 567848, 573409, 577473, 599078, 610605, 616990, 650992);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  417866
  420351
  422208
  422398
  422805
  425131
  428116
  440987
  441166
  442390
  443550
  443971
  446054
  446234
  451410
  452178
  453368
  455660
  459099
  459488
  468433
  473923
  474896
  475984
  479791
  485790
  485892
  486861
  488030
  488372
  490520
  493992
  495522
  495813
  496206
  500110
  501228
  501414
  507511
  509684
  511920
  512610
  515392
  516505
  517118
  518558
  520570
  522013
  522050
  522084
  523577
  524142
  524276
  525941
  526238
  526373
  526895
  526912
  527078
  528199
  529530
  531905
  533186
  533195
  533450
  533891
  540071
  540073
  540723
  555114
  560286
  562222
  564563
  567848
  573409
  577473
  599078
  610605
  616990
  650992
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (417866, 420351, 422208, 422398, 422805, 425131, 428116, 440987, 441166, 442390, 443550, 443971, 446054, 446234, 451410, 452178, 453368, 455660, 459099, 459488, 468433, 473923, 474896, 475984, 479791, 485790, 485892, 486861, 488030, 488372, 490520, 493992, 495522, 495813, 496206, 500110, 501228, 501414, 507511, 509684, 511920, 512610, 515392, 516505, 517118, 518558, 520570, 522013, 522050, 522084, 523577, 524142, 524276, 525941, 526238, 526373, 526895, 526912, 527078, 528199, 529530, 531905, 533186, 533195, 533450, 533891, 540071, 540073, 540723, 555114, 560286, 562222, 564563, 567848, 573409, 577473, 599078, 610605, 616990, 650992);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "пов доминирован"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'пов доминирован';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "пов доминирован"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'пов доминирован';