| 1 |
1.19 ms |
SELECT l0_.id AS id_0 FROM languages l0_ WHERE l0_.code = ?
SELECT l0_.id AS id_0 FROM languages l0_ WHERE l0_.code = 'en';
|
| 2 |
0.40 ms |
SELECT t0.id AS id_1, t0.lot_no AS lot_no_2, t0.price_start AS price_start_3, t0.price_end AS price_end_4, t0.description AS description_5, t0.dimensions AS dimensions_6, t0.image AS image_7, t0.index_id AS index_id_8, t0.debawin_id AS debawin_id_9, t0.debawin_consignation_no AS debawin_consignation_no_10, t0.debawin_consignation_name AS debawin_consignation_name_11, t0.min_auction_price AS min_auction_price_12, t0.title AS title_13, t0.condition_report AS condition_report_14, t0.start_bid AS start_bid_15, t0.created_by AS created_by_16, t0.created_date AS created_date_17, t0.modified_by AS modified_by_18, t0.modified_date AS modified_date_19, t0.auction_id AS auction_id_20, t0.category_id AS category_id_21 FROM catalogue t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.lot_no AS lot_no_2, t0.price_start AS price_start_3, t0.price_end AS price_end_4, t0.description AS description_5, t0.dimensions AS dimensions_6, t0.image AS image_7, t0.index_id AS index_id_8, t0.debawin_id AS debawin_id_9, t0.debawin_consignation_no AS debawin_consignation_no_10, t0.debawin_consignation_name AS debawin_consignation_name_11, t0.min_auction_price AS min_auction_price_12, t0.title AS title_13, t0.condition_report AS condition_report_14, t0.start_bid AS start_bid_15, t0.created_by AS created_by_16, t0.created_date AS created_date_17, t0.modified_by AS modified_by_18, t0.modified_date AS modified_date_19, t0.auction_id AS auction_id_20, t0.category_id AS category_id_21 FROM catalogue t0 WHERE t0.id = '419';
|
| 3 |
0.49 ms |
SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.file_size AS file_size_2, a0_.file_name AS file_name_3, a0_.file_name_encoded AS file_name_encoded_4, a0_.file_path AS file_path_5, a0_.model_name AS model_name_6, a0_.model_id AS model_id_7, a0_.type AS type_8, a0_.data AS data_9, a0_.sequence AS sequence_10, a0_.created_by AS created_by_11, a0_.created_date AS created_date_12, a0_.modified_by AS modified_by_13, a0_.modified_date AS modified_date_14 FROM attachments a0_ WHERE a0_.model_name = ? AND a0_.model_id = ? ORDER BY a0_.sequence ASC
Parameters: [
"Catalogue"
419
]
SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.file_size AS file_size_2, a0_.file_name AS file_name_3, a0_.file_name_encoded AS file_name_encoded_4, a0_.file_path AS file_path_5, a0_.model_name AS model_name_6, a0_.model_id AS model_id_7, a0_.type AS type_8, a0_.data AS data_9, a0_.sequence AS sequence_10, a0_.created_by AS created_by_11, a0_.created_date AS created_date_12, a0_.modified_by AS modified_by_13, a0_.modified_date AS modified_date_14 FROM attachments a0_ WHERE a0_.model_name = 'Catalogue' AND a0_.model_id = 419 ORDER BY a0_.sequence ASC;
|
| 4 |
0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.src AS src_4, t0.model_name AS model_name_5, t0.model_id AS model_id_6, t0.value AS value_7, t0.state AS state_8, t0.trace AS trace_9, t0.created_by AS created_by_10, t0.created_date AS created_date_11, t0.modified_by AS modified_by_12, t0.modified_date AS modified_date_13, t0.language_id AS language_id_14 FROM translations t0 WHERE t0.language_id = ? AND t0.model_name = ? AND t0.model_id = ? AND t0.state = ?
Parameters: [
2
"Catalogue"
419
"translated"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.src AS src_4, t0.model_name AS model_name_5, t0.model_id AS model_id_6, t0.value AS value_7, t0.state AS state_8, t0.trace AS trace_9, t0.created_by AS created_by_10, t0.created_date AS created_date_11, t0.modified_by AS modified_by_12, t0.modified_date AS modified_date_13, t0.language_id AS language_id_14 FROM translations t0 WHERE t0.language_id = 2 AND t0.model_name = 'Catalogue' AND t0.model_id = 419 AND t0.state = 'translated';
|
| 5 |
9.01 ms |
SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.file_size AS file_size_2, a0_.file_name AS file_name_3, a0_.file_name_encoded AS file_name_encoded_4, a0_.file_path AS file_path_5, a0_.model_name AS model_name_6, a0_.model_id AS model_id_7, a0_.type AS type_8, a0_.data AS data_9, a0_.sequence AS sequence_10, a0_.created_by AS created_by_11, a0_.created_date AS created_date_12, a0_.modified_by AS modified_by_13, a0_.modified_date AS modified_date_14 FROM attachments a0_ WHERE a0_.description = ?
Parameters: [
"124_2.1"
]
SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.file_size AS file_size_2, a0_.file_name AS file_name_3, a0_.file_name_encoded AS file_name_encoded_4, a0_.file_path AS file_path_5, a0_.model_name AS model_name_6, a0_.model_id AS model_id_7, a0_.type AS type_8, a0_.data AS data_9, a0_.sequence AS sequence_10, a0_.created_by AS created_by_11, a0_.created_date AS created_date_12, a0_.modified_by AS modified_by_13, a0_.modified_date AS modified_date_14 FROM attachments a0_ WHERE a0_.description = '124_2.1';
|
| 6 |
0.32 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.number AS number_2, a0_.index_id AS index_id_3, a0_.active AS active_4, a0_.visible AS visible_5, a0_.created_by AS created_by_6, a0_.created_date AS created_date_7, a0_.modified_by AS modified_by_8, a0_.modified_date AS modified_date_9 FROM auctions a0_ WHERE a0_.active = ? LIMIT 1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.number AS number_2, a0_.index_id AS index_id_3, a0_.active AS active_4, a0_.visible AS visible_5, a0_.created_by AS created_by_6, a0_.created_date AS created_date_7, a0_.modified_by AS modified_by_8, a0_.modified_date AS modified_date_9 FROM auctions a0_ WHERE a0_.active = 1 LIMIT 1;
|
| 7 |
0.31 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.bids_start AS bids_start_3, t0.bids_end AS bids_end_4, t0.lot_no_start AS lot_no_start_5, t0.lot_no_end AS lot_no_end_6, t0.type AS type_7, t0.created_by AS created_by_8, t0.created_date AS created_date_9, t0.modified_by AS modified_by_10, t0.modified_date AS modified_date_11, t0.auction_id AS auction_id_12 FROM auction_days t0 WHERE t0.auction_id = ?
SELECT t0.id AS id_1, t0.date AS date_2, t0.bids_start AS bids_start_3, t0.bids_end AS bids_end_4, t0.lot_no_start AS lot_no_start_5, t0.lot_no_end AS lot_no_end_6, t0.type AS type_7, t0.created_by AS created_by_8, t0.created_date AS created_date_9, t0.modified_by AS modified_by_10, t0.modified_date AS modified_date_11, t0.auction_id AS auction_id_12 FROM auction_days t0 WHERE t0.auction_id = 4;
|