1 |
0.76 ms |
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.description AS description_3, c0_.status AS status_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7 FROM ctrequest_type c0_ WHERE c0_.status = ?
Parameters: [
"enabled"
]
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.description AS description_3, c0_.status AS status_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.deleted_at AS deleted_at_7 FROM ctrequest_type c0_ WHERE c0_.status = 'enabled';
|
2 |
1.09 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.description AS description_2, c0_.coordinates AS coordinates_3, c0_.meeting_point AS meeting_point_4, c0_.contingency AS contingency_5, c0_.position AS position_6, c0_.name AS name_7, c0_.status AS status_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.deleted_at AS deleted_at_11 FROM ctorigin_destination c0_ INNER JOIN ctroute c1_ ON c0_.id = c1_.origin_id AND (c1_.status = ?) INNER JOIN cttariffication c2_ ON c1_.id = c2_.route_id AND (c2_.status = ?) WHERE c0_.status = ?
Parameters: [
"enabled"
"enabled"
"enabled"
]
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.description AS description_2, c0_.coordinates AS coordinates_3, c0_.meeting_point AS meeting_point_4, c0_.contingency AS contingency_5, c0_.position AS position_6, c0_.name AS name_7, c0_.status AS status_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.deleted_at AS deleted_at_11 FROM ctorigin_destination c0_ INNER JOIN ctroute c1_ ON c0_.id = c1_.origin_id AND (c1_.status = 'enabled') INNER JOIN cttariffication c2_ ON c1_.id = c2_.route_id AND (c2_.status = 'enabled') WHERE c0_.status = 'enabled';
|
3 |
0.58 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.coordinates AS coordinates_3, c0_.status AS status_4, c0_.tags AS tags_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.place_type_id AS place_type_id_9, c0_.location_id AS location_id_10, c0_.municipality_id AS municipality_id_11 FROM ctpredefined_place c0_
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.coordinates AS coordinates_3, c0_.status AS status_4, c0_.tags AS tags_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.place_type_id AS place_type_id_9, c0_.location_id AS location_id_10, c0_.municipality_id AS municipality_id_11 FROM ctpredefined_place c0_;
|
4 |
0.84 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.description AS description_2, c0_.coordinates AS coordinates_3, c0_.meeting_point AS meeting_point_4, c0_.contingency AS contingency_5, c0_.position AS position_6, c0_.name AS name_7, c0_.status AS status_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.deleted_at AS deleted_at_11 FROM ctorigin_destination c0_ INNER JOIN ctroute c1_ ON c0_.id = c1_.destination_id AND (c1_.status = ?) INNER JOIN cttariffication c2_ ON c1_.id = c2_.route_id AND (c2_.status = ?) WHERE c0_.status = ?
Parameters: [
"enabled"
"enabled"
"enabled"
]
SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.description AS description_2, c0_.coordinates AS coordinates_3, c0_.meeting_point AS meeting_point_4, c0_.contingency AS contingency_5, c0_.position AS position_6, c0_.name AS name_7, c0_.status AS status_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10, c0_.deleted_at AS deleted_at_11 FROM ctorigin_destination c0_ INNER JOIN ctroute c1_ ON c0_.id = c1_.destination_id AND (c1_.status = 'enabled') INNER JOIN cttariffication c2_ ON c1_.id = c2_.route_id AND (c2_.status = 'enabled') WHERE c0_.status = 'enabled';
|