mysql - PHP/PDO - EXPLAIN SELECT for PDO is it possible? -
this query:
$query = $db->prepare(" explain select transaction.id, transaction.datecreated, transaction.dateupdated, transaction.brandid, transaction.clientid, transaction.serviceid, transaction.currencycode, transaction.type, transaction.token, transaction.amount, transaction.reason, transaction.referenceorderid, transaction.servicetransactionid, transaction.chainmode, transaction.bonuscode, transaction.codeid, transaction.codemessage, su.name user_name, su.surname user_surname, b.name brand_name, su.email_address, su.player_id, sandbox, integrationid transaction_astropay transaction left join tokens t on transaction.token = t.token left join sys_users su on su.id=t.user_id left join brands b on b.api_brand_code = transaction.brandid transaction.clientid = :clientid "); $query->bindparam(':clientid',$clientid,pdo::param_int); $query->execute(); $result = $query->fetchall(pdo::fetch_assoc);
the query performed , data fetched db. question how can detailed information how time took. in mysqli
explain select
working.
we took information in mysqli
this:
$sql = 'explain select * table condition = "condition"'; $result = $mysqli->query($sql); $row = $result->fetch_array(mysqli_num); echo $row[0];
how can here in pdo ?
Comments
Post a Comment